Location: Johannesburg
Description:
Job description
The Database Developer 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.
The focus of the position will be more on the development side than the administration of the database. Applicants without development experience will not be considered.
Description:
Job description
The Database Developer 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.
The focus of the position will be more on the development side than the administration of the database. Applicants without development experience will not be considered.
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
·
· 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
·