DB2 Administrator

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

Employment type

Job function

#J-18808-Ljbffr