Senior Database Administrator at Netstar

Under direct supervision, responsible for the routine maintenance and tuning of simple production and development databases. Responsible for monitoring security, diagnosing database problems and backup/restore of applicable databases. Manage and grant access to the various databases. Works directly with users to resolve data conflicts and inappropriate data usage and may manipulate data within accordance of organisation standards. Directs the maintenance and use of the corporate data dictionary.

Key Responsibility Areas:

• Azure and On-Premises will be the focus areas.
• Administration and management of databases in DEV, QA, pre-prod & production environments.
• Provide technical expertise on the installation, setup, configuration of database servers, including infrastructure
• Pro-active monitoring of databases both from a performance and capacity management perspective.
• Performance tuning and optimization of database schema, indexes, stored procedures etc.
• Perform database maintenance activities such as backup/recovery, rebuilding and reorganizing indexes.
• Ensure that all database releases are properly assessed and measured from a functionality and performance perspective.
• Ensure that all database environments are up to date with the latest service packs, patches & security fixes.
• Take ownership and ensure high quality, timely delivery of database related projects on hand.
• Collaborate with application developers and operations/support teams in a fast-paced environment.
•  Manage database backup and restoration strategies, capacity management and DR framework, keeping within the prescribed RTO & RPO requirements of the company
•  Perform regular testing of BCP, DR and backup systems in line with audit requirements
•  Manage data security policies and controls in line with audit requirements
•  Manage critical database monitoring protocols and standards with proactive alerting
• Schedule and implement database and server updates in collaboration with IT governance and operations

Core Technical Competencies: 

Essentials

• T-SQL programming experience
• Database administration experience on Microsoft platforms
• In-depth knowledge of MS SQL Server performance metrics

Advantageous

• Experience with Microsoft Azure and/or AWS

Qualifications and Experience

• Bachelor's degree in Computer Science (or related field)
• 7+ years T-SQL programming experience
• 7+ years of database administration experience on Microsoft platforms
• Microsoft Database Administrator Certification

Knowledge and skills

• In-depth knowledge of MS SQL Server performance optimization
• Microsoft Azure and/or AWS