Resume

Sql Maintenance

Location:

Palestine, TX, 75801

Posted:

January 12, 2021

Contact this candidate

Resume:

JENNETTE SALIKI

Location: Tyler TX, • Tel: 405-***-****• Email: adjc7v@r.postjobfree.com

Work Authorization: U S CITIZEN

Technical Summary

• 5+ Years of Database Administration on MSSQL Server 2017,2014, 2012, 2008R2.

• Experience in Migrating from SQL server 2008R2 to 2012, 2014 and 2017 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 models, 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 through visual studio, (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, training 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) Query Optimization, Client/Server Connectivity, 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

• Some Experience in MS AZURE ( Still Learning )

BRIACLIFF HEALTH CENTER

SQL Server DBA – TYLER, TX- Dec/2018- Present

Responsibilities:

• Installation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test and development environments.

• 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

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

• Expertise Implementing high availability with Always On Availability and Failover Clustering with Disaster Recovering

HUMILITY HEALTH

Sql Server Dba – TYLER, TX- JULY/2016- NOV/2018