PostgreSQL Database Administrator

CareerCircle
Manassas, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 237K

Job location

Manassas, United States of America

Tech stack

Microsoft Word
Java
JavaScript
Microsoft Excel
Agile Methodologies
Artificial Intelligence
Amazon Web Services (AWS)
Border Gateway Protocol
Bioinformatics
Bootstrap
Cisco IOS
Cloud Computing
Configuration Management
Computer Networks
Databases
Continuous Integration
Data Centers
Data Transmissions
Data Governance
Data Systems
Database Design
Database Queries
Github
Hibernate
Hot Standby Router Protocol
Multi-protocol Systems
Apache Struts
Java Foundation Classes
JavaServer Faces
Junos
Local Area Networks
Network Layer
PostgreSQL
Microsoft Office
Microsoft Visio
Open Shortest Path First
Open Systems Interconnection (OSI)
Oracle
Oracle Applications
Enterprise Planning Systems
Microsoft PowerPoint
Query Optimization
Standard Sql
Software Engineering
Verification and Validation (Software)
SQL Stored Procedures
SQL Databases
Systems Integration
TCP/IP
Transmission Control Protocol (TCP)
Virtual Local Area Networks
Virtual Router Redundancy Protocols
Wide Area Networks
Computer Network Technologies
Generative AI
Juniper
Gitlab
GIT
Angular
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Real Time Data
Software Version Control
Devsecops
ServiceNow

Job description

Gitlab Github Equities Timelines DevSecOps PostgreSQL Scalability Market Data Persistence Self-Starter Apache Struts Amazon Aurora Real Time Data Microsoft Excel Microsoft Visio Database Design Ancient History Microsoft Office Oracle Databases Stored Procedure Hibernate (Java) JavaServer Faces Agile Methodology Query Optimization Business Objectives Amazon Web Services Information Privacy Microsoft PowerPoint Resource Constraints Database Administration SQL (Programming Language) Java (Programming Language) Verbal Communication Skills Verification And Validation Enterprise Planning Systems Git (Version Control System) Software Development Life Cycle Bootstrap (Front-End Framework) Troubleshooting (Problem Solving) JavaScript (Programming Language) Generative Artificial Intelligence Oracle Database Administration (DBA), The Homeland Sector within Leidos is seeking a PostgreSQL Database Administrator with strong systems, software, cloud, and Agile experience to support the Passenger Systems Program Directorate (PSPD) within Customs and Border Protection (CBP). PSPD supports the Department of Homeland Security (DHS) and CBP critical missions, specifically screening and processing travelers at the ports of entry (POEs) into the United States.

In this hands-on position, you will work collaboratively to design, build, deliver, enhance, and support highly available, scalable, real-time data persistence. You will exercise your judgment in determining and recommending the best designs based on customer business objectives, timelines and other resource constraints. You will participate in major deliverables of data solutions during the software development life cycle including scope and work estimation, design, implementation, and support.

This position REQUIRES the candidate to be in Ashburn, VA, 2 times a week

Primary Responsibilities:

  • Performs technical planning, system integration, verification and validation, cost and risk, and support ability and effectiveness analyzes.
  • Proactively monitors database health, optimizes SQL code, and addresses performance bottlenecks.
  • Designs and implements database schemas and structures according to project requirements.
  • Develops and maintains documentation for database environments, including data standards and procedures.
  • Implements security measures, set sup user permissions, and ensures compliance with data protection policies.
  • Plans for storage requirements and database growth, and scale infrastructure as needed.
  • Maintains data accuracy and ensures maximum uptime, and may require some on-call support.
  • Collaborates with developers to optimize queries, stored procedures, and database design for applications.
  • Must be a self-starter, strong leader, and the ability to work independently with little supervision., All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws. Related Jobs Shop Helper Aerotek Manassas, VAOn-Site Construction Data Centers Health Advocacy Inventory Management Artificial Intelligence Discounts And Allowances Critical Illness Insurance Verbal Communication Skills Employee Assistance Programs +0 Sr. Contracts Representative Leidos Chantilly, VAOn-Site Finance Debating Equities Negotiation Market Data Communication Self-Motivation Project Controls Contract Management Request For Proposal Research And Development Interpersonal Communications Top Secret-Sensitive Compartmented Information (TS/SCI Clearance) +0 Tier 2 Technician Leidos Chantilly, VA*On-Site Junos TCP/IP Foundry Equities Topology Cisco IOS Operations ServiceNow Market Data Network Layer Microsoft Visio

Requirements

  • BS/BA degree and 14+ years of prior relevant DBA experience or Masters with 12+ years of prior relevant DBA experience; OR 4 years of experience in lieu of degree
  • 4+ years' experience tuning Aurora PostgreSQL database performance and PL/pgSQL scripts to optimize performance
  • 4+ years' experience as an AWS Aurora PostgreSQL DBA in a 24x7 environment managing multiple databases of over 70TB.
  • Individual must have at least 4+ years' experience as an Oracle DBA in a 24x7 environment supporting databases of over 200TB
  • Proficiency in tuning Oracle Databases and troubleshooting performance issues.
  • Able to support on-call schedule and incident resolution.
  • Proficiency with Microsoft Office Products (Word, Excel, Visio, & PowerPoint)
  • Excellent written and verbal communication skills
  • U.S. Citizen.
  • Must be able to maintain and obtain a CBP Background Investigation prior to start

Preferred Qualifications:

  • Migration of Oracle to Aurora PostgreSQL with over 70TB migrating from Oracle to Aurora
  • Experience using Generative AI to tune SQL statements
  • Experience with CBP
  • Java Experience
  • Experience with other AWS data related services
  • Experience with any of the following: Struts, Hibernate, Java, JSF, Swing, JavaScript, Bootstrap, Angular.
  • Experience with CI/CD, SecDevOps, Git source code repository (GitLab, GitHub), Ancient History Asset Management Operating Systems Computer Networks Wide Area Networks Category 5 Cabling Data Transmissions Incident Management Local Area Networks Design Specifications Information Assurance Valid Driver's License Border Gateway Protocol Communications Security Configuration Management Hot Standby Router Protocol Juniper Network Technologies Open Systems Interconnection Brocade Network Technologies Multiprotocol Label Switching Open Shortest Path First (OSPF) Troubleshooting (Problem Solving) Virtual Local Area Network (VLAN) Virtual Router Redundancy Protocols Transmission Control Protocol (TCP)

Benefits & conditions

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available at www.leidos.com/careers/pay-benefits .

About the company

If you're looking for comfort, keep scrolling. At Leidos, we outthink, outbuild, and outpace the status quo - because the mission demands it. We're not hiring followers. We're recruiting the ones who disrupt, provoke, and refuse to fail. Step 10 is ancient history. We're already at step 30 - and moving faster than anyone else dares., Leidos is an industry and technology leader serving government and commercial customers with smarter, more efficient digital and mission innovations. Headquartered in Reston, Virginia, with 47,000 global employees, Leidos reported annual revenues of approximately $16.7 billion for the fiscal year ended January 3, 2025. For more information, visit www.Leidos.com .

Apply for this position