Peterson Technologies

Builds data systems for intelligence agencies

Database Engineer

Database AdministrationConfirmed live in the last 24 hours

Full-timeAnnapolis Junction, MD, USA$185k - $230kIn-person

About the Job

Requirements

Ten years of experience as a database engineer in programs and contracts of similar scope, type, and complexity is required.
A bachelor's degree in a technical discipline from an accredited college or university is required; five years of database engineering experience may substitute for the degree.
Experience with PostgreSQL and PostGIS is required.
Strong SQL skills and experience with performance tuning and query optimization are required.
Proficiency in Linux/Unix environments and command-line interface tools such as psql is required.
Experience with logical and physical replication, partitioning, and backup strategies is required.
Familiarity with monitoring tools such as pg_stat_statements, Prometheus, and Grafana is required.
Knowledge of scripting languages for automation and tooling is required.
An in-scope polygraph within the past seven years is required.

Responsibilities

Provide technical expertise in database design, development, implementation, information storage and retrieval, data flow, and analysis.
Develop relational and/or object-oriented databases, database parser software, and database loading software.
Project long-range requirements for database administration and design.
Develop a database structure that fits the overall system architecture, balancing data volumes, number of users, logical and physical distribution, response times, retention rules, security, and domain controls.
Work primarily at the front end of the lifecycle, from requirements through system acceptance testing and Initial Operational Capability.
Develop requirements from project inception through conclusion for a particular business and information technology subject matter area, covering simple to complex systems.
Assist with recommendations for, and analysis and evaluation of, systems improvements, optimization, development, and maintenance efforts.
Translate requirements and data into usable documents by creating or recreating ad hoc queries, scripts, and macros; update existing queries; create new queries to manipulate data into a master file; and build complex systems using queries, tables, Open Database Connectivity, and cloud-based database storage and retrieval.
Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability.
Monitor and tune database performance using native tools and custom scripts.
Implement and maintain high-availability and replication strategies.
Collaborate with developers to refine complex queries and stored procedures.
Automate routine tasks using scripting languages such as Bash and Python.
Document database architecture, processes, and best practices.

Desired Qualifications

Experience with containerized environments such as Docker and Kubernetes is preferred.
Familiarity with cloud platforms such as AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL is preferred.
Understanding of CI/CD pipelines and infrastructure as code tools such as Terraform and Ansible is preferred.
Exposure to other relational database management systems such as Oracle and MySQL, or NoSQL systems, is a plus.

Description:
Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

Experience Required:
Required Skills/Qualifications:
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; TS/SCI clearance with polygraph is required.

Ten (10) years’ experience as a DBE in programs and contracts of similar scope, type, and complexity is required. Bachelor’s degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelor’s degree.
The candidate must have experience with PostgreSQL and PostGIS.

Key Responsibilities:
• Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability.
• Monitor and tune database performance using native tools and custom scripts.
• Implement and maintain high availability (HA) and replication strategies.
• Collaborate with developers to refine complex queries and stored procedures.
• Automate routine tasks using scripting languages (e.g., Bash, Python).
• Document database architecture, processes, and best practices.

Required Qualifications:
• Strong SQL skills and experience with performance tuning and query optimization.
• Proficiency in Linux/Unix environments and CLI tools like psql.
• Experience with logical and physical replication, partitioning, and backup strategies.
• Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).
• Knowledge of scripting languages for automation and tooling.

Preferred Qualifications:
• Experience with containerized environments (Docker, Kubernetes).
• Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL).
• Understanding of CI/CD pipelines and infrastructure as code (Terraform, Ansible).
• Exposure to other RDBMS (e.g., Oracle, MySQL) or NoSQL systems is a plus.

This position requires in-scope poly, within 7 years.

Peterson Technologies provides for an excellent benefit package to include generous PTO, healthcare, STD, LTD, Life Insurance, 401k contribution and Tuition and Training reimbursement.
Salary range depending on experience - $185,000 - $230,000

Peterson Technologies will provide reasonable accommodations to applicants who are unable to utilize our online application system due to a disability.
Please send your request to HR at [email protected] or call.

Peterson Technologies is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

About the Company

Peterson Technologies

Builds data systems for intelligence agencies

Peterson Technologies builds custom software and information systems for intelligence agencies that need to turn large volumes of data into usable information. Its engineers design, integrate and deploy systems around each customer's mission, then maintain the software and infrastructure through ongoing support. The firm also develops analytical tools for finding patterns in structured and unstructured data, with decision support that includes language processing, speech translation and image recognition. Customers hire the firm for engineering projects and continuing technical support across the systems lifecycle. Founded in 2001, Peterson Technologies is headquartered in Elkridge, Maryland.

Company size: 51-200
Company stage: Not listed
Total funding: Not listed
Headquarters: Elkridge, MD
Founded: 2001

Recently Posted Jobs

Explore more opportunities at Peterson Technologies

See more jobs