
Senior Database Administrator – Production Support
Posted 2 days ago

Posted 2 days ago
This is a fully remote position, open to applicants in United States.
• Provide production assistance for mission-critical database environments, ensuring shift-based coverage and on-call support.
• Monitor database performance, address incidents, troubleshoot production issues, and facilitate service restoration.
• Conduct root-cause analysis for production defects and contribute to improvements for long-term stability.
• Operate within an Agile development environment, participating in daily scrums, biweekly sprint planning, and quarterly Program Increment planning.
• Establish operating standards and best practices regarding performance, security, scalability, and maintainability.
• Define, manage, and coordinate data elements and standards.
• Engage in database management policies and standards for quality control and data administration.
• Collaborate with Product Owners, users, agency leaders, stakeholders, consultants, and program personnel to collect business requirements and define technical specifications.
• Document intricate workflow designs for project teams and stakeholders.
• Analyze complex situations and data, contributing to business strategies, ideas, and methodologies.
• Gather, analyze, and interpret extensive datasets to inform business decisions.
• Utilize statistical analysis, data mining, and predictive modeling techniques.
• Synthesize information and identify patterns and relationships within data.
• Create data visualizations for KPIs and program outcome metrics.
• Conduct peer reviews of developers' code.
• Perform data validation to ensure accuracy and integrity of data.
• Develop stored procedures, jobs, views, tables, and other database objects using SQL Server Management Studio.
• Design and develop scalable data models for Databricks lakehouse environments, including bronze, silver, and gold layers, dimensional models, fact and dimension tables, and curated data products.
• Create and deploy ETL packages using CI/CD pipelines.
• Utilize configuration management systems for version control.
• Work with the Atlassian Suite.
• Index system and application logs in Splunk, creating dashboards, alerts, and reports.
• Support GDIT’s Case Management Modernization Program for the Administrative Office of the US Courts.
• Bachelor's degree in computer science, computer programming, computer engineering, or a relevant computer-based major with 5+ years of experience in server database maintenance and analysis, or a similar role.
• 4+ years of additional experience may be considered in lieu of a bachelor’s degree.
• 7+ years of related experience as per job qualifications.
• Experience providing support for 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.
• Familiarity with Databricks and exposure to the AWS cloud platform.
• Experience in the installation, configuration, and ongoing administration support of database environments.
• Understanding of standard concepts related to data warehousing.
• Experience with data modeling, data mapping, data flow diagrams, and data marts.
• Proven ability to architect and implement cloud-based database solutions across various platforms.
• Experience migrating data from legacy on-premises databases to multi-cloud/hybrid cloud platforms.
• Capability to lead initiatives independently, prioritize tasks, and complete assignments.
• Strong analytical, technical, and problem-solving skills.
• Excellent organizational and time management abilities.
• Skill in identifying priorities and managing diverse tasks within deadlines.
• Effective communication skills and the ability to collaborate with individuals at all organizational levels.
• Comfortable in writing ideas, implementation plans, and status reports.
• Must pass a background check to qualify for a position of Public Trust.
• Must be a US Person: Green Card Holder, US Permanent Resident Alien, Refugee, Asylee, or US Citizen.
• Preferred but not mandatory: Databricks Certified Data Professional, AWS Certified Database – Specialty, AWS Certified Solutions Architect – Associate and/or Professional.
• Comprehensive benefits and wellness packages.
• 401K with company match.
• Competitive compensation.
• Paid time off.
• Medical plan options, including those with Health Savings Accounts.
• Dental plan options.
• Vision plan.
• Flexible work weeks where feasible.
• Vacation, sick, and personal time.
• Paid holidays.
• Paid parental leave.
• Military leave.
• Bereavement leave.
• Jury duty leave.
• 15 days of paid leave per calendar year for new employees.
• 10 paid holidays annually.
• 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.
• AI-powered career tool identifying career steps and learning opportunities.
• Internal mobility team supporting career aspirations.
TriSphere Apps
Alphabria
Jonas Software
Jonas Software
Get handpicked remote jobs straight to your inbox weekly.