
Highly skilled Senior Database Administrator with over 8 years of hands-on experience supporting Microsoft systems in complex enterprise environments. Proficient in Microsoft SQL Server Database Installation, upgrading, Configuration, Administration, Maintenance, Performance Tuning, Backup and Recovery experience in SQL Server 2019/2017/2016/2014/2012; On-Premise and on AZURE cloud environment. Proficient in MySQL with hands-on experience in database management, and query optimization. Familiar with PostgreSQL Comprehensive knowledge and experience in all phases of the Software Development Life Cycle (SDLC) and great working experience in an Agile/SCRUM development team. Experience in implementing SQL Server Security, object permission, maintaining creation of users, configuring permissions database authentication and assigning roles of users. Extensive working experience in troubleshooting, monitoring and performance tuning various issues. Extensive experience in implementing HADR solutions such as Always on Availability Group, Replication, Log shipping, Clustering and Mirroring on physical and virtual machines. I am an expert in Data conversion, Data modeling, Normalization, Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment. I am highly proficient in using T-SQL scripts, Views, Triggers, and knowledgeable in Common Table Expressions (CTE), Functions, stored procedures that meet business requirements. Experienced in creating and deploying ETL packages to move data from various heterogeneous data sources such as Access, Excel, and CSV Flat files. Well Experienced with Microsoft SQL Server Integration (SSIS) and Reporting Services (SSRS). Well experienced in managing very large databases with minimum to no downtime, strong understanding of RDBMS concepts as well as Data Modeling Concepts. Demonstrates advanced proficiency in designing and optimizing ETL processes, implementing intricate Data Warehousing, Operations Data Store concepts, and employing expertise in creating data marts and OLAP technologies, along with a sophisticated understanding of Star and Snowflake schema design. Showcases exceptional proficiency in providing seamless support for mission-critical databases, leveraging extensive experience in Microsoft SQL Server Integration (SSIS) and Reporting Services (SSRS). Proficiently craft and optimize T-SQL scripts, Views, Triggers, and demonstrate advanced expertise in Common Table Expressions (CTE), Functions, and stored procedures, ensuring seamless alignment with intricate business requirements. Navigate seamlessly through advanced database management features such as Policy Based Management, Transparent Data Encryption, Always Encrypted, Dynamic Data Masking, and Contained Databases. Expertly define and enforce robust database standards, policies, security measures, and documentation, ensuring optimal efficiency in database operations. Possesses excellent analytical, problem-solving skills, and superior written and verbal communication skills across all organizational levels, showcasing an unwavering commitment to detail and precision.