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

Target Resume Now

About the Role

Performs advanced database administration, tuning, migration, and infrastructure management for complex data models, workflows, and reports within a state health agency's cloud platform (Azure/AWS). Focuses on migrating data from legacy Oracle applications to Microsoft SQL schemas and converting Oracle Stored Procedures and Functions to Azure SQL, ensuring database stability, security, disaster recovery, and high availability within an Agile (Scrum) SDLC.

Responsibilities

Perform advanced database tuning, query optimization, indexing, and customization to increase processing performance and resolve bottlenecks.
Execute database installations, patching, upgrades, and troubleshooting to maintain system health and reliability.
Implement robust database backup, retrieval, and recovery processes to mitigate hardware or software failures and ensure business continuity.
Configure and manage security at rest and in motion, control user access, and enforce administrative database policies.
Establish and maintain disaster recovery (DR) procedures, high-availability clustering, load balancing, replication, and data archiving.
Build and maintain logical and physical data models, translating business requirements into relational structures and database schemas.
Plan and execute data migrations and conversions, extracting legacy Oracle application data, transforming it, and loading (ETL) it into Microsoft SQL and Azure collections.
Convert legacy database logic, including Oracle Stored Procedures and Functions, into Azure SQL compliant syntax.
Design, configure, and maintain test database environments for development teams, including managing database libraries and schemas.
Collaborate within an Agile (Scrum) environment, partnering with developers, system administrators, and business stakeholders.
Maintain data dictionaries, ensure uniformity of definition standards, and evaluate stakeholders' requests for new data elements.
Support accessibility compliance (such as EIR Accessibility standards) across database administration user interfaces, reporting outputs, and input tools.
Provide daily and weekly progress updates, effort estimations, and technical project planning to development supervisors.

Requirements

10 or more years of professional database administration and engineering experience.
8 or more years of hands-on experience administering Oracle and Microsoft SQL Server database systems.
8 or more years of experience managing relational database administration (RDBA) in large-scale enterprise environments.
8 or more years of experience in database design, data analysis, schema structures, and performance tuning.
8 or more years of experience designing enterprise-class applications or data services.
8 or more years of experience creating highly detailed technical and functional design documentation.
8 or more years of experience working within the Software Development Life Cycle (SDLC) using Agile methodologies (such as Scrum).
8 or more years of experience supporting multi-tier system and application development (such as SOA, Microservices, or 3-Tier architectures).
Must currently reside in the State of Texas and be local to the Austin area, living within a 50-mile radius of the primary work location.
Ability to successfully pass a pre-employment security review to determine public sector employment eligibility.

Skills

Excellent written and verbal communication skills
Working knowledge of Electronic and Information Resources (EIR) Accessibility standards and assistive technologies.
Outstanding system diagnostics, debugging, and data-analysis capabilities.
Collaborative team player
Ability to manage workloads
Ability to mitigate technical risks
Ability to work independently

Location

Austin, TX

Work Type

Flexible work from home options available

Experience Level

Senior Level (10 or more years of experience)

Benefits

Competitive salary