SQL Tuning and Mainframe DBA Variyas Global Solutions Inc.

Variyasinc; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

A technology company in the United States is seeking a DB2 Database Administrator to manage and enhance its databases on IBM mainframe systems. The role involves translation of business requirements, optimizing SQL queries, and ensuring system performance and reliability. Candidates should hold a degree in Computer Science and possess at least 5 years of DB2 experience. This position offers opportunities for professional growth and involves working collaboratively with development teams.

Responsibilities

• Translate business requirements into a physical model for implementation.
• Collaborate with application development teams to review SQL code and recommend indexing strategies.
• Participate in capacity planning and workload forecasting.
• Utilize IBM and BMC DB2 utilities to support data integrity and high availability.
• Design and maintain scalable database structures.
• Conduct information sharing meetings with application teams.

Skills

Managing large data stores

Problem solving and analytical skills

IBM DB2 Administration Tool

Performance and SQL Tuning

Ability to organize and prioritize workflow and projects

Passion for continuous improvement and staying current with DB2 and mainframe technologies

Education

Bachelor’s degree in Computer Science, Information Systems, or a related field

IBM Certified Database Administrator

5+ years of DB2 experience on IBM z/OS

Job description

Overview

This role is responsible to manage and improve our DB2 databases on IBM mainframe systems. This role focuses on keeping our systems running smoothly and making sure SQL queries are fast and efficient. You’ll work with developers, monitor performance, and help keep the data safe and reliable.

Roles & Responsibilities

• 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.
• Collaborate with application development teams to review SQL code, recommend indexing strategies, and ensure optimized interaction between applications and DB2.
• Participate in capacity planning and workload forecasting to support business growth and system scalability.
• Utilize IBM and BMC DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER, UNLOAD) to support data integrity, recovery, and high availability.
• Design and maintain scalable database structures, including PBG/PBR tablespaces, temporal tables, and archive-enabled tables, in alignment with business and recoverability requirements.
• Conduct information sharing meetings with the application teams when requested.

Skills Required

• Managing large data stores
• Problem solving and analytical skills
• IBM DB2 Administration Tool
• Performance and SQL Tuning
• Ability to organize and prioritize workflow and projects
• Passion for continuous improvement and staying current with DB2 and mainframe technologies.

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• IBM Certified Database Administrator
• 5+ years of DB2 experience on IBM z/OS.