Harleen Bedi

Marlboro, New Jersey

Email – ac77pt@r.postjobfree.com

Contact no. – +1-848-***-****

Over 6 years of experience in Database Administration and Support of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Production, Test, Development, Replication and Failover Cluster environments

Professional Summary

Experience in providing 24/7 Production Support

Expertise in Database Administration on Production Servers with server installation, configuration, performance tuning, maintenance and troubleshooting

Experience in High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability groups, Replication, Log Shipping and Mirroring

Experienced in Upgrade/Migration of Microsoft SQL Server 2008 to 2008R2, Server 2012 to 2014, Server 2008 to 2014

Expert in automation through SQL stored procedures

Experience in Azure cloud hosting

Experience working with Azure SQL Database Import and Export Service and deploying SQL Databases in Azure.

Experience in tuning queries which are running slow using different methods in terms of evaluating joins, indexes, updating statistics and code modifications

Experienced with partially contained databases

Experienced in Backup and Recovery

Experienced in monitoring the health and performance of SQL servers using native tools and third-party solutions

Adept at T SQL, stored procedures, tables, indexes, views, functions, and triggers

Created various SSIS, SSRS and SSAS Packages to serve company needs

Used DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third-party tools to resolve bottlenecks, dead locks and slow running queries

Responsible for securing SQL Server - user management, assigning permissions and roles

Experienced with Test/Production which included documentation of processes, creation of test scenarios and execution of tests to ensure UI standards met the required specifications.

Experienced in creating technical documentations and process archiving and change management

Experienced in working independently as well as in team oriented environments

Experienced in problem solving, analysis and conflict resolutions

Experienced in supporting and maintaining large databases and troubleshooting

Excellent analytical, communication and interpersonal skills

SQL Servers & Tools: SQL Server 2005/2008/2008R2/2012/2014, Azure cloud, Export/Import, PowerShell, SQLBackup, Lite Speed, Red Gate, Idera, SQLSafe, and Backup Exec.

ETL Tools: SSIS

Data Modeler: SSAS

Reporting & Audit Tools: SSRS, Report Builder, Idera SQL Compliance Manager and SQL Secure.

Virtualization: VMware and Hyper V

Third Party Tools: RedGate, Spotlight, and IderaSQLsuite, Ola Hellengren and Brent Ozar’s Maintenance Scripts

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS,

Operating System: Windows 7, 8, 10, Windows NT/2000/2003/2008 and 2012 servers

Work Experience

Consultant SQL Server Database Administrator

Maintech Inc. Cranford, New Jersey February 2018 – July 2018

Installed and Upgraded from SQL server 2008, 2008 R2, 2012 to 2016 (rolling upgrade)

Migrated Databases from SQL Server 2012 to SQL server 2014 and 2016

Installed and administered Eight-node failover cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment

Collected information about the servers and database instances in scope for upgrade through Microsoft Assessment and Planning Toolkit

Provided 24/7 support during the migration process

Worked with the System Administration team and Network Administration team during the windows clustering creation.

SQL Server Database Administrator

Studyabroad.shiksha.com Noida, India October 2014 – May 2017

As a production L2 support, was responsible for resolving incident tickets escalated from L1 support and handling critical incidents (Sev1, Sev2 high)

Providing SQL Server implementation changes requested from application teams

Responsible for installing, configuring, and maintaining databases as per supported LOB applications

Created necessary T SQL scripts, stored procedures, tables, views, functions, triggers and indexes

Responsible for providing SQL Server problem resolution and 24/7 production support and server outages

Responsible for disaster recovery and high availability solutions and large-scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.

Created and migrated partially contained databases within AlwaysOn Availability Groups

Created automation of day-to-day operations, critical SQL server alerts and repetitive tasks

Monitored the health and performance of SQL server instances and in-house applications using Extended Events, SQL server Profiler, PerfMon and other third-party tools

Tested newly built servers for performance impact with Database load simulators

Setup and maintained Log Shipping between various environments

Maintained Test/Production which included documentation of processes, creation of test scenarios and execution of tests, via TSQL scripts, to ensure UI standards met the required specifications

Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling

Backed up master & system databases and restored them when required

Optimized the Indexes, adding/deleting them when necessary for better performance

Verified backups and error logs on the servers and troubleshoot any failures or alert problems

Responsible for Installing, configuring and maintaining SQL failover clustering for production environments

Worked with installation, configuration and creation of SSRS

Worked with installation, configuration and creation of SSIS

Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem

Responsible for securing SQL Server, user management, and taking care of permissions and roles

Environment: Microsoft SQL Server 2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2008R2, Clustering, Always On, Mirroring, Log Shipping, Replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Office 2013

SQL Server Database Administrator

99Acres.com Noida, India August 2012 - September 2014

Responsibilities:

Installed and configured SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail

Installed SQL Servers with latest service packs, cumulative updates, hotfixes

Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.

Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers

Monitored data activities like database status, logs, space utilization, locks and long transactions

Provided appropriate access to users except system databases owners

Supported SQL server developers working on different projects with various requests

Converted and redesigned existing DTS packages to SSIS packages

Developed SSIS packages to import and export data from existing systems to upgraded system.

Used database utility programs and third-party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.

Environment: MS SQL Server 2008R2/2008/2005, T SQL, Lite Speed, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 2003/2008 Server

Junior SQL Server Database Administrator

InfoEdge Pvt. Ltd. New Delhi May 2011 May 2012

Responsibilities:

As a L2 support, we worked on incident tickets escalated from L1 support team.

Responsible for MS SQL Server 2005 and 2008 and database administration.

24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.

Created database maintenance plans for SQL backups, optimization, and integrity check and t log backups.

Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.

Configured and maintained transactional and Snapshot replication for 3 environments.

Worked with SQL Disaster Recovery processes and documented/revised those processes.

Worked with capacity planning, database sizing and monitoring.

Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.

Involved in creating DTS Packages to import and export operations in and out of SQL Servers.

Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.

Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Environment: MS SQL Server 2008/2005, T SQL, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 2003 Server.

Education

Bachelors of Science – Computer Science

Miranda House College, Delhi University India 2007 - 2010

Emphasis in Database management

Trained in SQL and Testing

Volunteered and participated in several cultural events

Contact this candidate