Bosede Janet Onatemowo

MS SQL Server Database Administrator

Cell: +214-***-**** Email: adtfra@r.postjobfree.com

Key Technologies High Availability Solution- Clustering, Always On, Log shipping

TSQL SQL Server Configuration

Job Objective

A professional database administrator (DBA) with over 7 years’ experience, will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end users.

Accomplished and highly qualified DBA with diverse and extensive database administration experience. My career goal is to be a part of a growing organization and aid in accomplishment of organizational objectives by utilizing my knowledge with what I have learned and am still learning. I am equipped with an excellent work ethic, possesses a strong sense of responsibility and teamwork with a track record of dependability.

Recent Projects

Database Migration Services

SQL 2016 Upgrades, SQL 2019 Upgrades

Applying windows and SQL Server patches on Production/Non Production Servers.

Business Intelligence, SSAS, SSRS and SSIS

Configured database backups and restoration, monitored and tuned database.

High Availability and Disaster Recovery

Sage ERP Accounting solutions

Certifications

Database Fundamental Certified (MTA -Microsoft Technology Associate)

Pursuing AZ104 Microsoft Azure Database Administration

Education and Training

Post Graduate Diploma in Communication and Journalism – National Open University of Nigeria

The Federal Polytechnic Ado Ekiti, Ekiti State Nigeria - Higher National Diploma (HND) Secretarial Administration (Typing skill 130 words/Minute)

Ondo State Polytechnic, Owo, Nigeria - National Diploma (ND) Secretarial Administration

Soft Skills

Excellent team player

Fast learner with Logical approach to work

Good organizational skill

Communication and excellent interpersonal skill

Meticulous attention to details

Problem solving with ability to prioritize task

Post

Bosede Janet Onatemowo

MS SQL Server Database Administrator

Cell: +214-***-**** Email: adtfra@r.postjobfree.com

Key Technologies High Availability Solution- Clustering, Always On, Log shipping

TSQL SQL Server Configuration

PROFESSIONAL SUMMARY

Walmart Super Centre Ellicott City Maryland USA

MS SQL Server Database Administrator (Remotely)

March 2017 till date

Responsibilities

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Rebuilding the indexes at regular intervals for better performance.

Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Used Performance monitor and SQL Profiler to optimize queries and enhance the performance

of database servers

Used log shipping for synchronization of database

SQL Server 2005/2008/2012/2016/2017/2019 Administration

Reviewing and optimizing virtual machines environment

Reviewing and optimizing storage

Responsible to monitor and troubleshooting Log shipping

Used Data partitioning, Snapshot Isolation in SQL server

Update statistics, database integrity check and backup operations

Creating and Maintaining database maintenance plans

Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log

Shipping.

Planning and implementation of Database backup/restore and disaster recovery

Installed SQL Server 2016 on advanced servers, applied security fixes.

LM Ericsson (Telecommunications) Nigeria Ltd

MS SQL Server Database Administrator

Nov 2014 – Feb 2017

Responsibilities

Plan, install, and test software upgrades and patches.

Monitor database performance trends to identify anomalies or errors.

Develop, plan, and establish database performance baselines.

Test and coordinate database modifications.

Create and maintain all SQL Server databases required for development, testing, education and

production usage.

Install and configure new instances of the SQL Server.

Bosede Janet Onatemowo

MS SQL Server Database Administrator

Cell: +214-***-**** Email: adtfra@r.postjobfree.com

Key Technologies High Availability Solution- Clustering, Always On, Log shipping

TSQL SQL Server Configuration

Periodically test the databases backup and recovery process.

Implement and enforces security for all of the SQL Server Databases.

Enforce and maintain database constraints to ensure integrity of the database.

Administer all database objects, including tables, clusters, indexes, views, sequences, packages

and procedures.

Respond to and resolve database access and performance issues.

LM Ericsson (Telecommunications) Nigeria Ltd

Purchase-to-Pay Manager (SAGE ERP SOLUTIONS)

May 2013 – Oct. 2014

Responsibilities

Responsible for Vendors’ and Ericsson satisfaction in the areas of procurement and payment for Region Hub South Africa using Sage ERP Accounting software to:

Add Customers and Suppliers, create, send, and track invoices.

Create and send quotes and estimates

Set up recurring invoices, payments, and customer statements

Create purchase orders, track, and manage inventory

Perform automatic bank reconciliation and enable foreign invoicing

Track and manage inventory and forecast cash flow

Process online credit and debit card payments

Modify sales tax rates

LM Ericsson (Telecommunications) Nigeria Ltd

Market Logistics Manager

Oct. 2010 - April 2013

Responsibilities

Validate purchase orders, reject and report deviations, handle workflow, GR/IR & MRBR

activities

Monitor order acknowledgements, open PO report & provide status to CEM Inbound

Ensure goods receipt is done in accordance with Work completion note, Invoice & delivery note

from DSP Responsible to invoice customer according to contractual terms

Continuously monitor project spend, requesting variation purchase orders from Resource owners

Reporting on invoicing, update sales order & send invoicing report to Procurement & Billing

Communicate intercompany month end schedule to Project Planners, resource owners, Project

Managers

Ensure effective & efficient entry of goods receipt based on DSP deliveries and work completion

notes for services

Report on GR/IR & MRBR activities

Responsible for Vendors’ and Ericsson satisfaction in the areas of procurement and payment for Region Hub South Africa.

LM Ericsson (Telecommunications) Nigeria Ltd

Systems Administrator for (SAP ME23N)

Jan 2005 – Sept 2010

Responsibilities

Responsible for the maintenance, configuration, and reliable operation of computer systems, network servers, and virtualization

Giving access and logins to users following the principle of least privilege

Install and upgrade computer components and software, manage virtual servers, and integrate automation process.

Troubleshoot hardware and software errors by running diagnostics, documenting problems and resolutions, prioritizing problems, and assessing impact of issues

Provide documentation and technical specifications to IT staff for planning and implementing new or upgrades of IT infrastructure

Lead desktop and helpdesk support efforts, making sure all desktop applications, workstations, and related equipment problems are resolved in a timely manner with limited disruption

Responsible for capacity, storage planning, and database performance

LM Ericsson (Telecommunications) Nigeria Ltd

Project Planner/Coordinator

Jan 2003 – Dec 2004

Responsibilities

Coordinating the overall project

Making travel arrangement for incoming and outgoing expatriates

Collate and dispatch information to the department’s sole customer (MTNN)

Organizing Workshops, Seminars and meeting and taking detailed Minutes of such meetings

Organizing social functions

Plan, coordinate and monitor activities of assigned projects to develop and implement procedures, process and systems

Educate employees in methods to ensure project continuity and completeness.

Develop detailed task lists and work effort assessment.

Prepare short and long-term resource allocation plans based on input from all key players and team members.

DUNLOP NIGERIA PLC

Feb 1994 – Dec 2002

Personal Assistant in the Legal Department

Responsibilities

Registration of Shares Certificates for all shareholders of the company

Preparation of draft Annual Report and Accounts

Collating signature cards and sending them to the bank

Preparing and circulating audit reports, special investigations, internal memos, stock count

records and all minutes of meetings attended by my boss

REFERENCES: Available on Request

Contact this candidate