Neha Sharma adbh21@r.postjobfree.com

774-***-****

Experience Summary

SQL Server DBA with more than 10 years of IT experience with expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server in Production, Staging and Development Environments.

Career Summary:

● Installation, configuration & maintenance of SQL Standalone & Failover clustered servers with the latest Service Packs, Hot Fixes.

●Implementation & Maintenance of High Availability Concepts like Always on Availability Groups, Mirroring, Log shipping and replication.

● SQL server Migration from of on-premise application databases to SQL hosted over Azure.

●Performing Capacity Planning for the databases & and Logical/Physical database Designing along with the Backup and Restoration Strategies to meet RTO and RPO.

●Monitoring & troubleshooting Performance issues with tools like SQL Profiler and Windows Performance Monitor.

●Creating SQL Server Audits and policies to monitor activity on SQL databases to ensure databases compiled and meeting the Service Level Requirements of the clients.

●Strong experience in ITIL process and working on the ticketing system that coordinate (Service Request, Change, Incident, Release and Problem management) and met the Service Level Requirements of clients.

●Working on SSIS, SSRS and SSAS. Creating and migrating the SSIS packages and reports.

●Facilitating the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.

●Designing interactive dashboards using Power BI.

●Experience in a high volume OLTP & OLAP (Data Warehouse) environment. Having Experience on Data center servers and handling 2 TB databases.

Certifications

●ITIL® 2011 Foundation - Exam

●533 - Implementing Microsoft Azure Infrastructure Solutions

●764 - Administering a SQL Database Infrastructure

●IELTS General Training

Technical Skills

RDBMS

MS SQL Server 2016/2014/2012/2008R2

Operating Systems

Windows Server 2008, Windows Server 2012

Other Tools

ISM\Service Now, DMA, Litespeed, Foglight, SCOM, Spectrum, Attention, e-Health, Perfmon, SQL Server Profiler, Database Tuning Advisor, BMC Remedy, Power BI

Professional Summary

Company: Adroit Technologies & Cloud Solutions Inc. Nov 2019 – Till Date

Role: Database Engineer

Responsibilities

●Design interactive dashboards using Power BI.

●Validate the security of Power BI dashboards & update as needed.

●Evaluate the advantages, disadvantages, and limitations of various design options.

●Design and development of ETL jobs to perform Extract, transform, and load data using Power Query, SQL, SSIS, and related technologies.

●Document the requirements, dataflows, and dashboard construction.

Client: VectorUSA Dec 2018 – Nov 2019

Role: Database Administrator

Responsibilities

●Install, configure, and troubleshoot SQL databases, as well as cluster technologies.

●Perform capacity planning and monitor database usage while providing tier two support for the Database Administration team.

●Accurately document procedures, configurations, trouble descriptions, and problem resolution.

●Provide support to developers to implement solutions as needed, release code, and creatively solve problems.

●Participate in incident management and problem resolutions in a timely fashion, escalating issues as needed. Work with technical and service teams to maintain, troubleshoot, and connect technical issues.

●Document all work actions as required by VectorUSA in accordance with standard policies and procedures.

●Support multiple systems in 24 x 7 environment operational environments with high uptime requirements.

Client: Vyaire Medical Jun 2017 – Nov 2018

Company: Cognizant

Role: SQL DBA/Database Lead (SME)

Responsibilities

●Work as a Database Lead (SME) by providing technical leadership and efforts driven by database systems, such as upgrades, database appliance and consolidation for Data Center migration Project.

●As a technical resource, work directly with solutions architecture team to help onboard an Azure solution.

●Design & implement Always On, clustering, virtualization and high transactional enterprise systems.

●Perform Performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools. Triage/track outstanding issues, analyze root cause, provide solutions to minimize future occurrences.

●Maintain various database, server, and application metrics. Observe trends that might help longer-term capacity planning and analysis efforts.

●Document security policies, standards, and procedures for database elements including access, roles, tables, stored procedures, and schemas.

Client: Amgen Oct 2012 – Jun 2017

Company: Cognizant

Role: Sr. SQL DBA (Tier –III)

Responsibilities

●Create & maintain Performance Baseline for the reduction on time spent on performance issues.

●Install & configure 2012 & 2014 in Standalone as well as the Clustered environment. Migrate servers from SQL Server 2008 R2 to SQL Server 2012.

●Build DR sites for existing Production environments and synchronize them by configuring Log shipping or Transactional Replication.

●Troubleshoot issues on Always on, solve Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.

●Create KB\KEDB articles for future reference by the team.

●Create “Run book” during Knowledge Transfer phase of project & update the document with the best practices, so that new team members could refer the Run book to understand the environment.

●Help in resources evaluation for Ramp-up by interviewing candidates for the team. Provide KT to new members at both onsite & offshore.

Client: Bristol Myers Squibb Apr 2011 – Oct 2012

Company: Mphasis

Role: SQL DBA (Tier –II)

Responsibilities

●Install SQL Active-Active as well as Active-Passive clustered instances & administer them on SQL Server 2008R2 & 2008.

●Migrate SQL 2005 instances to SQL 2008R2. Configure the DB Maintenance Plan Tasks, schedule & perform backups / Restoration as required.

●Troubleshoot problems related to performance, disk space, log file full, tempDB full, database job failures, and Backup failures.

●Perform database refresh & user script execution on demand. Export or Import data from other data sources like flat files using the Import/Export wizard.

●Create Logins and provide permissions as per the security policies set by the client's organization.

Client: Microsoft IT Apr 2009 – Apr 2011

Company: Infosys

Role: Jr. DBA

Responsibilities

● Install SQL server 2000 & 2005 to newer servers.

●Backup user databases and perform database refreshes as required.

●Create Indexes and periodically check the fragmentation percentage of the existing indexes. Rebuild them at regular intervals for better performance.

●Troubleshoot blocking issues & deadlocks using blocker scripts, trace flags and activity monitor.

●Create SQL Logins and assign Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

●Identify slow-execution queries by Tracing and troubleshoot.

Education

Title of the Degree with Branch

College/University

Year of Passing

Bachelor of Engineering

Poornima College of Engineering/ University of Rajasthan

2008

Contact this candidate