I.Professional Summary

Highly analytical and results-driven IT professional with over 5 years of which 2 years of IT Support Specialist and 3 years of DBA. I have developed a working experience in SQL Server Administration. Design, install, and/or upgrade enterprise relational database management systems and application tool. Very good experience with performance tuning, and monitoring for optimization using inbuilt tools and third-party tools such as sp_blitz, SolarWinds. Extensive knowledge of designing Disaster Recovery Solutions and perform Backup and Recovery of databases and setting up High Availability and Disaster Recovery Solutions in SQL such as Always On Availability groups, Log Shipping, Mirroring and Replication. Good knowledge of TSQL and Stored Procedures. Excellent expertise in SQL server upgrade and database migration as well as Azure Databases. Knowledge of installing and configuring SQL Server Reporting Services (SSRS) as well as migrating SSRS database from one server to another and managing permission and deploying SSRS reports. A very good knowledge of Virtualization system.

II.PROFESSIONAL EXPERIENCE

A.MSSQL DATABASE ADMINISTRATOR

Project: 09/2020-11/2020

Migration from SQL Server 2012 to SQL Server 2019.

Worked with development and application team for application upgrades.

Abbott-REMOTE, USA

01/2021 – 01/2024

Responsibilities:

Maintain database security by assigning suitable responsibilities to diverse employees, monitoring user accounts, creating groups, and granting access to users.

Migrating and upgrading SQL Server 2016 to SQL Server 2019 by reviewing, planning, testing, and installing database security patches and service packs.

Installing and maintaining SQL Server database systems. Ensuring successful backups, resolving system issues, monitoring success and failure of automated jobs, monitor system availability, updating system and database recovery.

Coordinating with the Systems Administration team, in building virtual machines for SQL installation.

Worked with Relational Database Administration - SQL Server-Transact-SQL.

Design, documentation, and promote security best practices, policies, standards.

Working with development and systems teams to perform application and database upgrades and tuning.

Analyzing organizational needs and implementing cost-effective solutions.

Collaborating with developers to design, develop, and implement new database applications.

Setup the maintenance of appropriate database and application monitoring using sp_blitz and SolarWinds monitoring tools.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Setting up TDE and always encrypted and Dynamic Data Masking for sensitive data.

Configuring, monitoring HA and DR solutions. Always On AG, Log shipping, Replication, Failover clustering.

Performed daily tasks such as error checks and database health monitoring of physical resources (disc space, memory, CPU), as well as performance parameter adjustments as needed.

Set up, configured DB mail, and create jobs to send out an email whenever any SQL jobs fails.

Key skills and Strengths.

Good interpersonal skills; solid team player.

Attention to detail, excellent work ethic, professionalism, ability to work in a highly collaborative team environment.

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

Highly self-motivated, adaptable and open to learning and understanding new technology strategies.

B.INFORMATION TECHNOLOGY SUPPORT SPECIALIST

Maine Medical Center: Portland, Maine March 2019-August 2020

Prosearch IT Support Specialist:

Dealing with tickets, break and fix, reimaging PCs, Hardware and software deinstallation and installation, installing printers, PC upgrading from windows 7 to windows 10.

Various programs and software install on more than 1,500 laptops for users working remotely due to Covid-19.

HPI/EMHS: Bangor, Pittsfield, Waterville, Maine December 2018

Information Technology Support Specialist:

Hardware and software deinstallation and installation.

Updating software from windows XP or 7 to Windows 10.

Swapping out current printers for HP printers.

Swapping out current laptops for HP laptops.

Installations, moves, additions, and changes (IMAC).

Data Backup and Recovery.

Network Internet or WIFI connection.

Mercy Hospital: Portland, Maine. October 2018-November 2018.

Pro-search IT Technical Support worked on a Mercy Hospital project of imaging:

Install software and upgrading windows10 of about 1,000 laptops and Mini desktop in Portland, ME. October 2018.

III.EDUCATION

SMCC South Portland, Maine, US

CompTIA Network+.

Networking: CISCO routing, cabling, Vlans and Trunking.

NTI Scarborough, Maine, US

CompTIA+ at the NTI.

Computer Installation and Repair Technology/Technician

ISTC / Muanda-DRC

3 years of College, IT computer Programming.

OTHER SKILLS

Fluent in English, Portuguese, French and Lingala.

Microsoft Office Suite: Word, Excel, Power Point, Access, Outlook.

Contact this candidate