Apex Systems
Database Administrator V
Apex Systems, Jacksonville, Florida, United States, 32290
Position: DB2/DBALocation: Jacksonville, FLDuration : 12 mo. ContractRate Range: $65.13/hrPosition Overview:Requirements
In-depth
Mainframe DB2 DBA (DB2 on Z/OS)
knowledge with a focus onperformance tuning.7-9 years
of
DB2 DBA
experience on
Z/OS at a single large financial institutionJob stability is a key requirement.Experience with
DB2 Utilities
including
IBM
and
BMCSolid understanding of
DB2 recovery options .Broad understanding of
ACF2
and
RACF2
managed security for
DB2 Access .Working knowledge of
Endeavor .Working knowledge of
ITSM Processes and tools
including
BMC RemedyWorking knowledge of
BMC tools
including Change Manager, Catalog Manager, MainView, and SQL performance.Responsibilities
Develop log scrapingstrategies 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 settingup 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 methodsConsulting 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.*Please note that as a contract employee of Apex Systems, benefits include the below with employee contribution*
HealthDentalVisionLife Insurance; Short Term DisabilityHospitalization CoverageDirect DepositWeekly Pay PeriodsTraining and Development Programs401kReferral Program
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178 .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.
In-depth
Mainframe DB2 DBA (DB2 on Z/OS)
knowledge with a focus onperformance tuning.7-9 years
of
DB2 DBA
experience on
Z/OS at a single large financial institutionJob stability is a key requirement.Experience with
DB2 Utilities
including
IBM
and
BMCSolid understanding of
DB2 recovery options .Broad understanding of
ACF2
and
RACF2
managed security for
DB2 Access .Working knowledge of
Endeavor .Working knowledge of
ITSM Processes and tools
including
BMC RemedyWorking knowledge of
BMC tools
including Change Manager, Catalog Manager, MainView, and SQL performance.Responsibilities
Develop log scrapingstrategies 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 settingup 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 methodsConsulting 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.*Please note that as a contract employee of Apex Systems, benefits include the below with employee contribution*
HealthDentalVisionLife Insurance; Short Term DisabilityHospitalization CoverageDirect DepositWeekly Pay PeriodsTraining and Development Programs401kReferral Program
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178 .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.