End Client: State of Texas
Job Title: Database Administrator 3
Duration: 12 Months +Extendable
Location: 701 W. 51st, Austin, TX 78751 (Hybrid)
Hours Per Week: 40 Hours
Interview Type: In Person
Ceipal ID: STX_SQL759_SN
Job Code: 529701759
Department: Texas Health and Human Services Commission (HHSC)
Scope of Project:
The role is for a Senior Database Administrator (Database Administrator III) and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The successful candidate will work with Full-stack Java applications on HHSC s cloud platform (Azure/AWS) within an Agile (Scrum) environment. The role will involve migrating data from Oracle applications to SQL schemas and loading it into collections. Additionally, the candidate will optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics. The DBA III works on activities including but not limited to database tuning, indexing, customization, transformation, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability, and confidentiality of the sensitive and business-critical databases. The role will involve working closely with the team to create and maintain logical and physical data models, with a primary focus on Oracle and Azure Microsoft SQL. This role will require converting Oracle Stored Procedures and Functions to Azure SQL.
Responsibilities:
- Enters codes to create production database.
- Selects and enters codes of utility program to monitor database performance.
- Directs programmers and analysts to make changes to database management system.
- Reviews and corrects programs.
- Answers user questions.
- Confers with coworkers to determine impact of database changes.
- Modifies database programs to increase processing performance (performance tuning).
- Provides assistance in planning, development, maintenance, and monitoring of integrated database systems.
- Evaluates users' requests for new data elements and systems.
- Coordinates the use of data to ensure data integrity and control redundancy.
- Performs data modeling and prototyping.
- Performs logical and physical data modeling.
- Designs relational database models.
- Creates physical data models from logical data models.
- Performs security recovery procedures.
- Determines and implements database search strategies and storage requirements.
- Maintains data dictionary.
- Monitors database performance and recommends efficiency improvements.
- Creates test database environments.
- Executes backup, restore, and recovery procedures.
- Assists with database software installation.
- Assists with benchmarking and threshold testing.
- Assists with database security implementation.
- Works with Full-stack Java applications on Azure/AWS.
- Migrates Oracle data to Azure SQL.
- Optimizes database performance.
- Implements monitoring solutions.
- Performs database tuning, indexing, customization, and transformation.
- Performs data migrations and conversions.
- Performs installations, troubleshooting, upgrades, and patching.
- Manages database users.
- Ensures security of data at rest and in motion.
- Supports disaster recovery and clustering.
- Implements database policies.
- Performs data replication and backup to DR environments.
- Converts Oracle Stored Procedures and Functions to Azure SQL.
Required/Preferred Skills:
Years
Required/Preferred
Skills/Experience
10
Required
Database experience
8
Required
Experience with Oracle, Microsoft SQL (or similar)
8
Required
Experience with Relational Database Administration (SQL Server or Oracle)
8
Required
Experience in database design, analysis and performance tuning
8
Required
Experience in database structures, data analysis, performance tuning
8
Required
Experience designing enterprise applications and/or services
8
Required
Experience creating technical and functional design documentation
8
Required
Experience within SDLC using Agile methodology (Scrum)
8
Required
Experience with multi-tier system/application development (SOA, Microservices, 3-Tier applications)
8
Preferred
Experience with large volume databases, high availability, and disaster recovery infrastructure
6
Preferred
Experience with Azure
6
Preferred
Ability to Extract, Transform and Load (ETL) data into Azure SQL
3
Preferred
Experience with DevOps technology including CI/CD pipeline and Git
3
Preferred
Experience in Java/J2EE Enterprise Development
1
Preferred
Azure certification
1
Preferred
DBA Associate certification
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.
If you are considering applying for a position with V Group, or partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website: https://www.vgroupinc.com/publicsector
LinkedIn: https://www.linkedin.com/company/v-group/
Facebook: https://www.facebook.com/VGroupIT
Twitter: https://www.twitter.com/vgroupinc
LinkedIn: https://www.linkedin.com/company/v-group/
Facebook: https://www.facebook.com/VGroupIT
Twitter: https://www.twitter.com/vgroupinc
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more