· Install, configure and manage SQL Server 2019 Databases ensuring optimum performance.
· Design, implement and manage processes to ensure availability and integrity of the data stored in databases
· Ensure Databases are being properly backed up as per company policy and ensure backup integrity
· Implement disaster recovery strategies to meet business’s Recovery Point Objectives (RPO), Recovery Time Objectives (RTO)
· Set up and monitor DB performance, troubleshoot issues; implement and enforce DB access controls
· Manage multiple high-availability SQL Server 2019 failover clusters and Always-On Availability Groups
· Setup and manage Replication among different databases/sites
· Patch SQL Server installations in accordance with patch management processes
· Be available 24/7 to provide technical assistance, in support to critical business operations
Required Skillset:
· Implementation and management experience in SQL Server High Availability and Disaster recovery solutions; including clustering, Availability groups and Replication
· Experience with database security design and Database automation
· Well versed in SQL Server Performance tuning & troubleshooting using DMVs, Extended Events, Profiling, Wait Statistics etc.
· Good understanding of the database underlying infrastructure such as Storage, Networking components and Server Hardware
· Experience in setting up and managing SSIS/SSRS
· Self-motivated, quick learner and a responsive team player with ability to work under pressure, and deliver quality outcomes
· Write clear, concise, and well-organized technical documentation to maintain standards and procedures
· Excellent written/oral communication, presentation, and interpersonal skills