DB2 Database DeveloperAdministrator

Jacksonville, FL - USA

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

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

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 ...