onsite
PostgreSQL Database Developer - Contact Government Services, LLC
Software Engineer
Senior PostgreSQL developer leading migration from Oracle to PostgreSQL, managing database environments, optimizing performance, and supporting a growing data analytics platform for federal clients.
About the role
Key Responsibilities
- Lead the migration of enterprise data from Oracle to PostgreSQL, ensuring data integrity and minimal downtime.
- Design, implement, and maintain PostgreSQL database schemas, indexes, and partitions for high‑throughput analytics workloads.
- Develop and optimize complex SQL queries, stored procedures, and ETL pipelines to support business intelligence reporting.
- Monitor database performance, conduct tuning, and implement best‑practice configurations for scalability and reliability.
- Collaborate with data engineers and analysts to translate business requirements into robust database solutions.
Requirements
- 5+ years of experience with PostgreSQL and Oracle database administration.
- Strong proficiency in SQL, PL/pgSQL, and performance tuning techniques.
- Hands‑on experience with data migration tools and ETL processes.
- Knowledge of database security, backup/recovery, and high‑availability architectures.
- Excellent problem‑solving skills and ability to work in a fast‑paced, federal‑service environment.
Skills
postgresqloraclesql