Database Administrator

General Dynamics Information Technology
United States
26 days ago
Apply on www.builtincolorado.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$98,000.0 - $130,000.0
Working hours
Regular working hours

Tech stack

Query Performance Agile Methodology Artificial Intelligence Amazon Web Services Amazon S3 Data Analysis Build Automation Microsoft Azure Backup Devices Business Software Command-Line Interface Cloud Database
+39 more
Cloud Storage Databases System Configuration Continuous Integration Extract Transform Load (ETL) Data Recovery Relational Databases Database Security DevOps Disaster Recovery Documentum Enterprise Content Management Failover HAProxy PostgreSQL Linux System Administration Unix Shell MongoDB MySQL NoSQL Oracle Databases Oracle (Applications) Performance Tuning Windows PowerShell Aws Command Line Interface (CLI) SQL Stored Procedures PL-SQL SQL Databases Scripting Load Balancing System Availability Database Performance Infrastructure Automation Frameworks Information Technology Performance Monitor Cloud Migration Terraform Data Pipelines User Accounts

Job description

We are seeking an experienced Senior Database Administrator to join our Scientific Modeling, Application, Visualization, Computational Science, Software, and Statistical Support (SMAVCS4) team to support the Environmental Protection Agency. Office of Chemical Safety and Pollution Prevention (OCSPP), a scientific organization working to support Agency decisions by providing solutions-driven research to rapidly evaluate the potential human health and environmental risks due to exposures to environmental chemicals and ensure the integrity of the freshwater environment and its capacity to support human well-being.

The selected candidate will interface with the EPA Product Team and developers and will be responsible for but not limited to installation, capacity planning, configuration, database design, migration, performance monitoring, security, administration & management of user accounts, troubleshooting, disaster recovery as well as backup and data recovery to ensure the availability and consistent performance of OCSPP’s software and applications., * Install, configure, administer, manage, and document MySQL, PostgreSQL, and NoSQL (MongoDB) in a Cluster/Master with Replicas configuration across several nodes using HAProxy for load balancing, failover, and high availability across environments already procured by CCTE

  • Independently analyze, solve, and correct issues in real time-including troubleshooting PL/SQL, stored procedures, and Oracle database packages-providing end-to-end problem resolution
  • Advise Division management officials regarding integration of IT programs with other programs of equivalent scope and complexity. Lead engineering and architecture activities related to database performance monitoring and system health
  • Evaluate and establish database architecture standards, high availability, disaster recovery strategies, and work methods to continuously optimize both relational and non-relational data stores and clusters. Manage database assets including maintenance of inventory and related documentation

Roles & Responsibilities:

  • Provide expert level DBA services for production, stage, and development databases across all platforms. Work with senior developers and data modelers to perform physical database design for critical business applications/databases with the largest numbers of interfaces and users
  • Support both automated and ad-hoc report generation as well as existing ETL processes and data pipelines across enterprise platforms
  • Use expert communication and collaboration skills to provide domain and technical expertise, and offer technical mentorship and cross-training to peers and team members
  • Work involves analyzing the user experience of a variety of Agency IT programs and recommending design changes that can enhance the user experience and query performance.
  • Maintain advanced knowledge of database security, backup and recovery, and performance monitoring standards, Administer and optimize enterprise SQL Server databases across on-premises and AWS environments. Responsibilities include performance tuning, query optimization, high availability and disaster recovery, replication, backup and recovery, migrations, security, automation, monitoring, and production support. The role collaborates with application, SRE, and cloud teams, provides architectural guidance, supports database reliability, and participates in a 24x7 on-call rotation. Top Skills: Amazon Ec2Amazon RdsAmazon RedshiftAnsibleAurora PostgresqlAWSGitlabKubernetesMicrosoft Sql ServerOraclePerformance MonitorPostgresPowershellPythonServicenowSql ProfilerSsrsT-SqlTerraform RELX, Manage and optimize large-scale MySQL production environments, including highly available and disaster recovery architectures. Responsibilities include upgrades, patching, backup and recovery, performance tuning, capacity planning, cloud database support across Azure and AWS, infrastructure automation with Terraform and scripting, observability, incident response, root cause analysis, CI/CD collaboration, and on-call production support.

Requirements

Database Management, Microsoft SQL Server, Problem Solving, 3 + years of related experience, The selected candidate for this role must have a high degree of attention to detail as well as a collaborative and solution-oriented working style., * Technical Training, Certification(s) or Degree

  • 3+ years of related experience
  • Experience working in Linux environments
  • Strong command-line experience including Unix shell scripting, PowerShell, and AWS CLI for cloud storage management
  • Experience with Administering SQL (e.g., PostgreSQL, MySQL, Oracle, etc.) and NoSQL (e.g., MongoDB) technologies
  • Experience configuring and managing HAProxy/Keepalived for database load balancing, connection pooling, and automated failover routing
  • Experience managing automated database backups, repositories (e.g., pgBackRest), and backup retention strategies utilizing AWS S3 object storage
  • Ability to perform complex command-line scripts and SQL queries
  • Ability to thrive in an environment without a managed database service
  • Advanced knowledge of database security, backup and recovery, and performance monitoring standards

Required Soft Skills / Organizational Skills Qualifications:

  • Ability to prioritize and complete a wide variety of tasking workloads with critical deadlines
  • Excellent critical thinking and problem-solving skills
  • Superior communications skills, and a demonstrated ability to maintain a patient and professional demeanor, with a can-do attitude
  • Ability to communicate technical concepts clearly and professionally to both technical and non-technical parties (who may be key stakeholders)

  • Ability to manage equipment and services in remote locations
  • Ability to work effectively in a remote team environment
  • Workability to perform well under pressure
  • Strong customer service orientation
  • Ability to maintain an organized workflow, with a high degree of attention to detail

Preferred Qualifications:

  • Experience with MongoDB OpsManager is highly preferred
  • Familiarity with Oracle Database Appliances (ODA) is a plus
  • Familiarity or experience with Documentum or enterprise content management database backends is a plus

Beneficial:

  • Experience working on Federal Sector Contracts
  • Professional Certification(s)
  • Familiarity with DevOps, ITIL Agile processes

Clearance Requirements:

  • Security Clearance Level: must be able to obtain EPA Public Trust Level 4

US Citizenship required per contract

Benefits & conditions

Administer and optimize production, staging, and development databases across SQL and NoSQL platforms. Responsibilities include database installation, configuration, architecture, performance monitoring, security, backups, disaster recovery, high availability, failover, capacity planning, troubleshooting, and data recovery. The role supports ETL pipelines and reporting, collaborates with developers and data modelers, provides technical mentorship, and manages database infrastructure in Linux and AWS environments for EPA applications. The summary above was generated by AI, At GDIT, the mission is our purpose, and our people are at the center of everything we do.

  • Growth: AI-powered career tool that identifies career steps and learning opportunities
  • Support: An internal mobility team focused on helping you achieve your career goals
  • Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
  • Community: Award-winning culture of innovation and a military-friendly workplace, The likely salary range for this position is $97,968 - $129,950. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours: 40, Total Rewards at GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

Our Identity Verification Process: As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during virtual interviews. We reserve the right to take your picture to verify your identity and prevent fraud. By proceeding, you authorize the collection, processing, and use of your biometric data for identity verification and security purposes., 2 Days Ago In-Office or Remote 91K-191K Annually Senior level 91K-191K Annually Senior level Information Technology * Legal Tech * Analytics Manage and optimize highly available MySQL database platforms in large-scale production environments. Design disaster recovery and multi-region architectures, perform upgrades, backups, performance tuning, and capacity planning, and build automation using Terraform and scripting. Support Azure and AWS databases, monitoring, observability, incident response, and root cause analysis. Partner with engineering, DevOps, infrastructure, and security teams on reliability, CI/CD, cloud modernization, and self-service automation while participating in on-call support. Top Skills: Amazon CloudwatchAmazon Web Services (Aws)AnsibleAzure MonitorBashCi/CdDatadogElkGitGithub ActionsGrafanaAzureMicrosoft Sql ServerMongoDBMySQLOraclePostgresPythonSreTerraform

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

About the company

We are GDIT. A global technology and professional services company that delivers technology solutions and mission services to every major agency across the U.S. government, defense and intelligence community. Our 26,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50+ countries worldwide, offering leading mission-ready capabilities in AI, cloud, cyber and software development.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.builtincolorado.com
Prepare application

Good distractions

Loading talks and stories from around this role…