Senior Database Administrator

We are seeking a Senior Database Administrator to support the Case Management Modernization (CMM) Program, an initiative to develop a modern, cloud-based solution for the Administrative Office of the US Courts (AOUSC). The successful candidate will provide production support for mission-critical database environments, ensure high availability and timely issue resolution, and collaborate with the Data Architecture, Data Governance, and Migration teams.

Responsibilities:

• Provides production support for mission-critical database environments, including shift-based coverage and on-call support
• Monitors database performance, responds to incidents, troubleshoots production issues, and coordinates with development and operations teams
• Performs root-cause analysis for production defects and contributes to long-term stability improvements
• Works within an Agile solution development environment with daily scrums, biweekly sprint planning, and quarterly Program Increment planning
• Develops operating standards and best practices for performance, security, scalability, and maintainability
• Ensures proper definition, control, and coordination of data elements and standards
• Participates in the development and implementation of database management policies and standards
• Collaborates with Product Owners and users to gather business requirements and define technical requirements
• Analyzes large amounts of data to guide business decisions and uses advanced statistical analysis, data mining, and predictive modeling techniques
• Synthesizes disparate information and recognizes patterns and relationships across data
• Hosts and conducts peer reviews of code and performs data validation
• Develops stored procedures, jobs, views, tables, and other database objects in SQL Server Management Studio
• Designs and develops scalable data models for Databricks lakehouse environments
• Develops and deploys ETL packages using CI/CD pipeline
• Works with Atlassian Suite of software development management tools
• Indexes system and application logs into the Splunk system monitoring application

Requirements:

• Bachelor's degree in computer science, computer programming, computer engineering, or relevant computer-based major
• 7+ years of experience in server database maintenance and database analysis
• Experience supporting production database systems, including shift-based coverage and on-call responsibilities
• Proficient experience with AWS database technologies such as Amazon Aurora PostgreSQL and other AWS-managed data services
• Experience with Databricks and exposure to AWS cloud platform
• Demonstrated understanding of standard Data warehouse concepts
• Adept with data modeling, data mapping, data flow diagrams, and data marts
• Previous experience architecting and implementing cloud-based database solutions on various platforms
• Experience with Data migration from legacy on-premises database to multi-cloud/hybrid cloud platforms
• Proven ability to spearhead and work independently, prioritize, and get things done
• Strong analytical, technical, problem-solving skills
• Excellent organization and time management skills and ability to identify priorities
• Excellent communication skills and ability to work with people at every level