Database Administrator 2

Akaasa Technologies; United States; Hybrid; USD 90,000 - 120,000; Full time

Job summary

Akaasa Technologies in Austin, TX is seeking a Database Administrator 2 for a hybrid role. You will support database administration, data warehousing, ETL, and reporting across enterprise environments. Strong SQL, performance tuning, and data modelling experience are essential.

The position emphasizes security, recovery, data integrity, and collaboration with cross-functional teams. Experience with BI tools like Power BI and Oracle databases is required.

Qualifications

• 5+ years of experience in database management and data warehousing.

Responsibilities

• Support planning, development, implementation, maintenance, and monitoring of integrated database systems.
• Create, load, reorganize, and maintain production databases.
• Monitor database performance, memory utilization, and system efficiency.
• Perform database performance tuning, benchmarking, and threshold testing.
• Analyse database changes and assess their impact on applications and staff.
• Develop and maintain logical and physical data models.
• Design relational database models and physical database structures.
• Support data warehouse and data mart development and maintenance.
• Implement data population and modelling using Star/Snowflake schemas and normalized models.
• Work with GUI-based ETL tools like Informatica or DataStage.
• Support data sourcing, transformation, loading, and SQL development.
• Maintain the data dictionary and data definitions standards.
• Establish and maintain database security, backup, and disaster recovery procedures.
• Create and maintain test database environments and procedures.
• Assist with database software installation and design.
• Support database search strategies and storage requirements.
• Provide tech support to users and respond to data requests.
• Collaborate with tech and non-tech teams to resolve complex issues.
• Support analytical/reporting environments with Business Objects, Cognos, Hyperion, MicroStrategy.
• Ensure DB administration interfaces comply with accessibility standards.

Skills

Analytical skills

Problem-solving

Teamwork

Communication

Oracle Database experience

Tools

Informatica

IBM WebSphere DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Title: Database Administrator 2

Location: Hybrid in 701 W 51st Street, Austin, TX 78751 Need Local
Duration: 6+ Months

MOI: Skype

Need LinkedIn and Govt Exp

Job Overview

Seeking an experienced Database Administrator 2 to support database administration, data warehousing, data modelling, ETL, reporting, database performance, security, recovery, and data integrity initiatives.

The successful candidate will have strong experience with enterprise database environments, data warehouses and data marts, data modelling, ETL technologies, analytical/reporting platforms, SQL, and database performance optimization.

Key Responsibilities

• Support the planning, development, implementation, maintenance, and monitoring of integrated database systems.
• Create, load, reorganize, and maintain production databases.
• Monitor database performance, memory utilization, record distribution, and system efficiency.
• Perform database performance tuning, benchmarking, and threshold testing.
• Analyse database changes and assess their impact on applications, systems, and staff.
• Develop and maintain logical and physical data models.
• Design relational database models and physical database structures.
• Support data warehouse and data mart development and maintenance.
• Implement data population and modelling techniques using Star Schema, Snowflake Schema, and highly normalized data models.
• Work with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar technologies.
• Support data sourcing, transformation, loading, and SQL development.
• Maintain the data dictionary and ensure consistency of data definitions and standards.
• Establish and maintain database security, backup, recovery, and disaster recovery procedures.
• Create and maintain test database environments, libraries, and procedures.
• Assist with database software installation, database design, and implementation.
• Support database search strategies and storage requirements.
• Provide technical assistance to users and respond to data/information requests.
• Work with technical and non-technical teams to analyse requirements and resolve complex database issues.
• Support analytical and reporting environments using tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar platforms.
• Ensure database administration interfaces and reporting/input/output functions comply with applicable EIR accessibility standards.

Required Qualifications

Candidates must have at least 5 years of experience in the following areas:

• Strong knowledge of database management systems, data warehouse management, and decision-support tools.
• Development, implementation, and maintenance of data warehouses and data marts.
• Experience with Business Objects and building/maintaining data dictionaries.
• Database access tools for application delivery.
• Analysis, planning, and management reporting functions.
• Data warehouse population and data modelling.
• Star Schema, Snowflake Schema, and normalized data models.
• GUI-based ETL tools such as:
  • Informatica
  • IBM WebSphere DataStage
  • Similar ETL technologies
• Enterprise-class databases such as:
  • Teradata
  • Oracle
  • SQL Server
  • Similar technologies
• Analytical and reporting tools such as:
  • Business Objects
  • Cognos
  • Hyperion
  • MicroStrategy
  • Similar platforms
• End-to-end data warehouse implementation, including:
  • Business requirements
  • Logical modelling
  • Physical database design
  • Data sourcing
  • Data transformation
  • Data loading
  • SQL
  • End-user tools
  • Database/SQL performance considerations
• Database benchmarking processes and techniques.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication.
• Strong teamwork and interpersonal skills.
• Ability to work effectively with both technical and non-technical teams.
• Ability to manage multiple responsibilities and solve unusually complex problems.
• 5+ years of Oracle Database experience

• 5+ years of Power BI report creation experience