Randstad Digital Americas
Job Summary
DB2 DBA
Location: Wayne, Pennsylvania
Job Type: Contract
Salary: $55 - 60 per hour
Work Hours: 9am to 5pm
Education: No Degree Required
Responsibilities
Work with other DB2 teams in setting up log retention policies to cover for extended period of outages
Translate business requirements into a physical model for implementation, focusing on processing requirements (peak times, number of transactions, etc), performance, availability, recoverability, and data access methods
Consult with application teams to ensure appropriate access is provisioned for data access
Define and implement application specific backup and recovery strategies for the production environment
Support product upgrades related to DB2 replication, providing a focal communication point for development teams and completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new features and providing recommendations for use
Provide performance tuning support and recommendations for database calls, in cooperation with the application development team
Monitor and address 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 self identified audits, control assessments, database audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverable dates are met
Experience
Minimum 7-9 years of DB2 DBA experience on z/Os at a single large financial institution
In-depth Mainframe DB2 DBA (DB2 on Z/os) knowledge with a focus on performance tuning
Experience with 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
Working knowledge of ITSM processes and tools including BMC Remedy
Job stability is a key requirement
Qualifications
7-9 years of DB2 DBA experience on z/Os at a single large financial institution
In-depth Mainframe DB2 DBA (DB2 on Z/os) knowledge with a focus on performance tuning
Experience with 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
Working knowledge of ITSM processes and tools including BMC Remedy
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
#J-18808-Ljbffr
Location: Wayne, Pennsylvania
Job Type: Contract
Salary: $55 - 60 per hour
Work Hours: 9am to 5pm
Education: No Degree Required
Responsibilities
Work with other DB2 teams in setting up log retention policies to cover for extended period of outages
Translate business requirements into a physical model for implementation, focusing on processing requirements (peak times, number of transactions, etc), performance, availability, recoverability, and data access methods
Consult with application teams to ensure appropriate access is provisioned for data access
Define and implement application specific backup and recovery strategies for the production environment
Support product upgrades related to DB2 replication, providing a focal communication point for development teams and completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new features and providing recommendations for use
Provide performance tuning support and recommendations for database calls, in cooperation with the application development team
Monitor and address 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 self identified audits, control assessments, database audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverable dates are met
Experience
Minimum 7-9 years of DB2 DBA experience on z/Os at a single large financial institution
In-depth Mainframe DB2 DBA (DB2 on Z/os) knowledge with a focus on performance tuning
Experience with 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
Working knowledge of ITSM processes and tools including BMC Remedy
Job stability is a key requirement
Qualifications
7-9 years of DB2 DBA experience on z/Os at a single large financial institution
In-depth Mainframe DB2 DBA (DB2 on Z/os) knowledge with a focus on performance tuning
Experience with 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
Working knowledge of ITSM processes and tools including BMC Remedy
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
#J-18808-Ljbffr