DB2 Database Administrator

Hi,

Please find the job description below

Job Title: DB2 Database Developer/Administrator

Location: Jacksonville, FL

Job Description

Responsibilities include 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, Data replication products such as IIDr with CDC.

Day-to-Day Activities

• Plan subscriptions to keep related set of tables together while keeping the maintenance to minimum
• Setting up notifications (alerts alarms)
• Build Splunk dashboards to monitor the replication environment
• Work with other DB2 teams in setting up log retention policies to cover for extended period of outages
• 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
• Support of product upgrades related to DB2 replication 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
• 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
• Position requires in-depth Mainframe DB2 DBA (DB2 on z/Os) knowledge with a focus on replication

Skills

• Individual should have minimum of 5 years of DB2 DBA experience on z/Os. A minimum of 1 year experience with data replication in particular with IIDR using CDC
• Job stability is a key requirement
• In depth working knowledge IBM Infosphere Change Data Capture
• Experience with DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including Change Manager, Catalog Manager, Mainview, and SQL Performance
• Strong understanding of VSAM file structures and IDCAMS utility
• Solid understanding of DB2 recovery options
• Broad understanding of ACF2 and RACF2 managed security for DB2 Access
• Working knowledge of Endevor
• Working knowledge of ITSM Processes and tools including BMC Remedy
• Strong communication skills