SQL Administrator / SQL Developer

My client, a highly successful corporate commodity trading company has a vacancy for an SQL Administrator / SQL Developer to join their team.

The successful candidate must have a relevant Degree / National Diploma in Computer Science, Software Engineering or MCITP coupled with 2+ years of SQL DBA & SQL Development experience.

Qualifications, minimum requirements and skills:

• Relevant Degree/National Diploma in Computer Science, Software Engineering or MCITP essential
• 2+ years of SQL DBA & SQL Development experience essential
• Microsoft SQL Server 2012 / 2017 / 2019 experience with database administration, including installation and troubleshooting issues
• T-SQL Scripting, Backup and recovery, Replication Database Security experience
• Performance tuning on SQL queries / stored procedures
• Log shipping, Disaster Recovery Solutions and partitioning
• Ability to work under pressure if ever needed.
• Advantageous: | Automation | Excel | Programming

Key Performance Areas:

• Administer Microsoft SQL Server database environments
• T-SQL Scripting and development on both new and existing functions
• Troubleshoot and resolve server, database and data issues
• Security maintenance of server and database
• Maintenance and monitoring of SQL environment

The purpose of this role:

• Create new reports or dashboards based on supplied requirements
• Perform tests to ensure accurate compliance with project requirements
• Be comfortable documenting processes along the way

Responsibilities:

• Create, change and manage reports
• Access, investigate and extract data as needed
• Test data for completeness and correctness
• Provide support to internal users
• Issue investigation and resolution
• Investigate systems and document
• Problem escalation as needed