Bosede Janet Onatemowo
MS SQL Server Database Administrator
Cell: +214-***-**** Email: ***********@*****.***
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: ***********@*****.***
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: ***********@*****.***
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