Mainframe DB2 Z/OS DBA & ETL Specialist

ER Associates, Inc.

Atlanta (GA)

On-site

USD 90,000 - 130,000

Full time

5 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical insurance
Dental insurance
Vision insurance
Life insurance
Short-term disability
401(k)
Holiday pay

Job summary

TalentBridge in the United States is seeking a Mainframe DBA to design, implement, and maintain database solutions across platforms. You will analyze data issues, review SQL for standards, and document database structures, focusing on DB2 Z/OS and MS SQL Server environments.

Responsibilities include ETL via SSIS, SSRS reporting, and clear communication with technical and business stakeholders. A team player with meticulous problem solving and time management is essential.

Qualifications

  • BS or BA in Information Systems or related field preferred
  • Strong knowledge of database design principles in relational and data warehousing environment
  • Highly competent in database performance tuning, creation of right indexing strategy to meet data growth needs and query optimization
  • Strong SQL skills to provide code review and tuning feedback to the development and reporting team
  • Strong communication skills with the ability to communicate with business and technical teams
  • Effectively communicates and documents technical architecture and solutions to internal peer groups as well as other groups
  • Strong knowledge of database administration, Software Development Life Cycle (SDLC), and systems analysis procedures
  • Strong analytical and problem-solving skills
  • Minimum of two years of professional experience in a DB2 Z/OS environment and/or MS SQL Server environment
  • Knowledge of Microsoft SQL Server integration and reporting services
  • Self-motivation and remains flexible in a dynamic work environment
  • A team player with solid communication skills, excellent at problem solving, troubleshooting, and embracing new challenges
  • Ability to manage time across multiple, simultaneous projects, with attention to detail
  • Must demonstrate the ability to work effectively as a member of a team, as well as the maturity to work independently

Responsibilities

  • Design, implement, and maintain database solutions, across multiple platforms.
  • Performs problem analysis and resolution related to data and databases across various platforms.
  • SQL code reviews for standards, best practices and evaluate statement explain costs.
  • Research database structures including in-house and 3rd party solutions, data analysis, and documentation.
  • Previous knowledge and experience in a DB2 Z/OS environment.
  • Understand technical environments for DB2 on Z/OS mainframe.
  • Implement ETL using MS SQL Server SSIS and create MS SQL Server SSRS reporting.
  • Effectively communicate with technical and business stakeholders.
  • Other duties as assigned.

Skills

SQL skills
Communication
Teamwork
Problem solving
Self-motivation
Time management
Independence
SDLC knowledge
DB2 Z/OS experience

Education

BS or BA in Information Systems or related field

Tools

MS SQL Server SSIS
MS SQL Server SSRS
DB2 Z/OS

Job description

TalentBridge in the United States is seeking a Mainframe DBA to design, implement, and maintain database solutions across platforms. You will analyze data issues, review SQL for standards, and document database structures, focusing on DB2 Z/OS and MS SQL Server environments.

Responsibilities include ETL via SSIS, SSRS reporting, and clear communication with technical and business stakeholders. A team player with meticulous problem solving and time management is essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Mainframe DB2 Z/OS & SQL ETL Administrator
Mainframe DB2 Z/OS & SQL ETL Administrator

Central Bank • Moberly (MO)

On-site
USD 70,000 - 110,000
DB2 Z/OS Database Engineer & ETL Specialist
DB2 Z/OS Database Engineer & ETL Specialist

Central Bank • Missouri

On-site
USD 85,000 - 110,000
Database Admin
Database Admin

ER Associates, Inc. • Atlanta (GA)

On-site
USD 90,000 - 130,000
Medical insurance
Dental insurance
Vision insurance
+4
Mainframe DB2 Database Administrator
Mainframe DB2 Database Administrator

Veriipro • Midvale (UT)

On-site
USD 110,000 - 150,000
Database Administrator - DB2 Z/OS & SQL Server Specialist
Database Administrator - DB2 Z/OS & SQL Server Specialist

Central Bank • Springfield (MO)

On-site
USD 70,000 - 100,000
Senior Mainframe Developer
Senior Mainframe Developer

Quantum Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 140,000
Senior Mainframe Developer
Senior Mainframe Developer

Valiant Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 170,000
Application Database Administrator
Application Database Administrator

Central Bank • Columbia Township (MO)

On-site
USD 90,000 - 120,000
Application Database Administrator
Application Database Administrator

Central Bank • Sedalia (MO)

On-site
USD 70,000 - 90,000
Application Database Administrator
Application Database Administrator

Central Bank • Missouri

On-site
USD 85,000 - 110,000