Sql Server Support
Resume:
Harleen Bedi
Marlboro, New Jersey
Email – ********.***@*****.***
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