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.

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.

Security Clearance Required: TS/SCI with Poly
About Avid Technology Professionals
Avid Technology Professionals, LLC (ATP) is a premiere provider of software and systems engineering, and acquisition program management services for the community. ATP is actively seeking to pursue contract opportunities with other departments and agencies in the federal government, in state governments, and in the commercial sectors. Delivered by seasoned experts in the IT field, ATP solutions adeptly address the IT concerns manifesting in both the federal and commercial sectors.
Employee Benefits
 The ATP Employee Benefits package includes:

• A Supportive and Equitable Working Environment that is both Stimulating and Challenging
• Competitive Hourly Salary
• Unique Employee Success Sharing Program that allows ATP employees to Share in Company's Successes
• Automatic Approved Overtime (as long as contract permits)
• Retirement Pay (401K); 100% company paid, immediately vested with Profit-Sharing Component
• Company Medical Coverage Plans - HMO, Open Access, PPO plans
• Company Dental Plan - widely accepted, comprehensive, and flexible
• Progressive Overtime Policy
• Flexible Spending Account benefit
• Lucrative Referral Bonus Policy
• Holiday Scheduling that Coincides with Government Holidays
• Robust Professional Expenses & Training Program
• Computer Allowance
• Internet Allowance
• Short and Long Term Disability
• Life Insurance