PBT Group has an opportunity for a SQL DBA.

The SQL Developer Role is responsible for directly maintain existing and creating new SQL stored procedures, jobs and reports as well as assisting the DBAs in overseeing the health of the Databases used by the team. This role will develop and implement the strategic direction, with a service management philosophy that ensures customer satisfaction.

The employee will be responsible for being the SQL and Database subject matter expert within a small team of specialists looking after Data Sciences and Product Development. As such they will need to advise on best ways to implement new solutions within SQL, taking into account other technologies being used in the solution (e.g. Python, Java, Webservices (SOAP and Rest), PHP, SharePoint etc)

Duties:
- Researching system implications and solutions
- Researching latest technologies and methodologies
- Code profiling
- Providing input to the Business Analyst regarding the quality and accuracy of specifications in terms of the development requirements
Developing code:
- Develop SQL Scripts
- Stored Procedures
- Functions
- ETL (Extract, Transform & Load) processes Code automation
Testing:
- Test SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load) processes to business requirement.
- Monitoring and confirming of procedures and processes after implementation to ensure correctness
- Efficient Testing, Minimum Errors and Bug Free
Implementation:
- Deploy and Integrate SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load)
- Manage the physical implementation to conform with physical models and source data to target mapping
Documentation
- Documenting of SQL processes

Experience:
- Experience with SQL Server Database Design, Administration, Script Writing.
- 5 – 10 year’s database SQL Development and/or Administration Experience.
- 8+ years of SQL Server experience with hands on data analysis, problem solving, data design and modelling.
- Expert understanding of complex SQL, stored procedures, and database functions
- 5 - 10 years Windows Server experience (including Active Directory and proper disk configurations).
- 5 - 10 years MS SQL Server 2005 / 2008 experience.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server 2005 / 2008/ 2012
- Knowledge of indexes, index management, and statistics

Technical Skills Required:
- SQL Server Database Design
- Script Writing
- Data analysis
- Data design and modelling
- SQL stored procedures and database functions
- Indexes, index management, and statistics

Behavioural Skills Required:
- Client Centric
- Hard working and innovative
- Deadline driven
- Time management
- Self motivated
- Problem solving & analytical skills
- Clear understanding of computers and electronics
- Knowledge of security and virus protection software
- Ability to express themselves verbally and written

Qualifications/ Certification:
- Bachelor's degree or equivalent experience.
- Certification in MCTS, MCITP, MVP (advantageous)
- Knowledge of other languages, technologies and databases is not required but would be advantageous