Location: Johannesburg
Description:
The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
JOB FUNCTIONS:
· SQL server 2005, 2008 R2 and relational database development
· Develop and/or tune existing Stored procedures, Functions, triggers, tables, views, triggers, indexes, and constraints.
· Data Replications and scheduling
· Database Maintenance and Optimizations
· Develop and maintain strategies for managing both the logical and physical organization of data for multiple consumers and contributors.
· DTS packages, SSIS and SQL queries
· Writing more complex queries for specialized requirements on current and new projects
· Proficient in SQL Reporting services
· Develop systems to support operations
· Operations and maintenance of standard, routine queries
· Operate, maintain, enhance and optimize systems
· Ensure correct preparation of data for all operations
· Additional tasks related to data extracts, automated operations and SQL queries as required
· Assist with queries to support both business projects, operational and informational needs
· Responsible for the physical implementation of the database storage structures, allocation of system storage and planning of future storage requirements for the application databases
· Responsible for tuning existing large data warehouses and databases.
· Modification of the database-structure to support business needs, as well as populating and updating database tables.
· Ensure overall health of the databases including data integrity and operational efficiency.
· Implementing database audit and security, controlling and monitoring user access to the databases
· Monitoring and tuning the databases (includes writing scripts to facilitate the monitoring of the databases)
· Plan and perform database backup and recovery processes.
· Provide a managed database environment and all related analysis services
· Analyze data in testing environment
· Design documentation (including logical designs, physical designs, entity relationship modeling)
· Database designs for any new applications
· Troubleshooting any new problems in live database
· Liaison with developers, systems analysts, project managers, business owner regarding all project-initiatives.
· Responsible for complex data validation strategies and implementations
· Developing database test cases as well as testing
EDUCATIONAL REQUIREMENTS
· Matric
· Related tertiary qualification will be an advantage – B Sc, B Com, Technikon diploma
· Formal SQL training
BACKGROUND EXPERIENCE
· In depth SQL Server Database Administration experience.
· In depth experience writing, debugging, and tuning queries, stored procedures, functions, tables, views, triggers, indexes, and constraints.
· Experience of managing multiple MS SQL 2005/2008 RDBMS with large databases on large systems
· Strong self-sufficiency and initiative working on Database projects
· Experience with data management and data processing flowcharting techniques (UML preferred)
· Practical experience in monitoring, maintaining and performance tuning a large (> 1TB) database to provide a high availability clustered service.
· Experience with SQL Profiler, SQL Backup management, Maintenance plans,
· Experience of Transactional SQL, and DTS stored procedures.
· Practical experience in managing the internal and external MS SQL database security
· Understanding of, and experience with, server-client computing and relational database environments
· Cross platform exposure will be beneficial
· Must have the technical knowledge to produce efficient code which meets all employer standards and adopted industry standards
· Experience demonstrating strong interpersonal skills working with developers
NB: Applicants may be subjected to an ability assessment/test and obtain a satisfactory report before being considered for an appointment.
Please only apply if you have the correct skill set and experience.
Please note: Only shortlisted applicants will be contacted.
Apply to this job
Description:
The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
JOB FUNCTIONS:
· SQL server 2005, 2008 R2 and relational database development
· Develop and/or tune existing Stored procedures, Functions, triggers, tables, views, triggers, indexes, and constraints.
· Data Replications and scheduling
· Database Maintenance and Optimizations
· Develop and maintain strategies for managing both the logical and physical organization of data for multiple consumers and contributors.
· DTS packages, SSIS and SQL queries
· Writing more complex queries for specialized requirements on current and new projects
· Proficient in SQL Reporting services
· Develop systems to support operations
· Operations and maintenance of standard, routine queries
· Operate, maintain, enhance and optimize systems
· Ensure correct preparation of data for all operations
· Additional tasks related to data extracts, automated operations and SQL queries as required
· Assist with queries to support both business projects, operational and informational needs
· Responsible for the physical implementation of the database storage structures, allocation of system storage and planning of future storage requirements for the application databases
· Responsible for tuning existing large data warehouses and databases.
· Modification of the database-structure to support business needs, as well as populating and updating database tables.
· Ensure overall health of the databases including data integrity and operational efficiency.
· Implementing database audit and security, controlling and monitoring user access to the databases
· Monitoring and tuning the databases (includes writing scripts to facilitate the monitoring of the databases)
· Plan and perform database backup and recovery processes.
· Provide a managed database environment and all related analysis services
· Analyze data in testing environment
· Design documentation (including logical designs, physical designs, entity relationship modeling)
· Database designs for any new applications
· Troubleshooting any new problems in live database
· Liaison with developers, systems analysts, project managers, business owner regarding all project-initiatives.
· Responsible for complex data validation strategies and implementations
· Developing database test cases as well as testing
EDUCATIONAL REQUIREMENTS
· Matric
· Related tertiary qualification will be an advantage – B Sc, B Com, Technikon diploma
· Formal SQL training
BACKGROUND EXPERIENCE
· In depth SQL Server Database Administration experience.
· In depth experience writing, debugging, and tuning queries, stored procedures, functions, tables, views, triggers, indexes, and constraints.
· Experience of managing multiple MS SQL 2005/2008 RDBMS with large databases on large systems
· Strong self-sufficiency and initiative working on Database projects
· Experience with data management and data processing flowcharting techniques (UML preferred)
· Practical experience in monitoring, maintaining and performance tuning a large (> 1TB) database to provide a high availability clustered service.
· Experience with SQL Profiler, SQL Backup management, Maintenance plans,
· Experience of Transactional SQL, and DTS stored procedures.
· Practical experience in managing the internal and external MS SQL database security
· Understanding of, and experience with, server-client computing and relational database environments
· Cross platform exposure will be beneficial
· Must have the technical knowledge to produce efficient code which meets all employer standards and adopted industry standards
· Experience demonstrating strong interpersonal skills working with developers
NB: Applicants may be subjected to an ability assessment/test and obtain a satisfactory report before being considered for an appointment.
Please only apply if you have the correct skill set and experience.
Please note: Only shortlisted applicants will be contacted.
Apply to this job