| Essential - Production operational support experience for IBM DB2 (11.1/11.5) within and enterprise Linux/AIX environment.
- Must have an understanding of database disaster recovery/high availability technologies including DB2 HADR, QREP.
- Experience of supporting AWS RDS databases.
- Ability to plan and implement technical changes without unexpected disruption to the service and with some oversight.
- Ability to write Korn/awk shell / Python scripts for database maintenance and monitoring.
- Database performance tuning for bufferpools, indexes, access plan optimisation.
- Experience of providing production support activities for business critical databases/applications.
- Good documentation and technical writing skills.
- Must have excellent analytical and problem solving skills.
- Experience in working with ITIL ticket systems such as Service Now and an understanding of priorities and SLA's.
- Ability to collaborate effectively with other operational support teams in to support the service.
- Experience of providing cross training on technologies and operational processes to colleagues
- Have excellent time management and organisational skills
- Knowledge of ITIL framework (understanding of Incident, Problem, Change)
Desired - Knowledge of Banking systems and related industry standard practices
- Operational Support experience of Microsoft SQL Server in an Enterprise Windows environment.
- Experience in working and configuring monitoring systems such as Dynatrace.
- Working knowledge of PostgreSQL and Oracle
Operational - Provide operational support for the IBM DB2 Server and Oracle database environments. Responsibilities include database backup/restores, daily checks, maintenance tasks and building new database instances and applying service packs. Manage and escalate problems as appropriate.
- Investigate defects or problems, work with internal CLS Development team and external vendors to identify solutions and support any fixes that are required as part of service improvement.
- Provide support for database and InfoSphere QREP recovery exercises.
- Follow the CLS Change Management procedure and other standard practices in installing, configuring and supporting databases and related items in Test and Production environments.
- Ensure that the BAU Service is prioritised and all faults, incidents and problems are responded to in an efficient manner without negatively impacting SLAs and reporting metrics in place.
- IBM DB2 Performance tuning analysis and alerting.
- Work with Security Analysts to support DB2 security policies.
- Install, upgrade or maintain software at a time when the impact to the business is minimised.
- Execute the failover for the database and application services as required. Participate in regular Disaster Recovery testing activities.
- Create, maintain and review operational process and support documentation.
- Provide 24/7 on-call cover on a rotational shift basis.
- Participate in planned weekend work as required.
Strategic - Ensure CLS internal database systems are managed to the highest standard by following industry best practice.
- Demonstrate good problem management ownership and prevention of SLA breach under Incident/Problem Management processes.
- Where appropriate, contribute to the development of existing and new IT process and procedures to enhance service transition and service operation lifecycle stages.
Leadership - Through example and behaviour, strive to provide peer leadership to other team members ensuring a level of excellence is achieved in delivering the service.
- Participate in the successful release and transition of new database services into support, meeting the team's service acceptance criteria
Success Factors - Possess a strong service-oriented mind set who can consistently deliver a high level of service to the business.
- Proactive individual who can take the lead in engaging with the business users and to support the environment with minimal oversight.
- Self-motivated to exceed management expectations and objectives.
- Demonstrate strong technical, analytical and problem solving skills.
- Able to manage their time effectively and prioritise their own workload in order to meet changing demands from the business.
- A high level of presentation and communications skills with the ability to communicate confidently with both business and technical staff at all levels.
- Ability to engage with the business to effectively support the environment with minimal oversight.
| Qualifications / certifications | | Essential - Bachelor's degree or equivalent
- Prior IT operational support experience across business critical Production infrastructure, applications and database services.
Desired - IBM DB2 certification
- AWS Certified Database - Specialty
- ITIL certification
| Thanks and Regards, Rajiv Kumar Associate Manager Corporate Office: 650 Wilson Lane, Suite 201, Mechanicsburg, PA 17055 Testingxperts Inc DBA Damcosoft P: +1 Ext 518 E: |