SUMMARY

• IT Professional with 7+ years of experience in SQL Server Database Administration and SQL Server development
• Experience in installation, maintenance of different versions of SQL Servers (2016,2014, 2012, 2008R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments
• Implemented High Availability & Disaster Recovery techniques like Always - ON Availability Groups, Clustering (Active-Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R 2/2012/2014/2016.
• Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014/2016 new features.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity andDatabase Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and databasesMaintenance.
• Expert in using Native tools like SQL Server Profiler,Database Tuning Advisor and Perfmon.
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience in Physical and logical data modeling using ERWIN & VISIO.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages with (.Net) framework with C# and SSRS reports
• Configuring and maintaining Report Manager and Report Server for reporting services.
• Experience in planning and implementingDatabase Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Handled numerous Change Management requests on production servers Supported 24 X 7 Production on Call.
• Learnt and working knowledge on Cloud based environment for SQL Server (AWS).
• Documenting procedures in run books.

TECHNICAL SKILLS

Programming Languages: Transact-SQL, SQL, C/C++, Java, Mat lab, Lab view, and Visual Basic

RDBMS: MS-SQL Server 2005/ 2008/ 2008 R2/ 2012/ 2014, MS Access, ORACLE 10G/11G.

Operating Systems: Windows 2000, Windows Server 2003/2008/2008 R2,Windows XP, 7 Pro

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Log Viewer, Database Tuning Advisor, and Upgrade Advisor, ORACLE tuning advisor, TOAD, OEM.

ETL Tools: SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools: SSAS 2005/2008/2008 R2/2012

Reporting Tools: SSRS 2005/2008/2012 , Crystal Reports, MS-Excel(Pivot Tables, VBA, Macros)

Data Modeling Tools: CA Erwin, MS-Visio, MS-Visual Studio

Third Party tools: Red Gate, Lite Speed, Idera, Veritas net backup, Spotlight.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, Pennsylvania

SQL Server DBA/Oracle DBA

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2016/2014/12/08/05 Production and Non Production Servers
• Regular DBA tasks such as running jobs, solving the job failure issues and performing backups and restores.
• Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
• Gained very good experience in project delivery management.
• Gained very good experience in Oracle Enterprise Manager to monitor database health checks for databases and for I/O tuning.
• Proficient in Windows, UNIX, Linux, Solaris.
• Analyzing and translating business requirements to technical requirements and architecture.
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Software Architect, Developer, and System Admin.
• Responsible of Oracle Dataguard alerts and set up in different machines.
• Documenting new implementations to OEM
• Monitoring Daily backups, act on those if any backup failures.
• Applying new patches to databases on quarterly basis
• Implementing new cron entries to reduce dependancies on DBA’s
• As a client value developing automation tools to reduce dependency on Database Administrators
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Analyzed the execution plan and index management for better Query Optimization.
• Solved various performance tuning issues such as index fragmentation by reorganizing and rebuilding the indexes. Also worked on tuning the queries on various servers to improve the performance.
• Regular monitoring and workaround on Disk Management and Database File growths and take appropriate action.
• Monitoring SQL Server logins, logs, activities, connectivity, blocking, SQL Server Agent jobs, database andserver performance, and database space and disk space usagesusing home-grown scripts and Quest Spotlight.
• UsedSQL Power shell to script out DDL triggers, stored procedures, UDF’s.
• Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Implemented Database Mirroring as part of disaster recovery plan.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Migrated SQL server 2005 databases into SQL server 2012 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Experience working with the development team on DDL triggers.
• Extracted data from various sources like SQL Server 2008/2012/2014 , Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Handled up to 2.5 TB size database in Active Passive clustered Environment.
• Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/20 R 2/2012/2014.
• Migrated all the OLA scripts from our database(s) to the master database.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Excellent hands on experience writing and modifying various stored procedures and recompiled them based on the requirement.
• Also had an extensive experience working with the Always ON Failover set up in the newly built servers that will be later replacing the production servers from migration.
• Worked on High Availability 2012 Solutions like Always ON.
• Explicitly used third party tools like Lite Speed, Foglight and Red gate.
• Managed Disk space, memory and User connections.
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Configured Bi - directional transactional replication and have resolved many of the issues related to replication.
• Expertise in handling performance issues rose due to lock escalation leading to deadlocks. Also worked on identifying various blocking issues and resolved them.
• Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
• Service Now was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved.

Environment: MS SQL Server 2005, 2008 R2, 2012,2014, 2016, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, Unix, Oracle, SQL Toad MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Service Now Tool.

Confidential

SQL Server DBA/ Oracle DBA

Responsibilities:

• Implemented SQL Server 2008R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2008R2/2005 on Test, Development and Production Environments.
• Worked with SQL Server 2008 side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Moved SharePoint Content Databases from one Drive to another Drive.
• Fixed high Memory utilization issues.
• Experience in using Spotlight for managing databases and troubleshooting performance issues.
• Performance Monitoring of MS SQL Server 2005/2000 using various tools SSMS, Performance Analysis and Spotlight.
• Experience working with Spotlight on SQL Server performance problems, including a specific user, a resource-intensive SQL transaction, an I/O bottleneck and a lock.
• Installed Various Service packs for SQL Server 2008 and 2005.
• Having expertise Knowledge on SQL Server 2012 High availability concepts.
• Just upgraded some Servers to 2012 and have set up Availability groups in Always on.
• Managed SQL Server using PowerShell.
• Automated SQL jobs using SQLPower Shell.
• UsedPower shellfor scriptingSQL Server Database objects, collecting SQL Server information, to get failed jobs.
• Worked On SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Performed other Data Modeling tasks like Logical Modeling (between the Entities) and Physical Modeling (by generating scripts).
• Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources.
• Experience in writing with SSI along with APPLICATION PROGRAMMING INTERFACES (API) which were used to access resources on local computers.
• Also had an extensive experience working with the AlwaysON Failover set up in the newly built servers that will be later replacing the production servers from migration.
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Experience in using Spotlight for managing databases and troubleshooting performance issues.
• Creating SSIS Packages and maintaining them.
• Recreating of DTS packages in 2008 SSIS.
• Documentation of all the packages created.
• Creating SSRS reports in between to test the data by managers, Worked on Data Staging and Cleansing.
• Good hands on experience working with Team Foundation Server while handling operations such as Always On Failover cluster instances, Availability groups, SQL Mirroring and SQL server authentication.
• Worked in Data cleansing and data conversion using sql server 2008 and 2012.
• Migrated MS SQL Server 2008 R2 databases in VMware(Vblock) environment.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Extensively used NetIQ for analyzing SQL Servers Resource Usage, proactive event management, which also allows easy automation and lowers support costs with the Enterprise Management Systems.
• Experience with Visual Studio 2010 using Team Foundation Server
• Experience in working on the SOX environment for SQL Server
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Moved Tempdb files from One Drive to another Drive.
• Worked with Oracle DBA in migration project and supported oracle databases
• Gathering stats on s using DBMS COMPARISION, creating databases, schemas, granting privileges, creating roles, creating tablespaces & managing space issues on database used OEM 10G/11G to monitor Oracle databases on daily basis
• Refreshing schemas from Production to lower environment using Datapump
• Applying shipped archived logs to standby databases using MRP process
• Generated AWR, ASH & ADDM Reports to tune databases and long running queries on Oracle database killed Blocking sessions on oracle databases and monitoring Alert logs.

Environment: SQL Server 2014/2012/2008 R2, Windows Server 2012/2008R2 server, SQL Profiler, Data Collector Tool, Perfmon, T-SQL, SSIS, SSRS, MS- Excel, MS-DOS, Spotlight, Oracle 10g, 11g.

Confidential, Minneapolis, MN

SQL Server DBA/Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2008), SQL Server Enterprise Manager (2008) and Query Analyzer to Administer SQL Server..
• Migrated SQL server 2005 databases into SQL server 2012databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2008.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Install and configure Windows 2008 R2 and 2012 operating systems per contractors design and instructions.
• Built and configured VMware Virtual Machines with Windows operating system (versions: / 2012 R2)
• Domain Controller, DHCP, and application server upgrades from Windows Server 2003 to Server 2008r2 or 2012
• Perform root cause analysis on Windows 2008 R2 and 2012 servers
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Experience using PowerShell (Windows and sql server).
• Querying the databases using thePowershellscripts
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: TSQL,MS SQL SERVER 2000/2005/2008 , SSRS, QUERY ANALYSER, VISUAL STUDIO 2005,WINOWS SERVER 2008,IIS,SSAS

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured MS SQL Server and Clients.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database.
• Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
• Managed Disk space, memory and User connections.
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Established DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server
• Implemented and maintained Replication(Transactional, snapshot) using Dynamic scripts and solving problems
• Performed query tuning and reducedresponse time by 60%
• Discussions with Product team for new features
• Performed query plans and enforced indexing in each and every query
• Propped up the new schema changes and additional new features on Development, Staging/QA and Production servers
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored proc to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and creating Partition views for better performance.
• Programmed in T-SQL to implement StoredProcedures and Functions for different tasks
• Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor.
• Assisted the SQL Developers in query tuning and optimization.
• Created updatable partitioned views
• Created Stored Procedures and triggers to perform automated rules and updation to related tables

Environment: MS SQL server 2008, Windows 2000, Enterprise manager, Query Analyzer, DTS, SQL profiler.