Job#: 2045409
Job Description:
Position: DB2/DBA
Location: Jacksonville, FL
Duration : 12 mo. Contract
Rate Range: $65.13/hr
Position Overview:
Requirements
- In-depth Mainframe DB2 DBA (DB2 on Z/OS) knowledge with a focus on performance tuning.
- 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
- Solid 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 Remedy
- Working 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 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.
*Please note that as a contract employee of Apex Systems, benefits include the below with employee contribution*
- Health
- Dental
- Vision
- Life Insurance; Short Term Disability
- Hospitalization Coverage
- Direct Deposit
- Weekly Pay Periods
- Training and Development Programs
- 401k
- Referral 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.
VEVRAA Federal ContractorWe request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. The EEO is the Law poster is available here.