What are the responsibilities and job description for the SQL Database consultant position at Advait Consulting LLC?
· 4 years’ experience in migrating to large complex databases and applications along with associated logins, jobs, SSIS packages, linked servers.
· 4 years’ experience with designing and installing clustering with Always ON High availability.
· 4 years’ experience regarding project status, meetings, reporting requirements, scope changes.
· 4 years’ experience with providing Hyper Care support post migration of databases and applications, user support and
· 2 years’ experience with Redgate monitoring Software to fine-tune SQL Server database performance, creating indexes, optimizing response time, calculating IOPS and tuning SAN performance.
· 4 years’ experience with SQL Server Reporting Services (SSRS): Skills in creating, deploying, and managing reports using SSRS or other reporting tools like Power BI.
· 4 years’ experience with Data Analysis & Warehousing: Skills in data analysis, data warehousing concepts (e.g., star and snowflake schemas), and data visualization tools like Tableau or Power BI.