
Digital Technology - Lead Engineer
- Noida, Uttar Pradesh
- Permanent
- Full-time
- 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 L2/L3 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.
- Work directly with end customer, business stakeholders as well as technical resources."
- 7+ years of overall operational experience
- 4+ 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
- 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,mongo db atlas
- Experience with python / powershell scripting - preferred
- Secondary skill in MySQL/oracle - preferred
- Installation, configuration and upgrading of postgresql server software and related products