Description
The role is to be responsible for the performance, integrity and security of a number of core SQL databases. The applicant will be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
Technical Skills
- Microsoft SQL Server
- T-SQL programming (4+ years)
- SQL Server Integration Service
- SQL Server Reporting Services
- Experience in database design
- Experience with source control
- Knowledge of software engineering life cycle
- Previous experience in designing, developing, testing, implementing and supporting software
- Experience with Oracle preferable
- SQL MSCE preferable.
Mains Activities
- Installation, administration and maintenance of multiple SQL Server instances.
- Setup environments for use within the end to end software delivery life cycle.
- Define, design & implement control procedures.
- Backup monitoring and continuous review of the backup strategy.
- Troubleshoot and resolve issues quickly.
- Performance monitoring and tuning.
- Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O etc.)
- Planning and execution of Service Pack upgrades.
- Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching.
- Working closely with other team members.
- Complete structured and systematic testing.
- Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap.
- Experience in a Windows based 24/7 environment including 1st/2nd line support.
- Involved in the design and build of new systems, including high-availability and disaster recovery solutions.
We don't offer sponsorship for this role.