Database Administrator 3 (Microsoft Access and cloud-native SQL)

Job Title : Database Administrator 3 (Microsoft Access and cloud-native SQL)

Location : Austin, Texas 78751 (Hybrid)

Overview

We are seeking a Senior Database Developer with 10+ years of experience in Microsoft Access and cloud-native SQL to lead the migration of legacy Access databases into modern, high-performance SQL platforms. This role will work closely with program users to analyze existing data structures, design and execute schema transformations, ETL pipelines, validation checks, and cut-over plans, and guide stakeholders through a seamless data transition.

Responsibilities

• Enter codes to create production databases and select utility programs to monitor database performance (e.g., record distribution, memory usage).
• Direct programmers and analysts to modify 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 on staffing costs for changes.
• Perform performance tuning to increase processing efficiency and ensure data integrity; monitor performance and recommend improvements.
• Provide assistance in planning, development, maintenance, and monitoring of integrated database systems; ensure alignment with design parameters.
• Evaluate user requests for new data elements and systems, incorporate them into the shared data environment, and provide technical assistance.
• Coordinate data usage to maintain data integrity and control redundancy; load databases and reorganize as needed; perform data modeling and prototyping.
• Design relational database models (logical and physical), create physical data models from logical models, and perform security recovery procedures.
• Determine and implement database search strategies and storage requirements; maintain data dictionaries and standards for data definitions.
• Monitor database performance; plan and implement efficiency improvements; create test database environments and necessary libraries and procedures.
• Execute procedures to save, retrieve, and recover databases from hardware / software failures within established procedures; assist with database security standards and disaster recovery planning.
• Assist with database software installation, analysis, design, and implementation; participate in benchmarking, threshold testing, and defining security measures.
• Assist in selecting database management software and in setting development standards; monitor accessibility compliance for user interfaces to database administration and reporting.

Qualifications

J-18808-Ljbffr