SUMMARY

• Microsoft certified SQL Server DBA with 17 years of experience in database administration, monitoring, designing, troubleshooting and performance tuning, seeking for a challenging position with a prospective and growing company to utilize and expand my technical knowledge, skills and expertise using SQL Server Database 2016/2012/2008 R 2/2005/2000.
• My expertise entails in database optimization, installation, backup/recovery, DR/HA, database design, security management including data encryption/decryption, ETL, SSIS and SSRS. Ability to identify root causes, bottlenecks and other database issues to troubleshoot and resolve promptly.
• Skilled in high availability SQL Server solutions including Log Shipping, Mirroring, Replications, Always On Availability Groups and SQL Server Clustering. I am an effective communicator with strong work ethic, exceptional relationship, management skills and ability to relate to people at any professional level.
• Installation and configuration of SQL server 2016/2012/2008 /2005/2000.
• 24/7 on call support in Production, Testing and Development environment.
• Good understanding and working knowledge of SQL Azure.
• Migrated and Created SQL Server Databases using PaaS and IaaS.
• Automated Patching for SQL Server in Azure Virtual Machines (Resource Manager)
• Implemented, Configured, and Supported H/A technologies with Azure SQL Server.
• Good understanding of VmWare 5.5. Concepts and Implemented in Data centers.
• Experience with database Backups and Restores.
• Good experience in applying SQL Server Service Packs in all SQL 2016/2012/2008 servers.
• Performed Log Shipping and Database Mirroring as disaster recovery solution to different customers.
• Implemented Active Passive Clustering as high availability techniques using Always on in all SQL 2016/2012 servers.
• Installation and configuration of MS SQL Server Reporting Services (SSRS).
• Expert in performance tuning and handling blocking situation and dead lock situations.
• Experience in Deploying SSIS Packages in various environments.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Experience in working with Windows Server 2012/2008/2003 Enterprise Editions, Windows 2000 Advanced Server, Windows 2000 Server and Windows NT.
• Excellent communication and interpersonal skills, self - motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.
• Good team player with strong analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012/2008/2003/2000 ,Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS.

Performance tools: Spotlight.

Web Server: Internet Information Server 6.0 /7.0

Databases: SQL Server 2016/2012/2008 /2005/2000, MS Access, Oracle 7.3, DB2

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Backup Tools: VERITAS, Lite speed, DDBoost.

Cloud: VmWare 5.5, Azure SQL

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Database Administrator\Lead DBA

Responsibilities:

• Managing all SQL Servers in all environments i.e. SQL 2016/2012/2008 .
• Migrated and Created SQL Server Databases using PaaS and IaaS.
• Automated Patching for SQL Server in Azure Virtual Machines (Resource Manager).
• Implemented, Configured, and Supported of H/A technologies with Azure SQL Server
• Installation and Configurations of Large SQL Database instances.
• Performance tuning of large databases at Application, Operating systems and Database Levels.
• Backup and restore of SQL Server databases using Lite Speed and Veritas and DDbost in SQL2016\2012 environments.
• SQL Server 2012 and 2016 Migrations (Side By Side Migration).
• Implementing High Availability features like Always On in SQL2016\2012 environments.
• Extensive use of Data mirroring to replicate the data from PROD to DR
• Deployed SSIS packages and SSRS Reports.
• Monitored, Automated and scheduled jobs through SQL Server Agent.
• Coordinating with the I.T. Manager and Business Stakeholders, system downtimes and deployment of latest database releases across all environments. (Dev, UAT, Prod)
• Provided back-up DBA support for all DBA team members.
• Involved in setting up a Datacenter for Community Health Network of Connecticut.
• Implemented Active \Active and Active\passive Windows clustering.

Confidential, Princeton, NJ

Sr. Database Administrator

Responsibilities:

• Creating Database Backups and Restores upon client requests.
• Creating and managing user roles and assigning necessary permissions.
• Creating automation of maintenance jobs, Day-to-day maintenance activities such as running DBCC, Transaction Logs, File growths etc.
• Implement all high availability techniques like log shipping, Database Mirroring
• Solve critical production issues, such as table deadlocks and blocking
• SQL Servers 2008 Migrations.
• Coordinating with the I.T. Manager and Business Stakeholders, system downtimes and deployment of latest database releases across all environments. (Dev, UAT, Prod)

Confidential

Sr.Database Administrator/Tech. Lead

Responsibilities:

• Installed CRM Application and Web Vehicle Applications on Remote Servers
• Managed a team of 8 members.
• Installation and configuration of SQL server 2008/2005 with respective service packs.
• Maintained SQL Server Databases approx. 200 databases.
• Using TSQL Scripts automated maintenance activities.
• Migrated data from MS SQL Server 2000 to SQL Server 2005 and SQL Server 2008
• Monitored, Automated and scheduled jobs through SQL Server Agent.
• Maintained Database authentication and authorization of database objects, created users, configured permissions and assigned roles to users.
• Used Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries / Indexing.
• Continuously Monitored routine data maintenance like re-indexing, database shrinking, and log file monitoring using Dynamic Management Views and Functions.
• Responsible for Database Backups & Restoration, Backup Strategies and Scheduling Backups.
• Involved in Running DBCC consistency checks, and fixing data corruption in user databases.
• Monitored database growth activities & Troubleshoot Transaction Log & Space Issues
• Investigated and applied necessary SQL Server database patches and installed service packs.
• Involved in performance tuning and building indexes for query optimization.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Created SSIS Tasks and assigned to MS SQL Server Agent.
• Deployed SSIS package for bulk insert and maintained archival data.
• Monitored the event logs and Server error logs for troubleshooting purposes.
• Created web sites in IIS to access CRM Application (Web Servers).
• Created FTP sites for installing Web Vehicle Applications.
• Installed Crystal reports application viewer and hotfixes.
• Provided back-up DBA support for all DBA team members.
• Installed .NetFramework2.0 and MSxml4.0 and Crystal Reports Viewer.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).