Hybrid SQL Architect - PostgreSQL, MySQL & ETL

Njoyn; Fairfax (VA); Hybrid; USD 90,000 - 198,000; Full time

Job summary

CGI is seeking an experienced SQL Developer to design, optimize, and scale PostgreSQL and MySQL databases, build robust ETL pipelines, and bridge relational data with NoSQL solutions like MongoDB. The role supports hybrid work locations in Fairfax, VA or Lafayette, LA.

Responsibilities include designing scalable schemas, writing complex queries, optimizing performance, and ensuring data security and integrity across platforms. Requires a BS in CS/IT and hands-on RDBMS experience.

Qualifications

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
• RDBMS Expertise: Strong, hands on production experience engineering databases with PostgreSQL and MySQL.
• ETL Proficiency: Proven experience building data pipelines using ETL tools (e.g., Apache Airflow, Talend, AWS Glue) or custom scripting languages.
• NoSQL Familiarity: Conceptual and practical understanding of NoSQL database architecture, specifically MongoDB, including basic querying and JSON/BSON document structures.
• Tooling: Proficiency with database management utilities such as pgAdmin or MySQL Workbench alongside version control systems like Git.
• Problem Solving: Exceptional analytical skills with a proven track record of diagnosing complex data performance anomalies and tuning slow running queries.

Responsibilities

• Database Design & Development: Build and maintain scalable relational schemas, tables, views, and constraints across PostgreSQL and MySQL.
• Advanced Scripting: Write and optimize complex queries, triggers, CTEs, and stored procedures tailored to dialect features (e.g., PL/pgSQL).
• ETL Pipeline Engineering: Design, implement, and monitor ETL/ELT data pipelines to extract, transform, load data into target systems.
• Performance Tuning & Optimization: Optimize queries, manage indexing, resolve deadlocks and bottlenecks.
• Hybrid Data Collaboration: Integrate relational data with NoSQL stores like MongoDB for unstructured data workflows.
• Data Integrity & Security: Establish data security protocols, manage user roles/permissions, back up strategies.

Skills

PostgreSQL

MySQL

ETL pipelines

NoSQL MongoDB

Query optimization

Education

Bachelor's degree in Computer Science/Information Technology

Tools

pgAdmin

MySQL Workbench

Job description

CGI is seeking an experienced SQL Developer to design, optimize, and scale PostgreSQL and MySQL databases, build robust ETL pipelines, and bridge relational data with NoSQL solutions like MongoDB. The role supports hybrid work locations in Fairfax, VA or Lafayette, LA.

Responsibilities include designing scalable schemas, writing complex queries, optimizing performance, and ensuring data security and integrity across platforms. Requires a BS in CS/IT and hands-on RDBMS experience.