PROFESSIONAL SUMMARY:

• SQL Server Certified with 8+ years of experience as a SQL Server DBA in the analysis, design, and maintenance of Database systems in the Client Server environment on version 2014/2012/2008/ R 2/2005/2000.
• Troubleshooting SQL Server performance issues and train staff on areas for improvement in code, storage, indexes, and configuration.
• Managing and monitoring around 600+ Virtualized SQL Server.
• Bottleneck analysis on database and application and identify and resolve the issues.
• Have configured and implemented High availability and disaster recovery in company’s SQL Servers using Always On, Database Replication and log shipping
• Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server
• Data migration between homogenous and heterogeneous system using various tools like Data Transformation Services (DTS), SSIS, BCP, Bulk Insert.
• Develop system documentation for Encryption and data loss prevention.
• Develop operational and installation procedures for SQL Server encryption, databases, s, backups and recovery and data loss prevention.
• Enterprise Manager, Management Studio, Query Analyzer, Extended Events, SQL Server Profiler, SQL Server Agent, Business intelligent Studio.
• Implemented SQL server Always On, SQL Server clustering, Mirroring & log shipping.
• Experience in Normalization, Performance Tuning, Disaster Recovery and Data Archiving.
• Experience with T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensive experience with data modeling, logical and physical database design.
• Experience in Deploying SQL Scripts to update and deploy databases.
• Experience with Analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Strong knowledge and experience in SQL Server disaster recovery, backup/restore, migration and upgrade.
• Strong skills using Microsoft Integration Service and Reporting Services with Business Intelligence Development Studio.
• Deliver presentations and webcasts to my peers and juniors on a variety of database topics.
• Worked as IT coordinator for Onshore/offshore 24x7 (6 members team), which earned me good experience in managing/ documenting every piece for long term stability share easy.
• Hands on Experience on Change Data Capture an Enterprise Feature of SQL Server.
• Monitoring of Autosys jobs configured using SQL Server Agent, Alerts, and Operators.
• Received an for Completing SQL/TFS migration from 2005 version to 2012 both SQL server and TFS Server
• Industry working experience in SQL Server database management, maintenance, performance tuning, and troubleshooting.
• Strong Hold on ITIL Process and Concepts Using Remedy Management tools Like CA Service desk and BMC Remedy.
• SQL Server Migration Specialist which includes Side by Side and IN place SQL Server Migration on Cloud and Virtual Environment.
• Hands on experience on Oracle and MySQL.
• Around 15 months of Experience on Cloud Platforms like AWS and Microsoft Azure.

TECHNICAL SKILLS:

Operating Systems & DBMS: Proficient with WINDOWS WIN 2000, 2003, 2008, 2008R2, 2012, Windows azure 2012and Ubuntu Linux 15.XX. Good knowledge about the SQL Server 2000/2005/2008/2008 R2/2012/2014, MYSQL, SharePoint 2010, Team Foundation Server 2008/2010/2012 , Oracle 12c. Data warehousing using DTS tools, SSAS,SSRS, SSIS, and Oracle Golden Gate, DB Forge, Navicat, ApexSQlSuite. Proficient with IIS Setup.

Programming Language and Package: C, C#.Net, T-SQL.

Areas of Interest: Data Base Management System & Server Management & Cloud Computing.

Tools: BMC Service desk, CA Service Desk, Spotlight, Foglight, Red gate 5.0, Sanvoi, OP manager, IDERA, NetApp Manager, Light speed

PROFESSIONAL EXPERIENCE:

Confidential (Los Angeles, CA)

Sr SQL Server DBA L3 Support

Responsibilities:

• Supporting servers in the Dev/ QA/UAT/Prod environment for SQL Server 2014, 2012, 2008 R2, 2008, 2005 and 2000 Databases.
• Installation of SQL Server 2008 R2, 2012, 2014 and Implementing Fox standards.
• SQL Server migration - Migration of SQL server from 2000, 2005, 2008 to SQL server 2008R 2/2012/2014.
• Installation of Client Software Oracle, Netezza, MySQL, DB2 and NoSQL.
• Creating and Maintaining Linked Server
• Creating User logins & permission on Instance and Databases.
• Import & Export Data using SSIS and Import Export Wizard.
• Migrating SSRS and SSIS Packages in Co-ordination with Application Developers.
• Configuring SQL Replication, Log shipping, Database Mirroring, Always on and SQL clustering on Windows Platform involved in Migration and day to day Operations.
• Implementation and Configuration of DR Site Solution.
• Performance optimization and tuning of SQL server database.
• Capacity Planning and SQL Resource Management Implementation on Windows Platform.
• Implementation of Consolidation of SQL server.
• Installation, Configuration, Backup and Recovery of Microsoft SQL Server 2000, 2005, 2008R2, 2012, 2014.
• Configuring and Managing and Deploying SSAS, SSRS, SSIS Cubes, Reports and Packages.
• Configured and Deployed Light Speed for SQL Compressed backup.
• Handling of Day to Operations Tasks Using Service Now.
• Index Rebuild and Re-Organize as Per Microsoft Recommendation.

Confidential (Fresno, CA)

SQL Server DBA-III

Responsibilities:

• Supporting servers in the Dev/ UAT/Prod environment for SQL Server 2014, 2012, 2008 R2, 2008 and 2005 Databases.
• Configured DB mirroring with Automatic Fail over on SQL Server 2012.
• Configured Always ON Availability Group on SQL Server 2012.
• Deployment of SQL DB and project codes using TFS Server 2005/ 2008/2010/2012 .
• Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
• Implement SQL Server Database Mirroring with Automatic Failover using SQL server 2012
• Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
• Working on the Indexes of tables.
• Using Orion Tool for monitoring SQL Server Landscape of 50+ SQL Server platform.
• Managing Access Permissions to users on SQL database Servers.
• Maintaining IIS and Supporting windows Server as per SQL server dependent request.
• Provides communication to the customer for Service Request
• Assesses stalled Incident and Service Request and takes appropriate Action to move them through the process.
• Ensures misrouted cases are trapped and assigned to correct support workgroups.
• Complete Service Request as per the Service Level Agreement.
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
• SQL Server migration - Migration of SQL server from 2005 to SQL server 2008/2008R2/2012 on Cloud Platform including Amazon and Microsoft Azure.
• Assisting developers to Optimize Query.
• Creating and Maintaining Linked Server
• Create user logins & permission
• Import & Export Data.
• Implementation and Configuration of DR Site Solution
• SSRS site Management for Reports hosted on Production environment.
• Configuring and Managing and Deploying SSRS, SSIS Reports and Packages.
• Performance optimization and tuning of SQL server database.
• Installation, configuration of MYSQL on Ubuntu Server.
• Administration of MYSQL Server.
• Done Side by Side Migration from SQL server 2008 to SQL server 2012 on Windows Azure 2012 with Total DB size of around 450 GB.
• Full Development of SSRS & SSAS Reports as per Requirement.
• Implementation, Configuration, Deployment and Supporting of SSRS, SSIS, SSAS Components from SQL Server BIDS.
• SSAS Backup, Restore and Security Configuration using XMLA and GUI for Data warehousing Projects.
• Hands on Experience of MYSQL And Oracle 12c on Ubuntu 14.04
• Setting Replication for MYSQL 5.6
• Patching of MYSQL servers.

Environment: Amazon Cloud,AzureCloud Windows 2012/ 2008/2003/2000 , Ubuntu14.02, MS-SQL Server 2012/ 2008/2005/2000 , SSIS, SSRS, SSAS System Monitor / Performance Monitor, MYSQL.

Confidential (Bakersfield, CA)

Sr. SQL Server DBA

Responsibilities:

• Supporting servers in the Dev/ UAT/Prod environment for SQL Server 2012, 2008 R2, 2008 and 2005 Databases.
• Deployment of SQL DB and project codes using TFS Server 2005/ 2008/2010/2012 .
• Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
• Implement SQL Server Failover Clustering for High Availability production server
• Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
• Working on the Indexes of tables.
• Using Idera Tool for monitoring SQL Server Landscape of 600+ SQL Server platform.
• Managing Access Permissions to users on SQL database Servers.
• Maintaining IIS and Supporting windows Server as per SQL server dependent request.
• Provides communication to the customer for Service Request
• Assesses stalled Incident and Service Request and takes appropriate Action to move them through the process.
• Ensures misrouted cases are trapped and assigned to correct support workgroups.
• Complete Service Request as per the Service Level Agreement.
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
• SQL Server migration - Migration of SQL server from 2005 to SQL server 2008/2008R2/2012
• Assisting developers to Optimize Query.
• Creating and Maintaining Linked Server
• Create user logins & permission
• Import & Export Data.
• Implementation and Configuration of DR Site Solution
• Working in Agile Methodology with various projects within Confidential SJVBU.
• Configuring and Managing and Deploying SSRS, SSIS Reports and Packages.
• Performance optimization and tuning of SQL server database.
• Implementing of Change Data Capture and Enterprise Feature of SQL server for auditing the SQL Tables.

Environment: Windows 2012/ 2008/2003/2000 , MS-SQL Server 2012/ 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor, Oracle 11g, Idera .

Confidential (Monroe, NC)

Sr. SQL Server DBA

Responsibilities:

• Implemented 2 SQL Server 2008 R2 two node cluster in virtual environment as per client requirement.
• Implemented the Oracle Golden gate for Data replication from Oracle 11g server to SQL Server.
• Documented the data flow diagram using the Microsoft Visio.
• Migrated from SQL Server 2000 to Server 2008 r2 using side by side migration technique.
• Migrated SQL server 2000 DTS to SQL Server 2005 and above into SSIS packages in co ordination with development team.
• Documented the SQL server Inventory.
• Configured updateable transactional replication for implementing data staging SQL Server.
• Implemented the Back plan for All SQL Server and configured the Alerts to the client using SQL DB Mail.
• Planned and updated the SQL Server patches accordingly.
• Maintained the SQL Server Access list accordingly.
• Implemented Standard SQL practices for the Performance tuning.
• Implemented and configured the entire ATI Landscape on OPMANAGER Monitoring tool.
• Supporting servers in the Dev/ SIT/ UAT/Prod environment for SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 Databases.

Environment: Windows 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor, Oracle 11g, HP OPManager.

Confidential

Responsibilities:

• Supporting servers in the Dev/ SIT/ UAT/Prod environment for SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 Databases.
• Performance optimization and tuning of SQL server database.
• Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
• Implement SQL Server Failover Clustering for High Availability UAT & production server
• Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
• Working on the Indexes of tables.
• Using SQL Fog light, SQL Spot light, and Sanvoi Tools for Monitoring.
• Smoke Testing the Database once password change activity is done
• Assigning Access Permissions to users on SQL databases
• Providing access to Share folder
• Provides communication to the customer for Service Request
• Assesses stalled Incident and Service Request and takes appropriate
• Action to move them through the process
• Ensures misrouted cases are trapped and assigned to correct support workgroups
• Assess all escalated Incident and Service Request and provide the direction and communication
• Needed to resolve the Incident and Service Request quickly and efficiently as possible.
• Complete Service Request as per the Service Level Agreement
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
• Data migration - Migration of SQL server from 2005 to SQL server 2008/2008R2
• Query Optimization
• Linked Server
• Table Partitioning
• Database Normalization
• Create user logins & permission
• Import & Export Data
• Preparing POA and conducting POC as per the requirement and Documentation as per ISO Standards.

Environment: Windows 2012/ 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor

Confidential

SQL Server DBA

Responsibilities:

• Data Exporting and Importing (One server to other server) using DTS tools.
• Implement database design solution in collaboration with programming team
• Designed and maintained project databases using SQL ensured accuracy of information and automated functions.
• Managing indexes and Performance problems.
• Installation and configuration the SQL Servers
• Implementation and uploading of data on SQL SERVER
• Data migration - Migration of SQL server from 2000 to SQL server 2005
• To check it out the Backup of the databases. Restore the databases as per requirement.
• To setup the Backup plans and create the jobs and schedule the jobs.
• Monitoring database growth.
• Replication and Integrity - To create the Replication between the two servers and transferred the data using replication between two servers.
• Developed utility programs for SQL (Query’s, Store Procedures, Triggers, Views)
• Communication with client to ensure end user information discrepancies resolved.
• To optimize the queries using the Execution plan.
• Retrieving data as per the client requests and maintaining the log of data

Environment: Windows 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor.

Confidential

Jr SQL Server DBA

Responsibilities:

• Installation of SQL server versions and Configuring the Application with the Databases
• Data Exporting and Importing- Upload the new data in DB and managing productivity report.
• Data Extraction as per client requirement- Processed data can extracted from DB and Send the data to client. Backup activity And Maintaining the DB
• Updating Scripts according to Requirements.
• Checking the status whether the backup done or not according to Check list.

Environment: Windows 2003/2000, MS-SQL Server 2005/2000, SSIS, SSRS, System Monitor / Performance Monitor.