Job description
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
Required Skill Profession
Computer Occupations