Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This contractor role involves advanced database administration for applications with complex data models, workflows, and reports. The successful candidate will assist the team in creating and maintaining logical and physical data models, working with Full-stack Java applications on HHSC’s cloud platform (Azure/AWS) within an Agile (Scrum) environment. Key responsibilities include migrating data from Oracle to SQL schemas, optimizing performance, identifying and resolving bottlenecks, and implementing monitoring solutions.

Responsibilities

Enter codes to create production databases.
Select and enter codes of utility programs to monitor database performance.
Direct programmers and analysts to make changes to the database management system.
Review and correct programs.
Answer user questions.
Confer with coworkers to determine the impact of database changes on other systems and staff costs.
Modify database programs to increase processing performance (performance tuning).
Provide assistance in the planning, development, maintenance, and monitoring of integrated database systems.
Ensure that conceptual and design phases of new applications are consistent with structural parameters within the database environment.
Evaluate users' requests for new data elements and systems, incorporate them into the existing shared data environment, and provide technical assistance.
Coordinate the use of data to ensure data integrity and control redundancy.
Load databases and reorganize as needed.
Perform data modeling and prototyping.
Perform logical and physical data modeling, design relational database models, and create physical data models from logical data models.
Perform security recovery procedures.
Determine and implement database search strategies and storage requirements.
Maintain data dictionary, ensuring uniformity of definitions and setting standards for its use.
Monitor database performance and recommend efficiency improvements.
Create test database environments for applications, including necessary libraries and procedures.
Execute procedures to save, retrieve, and recover databases from hardware and software failures.
Assist with determining, implementing, and enhancing standards on database security.
Assist with monitoring agency disaster recovery procedures and systems.
Assist with the installation of database software.
Assist with analyzing, designing, and implementing databases.
Assist in benchmarking and threshold testing of databases.
Assist in establishing and controlling necessary database security.
Assist in the selection of database management software.
Migrate data from Oracle applications to SQL schemas and load it into collections.
Optimize database performance during and after migration.
Identify and resolve performance bottlenecks.
Implement monitoring solutions to track database health and performance metrics.
Perform database tuning, indexing, customization, and transformation.
Perform data migrations/conversions, installations, troubleshooting, upgrades, and patching.
Manage user access, data security (at rest and in motion), and disaster recovery.
Implement clustering for high availability and load balancing.
Manage data backup, purging, and archiving.
Implement database policies and data replication.
Perform backup to secondary sites for disaster recovery environments.
Ensure integrity, availability, and confidentiality of sensitive and business-critical databases.
Create and maintain logical and physical data models, with a primary focus on Oracle and Azure Microsoft SQL.
Convert Oracle Stored Procedures and Functions to Azure SQL.

Requirements

10 years of database experience.
8 years of experience with Oracle, Microsoft SQL - (or similar).
8 years of experience with Relational Database Administration - (SQL Server or Oracle, for example).
8 years of experience in database design, analysis and performance tuning.
8 years of experience in database structures, data analysis, performance tuning.
8 years of experience designing enterprise applications and/or services.
8 years of experience creating technical and functional design documentation.
8 years of experience within software development Life Cycle using Agile methodology – (Scrum, for example).
8 years of experience with multi-tier system/application development – (SOA, Microservices, 3-Tier applications, for example).
Experience in computer systems analysis or computer programming work.
Knowledge of the principles, practices, and techniques of computer programming and systems design.
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 EIR Accessibility standards and assistive technologies.
Ensure that user interfaces for database administration and inputting, viewing, outputting data(via reports) are compliant with accessibility standards.
Provide support to users in obtaining data / information when EIR Accessibility issues arise.
Candidates for this position will be subject to a pre-employment security review to determine employment eligibility.

Skills

Database administration
Database performance monitoring
Database management system changes
Program review and correction
User support
Impact analysis of database changes
Performance tuning
Database system planning, development, maintenance, and monitoring
Data modeling
Prototyping
Logical data modeling
Physical data modeling
Relational database design
Security recovery procedures
Database search strategies
Storage requirements
Data dictionary maintenance
Database performance monitoring
Efficiency improvement recommendations
Test database environment creation
Database saving, retrieval, and recovery procedures
Database security standards implementation
Disaster recovery procedures monitoring
Database software installation
Database analysis and design
Database benchmarking
Threshold testing
Database security establishment and control
Database management software selection
Agile methodology
Scrum
Full-stack Java applications
Cloud platform (Azure/AWS)
Data migration (Oracle to SQL)
Data loading
Performance optimization
Bottleneck identification and resolution
Monitoring solution implementation
Database tuning
Indexing
Customization
Transformation
Data migrations/conversions
Installations
Troubleshooting
Upgrades
Patching
User management
Data security (at rest and in motion)
Disaster recovery
Clustering
High availability
Load balancing
Data backup
Purging
Archiving
Database policies implementation
Data replication
Backup to secondary sites
Integrity, availability, and confidentiality of databases
Oracle
Azure Microsoft SQL
Oracle Stored Procedures and Functions conversion to Azure SQL
Large volume databases
High availability infrastructure
Disaster recovery infrastructure
Azure
Extract, transform, and load (ETL) data
DevOps technology
CI/CD pipeline
Build and deployment tools
Git
Java/J2EE Enterprise Development

Work Type

Contractor

Experience Level

Senior
III

Education Level

Azure certification
DBA Associate certifications

About the Company

HHSC’s cloud platform (Azure/AWS)