Application Database Engineer - PostgreSQL and AlloyDB

CGI Deutschland-posted 2 months ago
$88,200 - $214,800/Yr
Full-time • Mid Level
Fairfax, VA
Professional, Scientific, and Technical Services
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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).
  • 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
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service