IBM DB2 LUW Database Systems Administrator

Required Skills:

• Developing JBOSS Messaging and connectivity with Spring-JMS connectivity
• Designing DB schema as per the requirements and in sync with the old system
• Implementing the daily and weekly jobs that interact with external interfaces
• Coordinating with business stakeholders to understand their requirements

Preferred Skills

• Ability to administer IBM DB2 LUW database systems; skilled to perform IBM DB2 LUW tuning including SQL tuning; ability to perform IBM DB2 database backup, restore, and disaster recovery design and deployments; able to automate routine daily IBM DB2 database system management tasks such as database deployments and refreshes. Possess excellent communication skills to effectively interact with internal and external management teams, developers, network and infrastructure teams.
• Possess skills to install/upgrade IBM DB2 LUW databases from lower version to latest supported version such as 11.1.x and above.
• Possess skills to install, maintain, support IBM DB2 LUW server software and related features including HADR with auto failover.
• Possess skills to install, maintain, support IBM DB2 LUW Client on Linux and Windows platforms. Possess skills to install, maintain, support IBM DB2 LUW monitoring software such as IBM DB2 Data Management Console and recommend improvements for operational efficiency, following best practices.
• Ability to provide technical support and maintenance of the IBM DB2 LUW database systems to ensure their integrity, availability, and performance. Ability to document and refine database upgrade procedures following best practices and store on the section's MS SharePoint site.
• Possess skills to perform capacity planning, space management, and data maintenance tasks for IBM DB2 LUW database systems including management of data and log files. Possess skills to perform database backup/recovery of IBM DB2 LUW databases utilizing enterprise class backup software such as CommVault.
• Possess skills to prepare change management documents using an enterprise class change management tool such as Cherwell.
• Possess skills to manage and maintain security to IBM DB2 LUW systems via authentication and authorization of access users following best practices.
• Possess skills to support ADABAS/Natural database systems following the section's established processes and procedures.

Experience Required:

• 8 years of experience in systems development, analysis, programming or testing.
• 10 years’ experience in IBM DB2 LUW database systems administration, including installing and upgrading to new versions and applying maintenance processes
• Install, configure, maintain, troubleshoot HADR auto failover.
• Developing automation scripts using WMI, PowerShell, Perl, Python, Jenkins, Ansible, or Unix/Linux shell scripts etc.
• Using a DevOps GIT source code management tool.
• 5 years’ experience working with IBM DB2 LUW database systems in a RedHat Linux platform environment, installing new software releases, applying maintenance patches and fixes, and performing regular database administration support services including monitoring and troubleshooting.
• Working with IBM Data Management Console, installing and configuring new releases, and setting up monitoring profiles.
• Supporting, monitoring, and troubleshooting ADABAS/Natural database systems.
• Utilizing DBeaver to monitor DB2 resources and usage. Supporting Linux RedHat database systems running in a VMware virtualized platform.
• Managing systems in any Cloud platform such as Amazon Web Services, Microsoft Azure, Google Cloud Platform, or Oracle Cloud Infrastructure.
• SQL Server installations, configurations, management and monitoring, and system administration tasks at the level of a SQL Server Database System Administrator.
• Managing large MS SQL Server farms (300+ servers). Developing scripts to automate routine manual database server functions using tools such as Jenkins, Ansible, or similar tools.
• Migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure.
• Building and managing Azure SQL Managed Instance services.
• Building, configuring, and managing MS SQL Server Always On cluster services.
• Working with Commvault Backup client as a tool to perform SQL Server database Backup and Restore including the experience managing SQL Server backup and restore in native SQL Server Management Studio.
• Microsoft SQL Server experience on SQL Server 2016 and above.

Education Required:

• Bachelor’s degree in an IT-related or Engineering field.

Education Preferred

• IBM DB2 Database Administrator Certification