Job
Description
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. Education, Technical Skills & Other Critical Requirement Education Bachelor s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience. Experience (In Years) 10+ Years Total IT experience & 7+ Years relevant experience in UDB database Technical Skills 7+ years of 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) 6 years Unix and Linux operating systems and 3 years 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 Requirements 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
