DB2 DBA

3 days ago
United States ExecRecruitment Remote Full-time
Applicants must be legally authorized to work in the United States on a permanent, unrestricted basis and must not require employer-sponsored work visa sponsorship now or in the future. Support administration of DB2 for z/OS, Linux and Windows. Duties include:
• Performance Tuning
- Work includes analysis of access patterns to determine indexing and buffering needs. Collaborate with a team made up of DBA, Sysprog, Sysadmin and Developers to identify performance challenges, devise corrective action, test and implement changes.
• Backup and Recovery – Create, test and deploy database backup and recovery processes using IBM utilities. Work with storage management and scheduling to assure that backups are placed in correct locations in processing to capture the data at the correct time and be certain the tapes are shipped to the offsite vault.
• Disaster Recovery – Design and test recovery of application databases at DR vendor hot site. Work with storage management to design an overall recovery objective for all DB2 databases that fits in with the system recovery plans.
• Data Modeling – Participate in DB modeling sessions. Be able to create logical and physical models. Represent the DB2 DBA team in design sessions with architects and developers. Responsible to make sure the data model conforms to shop standards and can be managed long term.
• DDL construction – Create DDL to define DB2 objects from written specifications or modeling tool output.
• Application Diagnostics – Assist applications programmers and data analyst solve data access problems.
• Change Control for DB2 Objects – Create processes for promoting DB2 Objects from development through test and finally into production environments.
• Design, code and test data maintenance processes for conversions, archiving and purging.
• Train staff on the use of DB2 and related software. Required

skills:
• DB2 for z/OS (10+ years)
• DB2 on Linux, Unix or Windows (4+ years)
• Configuring DRDA/ODBC/JCBC connections (4+ years)
• Data modeling using ERWin or similar product
• Strong verbal communication and experience in consulting with senior business SMEs to elicit requirements
• Strong written, presentation and interpersonal skills. Nice to have

skills:
• Experience with SQL coding in Java
• Experience with SQL coding in COBOL
• An understanding of XML
• Dimensional Modeling
• Cognos BI
• InfoSphere Server DataStage
• SQL Server
• Sybase
• Scripting languages (Rexx, Bash, BAT...)

  • Mainframe DB2 DBA

    5 days ago

    Rye Brook, New York, United States Kyndryl Full-time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The...

  • Mainframe DB2 DBA

    7 days ago

    Chandler, Arizona, United States Veridic Solutions Full-time $50 - $65 Permanent

    We're Hiring: Mainframe DB2 DBA 📍 Location: Chandler, AZ / Plano, TX / Charlotte, NC / Jersey City, NJ (Hybrid) 💼 Job Type: Contract We are looking for an experienced Mainframe DB2 Database Administrator (DBA) with strong hands-on expertise in IBM DB2 for z/OS to support large-scale, business-critical mainframe environments. Key Responsibilities: •...

  • Mainframe DB2 DBA

    2 days ago

    , , United States Virtual Vocations Inc Full-time

    To support a global community of experts, the full-time remote Mainframe DB2 DBA will manage and administer database systems, ensuring peak performance, security, and scalability while collaborating with teams to improve system reliability. Key responsibilities Configure, install, and maintain database management systems to optimize performance Implement...

  • Mainframe DB2 DBA

    4 days ago

    United States Virtual Vocations Inc Full-time

    To support a global community of experts, the full-time remote Mainframe DB2 DBA will manage and administer database systems, ensuring peak performance, security, and scalability while collaborating with teams to improve system reliability. Key responsibilities Configure, install, and maintain database management systems to optimize performance Implement...

  • IBM DB2 DBA

    3 days ago

    Nashville, TN, United States 3B Staffing LLC Full-time

    IBM DB2 DBA Remote 7 Months Contract Job Description Seeking a IBM DB2 DBA to join one of our top clients for a remote opportunity. In this role, you will support enterprise database operations and lead critical upgrade efforts across multiple environments. You'll partner with infrastructure and application teams to ensure stability, performance, and secure...

  • Mainframe DB2 DBA

    4 days ago

    Remote, OR, United States Kyndryl Full-time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role Your...

  • Mainframe DBA – DB2

    2 days ago

    United States Global Connect Technologies Remote Full-time

    Job Title: Senior Db2 for z/OS DBA – Precisely Connect CDC Engineer Location: Remote Start Date: 2 Weeks from Offer Interview Process: 1 Interview (Technical SMEs Included) Interview Availability: Afternoons Job Summary We are seeking an experienced Senior Db2 for z/OS DBA / Precisely Connect CDC Engineer to support, administer, monitor, and troubleshoot...

  • Mainframe DB2 DBA

    5 days ago

    United States Veridic Solutions Full-time

    We're Hiring: Mainframe DB2 DBA Location: Chandler, AZ / Plano, TX / Charlotte, NC / Jersey City, NJ (Hybrid) Job Type: Contract We are looking for an experienced Mainframe DB2 Database Administrator (DBA) with strong hands-on expertise in IBM DB2 for z/OS to support large-scale, business-critical mainframe environments. Key Responsibilities: ...

  • DB2 DBA with SQL or Oracle

    14 hours ago

    McLean, VA, United States Hexaware Technologies, Inc Full-time

    What Working at Hexaware offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance,...

Top cities