Sql Server Dba Resume Philadelphia, PA - Hire IT People

SUMMARY:

5 Years of Database Administration on MSSQL Server 2016,2014, 2012, 2008R2.
Experience in Migrating from SQL server 2008R2 to 2012, 2014 and 2016 by using In - Place upgrade process as well as side-by-side upgrade process.
Supporting different High Availability & Disaster Recovery scenarios like Always-On Availability Groups, Clustering, Replication, Log Shipping and Database Mirroring.
Served as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management
2 years of experience Deploying SSIS packages (TFS), SSRS deployment to web report portal and granting users permissions to report server
Experience in setting up and managing database security by creating new users, roles, and provide required user privileges in development, test, environments
Some experience using PowerShell. (Still learning)
Experience handling Locks, Deadlocks, Detect CPU, I/O, Memory Bottlenecks, Optimization, Performance tuning of SQL Server databases using Extended events, DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tool. (SOLARWINDS DPA) Query Optimization and Database Consistency Checks using DBCC Utilities, Re-Indexing, Updating Statistics, performing Maintenance Tasks.
Diagnosed job errors and implemented solutions.
Experience in importing/exporting data from various sources of data into SQL Server Databases and vice versa
24 X 7 Production Database on Call Support.
Have a flair for technology and willing to take up challenging assignments
Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently.
Devoted and Quick learner with ability to master and implement recent technologies

SKILL:

Environment: Databases: Virtualization tools (VMware), Azure, SQL Server 2017/2016/2014/2012/2008 R2 Enterprise, Windows Enterprise Server 2012/2008R2, T-SQL, SSIS, SSRS, Tools BCP, Import and Export Wizard, Profiler, DTS, SQL Diagnostic Manager, Microsoft Office (Word, Excel, Power Point, Outlook, Access)

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Sql Server Dba

Responsibilities:

As a production dba, I am responsible for resolving Sql server database incident tickets
Providing Sql server implementation changes requested from application teams
Responsible for installing, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test and development environments.
Currently working on moving application workloads to AZURE
Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS.
Ensuring data recovery, maintenance, Data integrity and space requirements for physical database.
Creation and maintenance of Databases, creating Roles and managing user permissions and Admin groups.
Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics.
Supports day to day operational duties for the database platform such as service now requests and tickets, and other tasks as assigned or expected from DBAs
Responsible for Securing Sql server, user management, assigning permissions and roles.
Perform database deployments (After work hours) and provide support for application releases
Assist developers with MS SQL Server issues and questions
Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure
Deploying SSIS packages and SSRS reports
Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008R2, 2012, and 2014 environments
Participating in on call rotation.

Confidential, Columbia, MD

Junior SQL Server DBA

Responsibilities:

Monitored Databases and troubleshooting SQL Server performance issues
Designed and implemented comprehensive Backup plan and disaster recovery strategies
Maintained Cluster Fail-Over Servers in SQL Server 2008R2 $2012
Installed, Configured, and Administered SQL Server 2008R2 and 2012 in development, test, and production environment
Used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS Sql Server
Applied service packs and security fixes for all Sql Server and provided database administration support
Participated in DR Testing
Ran scripts for Quality Assurance and Production release
Created Jobs for database maintenance

We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Philadelphia, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship