SUMMARY

• 8+ years of experience wif teh 32bit, 64 - bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand-alone Server Environments.
• Experience in installing MS SQL Server 2008, 2008R2, 2012, 2014, 2016 and updating wif hot fix and service packs.
• Experience in implementing AlwaysON Availability Groups in SQL Server 2014 & 2016.
• Experience in SQL 2016 new features like Polybase, Stretch Database, In-memory OLTP and other SQL Server features like Transparent Data Encryption(TDE) and Change data capture(CDC).
• Experience in Microsoft Azure Cloud and working knowledge of Infrastructure as a Service(IaaS), Platform as a Service(PaaS) and Software as a Service(SaaS).
• Extensive experience in implementing high availability and Disaster recovery concepts like AlwaysON, Clustering, Mirroring and Replication (Snap Shot and Transactional).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Experience in data modeling like (Logical and Physical) modeling by using ERWIN tool, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Have hands on experience wif Powershell for backups, DBCC DB checks, post installation setups security (user & logins), and automating some jobs.
• Experience in analyzing Locks, Deadlock’s and handling teh Isolation Levels and Concurrency TEMPEffects.
• Extensively used teh native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis.
• Experience in Backing up, restoring teh database manually and also by scheduling teh jobs and Maintenance Plans.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Extensive experience in teh development of Reports using SQL Server 2008/2012 Reporting Services (SSRS) and MS Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi-dimensional objects.
• Extensive experience and proficiency and implementation of Business Intelligence tools, ETL process (Data Extraction, Transformation and Load) wif DTS/SSIS, Data Cleansing MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS).
• Experience configuring and working wif Microsoft SQL server 2008/R2, 2012, 2014 on VMware/Hyper-V Environment.
• Strong experience in mentoring team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, VB.NET, C/C++, Visual Basic 6

Operating Systems: Windows 2005/2008/2012/2014 , LINUX, VMware ESX servers

Databases: MS SQL Server 2016/2014/2012/2008 R2/2005, Oracle11g/12c MYSQL

ETL &Reporting Tools: SSIS, SSRS, SSAS, Power BI

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Symantec NetBackup, Erwin, Lite Speed, Red gate, Spot light,Idera

Cloud Computing: Microsoft Azure

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr. SQL Server DBA

Responsibilities:

• Expertise in Always-On Availability groups (AAG) and HA/DR setup and configuration.
• Implemented SQL Server 2016 Always-On pre-prod Cluster.
• Installed and administered several 2-Node cluster and multi node clusters using an active/active and active/passive on Microsoft windows server 2012 Enterprise Edition on SAN environment.
• Experience of handling 15+ TB Database.
• Achieved 99.9% uptime on all SQL Servers.
• Responsible for creating and changing teh visualizations in Power BI reports and Dashboards on client requests.
• Involved in Source Data Analysis and designing mappings for data extraction and also responsible for design and development of SSIS packages to load data from various databases and Files.
• Worked on SQL Server 2005/2008/2012 Clustered and Standalone environments to perform SAN migration of non-production, test and production data from teh Vmax environment.
• Assist wif verification of data integrity, database performance (deadlock, locking, blocking, etc.) and validate teh data migration completion.
• Administrating and Monitoring Database Mirroring and Replication(Transactional) on SQL Server 2008R2 and 2012
• Managing teh VERITAS NetBackup for SQL Backup and Restore.
• Checking teh SQL error logs for any errors dat may have occurred over Migration night and Checking Database Health by using DBCC Commands and DMVS.
• Work on day-day tasks like backup failure tickets, daily disk free space reports and application related supported work.
• Schedule project Update/Status meetings and Experienced working under agile project management.
• Experience working wif Service Now ticketing tool.

Confidential, Murray Hill, NJ

Sr. SQL Server DBA

Responsibilities:

• Installing, building, configuring and supporting SQL Server 2012 and 2014 database servers.
• Responsible for maintaining teh production and non-production databases for Duck Creek Suite hosted in teh cloud and database maintenance activities like (Reorganize and Rebuild Indexes).
• Creating and administering Databases in Cloud-Azure SQL and on-premises environment
• Implemented SQL Server 2012 new features like Always on Availability for high availability of multiple databases in place of database mirroring.
• Actively involved in setting up Active-Active/Active-Passive Clustering in production and non-production environments and applied hot fixes/Service Packs in Clustering environments.
• Implemented teh restores of SQL Azure databases wif a clear understanding of teh backup retention periods of teh Azure databases as per their service tiers.
• Set up and monitoredtransactional replication (Peer to Peer), database mirroring on Production, QA and Dev serversand troubleshot errors.
• Constructed SSIS packages, tested and implemented to import- export OLEDB sources.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.
• Implemented SQL server security best practices and transparent data encryption (TDE).
• Developed and automated daily, weekly and monthly counts of Claims by Scheduling teh SQL Job.
• Responsible for ensuring dat production SLAs are met, upgrades are delivered wifout disruption of claims service and monitoring Claims in case of any failures.
• Monitoring teh data files, log file space issues, blockings, Tempdb space issues and disk space issues.
• Applying data fixes into production as necessary, and triaging data-related tickets raised in production.
• Providing monthly metrics regarding database usage and Contributed to Technical Documentation and Run Book updates.
• Provided 24/7 support by actively monitoring teh job history, alerts.

Confidential, Dallas, TX

Sr. SQL Server DBA

Responsibilities:

• Created database diagrams using Erwin Data Modeler.
• Maintenance and support of over 10TB of critical financial database systems.
• Maintained over 55 SQL Server machines; over 100 instances; over 700 databases in this organization’s global environments.
• Transferring teh data (ETL) to Data warehouse (Informatica) by SSIS.
• Created reports having teh memory information of all teh databases in all instances in a clustered environment using SQL Server 2005/2008R2 Reporting Services (SSRS).
• Designed new schema for data partition and creating Partition views for better performance.
• Maintained databases on Oracle and IBM db2 environments.
• Extensively workedDMVs, DMFs and DTAto tune teh databases, servers and query tuning
• Provided support for day-to-day operations and troubleshooting
• Experience wif Red gate third party tool for SQL Server backup and Monitoring.
• Comply wif Change Control Procedures by working on tasks/tickets assigned to Database Operations Queues wifin BMC Remedy and Salesforce.
• Documented all processes to promote admin team knowledge sharing and Provided 24x7 On Call Production support.

Confidential, Compton, CA

SQL Server DBA wif Level II Support

Responsibilities:

• Performed in-place upgrade from SQL Server R2
• Migrated databases from SQL Server 2008R2toSQL Server 2012including SSIS packages
• Performed Failover drill tests to check teh High Availability during disasters.
• Used Lite Speed for backups and maintenance jobs which includes updating statistics, database integrity checks.
• Worked in setting upthe SQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Created Logins, Roles and Proxy accounts wif appropriate permissions and maintaining Database Maintenance Plans.
• Worked on extensively on Linked servers and also was part of Oracle 11g Upgrade.
• Monitored alerts usingFog LightandSpotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Installed, Managed and administrated SQL Server 2008R2/2008/2005 on production and non-production servers on both 64 & 32 bit systems.
• Installed SQL Server 2008R2 and service packson Windows Server Clustered environment.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server management studio and SQL Server agent. Implemented Point- In-Time recovery solutions.
• Created teh deployment scripts after development is done for every projects. Also, generated script files when teh changes applied to stored procedures and functions.
• Assisted on teh Adhoc-Query requests based on teh requirement by using joins, sub queries and co-related sub queries.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Worked on planning and implementing MS SQL Server security and permissions.

Confidential

Jr SQL Server Developer/DBA

Responsibilities:

• Worked as Jr SQL DBA/Developer, additionally completed academic project in this company.
• Installed and Configured of SQL Server 2005 and SQL 2008 on Windows 2008 systems.
• Used SQL profiler to monitor teh server performance, debug T-SQL and slow running queries.
• Created Clustered and Non-Clustered Indexes to improve data access performance.
• Scheduled Full, Differential and transactional log backups to disks, remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for teh databases
• Managed Disk space, memory and User connections.
• Extensively developed SQL scripts for maintaining administration tasks.