Database Administrator Job at Peraton, Washington DC

Nk54VEFXSHV5b28vL3dWQm5IaytEZWQ2UXc9PQ==
  • Peraton
  • Washington DC

Job Description

Responsibilities

Responsible for SQL and PL/SQL development to include: developing the backend reports to support user needs; developing custom scripts to automate various database management processes, monitoring and troubleshooting database performance; developing, optimizing, and tuning stored procedures, functions, triggers, views, and queries in support of application development; interfacing with customers, users, and developers as needed; maintaining the database schema, database design, and transition development activities; providing technical subject matter expertise (SME) on ingesting into the database from sources such as file systems, and perform maintenance, to include tuning with various transition implementation strategies with in-house developed applications; resolving various database issues, to include problems with data modeling, design, queries, security control, backup/restore, disaster recovery, and import/export data, as well as coordinate with data ingest efforts with regard to database operations; auditing performance by performing advanced activities such as load testing, response time testing; and providing a report on these activities on an on-going basis so that overall system performance may be documented and charters in the service level agreements (SLAs) are met.

Qualifications

Basic Qualifications:

  • Active TS/SCI
  • Minimum of 5 years of experience as a Database Administrator (Oracle and Postgres) 
  • Minimum of 3 years of hands-on experience with AWS Aurora PostgreSQL 
  • Strong knowledge of PostgreSQL configuration, tuning, and optimization 
  • 5 years of experience with BS/BA degree

Desired Qualifications:

  • AWS certification (Solutions Architect, Database Specialty) 
  • Experience with monitoring tools like CloudWatch, Dynatrace, Grafana, or pgBadger 
  • Knowledge of performance tuning and query optimization techniques 
  • Experience with database high availability and disaster recovery strategies 
  • Experience with automation tools for database administration tasks 
  • Scripting skills in Python, Bash, or similar 
  • Knowledge of database security best practices 
  • Background in agile development environments 
  • Experience with JIRA Ticketing systems preferred
  • Experience with DevOps and Agile methodologies
  • Demonstrated experience migrating data from Oracle to PostgreSQL 
  • Expertise in table partitioning strategies in PostgreSQL 
  • Proven ability to set up and configure database monitoring solutions 
  • Experience writing custom monitoring queries and scripts 
  • Experience in creating and maintaining database ERDs 
  • Proficiency with ETL tools and processes 
  • Experience with database upgrade planning and execution 
  • Ability to write and optimize complex SQL queries 
  • Familiarity with Jira for issue tracking and project management 
  • Strong troubleshooting and problem-solving skills 

Technologies:

  • AWS GovCloud (AWS Console)
  • SNOW
  • Ansible Automation Platform
  • Aurora AWS (PostgreSQL) database
  • Gitlab and Jenkins pipeline
  • CyberArk
  • Splunk

Peraton offers enhanced benefits to employees working on this critical National Security program, which include heavily subsidized employee benefits coverage for you and your dependents, 25 days of PTO accrued annually up to a generous PTO cap and eligibility to participate in an attractive bonus plan.

Peraton Overview

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure.

Target Salary Range

$104,000 - $166,000. This represents the typical salary range for this position based on experience and other factors.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.

Job Tags

Similar Jobs

DACUT

Cannabis Dispensary General Manager Job at DACUT

 ... We are a distinguished and rapidly expanding cannabis company seeking a highly skilled and experienced Cannabis retail General...  ..., driving profitability, and fostering growth within the dispensary, while ensuring an exceptional customer experience and full compliance... 

Autofleet

Technical Support Engineer- US Job at Autofleet

 ...Our global operation continues to expand. Were looking to grow our support team with hard-working, tech-savvy support agents to take part in the journey. The ideal candidate is service-oriented, self-motivated, with excellent organizational skills and a willingness... 

Untitled Entertainment

Assistant to Talent Managers Job at Untitled Entertainment

Opportunity for advancement at top global management firm.Untitled Entertainment is seeking an experienced assistant to support two talent managers in person atour Los Angeles office. The desk is high-volume and fast paced. This person will be performing all the typical...

IT EBusiness Consulting Services, Inc

Sr. Cognos Admin Job at IT EBusiness Consulting Services, Inc

 ...Sr. Cognos Admin Work location: NYC, NY Work remotely: Yes. 100% Remote Required skills : ~10+ years Strong experience in Installation and configuration of Cognos 11.2.X components including Content Manager, Report Server and Gate way ~ Strong... 

AO Globe Life - Chance Peters

100% Fully Remote-Entry Level-Call Center Representative Job at AO Globe Life - Chance Peters

 ...individual looking for an exciting opportunity to earn from the comfort of your own home? Look no further! Were seeking talented individuals to join our dynamic team with the flexibility to work from home and a schedule tailored to your needs. Why Join Us?# Work From...