Mainframe Database Administrator (DBA)

Mainframe Database Administrator (DBA)

Type: On-site 5 days

Client: Financial Domain through CTS

Location: Delaware

Hourly Rate: $55

We are seeking a highly skilled and experienced Mainframe Database Administrator (DBA) to help modernize our data platform by bridging legacy mainframe systems with modern cloud-based solutions. The ideal candidate will possess deep knowledge of mainframe environments, strong scripting abilities, and hands-on experience with cloud databases and observability tools.

Required Skills

• Strong, hands-on experience in writing, debugging, and optimizing REC scripts for data extraction and system automation.
• Proficient in developing, modifying, and troubleshooting JCL for batch processing, utility execution, and data management on mainframe systems.
• In-depth knowledge of mainframe operating systems (z/OS) and database management systems (e.g., DB2, IMS).
• Hands-on experience with Cassandra for distributed NoSQL database administration.
• Experience in building and maintaining enterprise-level dashboards using tools such as Grafana and Splunk.
• Familiarity with Data Warehousing Solutions (DWS) and their implementation in cloud environments.
• Understanding of cloud infrastructure concepts (AWS, Azure, GCP) and hybrid cloud-mainframe environments.

Responsibilities

• Lead the design, development, and optimization of data extraction processes from mainframe systems. This includes extensive use of COBOL, REC scripting and JCL queries to efficiently retrieve
• Administer, monitor, and maintain mainframe databases (e.g., DB2, IMS) while also providing expertise in the implementation and management of cloud databases, Cassandra and DWS.
• Collaborate with the Observability team to integrate mainframe data sources into modern observability platforms. This includes contributing to the design and development of interactive dashboards using tools like Grafana and Splunk for comprehensive data visibility and operational insights.
• Proactively monitor and tune database performance across both mainframe and cloud environments, ensuring optimal efficiency and reliability for data extraction and access.
• Ensure data integrity, security, and compliance with organizational standards and regulatory requirements across all database environments.