Database Administrator - 13+ years exp

ACS Consultancy Services; Austin (TX); Hybrid; USD 120,000 - 160,000; Full time

Job summary

ACS Consultancy Services in Austin, TX seeks a seasoned Database Administrator with 13+ years of experience to design, implement, and maintain enterprise data warehouses and databases. You will lead tuning, data modeling, and governance across Teradata, Oracle, and SQL Server environments, while collaborating with both technical and business stakeholders.

The role emphasizes strong communication, accessibility compliance, and hands-on leadership with ETL tools such as Informatica/DataStage, and

Qualifications

• : Strong knowledge of database management systems, data warehouse management, and decision support tools.
• : Experience with data warehouses, data marts, and data population modeling.
• : Experience with GUI-based ETL tools such as Informatica and DataStage.
• : Experience implementing enterprise-class databases (Teradata, Oracle, SQL Server).
• : Experience with analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy.
• : Strong analytical and problem-solving abilities.
• : Excellent oral and written communication skills.
• : Ability to work with technical and non-technical groups.

Responsibilities

• : Enter codes to create production databases and utility programs to monitor database performance.
• : Direct programmers and analysts in making changes to database management systems.
• : Review and correct programs to improve processing performance through tuning.
• : Answer user questions and provide technical assistance related to databases and data.
• : Coordinate data usage to ensure data integrity and control redundancy.
• : Load and reorganize databases as needed.
• : Perform data modeling and prototyping.
• : Maintain the data dictionary and standards for its use.
• : Monitor database performance and suggest efficiency improvements.
• : Ensure accessibility standards compliance for interfaces and reporting.

Skills

Database management

Data warehousing

Data modeling

SQL

ETL tools

Performance tuning

Data dictionary

Reporting tools

Communication

Teamwork

Analytical skills

Education

Bachelor's degree in a related field

Tools

Informatica

IBM WebSphere DataStage

Teradata

Oracle

SQL Server

Power BI

Cognos

Hyperion

MicroStrategy

Job description

Job Title: Database Administrator - 13+ years exp

Location: Austin, TX (Hybrid)

We are currently seeking candidates who meet the following qualifications:

Required Qualifications

• Strong knowledge of database management systems, data warehouse management, and decision support tools.
• Extensive experience in the development, implementation, and maintenance of data warehouses and data marts.
• Experience with Business Objects and building data dictionaries.
• Ability to use database access tools for application delivery.
• Strong familiarity with analysis, planning, and management reporting functions.
• Strong understanding of benchmarking processes and techniques.
• Knowledge of data warehousing data population and data modeling techniques, including Star Schemas, Snowflake Schemas, and highly normalized data models.
• Experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
• Experience implementing enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies.
• Experience implementing analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools.
• Experience with data warehouse implementation processes, including business requirements, logical modeling, physical database design, data sourcing, data transformation, data loading, SQL, end-user tools, database, and SQL performance.
• Strong analytical and problem-solving abilities.
• Excellent oral and written communication skills.
• Strong teamwork and interpersonal skills.
• Ability to work effectively with others and elicit work output.
• Ability to work successfully with technical and non-technical groups.
• Ability to manage multiple responsibilities.
• Knowledge of database structures, theories, and current database technologies.
• Knowledge of computer programming and systems design principles, practices, and techniques.
• Knowledge of computer operations, systems, and procedures.
• Knowledge of project control and cost estimating techniques.
• Knowledge of computer programming languages.
• Knowledge of data processing flowcharting techniques.
• Working knowledge of EIR Accessibility standards and assistive technologies.
• Experience ensuring database administration and data input, viewing, and reporting interfaces comply with accessibility standards.

Preferred Qualifications

• Oracle Database experience.
• Power BI report creation experience.

Key Responsibilities

• Enter codes to create production databases and utility programs to monitor database performance, including distribution of records and available memory.
• Direct programmers and analysts in making changes to database management systems.
• Review and correct programs and modify database programs to improve processing performance through performance tuning.
• Answer user questions and provide technical assistance related to databases and data.
• Confer with coworkers to determine the impact of database changes on other systems and staff costs.
• Provide assistance in the planning, development, maintenance, and monitoring of integrated database systems.
• Ensure the conceptual and design phases of new applications are consistent with structural parameters within the database environment.
• Evaluate user requests for new data elements and systems and incorporate them into the existing shared data environment.
• Coordinate the use of data to ensure data integrity and control redundancy.
• Load and reorganize databases as needed.
• Perform data modeling and prototyping.
• Perform logical and physical data modeling and design relational database models.
• Create physical data models from logical data models.
• Perform database security and recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain the data dictionary, ensuring uniformity of definitions and establishing standards for its use.
• Monitor database performance and recommend efficiency improvements.
• Create test database environments for application sections, including necessary libraries and procedures.
• Execute procedures required to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Assist with determining, implementing, and enhancing database security standards.
• Assist with monitoring agency disaster recovery procedures and systems.
• Assist with the installation of database software.
• Assist with analyzing, designing, and implementing databases.
• Assist with database benchmarking and threshold testing.
• Assist with establishing and controlling necessary database security.
• Assist in the selection of database management software.
• Support data warehouse population and data modeling using Star Schemas, Snowflake Schemas, and highly normalized data models.
• Work with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar technologies.
• Support enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies.
• Support analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar technologies.
• Support the data warehouse implementation process from business requirements through logical modeling, physical database design, data sourcing, data transformation, data loading, SQL, end-user tools, database, and SQL performance.
• Provide support to users in obtaining data and information when EIR Accessibility issues arise.
• Ensure database administration interfaces and data input, viewing, and output through reports comply with EIR Accessibility standards.
• Work effectively with both technical and non-technical groups while managing multiple responsibilities