SUMMARY:

• Over 11+ years of IT experience in Database Administration and System Administration in various domains like Finance, Insurance, Healthcare, Mortgage etc.
• Expert in installation and configuration of MS SQL Server 2014/2012/2008 /2005/2000.
• Experience of Upgradation and migration from earlier version of SQL Server to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 in different environments.
• Expert Level skills in providing 24x7 support in Production, Preview and Development environment.
• Strong in SQL, T - SQL and PL/SQL Database programming - development of stored procedures, cursors, triggers & Views.
• Implemented HADR solutions (Always On, Replication, Mirroring & Log shipping).
• Implemented Always On technology in Multi & Single subnet environments.
• Handled up to 9+ TB of data.
• Worked on VMWare, SQL Cloud (Azure) and Amazon Web services (AWS) technologies to host SQL Servers in cloud environment.
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard, Performance dashboard, Windows Performance Monitor.
• Expert in designing disaster recovery model for corporate databases.
• Expert in utilizing different Monitoring tools including third party tools.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Experience in MS SQL Server client/server connectivity, query optimization, replication, mirroring, back-up/ recovery, running Database Consistency Checks using DBCC commands.
• Worked extensively in clustered environment (active / passive) to further increase scalability and stability of business-critical systems.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Experience in Installation of SSRS. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
• Strong Leadership and Managerial skills, energetic, self-starter, quick learner and a team player.

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2000/20 R2/2012/2014, Analysis Server 2000/2005/2008 , Ms Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSAS

SQL, T: SQL, XML, PL/SQL.

MS: Front Page, Internet Information Server(IIS), FTP, TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Utility Tools: MS Office, MS Project, ClearQuest, Visual Source Safe 6.0, HP Openview, BMC Remedy, HP Service Manager, BDA.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

S r.SQL Server DBA

Responsibilities:

• As part of L3 team managed 1000+ servers and 10000+ databases.
• Automated pre-patching and post patching checklist for SQL Server process using PowerShell.
• Participated in Annual DR exercises, Disabled Mirroring, Log Shipping and Always on and re configured it after DR exercise. Performed health checks for SRM protected servers after DR test.
• Worked on SQL Upgrades and Data center migrations.
• Responsible for Installation, Configuration and Administration of MSSQL Server 2008R 2/2012/2014/2017 on windows 2003/2008/2012/2014 Servers.
• Implemented New backup solution Cohesity throughout the environment.
• Documented and Trained L2 Support DBA s on Cohesity.
• Modified SQL Scripts to do object level backups directly to Cohesity Cluster and Modified daily database refresh jobs using Powershell.
• Implemented PowerBI for new applications.
• Moved Archive data to AWS S3 Bucket using OneData.
• Moved databases to Azure for third party applications after End of life support for On-Prem servers.
• As part of Sybase retirement project, moved Data from Sybase to SQL Server 2016.
• As a Cross-Training effort, trained non-MS SQL L2 Support DBA s on MS SQL, Windows and Cluster.
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.
• Environment: SQL Server 2008R 2/2012/2014/2017 with Clustering, Windows 2000/2003/2008/2012 Servers, RML Utility, JIRA, Confluence, TFS, Power Shell 3.0, T-SQL, DTS, SSIS, SSAS.

Confidential, Jacksonville, FL

S r.SQL Server DBA

Responsibilities:

• As part of Operations L2 support managed 3000+ servers and managed 20000+ databases.
• Used ITSM, work request and ARM tools for day to day process as part of daily activities.
• Automated user access management using PowerShell.
• Automated pre-patching and post patching checklist for SQL Server process using PowerShell.
• Participated in Annual DR exercises, Disabled Mirroring, Log Shipping and Always on and re configured it after DR exercise.
• Used BDA tool to apply patches and fixes for SQL Instances on Stand-Alone server. Applied patches manually on Clusters.
• Worked on SQL Upgrades and Data center migration CRQ s as part of operations team.
• Responsible for Installation, Configuration and Administration of MSSQL Server 2008/2008R2/2012/2014 on windows 2003/2008/2012/2014 Servers.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for upgrades, patches and fixes.
• Monitor performance and current space utilization reports to management along with recommendations for any corrective action.
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.

Environment: SQL Server 2005/2008/2008 R2/2012/2014 with Clustering, Windows 2000/2003/2008/2012 Servers, BDA, RML Utility, Red Gate SQL Compare, TFS, Power Shell 3.0, T-SQL, DTS, SSIS, SSAS.

Confidential, Jersey City, NJ

S r.SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Administration of MSSQL Server 2008/2008 R2/2012 on windows 2003/2008 Servers.
• Successfully upgraded the databases from SQL Server 2005 to SQL Server 2008/2008 R2.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for upgrades, patches and fixes.
• Worked on tickets assigned as part of 24/7 on call support.
• Configured log shipping from Production to QA servers.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008/2012.
• Created VB Scripts to automate Month End Processing and Credit Bureau Reporting.
• Monitor performance and current space utilization reports to management along with recommendations for any corrective action.
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.
• Automated Monthly Invoicing process using SSRS and VB Scripts.
• Setup Data Warehouse environment for reporting and archiving needs.

Environment: SQL Server 2005/2008/2008 R2/2012 with Clustering, Windows 2000/2003/2008/2012 Servers, RML Utility, Red Gate SQL Compare, TFS, Power Shell 3.0,T-SQL, DTS, SSIS, SSAS and SSRS.

Confidential, Lexington, MA

S r.SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Administration of MSSQL Server 2008/2008 R2/2012 on windows 2003/2008 Servers.
• Consolidated SQL Instances on Physical and VMware to save the licensing cost. Decommissioned above 150+ unused databases and 20 SQL Instances as part of consolidation effort.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2008/2008 R2.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for upgrades, patches and fixes.
• Worked on tickets assigned as part of 24/7 on call support.
• Implemented Transactional Replication for FDA and Real Estate systems to accommodate their Reporting needs.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008/2008 R2.
• Installed and configured Red Gate SQL Backup and SQL Compare in Dev, QA and Prod servers.
• Strictly followed HIPAA standards for our Clinical Systems and SOX Compliance for our financial systems. Removed unused logins and users as per Audit requirements.
• Tuning Queries and Database performance using tools like Database Tuning Advisor, PSSDiag and RML Utilities.
• Setup Mirroring as part of DR solution for critical applications.
• Configuring backups using Symantec NetBackup client for all production and non-production databases.
• Setup Deadlock and Blocking chain monitoring alerts for critical OLTP systems.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Convert MS Access database to SQL databases to overcome 2GB limit hurdle for MS Access databases. Created indexes for these new databases to improve their performance
• Collected SQL profiler trace and analyzed it as part of AppProfiling effort. Provide recommendations to the Vendor and tested all custom changes and implemented in Production.
• Worked in Active/Passive and Active/Active 2 node and 3 node clustered environments.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/20 R2/2012/2014 with Clustering, Windows 2000/2003/2008 Servers, RML Utility, PSSDiag, BMC Remedy, Red Gate SQL Compare, TFS, Litespeed, Power Shell 3.0, Symantec NetBackup, T-SQL, DTS, SSIS, SSAS and SSRS.

Confidential, Orlando, FL

S r.SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Administration of MSSQL Server 2000/20 R2 on windows 2000/2003/2008 Servers.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008/2008 R2.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for upgrades, patches and fixes.
• Worked on tickets assigned as part of 24/7 on call support.
• Implemented Transactional Replication for New Production Environments for Disney Cruise Line.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008/2008 R2.
• Installed and configured Red Gate SQL Backup and SQL Compare in Dev, QA and Prod servers.
• Tuning Queries and Database performance using tools like Database Tuning Advisor, PSSDiag and RML Utilities.
• Schedule and Implement production changes following ITILv3 standards.
• Configure and Install EFS certificates on all Production Servers and Encrypt databases using certificate keys.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Setup mirroring on Critical DLR Production databases.
• Worked in Active/Passive and Active/Active 2 node and 3 node clustered environments.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/20 R2/2012 with Clustering, Windows 2000/2003/2008 Servers, RML Utility, PSSDiag, BMC Patrol, Red Gate SQL Backup, SharePoint, HP Service Manager, ITILv3, T-SQL, DTS, SSIS, SSAS and SSRS.

Confidential, Lenexa, KS

Responsibilities:

• Responsible for Installation, Configuration and Administration of MS SQL Server 2000/2005/2008 on windows 2000/2003/2008 Servers.
• Responsible for configuring Quest Spotlight tool on all Production servers.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for installations, upgrades, patches and fixes.
• Worked on tickets assigned as part of 24/7 on call support.
• Implemented the new SQL Server 2008 concepts like Policy Based Management and Resource Governor.
• Implemented Transactional Replication for New Production Environments
• Configured log shipping from Production to QA servers.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008.
• Automated Health Check process for database and auditing the servers using Power Shell.
• Installed and configured litespeed in Dev, UAT and Prod servers.
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, Power Shell 1.0, Windows 2000/2003/2008 Servers, RML Utility, PSSDiag, Quest Spotlight, HP Service Manager, SharePoint, T-SQL, DTS, SSIS, SSAS and SSRS.

Confidential, Somerset, NJ

S QL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005/2008 on windows 2000/2003/2008 Servers.
• Automated Installation of SQL Server 2005 SP3, CU6 and SQL Server 2008 client tools (work stations) through BMC Blade logic tool.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Automated Health Check process for database and auditing the servers using Power Shell 1.0.
• Implemented MBSA 2.1 in all the environments to monitor the windows/SQL Server patches.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008.
• Installed and configured litespeed on Dev, QA and Prod servers.
• Installed and configured Report Server on windows 2008 server.
• Monitoring and trouble shooting Cluster resources in all the environments.
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active multi node clusters.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, Power Shell 1.0, MBSA 2.1, Windows 2000/2003/2008 Servers, SQL Diag, BMC Blade Logic, TSM, DTS, T-SQL, SSIS, SSAS and SSRS.

Confidential, Chicago, IL

SQL Upgrade DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005/2008 on windows 2000/2003/2008 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Scheduling SSIS jobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.
• Documented steps need to be taken while upgrading the SQL server 2000 to SQL server 2005/2008, which includes in-place, side-by-side and stand-alone migration. environment.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Designed database standards as per HIPAA and PHI specifics.
• Participated in Disaster Recovery drill.
• Optimized the Disk space for performance using RAID and SAN.
• Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, DTSxChange, MSAccess, VMware ESX, Windows 2000/2003/2008 Servers, Litespeed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.