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/ R2/2005.
• 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, certificates, backups and recovery and data loss prevention.
• Enterprise Manager, Management Studio, Query Analyzer, Extended Events, SQL Server Profiler, SQL Server Agent, Business intelligent Studio.
• Proficient on SQL Server HA and DR Solutions like 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.
• Received an Award 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.

TECHNICAL SKILLS:

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

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

Tools: BMC Service desk, CA Service Desk, Spot light, Fog light, Red gate 5.0, Sanvoi,OP manager, IDERA, NetApp Manager

PROFESSIONAL EXPERIENCE:

Confidential,San Francisco,CA

Sr.Senior System Engineer

• 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/2010/2012.
• 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 Idera Tool for monitoring SQL Server Landscape.
• 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 Chevron SJVBU.
• Configuring and Managing and Deploying SSRS, SSIS Reports and Packages.
• Performance optimization and tuning of SQL server database.
• Team Foundation Server Implementation/Configuration and Administration.

Confidential,Monroe,NC

Sr.Systems Engineer

• 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 coordination 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.
• 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 using In place and Side by Side Migration Plan.
• Query Optimization
• Creating and Managing Linked Server
• Table Partitioning
• Database Normalization along with project team to achieve high DB standards.
• Create user logins & permission
• Import & Export Data using Server Wizards.
• Preparing POA and conducting POC as per the requirement and Documentation as per ISO Standards.

Confidential

Data QA Analyst

• 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

Confidential

Software Engineer

• 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.