Database Engineer
Peterson Technologies2 months ago
Annapolis Junction, MD, USASenior
Base Salary
$185k - $230k/yr
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 and replication strategies.
- Collaborate with developers to refine complex queries and stored procedures.
- Automate routine database tasks using Bash, Python, and other scripting languages.
- Document database architecture, processes, and best practices.
- Develop database requirements, structures, queries, scripts, and data-loading solutions across the system lifecycle.
- Analyze and recommend system improvements, optimization, development, and maintenance efforts.
Requirements
- Ten years of database engineering experience on programs or contracts of similar scope, type, and complexity.
- Bachelor’s degree in a technical discipline, with five years of database engineering experience permitted as a substitution.
- TS/SCI clearance with polygraph and an in-scope polygraph within seven years.
- Experience with PostgreSQL and PostGIS.
- Strong SQL skills, including performance tuning and query optimization.
- Proficiency in Linux or Unix environments and command-line tools such as psql.
- Experience with logical and physical replication, partitioning, and backup strategies.
- Familiarity with pg_stat_statements, Prometheus, and Grafana.
- Knowledge of scripting languages for automation and tooling.
- Preferred experience includes Docker, Kubernetes, AWS RDS, GCP Cloud SQL, Azure Database for PostgreSQL, Terraform, Ansible, Oracle, MySQL, and NoSQL systems.
Benefits
- Generous paid time off.
- Healthcare, short-term disability, long-term disability, and life insurance.
- 401(k) contribution.
- Tuition and training reimbursement.
- Salary range is $185,000-$230,000 depending on experience.
Tech Stack
Categories
BackendData Engineering
About Peterson Technologies
Peterson (Control Union) provides inspections, certifications, testing, logistics, and collateral management services to commodity supply chains in sectors such as agriculture, energy, and industry. It operates a fee-for-service model supported by a global network of offices and laboratories in more than 70 countries. The company was founded in 1920, is privately held, and is headquartered in Rotterdam.