Immediate need for a talented DB2 DBA/ Database Admin. This is a 12+ Months contract opportunity with long-term potential and is located in Jacksonville FL (Hybrid). Please review the job description below and contact me ASAP if you are interested.
Job ID: 23-30802
Pay Range: $60- $70/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
- 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, DB2 Connect, BMC and Shadow products.
- Day to day activities would include:
- 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.
Key Requirements and Technology Experience:
- Must have: DB2 Database/ DB2 Connect/BMC/ ACF2 and RACF2/ Endeavor/ Mainframe DB2 DBA (DB2 on Z/oS).
- Position requires in-depth Mainframe DB2 DBA (DB2 on Z/oS) knowledge with a focus on performance and DB2 internals.
- Individual should have minimum of 7-9 years of DB2 DBA experience on z/Os at a single large financial institution.
- Job stability is a key requirement.
- In depth working knowledge of DB2 Utilities including IBM and BMC.
- Working knowledge of BMC tools including change manager, catalog manager, Mainview, 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 ITSM Processes and tools including BMC Remedy.
- Understanding of Data Dictionaries including Brownstone.
- Background in database design for 24x7 availability.
- Excellent verbal and written communication skills.
Our client is a leading Banking and Finance Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
#BOA