Database Engineer Sr Stf - E5

Standard Job Description

Designs, develops, builds, analyzes, evaluates and installs database management systems to include database modeling and design, relational database architecture, metadata and repository creation and configuration management. Uses data mapping, data mining and data transformational analysis tools to design and develop databases. Determines data storage and optimum storage requirements. Prepares system requirements, source analysis and process analyses and design throughout the database implementation.

Basic Qualifications

• Five (5) 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.

• 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).

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.

• 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.