SQL DBA

Description

10+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2019, 2016, 2012, SQL Server 2008 R2 and 2008.
Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Expertise in T-SQL writing stored procedures, triggers and functions.
Administering SQL Server High Availability and Disaster Recovery strategies.
Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
Implemented the new SQL Server 2019/2016 mechanisms like data compression, online indexing, Contained Databases, security principals
Worked on logical and physical database modeling with UML and ERWIN tools.
Experience in using DMV and dynamic management functions for finding out long running queries.
Worked extensively on Clustering and server consolidation.
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Having hands on experience in DR processes including Log shipping and Database Mirroring
Handled multiple SQL Instances on Cluster environment for Server
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Worked on SQL Server 2012/2016 migration from SQL Server 2008 / 2005.
Having Experience on Data center servers and handling 1.4 TB databases.
Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
24 X 7 Production Database on Call Support