Anil P.

With over 15 years of extensive IT experience, I specialize in the design, modeling, development, implementation, and support of SQL Server environments ranging from SQL Server 2005 to SQL Server 2019. My expertise encompasses a wide range of skills and technologies: T-SQL Proficiency: Extensive experience in constructing complex triggers, tables, stored procedures, functions, views, user profiles, data dictionaries, and ensuring data integrity. Database Management: In-depth knowledge of normalization and relational database management systems (RDBMS). SQL Server Services: Hands-on experience with SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). SQL Server Administration: Skilled in installing, configuring, managing, monitoring, and troubleshooting SQL Server environments. Performance Tuning: Proficient in performance tuning and query optimization techniques. Data Modeling: Expertise in logical and physical data modeling and database design using Erwin. ETL Tools: Experienced in using ETL tools within SSIS for SQL Server 2017, SQL Server 2012, and DTS for SQL Server 2000. Dimensional Modeling: Skilled in designing and building dimensions and cubes using the star schema in SSAS. Reporting: Expert in creating various types of reports, including simple, parameterized, sub-reports, matrix/tabular reports, charts, and graphs using SSRS in Business Intelligence Development Studio (BIDS). Optimization Tools: Familiar with optimization tools such as Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning SQL Server performance. DBA Tasks: Experienced in server maintenance, fail-over clustering, replication, backup and restoration, log file maintenance, performance tuning, deployment of database changes, job scheduling, and error handling for failed jobs. Tool Proficiency: Proficient with tools like SQL Sentry One, Grafana, and Spotlight. Database Administration: Skilled in the development and administration of MySQL and PostgreSQL databases. Collaboration: Capable of forming and maintaining positive and productive working relationships in both internal and external team environments. Multitasking and Adaptability: Adept at handling multiple tasks, demonstrating initiative and adaptability. Self-motivated and organized team player with strong problem-solving and analytical skills, committed to organizational goals. Quick Learner: Strong ability to quickly grasp and master new concepts and technologies. Power BI: Experienced in using Power BI Desktop for creating various dashboards.