IBM DB2(UDB) Database Administrator

Location: Pune, Noida, Hyderabad Job 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 databases Education & 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