Application Database Engineer - PostgreSQL and AlloyDB

CGI Group • Fairfax, VA

73d • $88,200 - $214,800

About The Position

CGI Federal is a leading technology company dedicated to delivering innovative solutions and services. We are seeking a skilled Application Database Engineer with expertise in PostgreSQL and AlloyDB on Google Cloud Platform (GCP) to join our dynamic team. As an Application Database Engineer specializing in PostgreSQL and AlloyDB on Google Cloud Platform (GCP), you will be responsible for managing and optimizing our database systems to ensure high performance, reliability, and scalability. You will work closely with cross-functional teams to implement best practices in database management and support our applications and services. This position is located in Fairfax, VA.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Engineer or similar role, with a focus on PostgreSQL and AlloyDB on Google Cloud Platform (GCP).
• Strong knowledge of PostgreSQL and AlloyDB, including database management and SQL.
• Experience with GCP services such as Cloud SQL and AlloyDB.
• Familiarity with database design, performance tuning, and optimization techniques.
• Understanding of data security and compliance requirements.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

Nice To Haves

• GCP certification(s) related to database management or cloud engineering.
• Experience with automation and scripting languages (e.g., Python, Bash).
• Knowledge of containerization and orchestration tools (e.g., Kubernetes, Docker).

Responsibilities

• Manage instance backups for PostgreSQL and AlloyDB, including scheduling and on-demand backups.
• Perform database and table exports.
• Implement retention and archival strategies.
• Automate backup processes to ensure data integrity and availability.
• Execute instance and database imports for PostgreSQL and AlloyDB.
• Perform table recovery in cases of data corruption or missing data, both partial and full.
• Develop and implement automation for restore and recovery processes.
• Monitor database performance and set up alerting systems for PostgreSQL and AlloyDB.
• Manage users and service accounts.
• Conduct performance tuning and scaling up of database resources.
• Oversee connection management, vacuuming, and indexing.
• Develop scripts to automate administrative tasks.
• Diagnose and resolve issues related to sessions, SQL, performance, and connections in PostgreSQL and AlloyDB.
• Create and maintain scripts to facilitate troubleshooting processes.
• Develop and manage processes for data release and rollback to ensure smooth deployment and recovery.
• Maintain a comprehensive script repository for all database management and troubleshooting tasks.

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and Well-being programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees