SUMMARY

• Over 15+ years of experience in MSSQLSERVER 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000 and ORACLE 9I, 10G, 11G and 12C as a Lead Database Specialist / Architect.
• Expert in Installation, Configuration and Maintenance of MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2005 and 2000 standalone VM’s and Physical environments, Windows Cluster environments and Oracle 9I, 10G, 11G, and 12C Versions.
• Experienced in Project Manag e ment, Performance r ev i ew of team members, Budget planning and help with contract negotiations. Microsoft SQL licensing review and true up with Vendors.
• Designed, built and migrated Physical SQL servers to VM, and to Cloud (AWS and Azure) and also configured and planned migration of SQL servers, Oracle and App servers to Multiple Data center.
• Installed and configured SQL2 00 8R 2/ 2012/2014/2016/2017 large VLDB Cluster and with Always on. · Configure, Installed and Migrated reporting server SSRS 2005, SSRS 2008R2 to SSRS 2012/14/16/17. Configure and Migrated SQL2005 and SQL2008R2 SSAS to SQL 2012/14/16/17 SSAS . Extensive experience on Upgrading and Migrating SQL Server to newer versions & applying service packs and patche s.
• Exte nsively worked on 32 bit and 64 bit clustered and standalone server environments .
• Proficient in Performance Tuning, Query optimization using SQL Profiler, Index Tuning Wizard, Database T uning Adviso r (DTA), DMV 's, DBCC comma nd s and reading execution plan s.
• Experienced in maintaining the OLAP Cubes, Processing, Backup, Restore and permission for th e users.
• Experience on Data Transfer from and to SQL Server Databases using utilitie s tools like SSIS, DTS, BCP, BULK INSERT etc.
• 24 X 7 Production Database on Call Support and help solve issue via Service now and ITIL Management.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SSMS, Profiler, D TA, Query Analyzer, DTS, Replication, Mirroring, Always on, Clustering, log shipping, SSIS, SSRS, SSAS

Databases: SQL Server 2000/2005/2008/2008 R 2/ 2012/2014/2016/2017 , Oracle 9x/10x/11x, 12x AS400\DB2, Sybase, MongoDB.

Scripting Languages: T - SQL, PL/SQL, .Net

Web Technologies: HTML, CSS, XML, XSLT, IISOperating Sy stems: Windows XP/ 2000 / 2003 / 2008 / 2008 R2/2012/2012R2/ 2016R2, Linux, Unix

ETL a nd Reporting: DTS, SSIS, SSRS(SQL 2005 / 2008 / 2 0 12/2014/2016/2017 and Power BI

Other Tools: Quest Lite Speed SQL/ Oracle Backup, Quest Spotlight SQL Monitor, Fog light, Barracuda Backup, SQL Sentry, Toad, Salesforce, Developer for Oracle, Toad for Oracle, NetApp

Cloud and Virtual: AWS, AZURE, VMware, Hyper- V

In s tallation Tools: SQL Server 2000/ 2005 / 2008 R 2 / 2012/2014/2016 , Oracle 9I, 10G, 11G, Oracle Client 9I, 10G,11G,12C, Sybase 6.1, 7x, 13x- 17x

PROFESSIONAL EXPERIENCE

Confidential

Lead Database Architect Specialist

Responsibilities:

• Design, built and migrated Physical SQL servers to VM, Datacenters and to Cloud (AWS and Azure) and also Configured and planned migration of SQL servers, Oracle and App servers to Multiple Data center.
• Installed and configured SQL always on with SQL 2012/2014/2016/2017 (3&4 replicas)
• Provided support to 150-200 databa se Servers. Support included Production, QA and Development.
• In st alled and configured SQL Server 2017/2016/2014/2012/2008 R2 / 2005 on stand-alone and active/passive clusters on windows 2003 / 2008R2/2012/2012R2/2016 env ironment.
• Exp Confidential in Capacity plannin g, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures .
• Experienced in Project Manag e ment, Performance r ev i ew of team members, Budget planning and help with contract negotiations. Microsoft SQL licensing review and true up with Vendors.
• Configured and Implemented Log shipping, DB Mirrorin g and Clustering for high availability of data .
• Created Snapshot and Transactional Replication for SQL Server 2005/2008R 2/ 2012/2014/2016/2017 .
• Worked on designing and impl ementi n g the SQL Server behind the Firewall which s its out of domain (DMZ) .
• Involved in Capacity Planning and adding new storage space as needed. Worked on deploying and mi g rating DTS Packages and SSIS packages . Develop ed SSIS packages to transform data between var ious data sources .
• De s igned ETL packages dealin g with different data sources (SQL Server, Flat Files, and Oracle etc. ) and Data load into target data sou rc es by performing different kind s of transformations u sing SSIS.
• Maintain Fai l - Over and Back- up system through use of transaction lo gs, Snap s hot and Transactional replication.
• Good experience in creating Jobs, SQL m ail age nt, partitions and s cheduling DTS and SSIS, SSRS packages.
• Configured and migrated AS400\DB2 to SQL server 2012.
• Gathered user requirements from users and managers to better under stand the business log i c and developed required documentation.
• Main t aining the OLAP cubes Processing, Backup, Restore and permission for the users. Migrated and upgraded SQL Server Analysis 2000, 2005, 2008R2 to SQL SSAS 2012/2014/2016/2017.
• Migrated and upgraded SQL server reporting services 2005, SQLSSRS2008R2 to SQL 2012/14/16/17 and to Power BI.
• Worked as on-call DBA for 24x7 production support along with other team members.
• Partition table, User Permissions, performance tuning for Oracle Server. Managed and Maintain Oracle database such as ta ble spaces, Data files and Inde x Maintenance of Oracle Databases.
• Configured RMAN back up and Compressed Backup using Lite sp eed for Oracle 9I.
• Designed DR site and moved back up from Comm Vault to Disk using Lite Speed for Oracle 9I.

New York Life Insurance, NY

Sr. SQL Server DBA

Responsibilities:

• Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev - Test SQL Servers and 1000+ databases.
• Production Database Administration of SQL Server 2008R 2/2008/2005/2000. Installed and configured SQL Server 200/2005.
• Worked on call support 24/7 and solved many Incident Tickets involving Performance issues and troubleshooting database issues.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005. Created and Maintained jobs, alerts and maintenance plans.
• Worked in Active passive and Active/Active cluster environment, Configured Transactional, Merge and snapshot Replication environment. Implemented Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.
• Monitoring SQL server performance using profiler to find performance and dead locks. Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Created a new Reporting server in SQL SERVER 2005 environment.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
• Configured and maintained Database Mirroring and CTE, new topics like CLR integration on server and Maintained the database consistency with DBCC at regular intervals.
• Maximum performance and uptime in production environment.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Documentation for step needs to be taken while upgrading the SQL server 2000 to SQL server 2005.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Provided support to 50 database Servers . Support included Production, QA and Development.
• Worked on Migration from SQL Server 2000 to 2005 and Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output.
• Wrote complex T - SQL Scripts for generating reports and stored procedures and designed triggers, generated reports using SSRS.
• Designed and developed OLAP Cubes using Analy s is Services .
• Interacted with development and testing team and Configured Linked Servers .
• Involved in Importing and exporting of Databases using various techniques like BCP, DTS.
• Analy z ed and Installed Security patches as required.

Cardinal Health, Piscataway, NJ

SQL Server DBA/ Developer

Responsibilities:

• Built back - end database using programming and scripting language.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Create the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Created transactional and snapshot replication on different servers.
• Monitor database environments, related jobs end procedures Database tuning & optimization Write and maintain stored procedures Work with database tools and utilities for administration and development.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Maintained Fail-Over and Back-up system through use of transaction logs, Snapshot and Transactional replication.
• Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.
• Manage hardware configurations and considerations for SQL Server environment Recommend security of databases; insure that policies are adhered to when they are approved and implemented.
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2000.