Blog

TASKS:

· Database Review and Maintenance. Review all Microsoft SQL Server databases. Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies. Perform routine maintenance tasks such as index rebuilds, statistics updates, and database integrity checks. Always On Availability Group Maintenance. Monitor and maintain Always On Availability Groups for SQL Clusters. Ensure synchronization state across replicas. Perform failover testing and handle failover scenarios as necessary

Monitor backup jobs, troubleshoot failures, and perform periodic recovery tests. Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

MANDATORY SKILLS:

• Must have 12 years’ Experience.
• Microsoft SQL Engineer/DBA must possess advanced SQL querying skills, including expertise in writing complex SQL queries, stored procedures, triggers, and optimizing SQL performance.
• Proficiency in database administration tasks such as database creation, configuration, monitoring, backup and recovery, security management, user access control, and database optimization.
• Knowledge and experience in implementing and maintaining high availability solutions such as Always on Availability Groups, database mirroring, failover clustering, and disaster recovery planning.
• Ability to diagnose and troubleshoot database-related issues effectively, using tools such as SQL Server Profiler, Dynamic Management Views (DMVs), and Extended Events.

DESIRABLE SKILLS/EXPERIENCE:

• Knowledge of MySQL, Oracle, MongoDB, VMWare, AD, DNS