Genesis10 is currently seeking a Database Administrator with our client in the financial industry located in Plano, TX. This is a 12+ month contract position.
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
- Translate 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
- Consult with the application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access
- Define and implement 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
- 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 of Self Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met
Requirements :
Minimum of 7-9 years of DB2 DBA experience on z / Os at a single large financial institutionIn-depth Mainframe DB2 DBA (DB2 on Z / oS) knowledge with a focus on performance tuningJob stabilityExperience with DB2 Utilities including IBM and BMCWorking knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performanceSolid understanding of DB2 recovery optionsBroad understanding of ACF2 and RACF2 managed security for DB2 AccessWorking knowledge of EndevorWorking knowledge of ITSM Processes and tools including BMC RemedyIn depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC UtilitiesUnderstanding of SMF data and reportingKnowledge of Splunk, PythonPay Range : $58.32-$66.32
Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.
If you have the described qualifications and are interested in this exciting opportunity, please apply
For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10 :
Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)Behavioral Health PlatformMedical, Dental, VisionHealth Savings AccountVoluntary Hospital Indemnity (Critical Illness & Accident)Voluntary Term Life Insurance401KSick Pay (for applicable states / municipalities)Commuter Benefits (Dallas, NYC, SF and Illinois)