Database Administrator

POFESSIONAL SUMMARY

A very detail oriented,highly motivated IT professional with over 5 years of experience in SQL Server Database Administration.Worked in diverse environments(Stand Alone, Cluster) with differents versions of SQL ranging from 2012 to 2019. Highly experienced in scalability, Maintenance,Monitoring and Performance Tunning(troubleshooting complex queries using both SQL inbuild and third party tools Profiler,Execution Plan, Extended Event,Idera,SolarWinds...) Installed,Configured SQL Server 2019 cluster environment with Availability Groups. Highly Provide windows SQL DBA support and technical expertise for multiple Applications(cutting-edge tehnology) in Development,Test and Production. Exellent Experience with Log Shipping,Backup/Recovery,Always-On Availability Groups,Patching,Database Migration,Database Encryption Technologies,Extrating and Migrating using SQL Server Integration Services packages (SSIS,ETL). Experience providing exellent customer service in meeting client’s needs and continous support. Exellent team player with very positive attitude.

Work Authorisation: US Green Card Holder.

TECHNICAL EXPERIENCE

●Upgrading from SQL Server 2012, 2014, 2016 to SQL Server 2019

●Setting HA/ DR Solutions, Log Shipping,Replication, ALWAYS ON AvailabilityGroup

●Applying Windows and SQL patching

●Worked with SysAdmin in Active Directry and I have Installed,Configured SQL 2016,2019 on Virtual Machines(Hypr-V)

●Index maintenances (Rebuilded/Reorganized indexes,Updatae Statistics following best practices )

●Create Maintenance Plan for Backup, Restore using SQL Server inbuild tools and 3rd party tools

●Replication Model (Snapshoot,Transactional) and Log Shipping

●Database migration using SSMS and deployment using SSIS(SQL Integration services packages(ETL)

●Responding to ticket queue (refreshing databases, creating logins and users)

●Highly self-motivated,driven and adaptable,willingness to learn and understanding new technologies

●Excellent work ethic, Organized, attention to detail, ability to work in a highly collaborative

●Exellent communication skill

PROFESSIONAL EXPERIENCE

JOINIT SOLUTION LLC, 09/2018 - Present

MS SQL Database Administrator

Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups following the company SLA Agreement, resolving system issues, opening cases with vendors to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery.

Manage and design/build SQL Server databases/database design

Installing new databases,configuring and working with application teams

Colaborate with the Systems Administration team, in building virtual machines for SQL installation (Hyper-V,Active Directry)

Upgrading SQL Server(in place,side by side) database security, patches(Service pack Upgrade)

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

SQLServer installations,upgrade, strong migrations and configurations on cluster,nodes, availability Environment with differents versions

Investigates and analyes incidents for immediate fix

Perform SQL sever upgrades,patching and migrations

Grant access,creating logings to users and access issue resolution

Monitor and maintain databases maintainance plans for Backups,Inde rebuild/defragment, and database statistic.

Import export

Evaluate system’s health and performance metrics such as I/O, waits types

Implement High Availability (HA/DR) solutions (Log Shipping,Transactional Replication,Mirroring,Database Availabilty Group) and perform database backups and restores for high level of availability and sustainability

SQL Server Backup and Restore, Databases/Tables to meet the business RPO/RTO objectives

Refine and automate regular processes, track issues and document.

Detach and Attach Databases

Migrating Tables and Databases between instances using SQL Server Migration Wizzard.

Work on Migrating,deploying files from Exel,Flat files to SQL server Databases using SSIS,ETL(Extract, Transform and load)

Create/execute DML operations using TSQL/ scripting

Ability to work with vendors to perform installation,configuration and troubleshooting

Maintain security using TDE(Transparent data Encryption),Always Encrypted,Dynamic Data masking,to protect sensitives data.

Install and configure Sql server 2012,2016,2017 and 2019 following Microsoft best practices on Stand alone environment

Provide suggestions for solutions and Maintain database documentation as required

Epiliki Foundation 02/2017 - 08/2018

Database administrator

●Perform all day-to-day aspects of MS SQL database and Administration such as:

Installations, configuration, upgrades, security, user management and Logins, performance tuning and monitoring, database, backup and recovery, trouble shooting, and problem resolution.

●Perform tasks for data recovery, Maintenance, and promoting integrity. Creating and modifying table, running stored procedures, views, indexes and triggers just to name a few.

●Design, install, configure SQL Server databases

●Work with the development team to resolve bug-fixes and assist in relevant testing through various environments

●Automation of DBA Tasks and monitoring using SQL inbuild tools(Creating Jobs)

●Administer, troubleshoot, and resolve failures and critical alerts on SQL Server instances

●Respond promptly to user complaints regarding access to database.

●Perform automated Jobs to run and resolve database issues.

●Desaster Recovery planning assistance.

●Setting up TDE and always encrypted

●Manage database access,permission, security (Acess control,creating Loggins and granting Permission to Users)

●Troubleshooting SQL Server databases issues

●Writting basic T-SQL commands for Select,Joins statements

●Perform schedule maintainance and support release deployment activities after hours

●SQL Server Profiler, Extended Events.

●Write and administer SSIS packages for data import, export, and transfert to other databases

●Storage management.

●Databases Import/Export.

Education:

Associate

Certification

Microsoft Certified Tecnology Associate MTA

Microsoft Azure Data Fundamental DP-900

Languages

French and English

Contact this candidate