Database Administration - Db2

Gijima Holdings Hr; Pretoria; On-site; ZAR 850,000 - 1,200,000; Full time

Job summary

Gijima Holdings Hr is seeking a Specialist: Database Administration to lead the planning, development, and troubleshooting of enterprise databases. The role covers backups, monitoring, performance tuning, and high availability strategies while collaborating with application teams.

Qualifications include a CS-related degree and enterprise DB certifications, with 6+ years’ experience across IBM DB2, Oracle, Linux and data warehousing. National travel and after-hours work are expected.

Qualifications

• Diploma/Bachelor’s degree in Computer Science or related field.
• Certification on enterprise database products (IBM, Oracle, DB2, Redis, MongoDB, CouchDB, Cassandra, Ingres).
• 6+ years of experience developing data management systems and architectures using IBM DB2, Oracle, Redshift or similar.
• Experience with big data tech such as Hadoop/EMR and databases like DynamoDB, MongoDB, Redis, Cassandra.
• Experience designing and operating large Data Warehouses and web-facing OLTP databases.
• Proficiency in IBM Server, DB2, Oracle, Linux and programming languages such as R, Python, Java or Ruby.

Responsibilities

• Ensure all database servers are backed up to meet RPO objectives.
• Test backups to meet RTO objectives.
• Troubleshoot database server outages, including after-hours.
• Configure monitoring to minimize false alarms.
• Choose clustering, log shipping, or mirroring for new systems.
• Install and configure new database servers.
• Deploy change scripts from vendors.
• Tune performance and hardware configurations to improve performance.
• Document the database environment and data models.
• Travel nationally and work after hours as required.

Skills

Database technologies

APIs to WebApps

Communication skills

Project management

Analytical thinking

Team collaboration

On-call support

Education

Bachelor's/Diploma in CS or related

Enterprise DB certification

Tools

IBM DB2

Oracle

Linux

Python

Java

R

Job description

Responsible for performance, integrity and security of databases. The Specialist: Database Administration is involved in the planning and development of a database, as well as in troubleshooting any issues on behalf of the users.

Key areas of responsibility

• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Troubleshoot Database Server service outages as they occur, including after-hours and weekends
• Configure Database Server monitoring utilities to minimize false alarms
• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, or other technologies
• Install and configure new Database Servers
• Deploy database change scripts provided by third party vendors
• When performance issues arise, determine the most effective way to increase
• Performance including hardware purchases, server configuration changes, or index/query changes
• Document the Department’s database environment
• Tuning platform queries to improve performance
• Troubleshooting hardware using tools like Dell Open Manage, HP System Insight Manager, and IBM Director
• Failover clustering, SAN replication, and other high availability technologies
• Managing IBM Server components such as Analysis Services, Integration Services, or Reporting Services
• Root cause analysis of production-related database issues
• Daily maintenance, monitoring, problem resolution and internal customer/development support
• Review, design and develop data models in conjunction with the application development teams
• The role will be required to travel extensively nationally and work after hours as and when required

POSITION REQUIREMENTS

Education and experience required

• Diploma / Bachelor’s degree in Computer Science, Information Systems, Business Management, Electrical Engineering, Electronics Engineering, or related discipline from an accredited tertiary institution is
• Certification on at least one enterprise grade database product such, IBM, Oracle, Server, DB2, Redis, MongoDB, CouchDB, Cassandra, and Ingres.
• 6+ years of experience developing data management systems, tools and architectures using IBM
• Server, DB2, and Oracle databases, Redshift and/or other distributed computing systems.
• Familiarity with new advances in the big data space such as Hadoop/ EMR and other technologies like Dynamo DB, MongoDB, CouchDB, Redis, HBASE, and Cassandra.
• Experience designing and operating very large Data Warehouses and web facing online transaction processing databases.
• Demonstrable proficiency and experience in IBM Server, DB2, Oracle, Linux, and programming languages such as R, Python, Ruby or Java.

Skills and Competencies

• Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following – IBM, Oracle (minimum of 5 years)
• A results oriented individual who thrives working in a fast paced environment.
• Strong written and oral communication skills
• Strong organizational and project management skills with effective results focus within an information systems environment.
• Strong analytical and problem solving skills.
• Self-motivated with the ability to manage changing priorities and meet deadlines.
• Proven ability to be flexible and work hard, both independently and in a team environment, in a high priority customer service, on-call environment with changing priorities.
• Willingness to work occasionally outside of normal business hours in response to needs of the systems being supported.