Feedback
Job Category: Others

Job Source: NRBjobs.com

Job Summary

15
  • No. of Vacancy: N/A
  • Job Location: Gauteng
  • Employment Type: Full Time
  • Salary: N/A
  • Gender: Any
  • Age Limit: N/A
  • Experience: N/A
  • Career level: Mid-Senior level
  • Posted On: Jun 2, 2019
  • Application Deadline: Jul 2, 2019

Job Description/Responsibility

  • Introduction
    A global, multicultural company that is all about entertainment has an opening for an Application DBA, who will be responsible for the implementation, maintenance, performance, integrity and security of the software and database integration. The role includes the monitoring and improvement of application and database integration performance.
    Description
    • Develop and support C# application with SQL Server database integration (stored procedures and queries), and the development and maintenance of a DAL.
    • Focus on tasks related to building an effective usable database environment to support the creation and maintenance of applications.
    • Lend assistance and support, including building and maintaining the proper database structures required by the applications, as programs and systems are being built.
    • Manage, document and test all backup and restore processes in terms of dependencies between application and databases.
    • Design, manage, document and assist to deliver DAL processes and concepts.
    • Configure, manage and document all database server software that houses the SQL Engines.
    • Ensure uptime and optimal health of MSSQL RDMSs.
    • Schedule and monitor relevant SQL jobs.
    • Critically review and maintain new and current maintenance tasks on the databases, ensuring optimal index usage. Laisse with the server DBAs to ensure that all the Engine and Database settings are optimal for the environments source code.
    • Monitor and analyse performance trends on SQL Server and the host server OS. Use the gathered information to ensure optimal resource usage, identify resource bottlenecks and trend capacity usage.
    • Design, maintain and audit all security aspects around the SQL Server, the application development logins and the associated applications.
    • Assist with definition and implementation of Disaster Recovery strategy from a source code perspective.
    • Ensure that all security aspects around the SQL implementation is kept up to date as it pertains to the source code integration to the SQL.
    • Assist with occasional ad hoc queries.
    • Review and agree the SQL code received from Business Intelligence Software Development on the production systems.
    • Provide 24,7 support to application to database integration.
    • Participate in technical research and development to enable continuing innovation within the infrastructure. Research and recommend innovative, and where possible automated approaches for database administration tasks.

Experience Requirements

  • 5 years of C# development experience.

Education Requirements

  • N/A

Skills Requirements

  • 5 years of C# development experience.
  • SQL DBA experience (SQL 2014 -2016 preferred).
  • Microsoft Server Products (Server OS, Hyper V and Clustering) fair knowledge is important.
  • Solid experience in troubleshooting and resolving performance bottlenecks and optimising query plans.
  • MSCE (MSSQL 2014+) (2016 Preferred)
  • C# and Development Diploma.

Compensation/Benefits

  • N/A

Apply Instruction

About the Company

Company Name: Afrizan Personnel (Pty) Ltd.
Address: Freestone Office Park, Block B, Ground Floor 135 Patricia Road Sandown, Johannesburg, 2196, , SOUTH AFRICA

Company Profile: • Sourcing and placement of permanent candidates matched to client requirements • A superior database with high calibre candidates, including 80% affirmative action individuals • Evaluation and verification of candidates’ identities, education, credit and criminal histories as well as past employment prior to client placement and keeping with legislation. • Smart solutions to JSE Top 100 companies

Company Website: http://afrizan.co.za/

Personal Details

Documents for this application

Files can be up to 2MB for file types.
.pdf .doc .docx .rtf .txt

Cover Letter

Resume

All personal information submitted by you as part of an application will be used by us in accordance with our privacy statement

All Jobs of This Company

Upcomming Courses

More Courses

CAREER ARTICLE

More Article