You are visiting this website from:
Find Talent Find a Job

Database Administrator

Back to all Jobs

Job Summary

  • Singapore
  • Contract
  • BBBH832381
  • Oct 27, 2022
  • Competitive
Job Description

We are looking for a Technical Consultant on a 12-Month contract with the possibility of extension or conversion to a permanent position based on the performance and business needs.

This role will support DB2 Applications and DB2 Infrastructure support for Consumer, Card, Global wealth management business, using mainframe database administration skills.

Roles and Responsibilities:

  • Full life cycle management of DB2 mainframe databases from analysis through decommission. Additionally the Individual will be involved in DB2 related z/Os Database software upgrades, including DB2 Database, DB2 Connect, BMC and Shadow products.
  • Provision of technical consultation to application teams during the design of database solutions in regard to approach, resources, availability and recoverability.
  • Translation of business requirements into a physical model for implementation with a focus on a clear understanding of processing requirements (peak times, # trans etc), performance, availability, recoverability, and data access methods.
  • Consulting with the application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access.
  • Defining and implementing application specific backup and recovery strategies for the production environment.
  • Implement, change, remove database owned components ensuring adherence to Enterprise and database standards.
  • Support of product upgrades related to DB2 providing a focal communication point for development teams as well as completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new feature/function and providing recommendations for use.
  • Performance tuning support and recommendations for database calls, in cooperation with the application development team.
  • Monitoring and addressing items on exception reports to ensure a stable production environment
  • Supplying database technical expertise to application developers by assisting in development debugging efforts related to database and providing information on the various database utilities and facilities
  • Support DBA production on call rotation including 24X7 SEV1 test support.
  • Conduct information sharing meetings with the application teams when requested.
  • Support of Self Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met.

Requirements:

  • In-depth Mainframe DB2 DBA knowledge with a focus on performance and DB2 with a minimum of 5 years of DB2 DBA experience on z/OS.
  • In depth working knowledge of DB2 Utilities including IBM and BMC.
  • Working knowledge of BMC tools including change manager, catalog manager, Mainvew, and SQL performance.
  • Solid understanding of DB2 recovery options
  • In-depth understanding of DB2 Explain and ability to identify less than optimal access paths
  • Broad understanding of ACF2 and RACF2 managed security for DB2 Access.
  • Working knowledge of Endevor
  • Working knowledge of ITS Processes and tools including BMC Remedy
  • Understanding of Data Dictionaries including Brownstone.

If you feel that you have the right skills or experience for this role, please apply to this job or send your CV to gqlow@morganmckinley.com.

Only shortlisted candidates will be responded to, therefore if you do not receive a response within 14 days, please accept this as notification that you have not been shortlisted.

Guo Qiang Low
Morgan McKinley Pte Ltd
EA Licence No: 11C5502 | EAP Registration No: R22104891

broadbean-tracking