Database Administrator SQL

  • Newcastle
  • Gijima Holdings
FORMAL EDUCATION: ·

Grade 12 ·

Diploma / Bachelors degree in Computer Science, Information Systems, Business Management or related discipline from an accredited tertiary institution.

EXPERIENCE: ·

5 Years experience developing data management systems, tools and architectures using MS SQL tools. ·

Experience designing and operating very large Data Warehouses and web facing online transaction processing databases

TECHNICAL / LEGAL CERTIFICATION: ·

MS SQL Certification in database administration ·

Demonstrable proficiency and experience in MS SQL Server, DB2, Linux, and programming languages such as R, Python, Ruby or Java. ·

Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following

MS SQL, PL/SQL, MySQL, Oracle, or NoSQL (minimum of 5 years). ·

Experience in Unix AIX, Linux and MS Windows operating systems will be advantageous ·

ITIL v3 Foundation certification

OTHER REQUIREMENTS: ·

A results-oriented individual who thrives working in a fast-paced environment and under pressure. ·

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

RESPONSIBILITIES: Key areas of responsibility:

The SQL Database Administrator will be required to perform the following duties, amongst others: ·

Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO). ·

Test backups to ensure we can meet the business Recovery Time Objectives (RTO). ·

Troubleshoot SQL Database Server service outages as they occur, including after-hours and weekends. ·

Configure SQL 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 appropriate technologies. ·

Install and configure new SQL Database Servers. ·

Upgrading the SQL database software as and when required. ·

Deploy database change scripts provided by third party vendors. ·

Troubleshooting SQL database issues. ·

Troubleshooting hardware using technology toolsets. ·

Document the Departments database environment. ·

Failover clustering, SAN replication, and other high availability technologies. ·

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 might require traveling nationally and work after hours as and when required