Senior Database Administrator - Production Support

Job Description:

• Provide production support for mission-critical database environments with shift-based coverage and on-call support
• Monitor database performance, respond to incidents, troubleshoot production issues, and coordinate service restoration
• Perform root-cause analysis and contribute to long-term stability improvements
• Participate in Agile delivery through daily scrums, biweekly sprint planning, and quarterly Program Increment planning
• Develop operating standards and best practices for performance, security, scalability, and maintainability
• Define, control, and coordinate data elements and standards
• Facilitate efficient data relationships, systems integration, and physical data structures
• Develop and implement database management policies and standards
• Collaborate with Product Owners, users, agency leaders, stakeholders, consultants, and program personnel
• Gather business requirements and map them to technical requirements
• Document complex workflow designs for project teams and stakeholders
• Analyze complex situations and data to support business strategies and methods
• Collect, analyze, and interpret large datasets for business decisions
• Apply statistical analysis, data mining, and predictive modeling techniques
• Synthesize data from multiple sources and develop visualizations for KPIs and program metrics
• Conduct peer reviews of developers’ code
• Perform data validation and ensure data accuracy and integrity
• Develop stored procedures, jobs, views, tables, and other database objects in SQL Server Management Studio
• Design and develop scalable Databricks lakehouse data models using bronze, silver, and gold layers, dimensional models, fact and dimension tables, and curated data products
• Develop and deploy ETL packages using CI/CD pipelines
• Use configuration management systems for version control
• Work with the Atlassian Suite
• Index system and application logs in Splunk and create dashboards, alerts, and reports

Requirements:

• Bachelor’s degree in computer science, computer programming, computer engineering, or relevant computer-based major and 5+ years of experience in server database maintenance and database analysis or similar role
• 4+ years of additional experience may be considered in lieu of a bachelor’s degree
• 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
• Experience installing, configuring, and providing ongoing administration support for database environments
• Understanding of standard data warehouse concepts
• Proficiency in data modeling, data mapping, data flow diagrams, and data marts
• Experience architecting and implementing cloud-based database solutions
• Experience migrating data from legacy on-premises databases to multi-cloud/hybrid cloud platforms
• Ability to work independently, prioritize, and complete tasks
• Strong analytical, technical, and problem-solving skills
• Organization and time management skills
• Communication skills and ability to work with people at every level
• Comfortable writing ideas, implementation plans, and status reports
• Must be a US Person: Green Card Holder, US Permanent Resident Alien, Refugee, Asylee, or US Citizen
• Must pass a background check to obtain Public Trust
• Must provide onsite fingerprinting at a designated facility
• Preferred certifications: Databricks Certified Data Professional; AWS Certified Database - Specialty; AWS Certified Solutions Architect - Associate and/or Professional

Benefits:

• AI-powered career tool identifying career steps and learning opportunities
• Internal mobility team supporting career goals
• Comprehensive benefits and wellness packages
• 401(k) with company match
• Competitive pay
• Paid time off
• Medical plan options, some with Health Savings Accounts
• Dental plan options
• Vision plan options
• Full flex work weeks where possible
• Vacation, sick, personal, holiday, parental, military, bereavement, and jury duty leave
• Typically 15 days of paid leave per calendar year
• 10 paid holidays per year
• Up to 160 hours of paid family leave in a rolling 12-month period for eligible employees
• Short- and long-term disability benefits
• Life insurance
• Accidental death and dismemberment insurance
• Personal accident insurance
• Critical illness insurance
• Business travel and accident insurance
• Award-winning culture of innovation
• Military-friendly workplace
• Opportunities for career growth
• Identity verification process with virtual interviews conducted on camera