SQL Server DBA Senior Consultant

ABOUT VIGILANT

Vigilant is the Preferred & Trusted Oracle & Microsoft Technology Partner in North America, delivering comprehensive solutions across application, automation, infrastructure, data & analytics, security & networking, and application modernizations. Founded in 1999, Vigilant is a global company with deep experience in both traditional and disruptive technologies. We are headquartered in Troy, Michigan, and have offices in Toronto, Canada, and Hyderabad, India. As a trusted Oracle Platinum Partner, our team supports virtually all Oracle products and modules. Vigilant also partners with Microsoft, Amazon Web Services and Blue Prism on business applications, cloud services, analytics, robotic process automation and artificial intelligence technologies. Our team is also highly skilled at developing custom solutions for unique challenges. Whats more, our significant staffing practice provides the worlds largest companies with talented IT professionals.

( Website : https://vigilant-inc.com/ )

REQUIRED SKILLS

• Strong in SQL Server DBA & performance tuning
• Experience in installing and Upgrading SQL Server databases version 2012, 2014, 2017, 2019 and 2022.
• Experience in Migration of SQL Server from Lower version to Higher both in place and Side by Side.
• Experience with troubleshooting Windows 2012,2016,2019,2022
• Experience with Backups and restore in Native, Azure workloads and Third-party tools like (Avamar, Druva, Veeam)
• Writing & optimizing SQL statements, clustering, HA, DR. Exp in DMV & DDL queries.
• Experience on Replication configurations and troubleshooting, adding articles and syncing data.
• Troubleshooting SSIS Packages and working with dedicated team to fix it.
• Database security and user access on DB with Minimal level of permissions.
• Good experience on SSRS reports migration and troubleshooting.
• Monitoring the general SQL alerts and troubles.
• Knowledge on Scripting in T-SQL and PowerShell.
• Knowledge about monitoring tools SolarWinds, S24.
• Working experience in Azure Managed Instance and Azure SQL Database, certification will be an added advantage.
• Experience in applying SQL Server service packs and database upgrades on same server and new server.
• Experience in Database performance tuning and troubleshooting users and application related issues
• Experience in continuous process improvement and automation using PowerShell
• Experience in HA solutions like Always ON setup and maintenance, Log shipping, Database mirroring and replication
• Experience in Upgrade, Patching and migration to On Prem and Cloud
• Experience in Database security and encryption setup using TDE and masking.
• Manage database backup and recovery, as well as disaster recovery planning
• Create, change, and improve SQL Server Agent tasks and maintenance plans.
• Work as part of a team and provide 24x7 supportR