SUMMARY

• 10 years of experience in MS SQL SERVER 2014/2012/2008 R2,2008,2005/2000 database Development and Administration (DBA) in business & technical environments domains with a strong working knowledge of high availability
• I have an experience in database administration activities like installation, configuration of SQL servers and database lifecycle, Data migration and upgrading, strong SQL server.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience on Active/Passive and Active/Active Cluster.
• Implemented Database Mirroring and Log shipping in SQL Server 2005,2008,2012 and 2014
• Experience in using SQL Server Profilers, Index Tuning Wizard and Windows Performance monitor to monitor SQL Server.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008 & 2012.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Experience in Design, deployment, and maintenance of SSRS and SSIS SQL Server
• Hands on experience on Always on concepts in SQL 2012 & 2014
• Extensive knowledge about In memory process in SQL 2014
• Experience on Cluster Installation and Up gradation
• Experience in resolving MSI & MSP Files missing issues.
• Worked on resolving space issues on oracle databases.
• Experience in Oracle 10g, 11g & 12c database administration.
• Worked on Building table spaces, data files, tables, logins, roles, and indexes.
• Worked on Cold and hot backups of oracle database.
• Worked on Exporting and importing data from different sources to oracle databases in both legacy and data dump method.
• Worked on improving the performance on PLSQL queries
• Experience in Analyzing Execution Plan, Managing indexes and troubleshooting deadlocks.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle, Sybase and DB2.
• Worked on different third party tools like LiteSpeed, Foglight, SQLDM (IDERA), and SQLCM (IDERA).
• Highly dedicated, dynamic, ability to meet deadlines within fast paced environments
• Self-Starter, Result Oriented, Responsible Team Member and Co-Operative Individual
• Thorough experience with Recovery of SQL Server in a Disaster Condition. Provided 24x7 Production Support for mission critical applications on call rotation basis.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, .NET

RDBMS: MS SQL Server 2000/2005/2008/2012 and 2014, MS-Access, and Oracle 8i/9i/10g/11g/12c

Reporting Tools: Crystal Reports, SQL Server Reporting services (2000/2005)

Database Tools: SQL Server Management Studio, SQL Server Enterprise Manager, Query Analyzer, SQL Server Reporting Service, TFS,SQL Developer

Development skills: T-SQL, PL/SQL

Operating Systems: Windows 2000/NT/XP, Windows Server 2003/2008/2012 , UNIX

Software Packages: MS Word, MS Excel, PowerPoint, Power shell, MS Access, Visual Source Safe 2005,Visio

Third party tools: Foglight, Litespeed, ( Idera)Sqlcm(Idera)

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr SQL Server DBA

Responsibilities:

• Installation of SQL Server 2008 R2,2012 & SQL2014 on Standalone Servers
• Installation of SQL Server 2008 R2,2012 & SQL2014 clusters
• Performed SQL 2008 to SQL 2012/2014 migration
• Applying Service packs and Patches on standalone servers & cluster nodes
• Resolving the issues related to installations and up gradations
• Worked on Test, Dev, and pre-prod and production servers
• Worked creating logins, tables, indexes, table spaces and Data files
• Configuration of Log shipping
• Working on TFS Server
• Working on Power Shell
• Configuration of Mirroring (Synchronous &Asynchronous)
• Developed Data warehousing environments using SSIS packages
• Worked on high availability options of both SQL 2012 and SQL 2014.
• Configuration of Transactional replication (Push & Pull Subscriptions)
• Up gradation(Migration) of SQL Server 2008,SQL Server 2008 R2 to SQL Server 2012 & 2014
• Migration of SQL Server from physical servers to Virtual servers and Vice versa
• Configuration of Always-on on Type 1,2,3and Type 4
• Creation of Jobs and Sending Alerts using Database Mail.
• Implementation of Maintenance Plans and Shrinking for Database Consistency and Integrity.
• Creation of Logins, users and groups with appropriate roles.
• Developing Successful Backup Strategies based on recovery model.
• Recovery of Database at the time of Database crashes.
• Working on RDBMS, including SQL programming, data analysis and processing procedures.
• Worked on MSI & MSP files issues which were a raised at the time of SQL up gradation.
• Manage assigned support tickets to insure timely escalation and resolution of issues and provide required status to customer. Take ownership of assigned support issues, including “misdirected issues” when reported by the customer.
• Provide all levels of email/phone technical support for Change Management
• Work directly with MSIT customers, partners, and sales technical staff to provide technical support services.

Environment: Windows 2003/2008/2012 server, MS SQL Server 2000/2005/2008 R2, 2012, 2014 MSAccess, T-SQL,TFS, MS Excel, power shell, Performance analyzer and SQL developer

Confidential, Houston, TX

Sr. SQL Server DBA

Responsibilities:

• Maintained a stable process of database refresh from production to internal environments.
• Installed Configured and Maintained deployments for SQL 2008,2008r2 and 2012
• Responsible for Setup, configuration, maintenance of SQL Servers and their Mirroring.
• Ensured the integrity and security and auditing the SQL Servers.
• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
• Working on RDBMS, including SQL programming, data analysis and processing procedures.
• Configuring log shipping and replication
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Participated in regular annual Disaster Recovery Activity and successfully recovered Databases.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
• Working with Power Shell,Foglight (Monitoring tool) and lite speed (Backup tool).
• Working with TFS server.
• Generated Performance analysis reports for all the prod servers on weekly basis using third party tool Foglight.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.
• Created Linked Servers between SQL Server 2000, SQL Server 2008 and OLE DB data sources.
• Creating and scheduling maintenance plans which include Database Backups database maintenance checks like shrink database, re-organizing and rebuilding of Indexes

Environment: Windows 2003/2008/2012 server, MS SQL Server 2000/2005/2008 R2, 2012,MSAccess, T-SQL,TFS, MS Excel, Foglight, Lite speed, Power Shell, Performance analyzer and SQL developer

Confidential

Lead SQL Server DBA

Responsibilities:

• Providing 24/7 On-Call supports for critical production databases.
• Install, configure, administer, secure and maintain SQL Server 2000, 2008 and 2012 instances and databases
• Refreshes from Production backup to Stage and Development environments
• Troubleshooting performance issues with Native SQL Profiler, Perfmon and other third party tools
• Proactively monitoring space and minimizing space issues.
• Design and implementation of standards across all the SQL Servers.
• Implementing and administering database replication.
• Configure and Monitoring log shipping and planning for Disaster recovery.
• Managing SQL Server on a cluster and experience in installing service packs.
• Monitoring DBA and Application jobs and troubleshooting the same.
• Managing Database security my providing the appropriate permissions to the users.
• Preparing Capacity planning for the large databases.
• Ensuring the SQL Server to be with the Confidential and companies security compliance.
• Worked closely with developers and users to resolve and provide support for Confidential applications
• Patching and upgrading both Windows and SQL Servers in the Confidential space
• Planning downtime for patching and other application maintenance activities
• Troubleshooting SQL Server and application related issues
• Supported high available technologies like Clustering and Database mirroring and resolved critical issues.
• Resolving connectivity and ad-hoc user issues.
• Monitoring replication and resolving related issues.
• Working on Power Shell.
• Experience on performance tuning and query tuning.
• Worked on Creating logins and providing Permissions to user.
• Work on Stored Procedures, Modifying Tables, Views, Indexes, and User-defined Functions.
• Used DBCC Commands for to improve the performance and integrity of the database.
• Created linked server from SQL environment to other environments like oracle environment.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Writing T-SQL code.

Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2, MS Access, T-SQLMS Excel, lite speed,Power Shell, Sqldm( Idera)Sqlcm(Idera).

Confidential

Sr. SQL Server DBA

Responsibilities:

• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Applying Service Packs and Security patches for the Servers as released.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Created jobs to rebuild indexes and updating index statistics in regular intervals.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Have prepared User-Manuals and Technical documents for the project, which includes ED (Environment Description) documents/ Run Books / RCA’s within the team.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different Environments.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: - SSMS SQL Server 2008/2005/T-SQL, Windows XP, Windows 2000, 2003, 2008

Confidential

SQL Developer/.Net Developer/ SQL DBA and Oracle DBA

Responsibilities:

• Started working as developer and created advanced stored procedures
• Quickly migrated into SQL Server DBA and Worked on SQL 2000 and SQL 2005 servers.
• Created Maintenance plans to Automate Backups and Database maintenance
• Worked on Exporting and importing tables in oracle
• Worked on Backup and restore on oracle databases
• Databases creations
• Worked on .net coding for App
• Performed day to day actions on the server
• Created linked servers for both SQL to SQL and SQL to ORACLE 8i & 10g.
• Worked Migration of databases from SQL

Environment: SQL Server 2008/05/00, Windows 2003, Windows 2000 Server, MS SQL Server2000/2005,Oracle 8i/10g, Confidential SQL server Visual Studio 2005/2008, MS Business Intelligence