Serving Maryland and the Greater Washington D.C. area, SageCor Solutions (SageCor) is a growing company bringing complete engineering services and true full lifecycle System Engineering services to areas requiring (or desiring) nationally-recognized expertise in high performance computing, large data analytics and cutting edge information technologies.
Active TS/SCI w/ Polygraph required.
Description: The candidate shall 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.
Consistent with federal and state law where SageCor conducts business, SageCor Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, or any other protected class.