SQL Specialist Banking - City Of Johannesburg Metro
R
315
per hour
City Of Johannesburg Metro, Gauteng
City Of Johannesburg Metro,
Gauteng
more than 14 days ago
20-08-2015 7:29:09 AM
17-09-2015 7:29:09 AM
SQL Specialist (Banking)
Exp: 6-8 years. Rate: R315 per hour. Contract: 6 months. Start: Imm
• Participates in product roadmap discussions and identify key areas for database improvements in the product, and incorporate these goals into ongoing & future development initiatives
• Maintains database performance by calculating optimum values for database parameters; examining execution plans and tuning indexes and stored procedures; implementing new releases; completing maintenance requirements; assist in expanding and tuning monitoring solutions
• Own, track, and resolve database related incidents and requests, fulfilling requests and resolving incidents within service level agreements
• Respond to database related alerts and escalations and work with database engineers to come up with the strategic solutions to recurring problems
• Contribute to our growth and evolution through high availability solutions such as Mirroring, Clustering, AlwaysOn
• Mentor team members on best practices and related skills
• Daily database oversight
o Oversee support and auditing of user accounts and security rights (SQL and AD Logins)
o Create database backup procedures as well as system disaster recovery processes
o Responsible for maintaining data integrity, including maintaining backup strategies and periodic database consistency checks
o Oversee system patches or security updates
SQL Server 2005 – 2014 Administration (DBA)
• Backup and restore strategies
• Implement and maintain security access (logins, users, schemas)
• SQL Server Agent job system
• Table partitioning
• SQL Server Transactional Replication
• Identifying system bottlenecks
• Performance tuning, and index maintenance
• Linked servers
• Good knowledge of SQL
• Experience with high availability and disaster recovery solutions for MSSQL (i.e. database mirroring, clustering, AlwaysOn)
• Proficiency in T-SQL development
• Knowledge of virtual servers and SANs related to capacity planning, security and performance tuning
Computer Science degree or equivalent work experience