IBM DB2(UDB) Database Administrator

Location: Pune, Noida, HyderabadJob Responsibilities:● Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex IBM DB2/LUW databases from version 10.1 to 11.5/12.1 on AIX and RedHat Linux on VM and Cloud (Azure,AWS)● Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance.● Design, implement and maintain automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform.● Develop and manage of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic.● Cross OS platform database migration and upgradation.● Identifies and resolves problem utilizing structured tools and techniques.● Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance.● Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards.Technical Skills:● Strong work experience with database design, installation configuration and implementation; knowledge of all key IBM DB2/LUW utilities such as HADR, Reorg, run stats, Load on (Linux/Unix/Windows)● Expertise in Unix and Linux operating systems and shell scripting.● Expertise in database migration, Upgradation and Patching.● Strong experience in cloud computing (Azure, AWS RDS, IBM Cloud PAK).● Experience with backups, restores and recovery models and implementation of Backup strategies mandatory including RTO and RPO with tools (Rubrik,Networker,BCV).● Very good experience in managing of database elements, including creation, alteration, deletion and copying of schemas,databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints ● Experience in IBM db2 LUW replication (Db2 SQL replication and Q Replication, a Queue -based Replication) as well as using Third party tools for Replications.● Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools (Explain plan, Db2 reorg, Db2 run stats).● Strong knowledge of Clustering, High Availability (HA/HADR) and Disaster Recovery (DR) options for DB2 LUW.● Strong Knowledge of data security (User Access, Groups and Roles) and Data encryption (at rest and in transit) for DB2 LUW.● Should have ability to work closely with IBM-PMR to resolve any ongoing production issues.● Experience administering IBM Informix databases is a Big Plus.● Good knowledge on ITSM Processes like Change, Incident, Problem, Service Management using ServiceNow tools.● Strong database analytical skills to improve application and database performance.● Automation tools and programming skills such as Ansible, Perl,Shell scripting and MS PowerShell.● Strong knowledge Database monitoring with Observability tools (Elastic)● Understanding of modern IT infrastructure such as Cloud Architecture as well as Agile DevOps Framework.● Participates in a 24X7 oncall rotation, providing Subject Matter Expert support to the on call DBA as needed● Strong Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills● Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders.Other Critical Requirement:● Project management experience is required to follow the Agile methodology to improve and deliver the project or operational excellence.● DB2/LUW database administration/advanced database administration for experts certification is preferred.● Demonstrate ability to work independently and in a team environment● Ability to work 24*7 rotational shift to support for production, development, and test databasesEducation & Experience: ● Bachelor’s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience.● 10+ Years Total IT experience & 7+ Years relevant experience in UDB database