Database Administrator

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.

Database Administrator 2

Austin, TX

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

• 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 reorganises databases as needed.
• Performs data modelling and prototyping.
• Performs logical and physical data modelling, 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.

• 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 Web Sphere Data Stage, or similar tools.
• Implementation experience with enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies.
• Implementation…