GCP Engineer Job at NTT DATA (Noida)

Job Description

The GCP Engineer role involves managing PostgreSQL and MongoDB databases in cloud environments, particularly GCP. The ideal candidate should have over 3 years of operational experience, with a strong focus on customer service and communication skills. Responsibilities include optimizing SQL queries, implementing backup strategies, and providing technical mentorship.

Job Responsibility

Managing PostgreSQL and MongoDB databases in cloud environments, particularly GCP
Optimizing SQL queries
Implementing backup strategies
Providing technical mentorship
Supporting traditional server based relational databases (SQL server, PostgreSQL, Redis DB and MongoDB)
Managing PostgreSQL databases on AZURE, GCP and AWS RDS
Setting up and managing monitoring tools for PostgreSQL on GCP
Configuring alerts based on performance metrics
Implementing and testing backup and recovery strategies for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL
Designing and implementing disaster recovery plans for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL
Identifying and resolving performance bottlenecks in PostgreSQL databases
Optimizing database configurations for better performance
Providing 24*7 shift hours support at L1/L2 level
Updating KB articles, Problem Management articles, and SOPs/runbooks
Delivering timely and outstanding customer service
Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
Working directly with end customer, business stakeholders as well as technical resources
Query fine tuning - MongoDB
Writing shell scripts for Monitoring
Performing Backup and restores
Conducting Database Health checks
Performing Upgrades
Performing Maintenance
Architecture design as per the Application requirement
Writing best practices documents
Performing Log rotation/ maintenance
Segregation of duties (User Management)
Designing DR (Disaster Recovery)/COB (Continuity of Business) plans
Database Profiling
Export and Import of Data to and From MongoDB
Data Managements in MongoDB
Monitoring of Various issues related with Database
Database software Installation and Configuration
Database Migrations and Updates
Capacity management- MongoDB
Server Performance tuning and Recommendations
Providing High availability solutions and recommendations
Root cause analysis for business impacting issues

Requirements

3+ years of overall operational experience
2+ years of GCP experience as a cloud DBA (PostgreSQL/Mongo DB)
3+ years of experience working in diverse cloud support database environments in a 24*7 production support model
B.Tech/BE/MCA in Information Technology degree or equivalent experience
Azure fundamentals certification (AZ-900) - REQUIRED
Google Cloud Associate Engineer - REQUIRED
Hands-on experience with PostgreSQL/MongoDB, including installation, configuration, performance tuning, and troubleshooting
Demonstrated expertise in managing PostgreSQL databases on AZURE, GCP and AWS RDS
Experience with features such as automated backups, maintenance, and scaling - PostgreSQL
Ability to Analyze and optimize complex SQL queries for performance improvement
Proficiency in setting up and managing monitoring tools for PostgreSQL on GCP
Experience with configuring alerts based on performance metrics
Experience in implementing and testing backup and recovery strategies for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL
Knowledge and experience in designing and implementing disaster recovery plans for PostgreSQL databases on AWS RDS/AZURE SQL/GCP Cloud SQL
Good Understanding of database security principles and best practices
Proven ability to identify and resolve performance bottlenecks in PostgreSQL databases
Experience in optimizing database configurations for better performance
Able to provide 24*7 shift hours support at L1/L2 level
Experience in updating KB articles, Problem Management articles, and SOPs/runbooks
Passion for delivering timely and outstanding customer service
Great written and oral communication skills with internal and external customers
Strong ITIL foundation experience
Ability to work independently or no direct supervision
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
Work directly with end customer, business stakeholders as well as technical resources
Query fine tuning - MongoDB
Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fails, disk usage. etc
Backup and restores (Backups should be automated with shell scripts/Ops Manager)
Database Health check (Complete review of Database slow queries, fragmentation, index usage. etc)
Upgrades (Java version, Mongo version. etc)
Maintenance (Data Centre outages etc)
Architecture design as per the Application requirement
Writing best practices documents for shading, replication for Dev/App teams
Log rotation/ maintenance (mongos, MongoDB, config etc)
Segregation of duties (User Management – designing User roles and responsibilities)
Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable
Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
Export and Import of Data to and From MongoDB, Run time configuration of MongoDB,
Data Managements in MongoDB Capped Collections Expired data from TTL,
Monitoring of Various issues related with Database,
Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB,
Database software Installation and Configuration in accordance with Client defined standards.
Database Migrations and Updates
Capacity management- MongoDB
Hands on experience in Server Performance tuning and Recommendations
High availability solutions and recommendations
Hands on experience in Root cause analysis for business impacting issues.
Experience with SQL, SQL Developer, TOAD, Pgadmin, MongoDB atlas

Nice to have

Experience with python / PowerShell scripting - preferred
Secondary skill in MySQL/oracle - preferred
Installation, configuration and upgrading of PostgreSQL server software and related products
Azure Database Certification (DP-300) - preferred
AWS Certified Database Specialty - preferred
PostgreSQL certification a plus
MongoDB certification a plus

NTT DATA - All Job Offers

Select Country

GCP Engineer

Job Description

Job Responsibility

Requirements

Nice to have

Looking for more opportunities?

GCP Engineer

Senior Data & AI/ML Engineer - GCP Specialization Lead

Gcp Data Engineer

Senior DevOps Engineer (GCP)

GCP Cloud Engineer

Senior DevOps Engineer - AWS & GCP

Lead Software Engineer Scientific Engine

Senior Data Engineer

Intermediate / Senior Software Engineer Scientific Engine (Python)

Our AI answers in your language