What are the responsibilities and job description for the DB2 Database Administrator position at Elite IT Solutions Inc?
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