MANDATORY SKILLS/EXPERIENCE
- 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
- SQL querying
- database administration
- high availability solutions
- troubleshooting
- Always On Availability Groups
- SQL Server Profiler
- database mirroring
- failover clustering