SUMMARY

• A motivated Database Administrator with knowledge of MSSQL,PostgreSQL, T - SQL, SSMS, SSIS, Windows Server, and Linux, and with passion for data availability and consistency. Hands-on experience in operation and configuration of ORACLE instances/databases, as well as QA and project coordination. Data Professional with genuine interest in BI, ETL, and Reporting based on EDW.
• Known as an effective communicator productively collaborating with product owners and their respective teams. Experienced in working together with offshore teams.
• Expert in agile and waterfall project management methodologies. Trained as Agile Scrum Master in addition to Oracle Professional Certifications.

TECHNICAL SKILLS

• Core DBA and DevOps skills, including Installation, Configuration, Capacity Planning, Database Management, Troubleshooting, Upgrades & Migration, and Database Security & Patching. Oracle 10/11g and 12c using OUI, DBCA, DBUA. Data Modeling with Erwin and Visio. High Availability/Oracle RAC, ASM & Grid Infrastructure. Monitoring and performance Tuning using OEM Console, Toad, SQL Developer, Grid Control, Explain Plan. QA, ETL, Data Modeling, Agile, SDLC. DR/Backup & Recovery using RMAN, Database security and auditing.
• Windows Server, UNIX, LINUX;
• Oracle 10g, 12c, 18c, 19c, MySQL, MS SQL Server
• Virtualization and reporting: Power BI, SRS, Talend.
• T- SQL, PL/SQL, UNIX Shell Scripting, Bash Shell Scripting, XML, .NET.
• Oracle Enterprise Manager, SQL*Plus, Netca, Netmgr, vi editor, WinSCP, PuTTY, Jira, Bugzilla, SharePoint, Remedy, SVN, TFS, SSMS, SSIS.
• Database migration using Exp/Imp, Datapump (Expdp/Impdp), and SQL*Loader, SSIS.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator/Developer

Responsibilities:

• As a DBA, Responsible for supporting web-based applications and reports (written in Java, .NET, SSRS, Excel, Tableau, MSSQL, Oracle Reports, and Crystal Reports and other tools), supporting back-end processes and GUI and Dashboards/BI and Data Warehouses and Data Marts loading jobs.
• Troubleshooting Linux and Windows Server based instances of Oracle 12 and SQL Server 2016. Solving infrastructural and operational problems as a part of on-going DBA and technical support.
• Query Performance Analysis and hands-on optimization of PL/SQL and T-SQL code (Stored Procedures and Functions as well as Views and Ad-Hoc).
• Applied strong working knowledge of both Oracle PL/SQL and SQL/T-SQL in Oracle (10, 11, 12) and MS SQL SERVER environment (ver. 2014 and up).
• Used my solid interpersonal and communication skills in order to interact with application systems administrators, Front- and Back-end support analysts, technology engineers, network specialists, and vendor support analysts regarding database needs.
• Played substantial role in Data Migration projects (Oracle <--> SQL Server) as well as Process Improvement and Platform Stabilization in every environment that I was supporting, including EDI/ETL.

Confidential

Database Admin/Logistics Coordinator

Responsibilities:

• Logistics data analysis at various levels as well as handling the warehouse loads and incremental data loads.
• Handled capacity planning, evaluate database server hardware.
• Recruited by Nigerian leading IT consulting firm. Provide VAS (Valued Added Services) to Nigeria Telecommunication Operators (MTN, GLO, ETISALAT, VISAFONE) with project management over large-scale, top-priority and complex technology initiatives. Drove the high-quality completion of systems engineering, software/database development and enterprise-wide implementation projects.
• Managed Data Access, Auditing, Backup, Restore Database and Monitor SQL Server Instances.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Confidential

ORACLE AND SQL SERVER DBA

Responsibilities:

• Provided Training Students on Oracle Database, Linux OS, Networking, Hardware & Software Engineering.
• SQL Server 2000 to SQL Server 2005 migration projects. Experience in SQL Server Clustering, Tuning and Performance Monitoring. Supervised: ORACLE DATABASE 10g (with LINUX ESSENTIALS). Responsible for all Database Upgrades and Migrations, Tuning and Performance Monitoring, Stored Procedures and Triggers, Moving data into the database(SQL*Loader).