RESPONSIBILITIES:

Ø Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.

Ø Experienced in Database Performance, Maintenance and Development to perform the following:

·      Knowledge in Database concepts.

·      Knowledge of MS SQL server architecture.

·      Database management including backups, recovery, and maintenance.

·      Database management for export, import and mass data loads.

·      Monitoring and resolving data lock/blocking 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 reports.

·      Responsible for planning, configuring, and maintaining HA (high availability) and DR (disaster recovery) solutions:  Backup/Restore, FCI (failover cluster instance), AG (availability groups), Mirroring, Replication, Log-shipping.

·      Strong knowledge in MS SQL replication.

·      Experience in linked servers.

·      Troubleshooting knowledge of MS SQL servers.

·      DBCC commands knowledge.

Ø Experience in Create, modify, and optimize SQL Server Agent jobs and maintenance plans.

Ø Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.

Ø Develop documentation and training of routine database administration tasks.

Ø  T-SQL Programming Perform additional tasks as assigned.

TECHNICAL SKILLS / KNOWLEDGE REQUIRED:

·      Microsoft SQL Server DBA experience.

·      Microsoft Azure experience.

·       Data Warehousing experience.

TECHNICAL SKILLS OPTIONAL

·      ITIL experience.

·      Certifications.

·      Experience in corporate environment.

·      Experience in IT auditing.

·      IT Infrastructure knowledge.

Soft Skills

·      Excellent command over English.

·      Good communication skills.

·      Should be a team player.

·      Good interpersonal skills

Career path

·      Minimum 3 years’ experience in managing multiple SQL servers.

Educational qualifications

·      Bachelor’s degree / Diploma holder.