Application Database Engineer - PostgreSQL and AlloyDB

CGI GroupFairfax, 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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume

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

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service