Mainframe Database Analyst / Systems Programmer
Mainframe Database Analyst / Systems Programmer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Location: Atlanta GA(Hybrid)
Duration: 12 Months
Tax terms: C2C W2 1099
- We are seeking a highly experienced Mainframe Database Analyst or Systems Programmer with expertise in z/Db2 IMS DB/DC and/or ADABAS to join our enterprise infrastructure team. The successful candidate will be responsible for managing maintaining and optimizing mainframe database platforms to ensure high performance availability security and scalability of enterprise applications.
- 8 years of hands-on experience with z/Db2 IMS DB/DC and/or ADABAS.
- Strong knowledge of IBM DB2 database administration on z/OS.
- Proficiency in SQL data partitioning indexing and data sharing concepts.
- Experience with IIDR IBM Infosphere Data Replication Suite.
- Working knowledge of zConnect (zCEE) API framework.
- Solid experience with JCL and mainframe operating system concepts.
- Proven troubleshooting performance tuning and incident resolution skills.
- Familiar with backup/recovery and DR planning in enterprise environments.
- Manage IBM Db2 databases on the z/OS mainframe platform.
- Create and manage database objects (tables indexes table spaces).
- Load unload and reorganize data using DB2 utilities.
- Develop and implement robust backup recovery and DR strategies.
- Monitor database performance and identify/resolve bottlenecks.
- Perform tuning to optimize SQL query and system performance.
- Use tools like RUNSTATS and EXPLAIN for statistics collection and optimization.
- Partner with application development teams to support database design and system integration.
- Serve as SME for database architecture and zConnect (zCEE) APIs.
- Provide guidance and mentorship to junior DBAs or contractors.
- Oversee installation configuration and upgrades of database software (DB2 IMS ADABAS).
- Collaborate with external vendors on software releases and conversions.
- Ensure compliance with change incident and problem management processes.
- Ensure data security and regulatory compliance (SOX etc.).
- Participate in internal and external audits and implement remediation plans.
- Identify and communicate database risks to leadership with appropriate mitigation strategies.
- Participate in DR planning testing and implementation.
- Ensure backup and failover procedures are tested and documented.
- Stay current with emerging database technologies and IBM z/OS ecosystem.
- Evaluate deprecated features and plan migrations or replacements accordingly.
Employment Type
Full-time
