DataOps Database Administrator

Key purpose:

The primary focus of this position is to administrate, configure, monitor and maintain our Database environment. You will need to be helpful and supportive to your team and your clients, your fellow developers. You join an energetic, focused and dynamic team. The ideal candidate will be accurate, self-motivated and meticulous with an eye for detail, who enjoys undertaking complex assignments, meets deadlines and continually strives to deliver superior performance. The candidate must operate with a strong sense of ownership and responsibility and thrive in a fast-paced environment

Duties and responsibilities:

• Documentation of processes
• Database installs and DR environment configuration
• Database patching and upgrades as well as backups and restores
• Implementation of database monitoring utilities
• Database performance investigations
• Structural changes and deployment of database objects
• User requests
• Standby
• POC new technologies or processes for clients
• Provide consultancy, education and guidance in the use and exploitation of DBMS and database environments and infrastructure.
• Recommend technical solutions to our clients.
• Assist in the logical design and implement the physical definition of databases in conjunction with application systems analysts.
• Enhance and maintain databases to accommodate new business functions and improve existing business functions.
• Assist application developers with problem analysis and resolution of development and production failures.
• Provide and maintain technically stable and performing production environments.
• Research and evaluate alternative solutions and recommend the most efficient and cost-effective database solution for the application design.
• Monitors and analyzes ongoing database status, utilization and capacity.
• Implements and supports database security regulations, policies, and guidelines.
• Work closely with technical and client management to plan and implement database tools in support of business applications development requirements and processes.
• Support user and developer access, upgrade planning, implementation and resolution of database
• Capacity Plans
• Meet contracted SLAs
• Disaster recovery (backup and restore)
• Procedures and checks

Qualifications, experience and skills:

• Matric
• Tertiary qualification in IT
• Take responsibility for team failures
• Strives for continuous improvement
• Works smart
• Needs to embrace change rather than fear it
• Sound working knowledge of Oracle.
• OCA and OCP certifications
• Analytical and technically minded.
• Organizational, interpersonal and verbal/written capabilities.

Technologies:

• Oracle Enterprise Manager
• Oracle, SQL Server & MySQL Databases
• Linux
• Oracle Data Guard
• Oracle RMAN
• Performance Tuning
• GCP CloudSQL experience beneficial