DB2 Administrator

BlueSky Resource Solutions; Atlanta (GA); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A leading recruitment firm is seeking a Sr. Technical Recruiter for a hybrid role in Atlanta, GA. The position focuses on troubleshooting and optimizing database performance, along with managing DB2 environments. Candidates should have strong skills in database performance tuning and shell scripting, alongside experience handling database-related issues. This contract-to-hire role offers an opportunity to work collaboratively in a dynamic environment.

Qualifications

• Experience in managing and maintaining DB2 databases.
• Strong performance tuning skills using Explain, Event Monitors, etc.
• Ability to write and maintain shell scripts.

Responsibilities

• Troubleshoot and analyze root causes of database issues.
• Install and upgrade DB2 instances and databases.
• Provide guidance on technical questions related to DB2.

Skills

Database performance tuning

BASH/KSH shell scripting

SQL statement tuning

DB2 software installation

Problem analysis and troubleshooting

Tools

DB2

Job description

Overview

This is a 3-6 month contract-to-hire position. This will be a hybrid position requiring 3 days a week onsite in Sandy Springs. The role is not open to C2C, C2H, OPT, or Visa consideration. No vendor support of any kind.

Job Title

Sr. Technical Recruiter at BlueSky Resource Solutions

Responsibilities

• Troubleshoot, analyze for root causes for problems, ensure database availability, security and stability, performance tuning and optimization.
• Able to provide performance tuning by analyzing Database and O/S performance using Explain, Event Monitors, vmstats, etc.
• Able to install DB2 software and upgrade DB2 instances and databases. Install DB2 client versions and the drivers on the application servers and users\' machines.
• Able to write and maintain BASH/KSH shell scripts.
• Good application management experience, including but not limited to Explains, Joins, Referential Integrity, Stored Procedures and Triggers,and indexes.
• Provides guidance to developers\' technical questions related to Db2 as well as creating and updating Stored Procedures and Triggers.
• Analyze and tune SQL statements and indexes; make performance recommendations to development teams.
• Experience in problem analysis and troubleshooting database related issues.
• Manages and maintains data in all Production and Non-Production Db2 Databases.
• Handles data refreshes from Production to Test environments based on user requirements.
• Performs maintenance of the DB2 environments including image copies, performance monitoring, capacity management, and object upgrades.
• Experience with all DB2 utilities including Backups, Unloads, Loads, Runstats and Reorgs.
• Can perform database recovery to Image Copy or Point-In-Time.
• Install and manage the TSA Cluster and HADR

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Administrative