SUMMARY:

• More than 9+ years working experience in SQL Server 2000/2005, 2008, 2012, 2014, and 2016.
• Strong experience in installing, upgrading, migrating and administrating SQL Server 2005\2008\2008R2\2012\2014\2016 instances.
• Hands on implementing of Fault Tolerance - High availability and DR solutions such as Always On, Log -Shipping, Database Mirroring, Clustering and Replication.
• Accountable providing 24/7 Production DBA Support as well Projects related support.
• Experience on Databases Migration from Old SQL server to New SQL Server 2005, 2008, R2, 2012 to 2012, 2014 and 2016.
• Experience on MS Azure, Migrated On-premises SQL Server Databases to Azure Cloud.
• Experience in building, automating, deploying database services, automating compliance and monitoring in Azure.
• Experience administering a MS SQL Server Database as a Production/Operational Database Administrator, in a mid to Big-size environment (approximately 60 to 150 servers with various SQL versions including SQL Server from 2005 to 2016).
• Expertise in Performance tuning, Optimization, Data integrity, Statistics and troubleshooting production issues using native (SQL Profiler) or 3rd party tools: DPA, Extra Hops/ AppDynamics.
• Experience with backups, restores and all recovery models.
• Experience on configuring, monitoring and using High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Represent Change management, work with developers and other team members to deploy database changes to production.
• Perform Installing SQL Server, Service packs, CUs, Hotfixes for SQL Servers.
• Good hands on indexes, index management, and statistics.
• Experience working with Server &, Store Team for configuring or building Windows/virtual server.
• Experience installing and supporting a scaled-out Reporting Services environment (SSRS). Configured and deployed Reports as per Business requirements, Handling Data Source configuration for the Reports deployed.
• Hands on Creating Stored Procedures, Functions, SSIS packages..
• Experience working on Virtual technologies (VMWare and Hyper V), like resolving issues, provisioning VM servers, moving, backing up VM servers etc.
• Experience on Microsoft Technologies, like .Net, SSIS, SSAS, SSRS, Azure, Office 365 etc.
• Implemented Data Masking, we masked sensitive data(columns) in SQL servers using IBM tool.
• Set up alerts in Splunk, AppDynamics and Extra Hops monitoring tools.
• Resolved lot of performance issues like Slow running application/timed out/T-SQL running slow/ TempDB issues/ Blockings/ Deadlocking/ application hung and got 100% performance back.
• Involved in major application databases migrations from SQL Clustering to Always ON High Availability Groups.
• Migrated SQL databases from SQL Server 2005, 2008, R2, 2012 to 2012, 2014 and 2016.
• Work with Dev and Application team on slow running applications/codes/T-SQ Queries and provide them recommendation to optimize SQL/applications.
• Created multiple Microsoft PowerBI Reports to visualize company data by graphically.
• Implemented Attunity Replication in SQL Server Environment to refresh data from Production to Reporting/EDW/Netezza, doing this we saved 80% refresh time as physical refreshes for reporting were taking much time to refresh database. Replaced Nightly Batch/SSIS processing which was taking more than 8 hours but after implementing Attunity we achieved this in 2 hours.
• Implemented Vormetric Encryption (DSM) to ensure databases security and invulnerability, this is file level encryption which encrypts all database files from outside hackers/threats, no one can read or use those back until they get decrypted.
• Implemented Delphix Database refreshes, where we provide virtual copy of databases instead of physical which save lot of storage, I helped here saving storage and ultimately money because we had to refresh production copy of DB to UAT, SIT, DEV and Reporting, restoring 5 TB DB on all server requires lot of storage which we saved using Delphix.

TECHNICAL SKILLS:

Operating System: Windows 2008, 2012R2, 2016 Server

Languages: C, C++

Internet Technology: ASP .Net, HTML

Front End: Visual Basic 6.0, C# .Net, VB .Net.

Databases and Tools: SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016. SSIS, SSRS, SSAS

Others: Virtualization (Hyper V, VMware, Vblocks), Windows Clustering, SQL Clustering, DPM (Data Protection Manager), SCOM (System Center Operation Manager 2007/2012), SharePoint

Packages: Delphix, Idera, Vormetric, Attinity

THIRD PARTY TOOLS:

• Delphix tool.
• Power BI
• Lite Speed.
• SQLSafe from Idera.
• DPA (Performance Analyzer Tool)
• ExtraHops
• Check MK
• REDGATE
• AppDynamics
• Attunity Replication
• DSM (Security Manager)
• Splunk
• Vormetric Encryption
• BMC Remedy.
• Altiris Ticketing system.
• CMD - Change Management Deployment.
• DB Refresh Utility Tool.
• RQMS iServe

PROFESSIONAL EXPERIENCE:

Confidential

Tools: SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016

Environment: Windows 2008 and 2008 R2, 2012 R2.

Responsibilities:

• Providing 24/7 DBA Support for any System or SQL Server related issues.
• Install, configure, manage, troubleshoot, create and monitor SQL Server databases.
• Configure High Availability Architecture - Always on Availability, Clustering, Log Shipping, Replication and Mirroring.
• Worked on Azure SQL Database- Migrating databases from On-Premises to Cloud, Creating and maintaining databases and tables.
• Check all on-going issues, like performance/application/ login failure issues.
• Perform backup and restore activities every day.
• Perform Disaster recovery in various critical situations with minimal downtime.
• Refresh the databases every day on request from production to Development, UAT, Test, SIT Env.
• Monitor database refreshes from prod to Reporting server everyday which happens through RM Clone, SQL CDC, Physical and Delphix.
• Generating Config SYNC using REDGET tool for Prod, DEV, SIT, UAT, UT, STG, TRN.
• Check the issues/Alerts like, Log file full, primary file group Full, Database is out of space, TempDB is full. Drive is Full, Running out of space.
• Check the slow running Queries which is impacting SQL server to run slow, Blocking, Deadlocking, Performance Analysis, Optimization and Fine tuning.
• Windows Server is running slow on which SQL is hosted.
• Handling more than 300 Servers having an average of 15 databases in each server ranging from 500MB to 10TB DB size.

Confidential

Database Engineer

Responsibilities:

• Installing, configuring and managing SQL Server on Live sites and on in-house servers.
• Monitoring these servers remotely and managing the databases of sizes ranging from 100 to 4 TB.
• Remotely handling more than 200 Servers having an average of 12 databases in each server at various places in US and India.
• Checking for drive space issues and shrinking the SQL Server database files as necessary.
• Taking Backups, Restoring Backups, and Scheduling backup jobs.
• Server reboot checks and analysis about server settings and cause of reboots and make sure, SQL server related Services are running fine in Auto Start mode.
• Implementing Log shipping in various client servers.
• Configuring SQL Server Memory settings, service packs, deploying databases, mapping user accounts to logins and assigning permissions and roles.
• Configuring and implementing Replication in various client servers.
• Monitoring Event Logs and SQL Server Logs of Servers in a scheduled manner.
• Tracking performance degradations using SQL Profilers and Tuning Advisor.
• Use DTS Packages to Upload the Data extracted from Meditech server to the databases. Creating and Maintaining Databases and Tables.
• Analyzing and Fixing Oversize, Data mismatch, Duplicate Exceptions.