Sql Server Database Administrator

BENJAMIN ADELEKE OKANLAWON

SQL SERVER DATABASE ADMINISTRATOR

323-***-**** ********.*********@*****.*** Hawthorne, California 90250 https://www.linkedin.com/in/benjamin-okanlawon-097316276/ PROFESSIONAL SUMMARY

Seasoned SQL Database Administrator with over 5 years of experience effectively managing PROD, TEST, DEV, and clustered environments. Possesses deep expertise in SQL Server installations and configurations, spanning versions 2008 to 2019, while adhering to Microsoft best practices. Extensive knowledge in various areas including database backups and restore, database performance tuning, Windows clustering, database encryption/security, High Availability, and disaster recovery solutions. My experience encompasses implementing failover clustering, log-shipping, mirroring, replication, and Always On solutions in accordance with SLA requirements. Proficiency in database refresh and deployments, SQL server upgrades, patching, and maintaining high- priority database security following the company's security policies. I prioritize creating and managing logins/user permissions based on the principle of least privilege. Strong understanding of Virtual Machines with Hyper-V, Virtual Networks, Active Directory, and Windows server features.

My expertise extends to reviewing database designs and documents and providing suggestions for enhancements to optimize database performance.

Knowledgeable in SSIS, including SSAS, and possess Azure Cloud knowledge, with experience in migrating data to the cloud, ETL processes.

I pay meticulous attention to details, possess exceptional communication, analytical, & organizational skills. Throughout my career, I have demonstrated a strong sense of team commitment, a constant eagerness to learn, and a genuine passion for continuous improvement. PROFESSIONAL SKILLS

• Active Directory

• SQL DBA

• Always-ON

• Technical documentation

• Metrics Communication

• SQL Server Monitoring

• Database Mirroring

• Log Shipping

• Database maintenance

• Troubleshooting

• Power shell

• T-SQL Scripts

• Procedure documentation

• RDBMS (Relational Database)

• Patching

• Data Extraction

• Database Administration

• Replication

• Backup and restore

• High Availability (HA)

• Disaster recovery

• Performance tunning

• Team leadership

• Extract Transfer Load (ETL)

• Clustering

• SSIS, SSRS, SSAS

• Traditional Failover Clustering

• Data Migration

• Security management

• Microsoft Tools

SKILLS

Jira ServiceNow Redgate Idera Diagnostic Manager Microsoft Visual studio Data Migration Assistant SSTD SQL Profiler Extended Events Share point Excel Crystal Report Database Tunning Advisor SQL Agents DMV

Report Builder

EXPERIENCE

SQL Server Database Administrator

Divine Protection Services, Los Angeles, California June 2021 - Current

• Spearheaded and design and implementation of the Enterprise SQL database environment including working with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives

• Overseeing the development and organization of the databases, assessment and implementation of this new technology

• Support applications team to better utilize on-line processing databases environment.

• Create a working model of the transaction processing environment for capacity assessment and planning.

• Develop a methodology for the ongoing assessment of database performance and the identification of problem areas.

• Developed and implemented a security scheme for the database environment, as well as assisting in disaster recovery if necessary.

• Provide leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications.

• Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of the processing database and computing environments.

• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.

• Work with vendors in evaluating and implementing new technologies.

• Own, track and resolve database related incidents and requests within established SLAs.

• Review service-related reports such as database backups, maintenance, monitoring on daily basis.

• Respond to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems that ensure efficiency and effectiveness.

• Ensure scheduled SQL Patching, upgrade, and installation.

• Led a team on installing, configuring, and administering SQL Server 2016 - 2019 environments.

• Configuring Transparent Data Encryption (TDE) for data security at rest and secure backup files for compliance.

• Creating SOP and documenting all Processes for standardization.

• Administering backup and recovery strategies, rollback plans, and capacity planning to meet SLA requirements

(RPO, RTO, and retention policy).

SQL Server Database Administrator

Olakende Concept Limited, Lagos, Nigeria

Oct. 2019 - May 2021

Administering backup and recovery strategies, rollback plans, and capacity planning to meet SLA requirements (RPO, RTO, and retention policy).

Configuring high availability (HA) and disaster recovery (DR) solutions using technologies like Clustering

(Always On and Windows Server Failover Cluster), replication (snap shot, peer-to-peer, merge, and transactional), and log shipping to ensure continuous availability and meet SLA criteria. Reviewing and tuning scripts submitted by the development team for optimal performance. Plan database refresh and timely deployment to meet deadlines and requirements for production environment. Managing users accounts by creating logins, assigning privileges based on the principle of least privilege, and revoking access when necessary.

Responding promptly to tickets, resolving user requests based on priority, and troubleshooting issues. Collaborating on planning, designing and migrating environments from on-premises to cloud-based platforms. Ensuring data security at rest and in transit using tools like Always Encrypted, Transparent Data Encryption

(TDE), and Dynamic Data Masking (DDM).

Creating and monitoring maintenance plans for agent jobs, including tasks like index rebuild, reorganizing, database backup, shrinking database, and updating statistics. Performing Windows and SQL patching during scheduled downtimes to keep databases up to date in virtualized environments.

Installing, configuring, and maintaining SQL Server environments (clustered and standalone). Providing SQL support for auditing, patching, encryption, and backup strategies. Assisting with capacity planning and providing strategies for increasing data storage and maintenance needs. Perform imports/exports and other database functions, plus complete assigned tasks from managers.

Use Jira and ServiceNow as the ticketing system to create tickets. Support the Service Desk by handling IT tasks such as receiving phone calls, password resets, and more. Help desk Technician

WEMA Bank PLC, Lagos, Nigeria

May 2017 – Sept. 2019

• Provided service desk support to end-users, both onsite and remotely

• Assisted with hardware, software, and network issues resolution.

• Documenting all my processes in a step-by-step manner to keep up with a good knowledge-sharing policy within the team and the entire company.

• Training other staff members in troubleshooting and diagnosing problems.

• Writing, editing, and revising training manuals for new and updated software and hardware.

• Resolving issues with networks and other computer systems

• Diagnosing system errors and other issues

• Responding to queries via chat, email, or phone

• Following up with customers to ensure full resolution of issues.

• Requesting feedback and/or monitoring calls and other methods of correspondence to improve training methods.

• Automated Teller Machine (ATM) installation, remote support, onsite issues resolution and custodians training

• ATM uptime and availability monitoring as well as ATM vendors relationship management.

• Running reports to analyze common complaints and problems.

• Installing or changing software to fix issues.

• Remotely accessing hardware or software for clients to make changes and fix problems. EDUCATION

400+ Hours of Training Program in SQL server Administration KiawiTechIT Academy, United States

Master of Business Administration: Marketing - Ladoke Akintola University of Technology, Nigeria

November 2022

March 2012

Bachelor's Degree: Electrical Electronics Engineering - Federal Polytechnic Ilaro, Nigeria

Associate Degree: (Elect. Elect) Computer Science - Federal Polytechnic Ilaro, Nigeria

March 2004

September 1999

LANGUAGE

English

Fluent

Contact this candidate