Seeking a position with a company that will allow me the opportunity to expand my knowledge and experience in the area of SQL Server and becomes an entrusted professional in an organization that is technology oriented and encourages innovative thinking by delivering the best quality services emanating from my creative ability, knowledge, and experience. Microsoft certified Professional in SQL Server administration with more than 5 years of proven experience in providing 24/7 support on production and non-production environments. Excellent understanding of conceptual, logical and physical database modeling and software development life cycle(SDLC) Strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation Provisioning an Azure SQL Server and SQL Azure database through Azure web portal and Azure Powershell Configuring server level and database level firewall rules to connect to secure SQL Azure server Setting up Active Geo-Replication using Azure web portal and Powershell Database administration on Production and non-production MSSQL Servers with server configuration, performance tuning, and maintenance with troubleshooting capabilities. Installing and configuring SQL Server on standalone and clustered environments and Applying Service packs, patches, hotfixes and cumulative updates. Installing and Configuring SSIS, SSRS and SSAS Servers Excellent understanding of SQL Server architecture and Database storage structure Have experience with Normalization (1NF, 2NF, and 3NF) techniques for improved database performance in OLTP environments. Worked in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency Experience in implementing Business logic by using T-SQL statements like stored procedures, triggers, and user-defined functions (UDF). Working on Virtualization technologies like VMware, Virtual Box, and Hyper -V Migration of databases Side-by-side and in place upgrade from old version to newer version and from one edition to another edition Experience in analyzing Performance, Query optimization and tuning, creating Indexes and re-written stored procedures Worked with system administrators and developers to migrate databases from SQL Server 2008 to SQL Server 2012R2 and SQL Server 2016 Identified the I/O and memory bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans Solid experience and outstanding knowledge on High availability (HA) and Disaster recovery (DR) solutions like log shipping, Mirroring(HIGH safety and High performance), Replication(Snapshot & Transactional), Clustering and Always on Designing and implementing database Backups including Full, Differential & Transactional log and restoring databases based on the company's RPO and RTO Excellent knowledge of point-in-time recovery of databases Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL agent and monitoring and troubleshooting Job Failures Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs. Responding to database related alerts and escalations and working with engineers Experience in Managing Windows server, Active Directory and SAN disk configurations Experience in Creating and deploying SSRS reports Rebuilding databases including user and system databases at the time of server crash and bringing back the server to online state Experience in Data Extraction, Transforming and Loading (ETL) packages and deploying on a production server Experience in supporting production environment 24/7