Key Facts

Remote From:

Full time

English

Hard Skills

Database Tuning Restructuring (Business) Configuration Management Data Maintenance Database Activity Monitoring ServiceNow Space Planning Windows PowerShell Database Indexes Tablespace Foglight (Database Software) Capacity Planning Change Management Strategy Lifecycle Management

Roles & Responsibilities

Expertise in DB2 LUW activities, especially upgrades
Hands-on experience with DB2 installation and version upgrades on Windows
Experience with PowerShell scripting
Knowledge of HADR setups and ServiceNow change management processes

Requirements:

Upgrade DB2 Windows Servers
Perform database backup (online, Incremental, and Delta backup) and recovery tasks
Monitor daily DB backups and weekly RUNSTATS and REORGS on tables
Assist in capacity planning, space management, and data maintenance activities for the database system

Georgia IT, Inc.

About Georgia IT, Inc.

Georgia IT, Inc. provides IT Consulting for a wide range of IT services and custom build turn-key enterprise solutions. GIT specializes in improving business scalability and efficiency through BSM and SBA Solutions. GIT transforms business with service management and service automation solutions. We are BMC & HP partners. GIT Services include custom built enterprise software and customer-centric web portals, network design and implementation, remote and site-to-site VPN, network and server security assessment and setup, server and desktop virtualization, and many others. GIT also provides IT Consulting in many areas such as Disaster Recovery Planning, Enterprise Data Backup Strategy, Long Term Strategic IT Planning and Augmentation Professional Services Solutions. Professional Services Specialties: Business Process Integration, Software Integration & Development, Web portal, Networking, Remote and site-to-site VPN, Virtualization Solutions, Product Development Please contact us Hrus@georgiait.com / uthay@georgiait.com/470-798-5000 x 1010 / (732) 890-2535 direct

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Title: DB2 DBA
Location: Remote
Duration: Short-term Term Contract
Work Eligibility: US Permanent Eligibility to Work Required
Responsibilities:

Support Technology Upgrade Project
Upgrade DB2 Windows Servers
Support Windows upgrade of Database servers
Perform database backup (online, Incremental, and Delta backup) and recovery tasks
Monitor daily DB backups and weekly RUNSTATS and REORGS on tables
Assist in capacity planning, space management, and data maintenance activities for the database system

Skills and Experience Needed
Required:

Expertise in handling all DB2 DBA LUW activities, especially upgrades.
Hands-on experience DB2 installation and version upgrades on Windows.
Able to trouble shoot database issues arising from DB2 version upgrades.
Able to perform database backup (online, Incremental and Delta backup) and recovery tasks.
Able to perform monitoring daily DB backups and weekly RUNSTATS and REORGS on tables.
Able to set DB alerts using tools like Foglight.
Perform DBA DB2 support for application development team.
Can perform maintenance of DB objects like tables, table spaces, Indexes, Views, Triggers etc.
Able to update the UDB DB and DBM configuration parameters.
Good experience in DB2 Database management, performance tuning and troubleshooting.
Know how to manage DB2 database on windows OS.
Experience with PowerShell scripting.
Know how to manage HADR setups.
Working knowledge of change Management Processes and tools such as ServiceNow.
Candidate will need to be available for on-call 24x7 support as necessary