Database Administrator 2

Ampcus Inc; Austin (TX); On-site; USD 70,000 - 120,000; Full time

Job summary

Ampcus Inc is seeking a Database Administrator 2 to join our Austin, TX team. The role involves administration, development, maintenance, performance monitoring, security, recovery, and data modeling for enterprise databases.

You will lead database changes, optimize performance, and collaborate with developers, analysts, and users to ensure data integrity and availability. This position requires deep experience with data warehouses and BI tools.

Qualifications

• 5+ years of experience with database management systems and data warehouses.
• Experience with data modeling, data dictionaries, and ETL tooling.
• Proven ability to design, implement, and optimize enterprise databases.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Administers production databases and monitors performance.
• Directs changes to database management systems and reviews programs.
• Ensures data integrity and implements security and recovery procedures.
• Supports data modeling, loading, and testing of new databases.
• Collaborates with teams to assess impact of changes on systems and costs.

Skills

Database design

Data warehouse

SQL optimization

Analytical skills

Communication

Tools

Informatica

IBM DataStage

Power BI

Oracle/SQL Server

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Database Administrator 2

Location(s): Austin, TX

Job Description

Provides database administration, development, maintenance, performance monitoring, security, recovery, and data modeling support for enterprise database environments.

Key Responsibilities

• Enters codes to create production databases.
• Selects and enters utility program codes to monitor database performance, including record distribution and available memory.
• Directs programmers and analysts to make changes to database management systems.
• Reviews and corrects programs.
• Answers user questions and provides technical assistance.
• Confers with coworkers to determine the impact of database changes on other systems and staff costs associated with database changes.
• Modifies database programs to increase processing performance through performance tuning.
• Provides assistance in the planning, development, maintenance, and monitoring of integrated database systems.
• Ensures conceptual and design phases of new applications are consistent with structural parameters within the database environment.
• Evaluates requests for new data elements and systems and incorporates them into the existing shared data environment.
• Coordinates the use of data to ensure data integrity and control redundancy.
• Loads and reorganizes databases as needed.
• Performs data modeling and prototyping.
• Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.
• Performs security and recovery procedures.
• Determines and implements database search strategies and storage requirements.
• Maintains the data dictionary, ensuring uniformity of definitions and establishing standards for its use.
• Monitors database performance and recommends efficiency improvements.
• Creates test database environments for application teams, including necessary libraries and procedures.
• Executes procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Assists with determining, implementing, and enhancing database security standards.
• Assists with monitoring disaster recovery procedures and systems.
• Assists with the installation of database software and with analyzing, designing, and implementing databases.
• Assists in database benchmarking and threshold testing.
• Assists with establishing and controlling database security.
• Assists in the selection of database management software.
• Ensures database administration and data input, viewing, and output interfaces comply with accessibility standards.
• Provides support to users in obtaining data and information when accessibility issues arise.

Required Knowledge And Skills

• Experience in computer systems analysis or computer programming.
• 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.
• Knowledge of database structures and theories.
• Knowledge of current database technologies.
• Working knowledge of accessibility standards and assistive technologies.
• Strong database management systems knowledge, including data warehouse management and decision support tools.
• Experience developing, implementing, and maintaining 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 oral and written communication skills.
• Strong teamwork and interpersonal skills.
• Extremely high analytical ability to address unusual and highly difficult problems.
• Understanding of benchmarking processes and techniques.
• Strong interpersonal skills to work effectively with others, motivate employees, and elicit work output.
• Knowledge of data warehouse 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.
• Implementation experience with enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies.
• Implementation experience with analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools.
• Experience with the data warehouse implementation process, including business requirements, logical modeling, physical database design, data sourcing and transformation, data loading, SQL, end-user tools, database administration, and SQL performance.
• Excellent analytical, problem-solving, teamwork, oral, and written communication skills.
• Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.

Minimum Qualifications

• 5+ years of experience with database management systems, data warehouse management, and decision support tools.
• 5+ years of experience developing, implementing, and maintaining data warehouses and data marts.
• 5+ years of experience with Business Objects and data dictionary development.
• 5+ years of experience using database access tools for application delivery.
• 5+ years of experience with analysis, planning, and management reporting functions.
• 5+ years of experience with data warehouse data population and modeling techniques.
• 5+ years of experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar technologies.
• 5+ years of experience implementing enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies.
• 5+ years of experience implementing analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar technologies.
• 5+ years of experience with end-to-end data warehouse implementation processes, including requirements, modeling, database design, data sourcing, transformation, loading, SQL, and end-user tools.
• 5+ years of experience demonstrating strong analytical, problem-solving, teamwork, and communication skills.
• 5+ years of experience working effectively with technical and non-technical groups and managing multiple responsibilities.

Preferred Qualifications

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

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.