Database Administrator Administration

OPIA STEPHEN SUNDAY

Phone No: +***-802-***-****, 090********

E-mail address: ********@*****.***

Home Address: **, ******* ******, *****, *****, Nigeria. SUMMARY OF EXPERIENCE

Experienced Database Administrator with over 6 years of experience in Energy, ERP, and Fintech. Excellent reputation for resolving problems, improving customer satisfaction, and driving overall operational improvements. Consistently saved costs while increasing profit.

EDUCATIONAL HISTORY

New Horizons Systems I 10/2011

Diploma Database Administration Oracle Certified Associate OCA Diploma Database Administration Oracle Certified Professional OCP Oracle Cloud ERP Solution Engineer 08/2021

Olabisi Onabanjo University, Ogun State. II, 04/2009 BSc Geology

PROFESSIONAL EXPERIENCE

Seven Up Bottling Company Ijora, Lagos. I

IT, Data Management

Database Administrator, June 2023– Present

Oversaw the installation, configuration and maintenance of various database systems. Ensured high availability, performance and scalability of databases by implementing best practices, tuning parameters, and optimizing query performance.

Monitored database systems regularly to proactively identify and address issues, ensuring minimal downtime and maximum uptime.

Implemented and enforced security measures to safeguard sensitive data and ensured compliance with industry regulations.

Developed and maintained backups and recovery strategies to ensure data preservation and disaster recovery readiness

Collaborated with application developers and data architects to design and optimized database schemas, ensuring efficient data storage and retrieval.

Participated in capacity planning and scalability discussions to accommodate future data growth and system demands

Configured and managed sql server Always On technology, Mirroring and log shipping Managed Oracle RAC and Data guard architecture effectively. Xpress Payments Solutions Limited GRA Ikeja, II

IT INFRASTRUCTURE,

Database Administrator, November 2022 – May 2023

Implemented the DDL triggers, Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user.

Utilized RDBMS tools and utilities to monitor, tune and optimize system performance. Reviewed T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.

Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision

Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification and indexing using Control-M agent and SQL Server Agent. Performed DB Security, created users, roles, and assigning permission to them Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for design and development of SSIS Packages to load the data from various Databases and Files. Worked on enhanced security features Data encryption, data masking and data redaction CounterHouseConsultants Limited

IT.

Consultant Database Administrator March 2022 - November 2022 Administered application servers and ensured optimal performance Coordinated with Oracle team and recommended improvement to security issues. Designed appropriate PLSQL interface for various environments Carried out Database installation, configuration, and cloning as assigned by the unit manager Developed and maintained all required database and performed tests on production databases. Prin-Shafis Petroleum Limited

IT.

Applications Database Administrator October 2018 - February 2022. Coordinated the migration of project information from an existing system to new database, enabling company to produce proposals and other project related documentation more efficiently. Conducted audits on the environment and provided capacity planning, best practices guide for future production, development, and tests on database administration. Drove operational improvements which resulted in savings and improved profit margins. Reviewed database design to recommend enhancements or improvements. Developed and maintained PL/SQL stored procedures, ETL and triggers for our various web-based applications.

PROFESSIONAL CERTIFICATIONS AND HONOURS

Oracle Certified Professional

Oracle Certified Associate

Microsoft

SKILLS AND ABILITIES

Azure

ETL pipeline (SSIS packages)

Database Replication technology

UNIX Shell Scripting Oracle Linux & IBM AIX

MS SQLServer2012 R2 /2014/2016/2019.

ORACLE DATABASE 11g, 12c, 19c and 21c

MYSQL

PostgreSql

Data guard

ASM

Contact this candidate