Edoh GBETOULA
Silver Spring,MD
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
6
6
years of professional experience
Work History
SQL Server Database Administrator
ADMIRAL SECURITY SERVICES
03.2020 - Current
- Planning the Installation of Microsoft SQL Server 2012, 2014, 2016, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in Virtualized environments
- Implementation and level of database access the user would need and with tools like Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure clients sensitive data
- Define vigorous Backup and Recovery strategies and Capacity planning following the company's Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and the Retention policy
- Recommending and implementing data security by creating users and assigning permissions based on the minimum
- Leveraging the uses of in-built software in SSMS such as SQL Server profiler, Performance monitor, Extended Events, DMVs, Database Integrity checks to ensure database integrity, stability, and system availability
- Configured High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems using Clustering - Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring, Replication such as peer-to-peer replication, merger replication and transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery testing
- Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development and testing to mission-critical production systems
- Create and update database documentation about company standard procedures, technology features and production issue troubleshooting
- Analyze, solve, and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning, compression and statistics to enhance speed and maximize system performance
- Creating and monitoring maintenance plans and agent jobs that take backups and defragment indexes for query performance
- Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing on call support during after-hours and weekends
- Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24/7 support
- Review scripts submitted by the development team and working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases
- Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases
- Develops database security guidelines and performs audits.
MS SQL Database Administrator
SCHNEIDER ELECTRIC
01.2018 - 03.2020
- 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 2016 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.
Education
Bachelor in Marketing -
Trade School of IAEC
Lome, TOGOSkills
- Virtualization using VMWare and Hyper-V
- SQL Server Integration Services - SSIS
- SQL Server Analysis Services – SSAS
- SQL Server Reporting Services - SSRS
- Using PowerShell to automate processes on my servers
- Proficient with SQL Server 2012 to 2019, Optimization and Performance Tuning
- Support big databases - 3 terabytes and more
- (HA) and Disaster Recovery (DR) solutions; Traditional Failover Clusters, Always On Availability Groups, Replication, Database Mirroring and Log Shipping
- SQL Server Monitoring - Inbuilt monitoring tools like SQL Server Profiler, Database Tuning Advisor, Extended
Training
Database Administrator, 11/01/17
Languages
English
Full Professional
French
Native or Bilingual
Timeline
SQL Server Database Administrator
ADMIRAL SECURITY SERVICES
03.2020 - Current
MS SQL Database Administrator
SCHNEIDER ELECTRIC
01.2018 - 03.2020
Bachelor in Marketing -
Trade School of IAEC
Similar Profiles
Walkins BeneusWalkins Beneus
Security Supervisor at Admiral Security Services/ ADM Security SolutionsSecurity Supervisor at Admiral Security Services/ ADM Security Solutions
Cordell WrightCordell Wright
Account Manager at Admiral Security ServicesAccount Manager at Admiral Security Services
Richmond GarrickRichmond Garrick
Security Officer at Admiral Security Services/Adamas Building ServicesSecurity Officer at Admiral Security Services/Adamas Building Services
Tyra T. WalkerTyra T. Walker
Supervisor duties – Supervise security guards at Admiral Security ServicesSupervisor duties – Supervise security guards at Admiral Security Services
Alvin BeltranAlvin Beltran
Personal Banker at PNC BankPersonal Banker at PNC Bank