Sql Server Database Administrator

La Vitesse Njinke

Phone: 726-***-**** Email: ad5v43@r.postjobfree.com

PROFILE

I am a goal-oriented IT professional with 4+ years of hands-on experience as a SQL Server database administrator Experience working with high profile customers, both internally and externally, and have an excellent verbal, and communication skills in French and English language. Experience in SQL Server Installation, upgrade, database Migration, Performance tuning and monitoring, database security, general Support of SQL Server for versions 2019/2017/2016/2014/2012 in Production, Development, Test, Environments. Great hands-on experience working with multiple MSSQL Server tools like: MSSQL Server Management Studio (SSMS), Database Engine Tuning Advisor, Query Adviser, SQL Profiler, Data Transformation, Upgrade Wizard, Replication, SQL Reporting, SSIS, Solar Winds, Adera, A proactive DBA who is Ready to Learn and implement New Technologies.

KEY SKILLS AND STRENGTHS

-Excellent work ethic, professionalism, attention to detail, ability to work in a highly collaborative team.

-SQL Server installation and upgrade following best practices

-SQL Server security (TDE, Always encrypted, data masking)

-Setting up HADR solutions (Always-on, Log shipping, replication)

-Excellent analytical skills with the ability to manage time, priorities, and requests.

-Excellent communication and interpersonal skills.

-Strong knowledge of database recovery models, high-availability (HA) and disaster recovery (DR) options for SQL Server.

-Ability to produce quality work products with attention to detail.

-Good working knowledge of health care industry.

-Highly self-motivated and adaptable to learning and understanding new technologies.

-Good interpersonal skills.

-Team player.

-Ability to serve and communicate with diverse clients in English and French

-Effective time management

PROFESSIONAL EXPERIENCE

American Freight 08/2021 to Present

MSSQL SQL Server Database Administrator

-Implement best practices on Microsoft SQL Server Databases and Servers.

-Installed SQL Server 2014, 2016 and, 2017 on servers, applied security fixes Monitor databases using inbuilt SQL Server tools and 3rd party tools.

-Create and Manage SQL server Users, Roles, and Privileges.

-Implemented Snapshot, transactional and merge Replication.

-Plan and implement database backups/restore based on company’s SLA.

-Manage indexes (update statistics) to improve performance.

-Schedule jobs, configure alert and monitor using SQL server agent.

-Maintain database security at high priority following company security policies.

-Update security tables, database auditing and limiting data access to defined groups.

-Upgrade SQL Server databases from SQL Server 2012 to SQL Server 2019.

-Performance tuning and Query Optimization.

-Setup Always on Availability groups for High Availability and Disaster Recovery.

-Troubleshooting and fixing performance issues related to slow running applications and queries.

-Document Processes and Procedures.

-Interact with developers, application team and project managers.

-Use Redgate monitoring tool to monitor our environment.

-Respond to and resolve all databases access and performance issues.

-Ensure databases adhere to corporate standards and policies, including database auditing.

CLZ Consulting. 02/2020 to 07/2021

MSSQL SQL Server Database Administrator

-Design, develop, test, deploy and maintain databases, database objects, database security and database recovery solutions.

-Supervised and Upgraded SQL Server 2012 servers to SQL Server 2019 with both In-place and Side by Side Upgrade for new client applications.

-Configure and setup Always On availability groups in a 3-node cluster.

-Instituted the maintenance and support of Replication and Log Shipping.

-Created various maintenance plans for index fragmentation and backups to automate the teams’ tasks and ensure better system health and performance.

-Identify existing systems that are candidates to be enhanced or modernized through detailed analysis of the use and design of current databases.

-Develops rules and guidelines for the development of SQL objects. Optimizes indexes and tables. Creates and maintains database dictionaries and schema documentation. Designs and deploys data table structures, triggers, functions, stored procedures, and views. Creates queries and reports. Fulfills data requests. Resolves database access and performance issues.

-Interface with developers, network, virtualization, storage, and systems operations teams to resolve problems with applications and database systems.

Contact this candidate