DB2 Database Administrator

Description

The company DATA is a $30+ billion business and technology services company that serves 75% of the Fortune Global 100.

The company has experts in more than 70 countries and is part of the company Group, which invests over $3 billion each year in R&D.

The Database Administrator is a senior subject matter expert who keeps critical data assets available, accurate and performing well.

You will work with cross-functional teams to support data-driven applications, fix issues and build backup and recovery plans.

You will work alongside Change Control, Release Management, Asset and Configuration Management, and Capacity and Availability Management to understand user needs, watch user access and security, and help control access to databases through permissions and privileges.

Responsibilities

• Look after IBM DB2 databases on z/OS.
• Watch, examine and fine-tune database and SQL performance.
• Run database utilities such as REORG, LOAD, COPY and RECOVER.
• Set up backup, recovery and disaster recovery procedures.
• Support application releases and database changes.
• Keep databases secure, compliant and running reliably.
• Investigate production problems and guide the team technically.
• Work with application, infrastructure and development teams.
• Take on other related tasks when needed.

Requirements

• 8+ years of database administration experience, with 5+ years on DB2 for z/OS.
• Strong working knowledge of IBM z/OS, DB2 utilities, SQL tuning, JCL, TSO/ISPF and RACF.
• Hands-on experience with SQL subqueries, joins, unions and GROUP BY clauses.
• Working understanding of relational concepts such as normalization and referential integrity.
• Familiarity with OMEGAMON and IBM Db2 Administration Tools.
• Experience with IBM DB2 Connect is a definite plus.
• Strong problem-solving, communication and leadership skills.
• Seasoned skill in installing, configuring, maintaining and tuning databases.
• Seasoned understanding of the application development lifecycle and data access layers.
• Strong analytical skills for working with unstructured data.
• Ability to manipulate, process and extract value from large, disconnected datasets.
• A bachelor's degree or equivalent in computer science, engineering, information technology or a related field.
• A relevant certification, such as MCSE DBA or Oracle Associate, or an equivalent, is preferred.
• IBM DB2 Certification Professional is preferred.
• Coursework in database administration, data modelling, SQL and performance tuning is useful foundational knowledge.
• Seasoned experience as a Database Administrator in an IT organization.
• Seasoned experience with backup and recovery best practices.
• Seasoned experience creating and running health assessment reports.
• Seasoned experience working with suppliers to deliver solutions.
• IBM DB2 Certification.
• Ability to read and understand COBOL.
• Experience with Microsoft SQL Server is a plus.
• Seasoned experience managing databases.

Conditions

This is a remote role in the US.

The starting pay range is $80,000.00 - $114,000.00 - $148,000.00 USD annually, covering the minimum and maximum target pay across all US locations.

Actual pay depends on factors such as the work location, relevant experience, technical skills and other qualifications.