Database Administrator - Microsoft SQL at Frank Management Consult Ltd

Roles & Responsibilities;

• Install and configure new Microsoft SQL Server instances
• Ensure high availability including Always On availability groups, Replication mirroring and failover clustering.
• Maintain secure access and database integrity.
• Management, design and planning of physical data storage
• Database administration activities including but not limited to;
  • Database management including backups recovery and maintenance.
  • Restoration of databases in different environments.
  • Monitoring and resolving blocking sessions and data lock issues
  • Check all statistics related to memory locks, I/O database response time, wait events top sessions and background processes
  • Create indexes to achieve critical dataset response time for time sensitive activities.
  • Install SQL Server service packs and updates.
  • Archiving and partitioning
  • Updating statistics
• Proactively monitor and maintain SQL Server jobs troubleshoot failed jobs and resolve issues in a timely manner.
• Provide technical guidance for design, development, integration, and testing of production
• Perform database performance analysis, tuning, capacity planning, system sizing and ongoing maintenance to ensure maximum performance.
• Communicate and coordinate with other IT teams to successfully resolve support and maintenance Issues.
• Create, document and lead in the compliance of policies, procedures, and standards for business continuity
• Risk management of the database administration function.
• Build and maintain a network of support structures (like the: vendors, employees, user groups etc) for consultation purposes and best practice adoption.

Minimum Qualifications:

1. Bachelors degree in IT, Computer Science and related field.
2. Microsoft Certified Solutions Associate Certification.
3. 5 Years experience in DBA roles- Microsoft SQL databases a MUST
4. Experience managing Multiple databases in a large enterprise with many branches