Application Database Engineer

CGI•Fairfax, VA

23h•Hybrid

About The Position

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 can be located at any CGI office in the U.S, preferred location is Fairfax, VA; however, a hybrid working model is acceptable. Your future duties and responsibilities: Database Backups: 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. Database Restore & Recovery: 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. Database Administration: 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. Troubleshooting: Diagnose and resolve issues related to sessions, SQL, performance, and connections in PostgreSQL and AlloyDB. Create and maintain scripts to facilitate troubleshooting processes. Data Release and Rollback Processes: Develop and manage processes for data release and rollback to ensure smooth deployment and recovery. Script Repository: Maintain a comprehensive script repository for all database management and troubleshooting tasks.

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.