Azure Lead Engineer

Req ID 248733NTT DATA Services strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Azure Lead Engineer to join our team in Bangalore Karnxc4x81taka IN-KA India IN Preferred Experience Ideal candidate has been supporting traditional server based relational databases DB2 Postgresql and MongoDB for over 6 years out of which last 3 years in public cloud environments Azure AWS GCP DB2-installation and maintenance of the databases AWS GCP DB2 upgrades and patches checkouts performance and capacity monitoring management and security compliance AWS GCP Monitoring health check jobs like Image copy Runstats DDL DML reports Rebalancing of Partitions AWS GCP Space Management and Monitoring Performed End-to-End Release activities Creating and scheduling utilities like COPY Reorg RUNSTATS and QUIESCE Running Adhoc Reorgs Runstats and Rebinds in Productions Environment Implementing and scheduling production DB2 jobs - AWS GCP Monitoring on daily weekly and monthly batch cycles Hands-on experience with PostgreSQL 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 AWS AZURE 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 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 Basic Qualifications 6 years of overall operational experience 3 years of Azure AWS GCP experience as a cloud DBA DB2 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 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 Preferred Certifications Azure fundamentals certification AZ-900 - preferred Azure Database Certification DP-300 - preferred AWS Certified Database Specialty - preferred DB2 Postgresql certification a plus Google Cloud Engineer - preferred Four Year BS BA in Information Technology degree or equivalent experienceAbout NTT DATA ServicesNTT DATA Services is a recognized leader in IT and business services including cloud data and applications headquartered in Texas As part of NTT DATA a 30 billion trusted global innovator with a combined global reach of over 80 countries we help clients transform through business and technology consulting industry and digital solutions applications development and management managed edge-to-cloud infrastructure services BPO systems integration and global data centers We are committed to our clients long-term success Visit nttdata com or LinkedIn to learn more NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race color religion citizenship national origin ancestry age sex sexual orientation gender identity genetic information physical or mental disability veteran or marital status or any other characteristic protected by law We are committed to creating a diverse and inclusive environment for all employees If you need assistance or an accommodation due to a disability please inform your recruiter so that we may connect you with the appropriate team LI-MIWS