Confidential

Database Administrator

• Works with client organizations to identify their needs User Identification
• Identifies, specifies, and recommends technical solutions to clients Requirement Specification
• Architects, designs, and deploys data management RDBMS solutions, data access and storage solutions for clients
• Designs, identify resources, and coordinates Data Management Projects on an on-going basis
• Prepares designs databases, loads data from dump files into Oracle/SQL Server instances, performs ETL operations from other data sources into Oracle and MS SQL Server
• Monitors manages project storage needs
• Responsible for performance tuning of Oracle and SQL Server databases
• Analyzes/recommends, and performs scheduled and as-is performance tuning, optimization, and database maintenance
• Provide database technology guidance to the development team
• Coordinates and executes clients' database software patching strategies critical patch updates and patch set updates
• Administers Oracle databases, RAC clusters, MS SQL Servers, and Application Servers
• Provides overall Oracle/SQL administration expertise and undertakes administrative support
• Writes scripts for data processing to support analytic functions in the application solutions

Confidential

Database Administrator

• Used various tools TOAD, Idera SQL Analyzer, SolarWinds DB Performance Analyzer for database monitoring management
• Performed Security testing simulated SQL injection , schema change management, performance monitoring tuning, resource capacity planning and hardware optimization
• Performed user/security audits managed users, roles, object access, and privileges
• Performed daily database functions using imp-exp utility, sql loader, DataGuard, SQL Plus
• Performed software patching/upgrades, database design and development, creation and maintenance of database objects including tables, views, cursors, indexes, triggers, functions, writing PL/SQL and T-SQL Stored Procedures, SQL scripts for altering the Database Schema
• Managed and maintained all database servers responsible for the design, implementation and maintenance of Oracle Grid node infrastructure
• Responsible for the evaluation, installation, configuration and management of all database software Oracle 10g/11g database SQL Server 2005/2008/2012 , and related products
• Initially worked in a team of systems/database administrators wholly responsible for the configuration and deployment of various server machines hosting email systems Exchange , user/profile management Active Directory , database management system SQL Server and Oracle , web/application management IIS Server , report management SSIS, SSRS, OBIEE
• Responsibilities:
• Arik Air is Nigeria's and indeed Africa's fastest growing airline. It is an indigenous airline operating local, regional Ghana, Sierra Leone, Senegal, Gambia, South Africa , and international flights to Europe UK , America NY , and the Middle East Dubai .
• Established maintained backup and recovery policies/procedure using RMAN and DataPump utility
• Performed on-request data transformation, integration and reporting SSIS, SSRS with SQL Server 2008 R2
• Maintained company-wide end-user documentation, backup recovery documentation, general operational documentation schema maps, standard procedure and policies, historical details, schedules, batch jobs defined , future capacity planning

Environment:

Microsoft 2003/2008 Server Ultimate, Active Directory, Windows XP/7.0, .Net 3.5, SQL Server 2005, 2008, 2012 SSIS, SSRS , Oracle Database 10g/11g, IIS Server 5.1/6.0, Visual Studio.Net 2005/2008, Microsoft Exchange 2003/2005, Microsoft Visio 2003, Microsoft Office 2003/2008, Microsoft Project 2008

Confidential

Database Analyst

Infographics Limited is a digital technology consultancy offering multi-platform web-based, digital marketing, document/content management, and collaborative solutions and services for leveraging business operations. Its core products are developed with Microsoft and Oracle development and management tools.

Responsibilities:

• As a database analyst, I researched, analyzed, brokered, and deployed data management solutions for client companies based on mutually-agreed SLAs
• Developed, administered and maintained strategic roll-out plan for database deployments that supported specific organizations business models
• Worked with various business development and data management tools such as T-SQL, PL/SQL, SQL Server Query Analyzer, Oracle Scheduler, Enterprise Manager, Resource Manager, Oracle Forms and Reports, Crystal Report Designer, Oracle Designer, SQL Server, Oracle Database, Oracle Data Transform, import-export wizard, Microsoft DTS, Data Loader, Visual Studio for Application, Microsoft Visio, Microsoft Project
• Designed and implemented SLAs, system standardizations, security compliance and best-use policies for database access, data usage, and operational procedures
• Performed in-depth consulting services, training, and general DBA functions for clients:
• installed/configured/maintained various database engines Microsoft SQL Server 2003, 2005 Oracle Database 9i/10g
• created and managed databases, database objects, and defined data structures for client deployments
• user/access management, Users, Roles, Privileges , database security Oracle Transportable Databases Oracle Secured Log-in , database management Oracle Enterprise Manager, Backup Restore Manager , node management Oracle Clustering Grid computing
• Documented installation procedures, end-user policies, training, and database management procedures for clients/end-users
• Interfaced with both Microsoft and Oracle Corporations with my active OTN membership to proffer post-deployment support for clients.

Environment:

SQL, PL/SQL, SQL Server 2003/2005, Oracle 9i/10g, .NET 3.0, Windows Server 2000, 2003, 2005, ADO.NET, OLEDB, Java, AJAX, Team Foundation Server TFS , Microsoft Enterprise Library 5.0, Microsoft CMS 6.0, IIS 4.0, Microsoft SharePoint Server, Visual Studio .NET 2003

Confidential

Systems/Database Administrator

• Morison Industries is a top-notch player in the pharmaceutical sector of the Nigerian economy. The parent company is UK-based and owned by fourth-generation entrepreneurs: J.L. Morison Sons Jones Limited.
• The company is listed on the Nigerian Stock Exchange, and is responsible for producing orthopedic consumables and household sanitary-ware.

Sys Admin Responsibilities:

• I was responsible for the day-to-day running of the IT department. My role/achievements include the following:
• Successfully upgraded company's legacy hardware running Windows NT 4.0 , to a newer HP ML350 Generation 2 Server machine running Windows 2000 Enterprise Server
• Coordinated the computerization of all key operations of the company
• Designed, developed and maintained a company-wide Intranet Portal using Microsoft FrontPage 5.0
• Coordinated the roll-out of a newer, secure, and more robust multi-user Accounting package Sage Pastel 3.0 , as well as a manufacturing Inventory-control package Solomon IV for Windows
• Coordinated the deployment and maintained a Microsoft Exchange 2000 Enterprise Server running on Microsoft Communication Server for Medium Businesses
• Designed and implemented company-wide End-user Audit control and Security policy Log-in, Password management, File/Folder access , using Intranet Forms-based Authentication and Domain-level validation control

DBA Responsibilities:

• Planned, installed, configured, and managed the database engines SQL Server 7.0/2000 Enterprise Edtn and Oracle 8/8i Standard Edtn supporting both the intranet and enterprise solutions
• Developed and enforced database policies, standards, naming conventions, operating procedures and best practices developed a strategic plan for the database development that supports the organizations operational requirements
• Created and managed database instances, structures, objects, and users for optimal operation of the various in-house Application software
• Managed the day-to-day running of the database systems for efficiency and availability: monitoring of Alert Logs and trace files, identifying and resolving bottlenecks in DB performances resolving waits, identifying CPU-intensive queries, mitigating disk I/O contentions , tuning objects memory/SGA, indexes, locks
• Scheduled, performed, tested and validated daily, weekly and monthly DB backups using standardized tools/procedures to ensure database availability
• Coordinated DB access, usage and security managed user accounts: created, modified and monitored user access rights privileges
• Designed, developed and generated timely reports using Crystal Report
• Produced and maintained cross-platform database documentation and daily Administrative logs, arising from troubleshooting and resolving user issues and other database-related operations.

Environment:

Windows 2000 Professional/Enterprise Server, Windows Communication Server, Microsoft Exchange 2000, SQL Server 7.0/2000, Oracle 8i Database, Crystal Report 4.0, Microsoft FrontPage, .Net 2.0, Visual Basic 6.0, Internet Information Server 3.0, Microsoft Visio 2000

Confidential

Systems Programmer/Analyst

Ultimate Systems is an Enterprise-based solutions and business-software development company with products encompassing varied businesses and industries. Its multi-faceted enterprise and web-based solutions deployed for top-rated Nigerian educational institutions and government agencies, provide knowledge-based training, employee-skill assessment, recruitment, document sharing/collaboration, and asset/knowledge management.

Responsibilities:

• Extensive collaboration of stakeholders throughout each project via the adoption of Software Development Life Cycle methodologies including Programmatic Task Iteration, Code Delegation, Code Reviewing, Multi-lateral Debugging, and Application Interface Testing
• Adopted standardized functional design specification, annotated design architecture and programmable web structures
• I worked as part of the application development team responsible for building top-notch IT solutions. Honed my programming skills doing the following:
• Employed adaptive design frameworks for implementing unbreakable, easy-to-manage, and shareable codes
• Responsible for development and implementation of web user-interfaces on Microsoft .NET platform
• Performed constant server-side programming using C /C /Visual C , FoxPro, Dbase and ASP
• Designed and implemented reusable program modules using Visual Basic/Visual C and Active Server Pages.

Environment:

Visual Basic 5.0, Visual C 5.0, Object-Oriented Methodology, Forms/Reports Designers, Active Server Pages, HTML 2.0, .NET 1.0.3, ActiveX Programming, Java, SQL Server 7.0, Windows 98/2000 Server, Dbase 4.0, Visual FoxPro 5.0, Microsoft Access.

Confidential

Systems Analyst

Data Cybernetics is a full-fledged IT consultancy offering best-in-brand bespoke, and over-the-shelf IT solutions to clients across many sectors of the Nigerian economy. It is renowned as one of the pioneer IT-Solutions companies in Nigeria. Its biggest clients are state and local government agencies and bureaus.

Responsibilities:

Systems Analysis role featured the following: Requirement Analysis, User/Site Evaluation, User Specification, Feasibility Studies, Requirement Specification, Solution Design, System Acquisition, Project Management, System Deployment, End-User Training and Post-Installation Support.

Environment:

Microsoft Windows: Clients OS Win 95 Professional Windows NT 3.5/4.0 Database Tools: Access, FoxPro, Delphi, Paradox Development/Scripting Tools: Visual Basic 4.0, C /C , Visual C 4.0, Visual FoxPro 4.0 Platform: .NET 1.0 Productivity Tools: Microsoft Office 98 Suite.