Matlen Silver
Base pay range
$60.00/hr - $65.00/hr Job Title:
Db2 Database Administrator Duration : 12 months with extension possible to 18 months Other Approved Locations:
Charlotte, NC / Chandler, AZ / Richmond, VA / Jacksonville, FL / Atlanta, GA / Hopewell, NJ Pay Scale:
$60-65/hr W2 (Cannot subcontract or C2C) Job Description: Matlen Silver has partnered with a leading global financial services firm to recruit a Db2 DBA with extensive experience installing and managing relational databases running on z/OS. Your primary responsibility will be to ensure optimal Db2 database efficiency and security by analyzing database issues and monitoring database performance. Responsibilities Develop log scraping strategies to limit CPU, memory usage, and staging space while log scraping. Build Splunk dashboards to monitor the Db2 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, 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. Qualifications Position requires in-depth Mainframe Db2 on z/OS knowledge with a focus on performance tuning. Minimum of 7 years of Db2 DBA experience on z/OS. Experience working at a large financial institution is preferred. Working knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performance. 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. In depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities. Understanding of SMF data and reporting. Knowledge of Splunk Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at info@matlensilver.com or 908-393-8600. Seniority level:
Mid-Senior level Employment type:
Contract Job function:
Information Technology Industries:
Financial Services, Banking, and Capital Markets Matlen Silver is committed to equal opportunity in employment and hiring practices. #J-18808-Ljbffr
$60.00/hr - $65.00/hr Job Title:
Db2 Database Administrator Duration : 12 months with extension possible to 18 months Other Approved Locations:
Charlotte, NC / Chandler, AZ / Richmond, VA / Jacksonville, FL / Atlanta, GA / Hopewell, NJ Pay Scale:
$60-65/hr W2 (Cannot subcontract or C2C) Job Description: Matlen Silver has partnered with a leading global financial services firm to recruit a Db2 DBA with extensive experience installing and managing relational databases running on z/OS. Your primary responsibility will be to ensure optimal Db2 database efficiency and security by analyzing database issues and monitoring database performance. Responsibilities Develop log scraping strategies to limit CPU, memory usage, and staging space while log scraping. Build Splunk dashboards to monitor the Db2 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, 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. Qualifications Position requires in-depth Mainframe Db2 on z/OS knowledge with a focus on performance tuning. Minimum of 7 years of Db2 DBA experience on z/OS. Experience working at a large financial institution is preferred. Working knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performance. 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. In depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities. Understanding of SMF data and reporting. Knowledge of Splunk Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at info@matlensilver.com or 908-393-8600. Seniority level:
Mid-Senior level Employment type:
Contract Job function:
Information Technology Industries:
Financial Services, Banking, and Capital Markets Matlen Silver is committed to equal opportunity in employment and hiring practices. #J-18808-Ljbffr