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 and Database 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 databases Maintenance.
• 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 implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement. Configured Amazon Virtual Private Cloud (Amazon VPC) to control security groups and firewall rules and AWS Identity and Access Management (IAM) to control user credentials and roles.
• Develop and implement solutions using AWS Cloud platform and its features which includes EC2, VPC, EBS, AMI, SNS, RDS, EBS, CloudWatch, Cloud Trail, Cloud Formation, AWS Config, Auto scaling, Cloud Front, IAM, S3, and Route53
• 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++ 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

• Installed, managed and administrated the MS SQL Server 2016/2014/12/08/05 Production and Non-Production Servers
• 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.
• Responsible of Oracle Dataguard alerts and set up in different machines.
• 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.
• Develop and implement solutions using AWS Cloud platform and its features which includes EC2, VPC, EBS, AMI, SNS, RDS, EBS, CloudWatch, Cloud Trail, Cloud Formation, AWS Config, Auto scaling, Cloud Front, IAM, S3, and Route53.
• Monitoring SQL Server logins, logs, activities, connectivity, blocking, SQL Server Agent jobs, database and server performance, and database space and disk space usages using home-grown scripts and Quest Spotlight.
• 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.
• 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/2005/2008 /2008 R 2/2012/2014.
• 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.
• Explicitly used third party tools like Lite Speed, Foglight and Red gate.
• Configured Bi - directional transactional replication and have resolved many of the issues related to replication.
• Hands on experience with Shell scripting.
• 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, Excel, HTML, NetBackup tool, Service Now Tool.

Confidential

SQL Server DBA/ Oracle DBA

• 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 on Operational side for Disk Space, Log Space, Blocking, Deadlock issues and fixed high Memory utilization issues.
• 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.
• Upgraded some Servers to 2012 and have set up Availability groups in Always on.
• Used Power shell for scripting SQL Server Database objects, collecting SQL Server information, to get failed jobs.
• Worked on SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• 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.
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• 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.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• 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.
• 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

• 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: 2008 / 2012 / 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.
• 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

• 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