Captivation
Database Engineer 2 - PostgreSQL/PostGIS/Bash/Python/Grafana/Docker/AWS
Captivation, Baltimore, Maryland, United States
Database Engineer 2 - PostgreSQL/PostGIS/Bash/Python/Grafana/Docker/AWS
at
Captivation
Build to something to be proud of. Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country.
Captivation Software is looking for a mid level database engineer to assist with daily responsibilities.
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.
Security Clearance Must currently hold a Top Secret/SCI U.S. Government security clearance with a favorable polygraph; all candidates must be a U.S. citizen.
Minimum Qualifications
Five (5) years' experience as a DBE in programs and contracts of similar scope, type, and complexity.
Bachelor's degree in a technical discipline from an accredited college or university.
Five (5) years of DBE experience may be substituted for a bachelor's degree.
Required Skills
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.
Desired Skills
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 is open for direct hires only. We will not consider candidates from third party staffing/recruiting firms.
Benefits
Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)
Up to 20% 401k contribution (No Matching Required and Vested from Day 1)
Above Market Hourly Rates
$3,400 HSA Contribution
5 Weeks Paid Time Off
Company Paid Employee Medical/Dental/Vision Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries Software Development
#J-18808-Ljbffr
at
Captivation
Build to something to be proud of. Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country.
Captivation Software is looking for a mid level database engineer to assist with daily responsibilities.
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.
Security Clearance Must currently hold a Top Secret/SCI U.S. Government security clearance with a favorable polygraph; all candidates must be a U.S. citizen.
Minimum Qualifications
Five (5) years' experience as a DBE in programs and contracts of similar scope, type, and complexity.
Bachelor's degree in a technical discipline from an accredited college or university.
Five (5) years of DBE experience may be substituted for a bachelor's degree.
Required Skills
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.
Desired Skills
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 is open for direct hires only. We will not consider candidates from third party staffing/recruiting firms.
Benefits
Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)
Up to 20% 401k contribution (No Matching Required and Vested from Day 1)
Above Market Hourly Rates
$3,400 HSA Contribution
5 Weeks Paid Time Off
Company Paid Employee Medical/Dental/Vision Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries Software Development
#J-18808-Ljbffr