Database Administrator 3 – Cloud Database Migration | Austin, TX Hybrid | 10+ Years Database Experience

About the role

A Texas state agency seeks a Senior Database Administrator (Database Administrator III) to perform advanced database administration tasks for applications with complex data models, workflows, and reports. The role involves migrating data from Oracle applications to SQL schemas, optimizing database performance during and after migration, identifying and resolving performance bottlenecks, and implementing monitoring solutions to track database health and performance metrics.

Responsibilities

• Perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports
• 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
• Create and maintain logical and physical data models; design relational database models
• Convert Oracle Stored Procedures and Functions to Azure SQL
• Perform database tuning, indexing, customization, transformation, and data migrations/conversions
• Manage installations, troubleshooting, upgrades, patching, user management, and security of data at rest and in motion
• Implement disaster recovery, clustering for high availability and load balancing, data backup, purging, and archiving
• Implement database policies; perform data replication and backup to secondary sites like disaster recovery environments
• 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
• Ensure user interfaces for database administration and data input/output are compliant with accessibility standards
• Provide support to users when accessibility issues arise
• Direct programmers and analysts to make changes to database management systems
• Evaluate users' requests for new data elements and systems; incorporate them into the existing shared data environment
• Coordinate the use of data to ensure data integrity and control redundancy
• Maintain data dictionary ensuring uniformity of definitions and set standards for use
• Assist with determining, implementing, and enhancing standards on database security
• Affiliate with monitoring disaster recovery procedures and systems

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, and 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)

Preferred Qualifications

• 8+ years of experience with large volume databases, high availability, and disaster recovery infrastructure
• 6+ years of experience with Azure
• 6+ years of ability to extract, transform, and load (ETL) data from various sources into Azure SQL
• 3+ years of experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git
• 3+ years of experience in Java/J2EE Enterprise Development
• Azure certification
• DBA Associate certifications