Job description

Position: 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 • 10+ years of proven experience in designing, developing, and maintaining advanced MS Access databases with normalized tables, advanced queries, intuitive forms, and comprehensive reports; expert-level relational database design, normalization, ER modeling, and translating Access models to scalable SQL schemas. • Extensive experience with Microsoft Access (table design, complex queries, forms, reports) and VBA for custom functionalities and workflow automation. • Experience migrating legacy databases to major cloud SQL services (Azure SQL Database/Managed Instance, Postgre SQL, AWS RDS for SQL Server/MySQL). • 8+ years of experience with ETL tools (SSIS, Azure Data Factory, AWS DMS) or equivalents; ability to create migration runbooks, data dictionaries, technical documentation, and deliver training. • Proficiency with RDBMS admin/console tools (TOAD, SSMS, SQL Developer); configuring data integration and batch processing in Azure Data Factory and/or SSIS; monitoring ingestion processes and performance; analyzing execution plans. • Experience migrating data from legacy to new target databases. • 6+ years of experience with CI/CD workflows (Git Hub, JIRA); 6+ years with data visualization/reporting tools (Power BI, Tableau); familiarity with Agile development methodologies. • 3+ years of experience in healthcare or public health is preferred; experience implementing agile methodologies for state agencies is preferred. #J-18808-Ljbffr

Requirements