USM
Start Date: Interview Types
Skills Mainframe, DBA, DB2 .. Visa Types Green Card, US Citiz..
DB2 DBA
Location: Plano, TX
W2 Candidates
$65 pr hr on W2
Duration: 12+ Months
Hybrid: 3 Days onsite and 2 days remote
The ideal candidate will have: Mainframe, DBA, DB2 and Z/os, Performance tuning.
Job Description
:
• Develop log scrapring 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, # 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 performance tuning.
• 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.
• experience with DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including change manager, catalog manager, Main view, 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
DB2 DBA
Location: Plano, TX
W2 Candidates
$65 pr hr on W2
Duration: 12+ Months
Hybrid: 3 Days onsite and 2 days remote
The ideal candidate will have: Mainframe, DBA, DB2 and Z/os, Performance tuning.
Job Description
:
• Develop log scrapring 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, # 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 performance tuning.
• 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.
• experience with DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including change manager, catalog manager, Main view, 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