DB2 Administrator (8 Years of Work Exp + Min 5 Years in DB2 Admin + Exp in BMC Tool + Scripting/Automation + Customer Experience)

Senior Engineer-Db2 Database Administrator, Assurant, GCC-India

Reporting to the Global Director of Infrastructure and Products you will design, install/configure, operate, and maintain systems hardware, software, and related infrastructure. This may include directing work of less senior engineers. You will help establish strategy and adoption of new technologies in a single domain. Provide engineering design and support for multi-tenant platforms in a single domain including hardware, software, automation, and monitoring.

This position will be in Hyderabad at our India location.

Working Hours: 12:30 PM IST – 9:30 PM IST

On call support will be required on rotational basis (A week every after 3 weeks) which might be in IST or EST hours as per requirement.

What will be my duties and responsibilities in this job?

• Ensure the global stability, integrity, and efficient operation of the systems and infrastructure that support departments, and conduct/lead research on latest technologies for practical application to business problems and strategic plans.
• Demonstrate advanced application of technical skills and interpersonal competencies
• Provide direct global technical leadership and support for all requirements in developing strategy, planning, coordination, scripting, and implementation of releases, upgrades, or changes to our distributed computing environment. This includes managing several small to medium-scale projects and tasks of several complexities across the enterprise.
• Provide direct technical support for all requirements in the planning, coordination, scripting, and implementation of upgrades or changes to our Db2 database footprint.
• Perform capacity planning, performance monitoring, tuning, and prediction.
• Provide high-level support Db2 databases, ensuring proper management procedures and methodologies are followed.
• Some after-hours work will be required
• You will require participation in a daytime, on-call rotation on-call rotation to assist with incident handling for the purpose of resolving Db2 database related infrastructure issues Provide technical assistance/guidance to less experienced administrators – the rotation will be one week in three inclusive of weekends.

What are the requirements needed for this position?

As a Senior Db2 Engineer, you will be responsible for global administration and support of the Db2 database platform. You will work closely with our global teams in related technologies and platforms to support Db2 database infrastructure.

You have:

• Db2 v11.X
• Db2 v12.X
• IBM z/OS: TSO, Utilities, JCL, VSAM, RACF
• CA7, CA11: Host scheduling administration
• BMC AMI and related Admin/utility software
  • Catalogue Manager
  • Change Manager
  • DASD and recovery manager
  • Load
  • Unload
  • Copy
  • Recover
  • Reorg
  • Apptune
  • Logmaster
  • Mainview
• Language:
  • CICS
  • COBOL
  • Easytrieve
  • REXX
  • XML
• Coding Skills
  • SQL/PL
  • REXX
  • Easytrieve
• IBM DB2 Administration Suite

Education: Bachelor’s degree in Computer Information Systems or Management Information Systems, or equivalent experience.  Base education is a CIS or MIS degree with at least 5 years of technical experience in design, deployment, and support of complex RDBMS technologies.

• Overall 8 years of experience engineering and administering RDBMS.
• 5 or more years’ experience installing and supporting DBb2 databases
• 5 or more years’ experience working with IBM z/OS
• Knowledge of Db2 database internals (locking, partitioning, security, cloning)
• Ability to troubleshoot mainframe and distribute processing problems in a Db2 z/OS environment
• Experience with dependent or related technologies to Db2 databases
• Expert technical diagnostic and research skills, expert troubleshooting, issues holistically
• Work with and communicate with multiple customers
• Identify and escalate issues to management to meet Service level agreement requirements.
• Correctly assess risks of several alternatives and take appropriate actions to restore services in the event of system outages.
• Explain the technical effects of several alternative solutions to management.
• Ability to upgrade and maintain Db2 and related 3rd party software at or above release levels of N-1
• Work on a diverse team or with a diverse range of people separated geographically both in the UK and the USA

What are the preferred skills required for this role?

• Bachelor’s degree in Computer Science or Computer Engineering, or related field
• 8 years of experience engineering and administering RDBMS
• Familiarity with at least one compiled language
• Experience with Microsoft Azure Cloud and related technologies
• Experience using ServiceNow ITIL managed processes
• Experience in mass conversion, recovery, environment build and replication