ABI IBIRONKE A.

Address: *** ***** **** *****, ****** GA 30132

Phone: (470) 407 - 8941

Email: addoza@r.postjobfree.com Skype ID: live:.cid.aef929cef214c5af

MS - SQL DATABASE ADMINISTRATOR

SUMMARY

Highly motivated MS-SQL DBA with over 7 years of extensive experience using SQL Server, SSIS, SSAS, SSRS from various fields including Healthcare, retail, education, manufacturing, and high technical environments managing over 3,000 MS-SQL instances and a record of increase responsibility with 10 mins MTTR SLA with our Clients. An excellent team player, who is attentive to details, proficient in exceeding ongoing and overlapping deadlines in a fast-paced environment, yet flexible in multitasking and delivering under minimal supervision. A DBA who enjoys learning new programs and processes; with excellent oral and written communication skills, as well as problem solving and strong analytical skills

Area of Expertise/Core Competences

Strong experience in Database Administration in SQL Server

Installation, configuration, and upgrade of Microsoft Windows Server 2008, 2008r2, 2012, 2014, 2016, 2017 and 2019

Configuring and setting up windows Server Failover Clustering Environment Strong

Administering Windows Server 2008, 2008r2, 2012, 2014, 2016, 2017 and 2019

Experience with Windows environment, VM

Proficient ability in creating Stored Procedures to extract and transform data and load into transactional/dimensional database

Configuring and installing SQL Server on Linux

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention

Knowledge of SQL Server tools and Third-Party tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, Red-Gate, Solar Wind. system sprocs)

Database Security

High Availability (Always On)

Database Back-up & Recovery

Database Maintenance

Data Migration in SQL and Experience moving data on AZURE, CLOUD

Intermediate knowledge of T- SQL

Intermediate Knowledge of Data warehouse,ETL using SSIS, SSAS, SSRS and other Third party tools

Intermediate knowledge of TOAD, IBM Data Studio, PL/SQL, SQL Developer, Oracle

Strong customer service mindset & ability to manage multiple projects at the same time

Performance Tuning, Mirroring, Log Shipping, Replication & Capacity Monitoring

Generate the weekly, monthly, and quarterly report by using SQL Standard Report

Create reports that ran daily for jobs running in SQL Server Agent

PROFESSIONAL EXPERIENCE

Join Group Consulting LLC

MSSQL DBA (April 2018 – Till Date)

413 Cathedral Drive, McDonough, GA 30253

Experience in Day to Day SQL DBA activities

Assist with developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases

Responsible for Windows troubleshooting of all incoming incidents and performs requests for service

Design, install, configure and support SQL Database instances

Work with a team of 11 in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients

Assist application developers with query tuning and schema refinement

Involved with T-SQL scripts and stored procedures development

Involve with trouble shooting in Clustered environments

Involve with migration and upgrades of SQL Server instances

Create High Availability (Always on) to feature disaster-recovery solution that provides an enterprise-level alternative to database mirroring

Create and maintain High availability solutions including Log shipping, mirroring, Replication, Performance tuning and query optimization

Support and maintain SSIS packages, SSRS reports, and SQL Server Agent jobs

Supports automatic page repair for protection against page corruption (Database Mirroring)

Create availability group to supports a failover environment for a discrete set of user database

Assist with the coordination, preparation, presentation and implementation of proposals and projects linked to the SDAs

Implement backups & disaster recovery on High Availability Solutions

Co-ordinate with the application and database vendors for resolution of problems (functional bugs, performance issues)

Assist in the planning and running of disaster recovery tests

Undertake performance tuning and monitoring using SQL Server native tools and Third Party tools

Backup and restore databases on SQL

Setup and manage VMs

Perform production support activities and provide incident and problem management support

Produce documentation as required per SQL guidelines

Help in coordinating team meetings with groups for new design/strategies

Assist in implementing project-type activities and other requests for services

Participate in DBA on-call rotation and support as and when required

Phoenix at Dallas, GA

MS-SQL DBA (March 2017 – April 2018)

100 Westminster Court, Dallas GA, 30132

Involved in managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems

Migrated Databases from different platforms like SQL Server 2005 to 2008, 2012, 2014

Provided solutions for database issues including capacity, redundancy, replication and performance

Monitored the system health and performance, data activities like database status, logs, space utilization, extents, Checkpoints, locks and long transactions

Assisted in developing strategic technical/architectural plans, coding standards, and quality assurance policies and procedures for the SQL database and web applications infrastructure

Developed and maintained scripts, utility jobs and implemented all needed software for database maintenance

Assisted in suggesting Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards

Developed and executed scripted changes requests in accordance with change control guidelines.

Generated the weekly, monthly, and quarterly report by using SQL Standard Report

Used SQL SSIS, T-SQL and ETL tools to populate data from various data sources, creating packages for different data loading operations for application

Configured and supported SSIS & SSRS for SQL Server 2005, 2008 R2, 2012, 2014 and 2016

Worked with the development team to resolve bug-fixes and assisted in relevant testing through various environments

Used MSSQL SERVER Database Administration

Setting up Log Shipping, MSSQL Mail, always on, Clustering, Mirroring and Replications

Created, administered & maintained SQL Server Databases (from Production, Development, QA, Test and Staging Env.) for various groups like Developer, QA, DA & User, and ensuring the Availability of the Database Server in a 24X7 Environment

Ensured work is performed in compliance with company policies including Privacy/HIPAA and other regulatory, legal, and safety requirements

Ensured database security and encryption

Parkway Inc.

SQL DBA Architect (January 2016 – February 2017)

1040 Cobb Industrial Dr., Marietta, GA 30066

Worked with a team of 6 to manage the data warehouse life cycle from ETL to end-user reports

Integrated 5 new source data systems from requirements through testing

Managed the duplication and upgrade of the entire system for corporate restructuring project

Developed and maintained reports and reporting stored procedures

Worked with new customers to determine reporting requirements to deliver a useful yet efficient product

Managed the development, design, and implementation of new applications and changes to existing computer systems and software packages for customers

Populated Database with new information or transfer existing data of customers & Company products

Assisted in developing and implementing policies, processes and procedures for managing IT related projects

Proactively worked with other project team members and Contractors in order to produce positive action and accountability for assigned tasks

Generated daily/weekly/monthly reports using SQL Standard Report guidelines

Involved with managing risks, issues, and actions logs

Contributed to adhering appropriate products or services for clients according to project scope, requirements, and deliverables while also providing input to project plans

Chalcedony Group of Schools

Lead Database Administrator (July 2013 – September 2015)

Goodwill Estate, Abijo G.R.A, Kilometer 41, Lekki, Lagos, Nigeria

Managed and motivated a group of 7 database team members of developers and programmers, to consolidate and perform design, development, tuning and maintenance of SQL Server

Provided leadership approach to problem determination, in response to resolving databases issues, performance of database migrations and data modeling activities

Ensured the best practices and design methods in order to achieve successful projects.

Maintained replication environments for District students and business systems

Generated and kept up-to-date documentation for District databases, web-based resources

Installed and configured databases

Involved in troubleshoots and resolved issues as assigned in call logging and defect tracking systems

Supported database functions by designing and coding utilities

Maintained daily database jobs and stored procedure library

Evaluated security risks of current and planned development for databases

Maintained up-to-date documentations of the school data in accordance to procedures and guidelines

Worked with my team to identify database requirements by interviewing customers and web developers; analyze department applications, programming, and operations; evaluates existing systems and designs proposed systems

Effectively trained IT staff on how to perform essential tasks related to maintaining web pages that can be easily updated and are engaging to the end user

Developed innovative approaches to solving problems as the Lead Administrator

Maintained quality services by establishing and enforcing organizational standards

Charks Investment Limited

Junior SQL DBA (January 2012 – August 2013)

115, Obafemi Awolowo Way, Ikeja, Lagos, Nigeria

Participated in trouble shooting and solving problems relative to current environment and

architecture using a wide range of techniques and resources to detect, identify and eliminate

database system problems

Worked with a team of 15 staff in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients

Documented established procedures used to perform repetitive but complex DBA tasks

Established and maintained comprehensive database design including updating documentation reflecting changes to the database design

Produced reports for a wide variety of purposes

Provided technical assistance to the computer operations staff and user community

Performed database backups, integrity checks, load monitoring and performance tuning

Developed, documented and enforced standards for access to the databases

Analyzed all informational requirements of production systems and develops database specifications

Provided on call support as per rotation cycle

Ensured a delivery of up to date weekly/monthly reports in accordance to guidelines

Charks Investment Limited

Business Development Associate (February 2010 – October 2012)

115, Obafemi Awolowo Way, Ikeja, Lagos, Nigeria

Assisted in the daily growth and development of the company

Assisted with efforts of new business acquisition

Professionally managed the needs of external customers based on company’s structured information and guidelines

Involved with presentations, forums, fairs to promote and sell out the company’s products and services

Maintained client-employer relationships long term

Collaborated with appropriate management to discuss bid proposal details including cost estimates, time frames, deadlines and project performances

Acted as a liaison for clients, guiding them through the bid process, solving any doubts and providing solutions

Developed strong leadership and interpersonal skills

Ensured a Business to Consumer “B2C” sales of goods or services to new business prospects

Generated new sales from prospective accounts

Demonstrated and ensured a clear understanding of Charks’s business operation processes

Communicated in a one on one based sales environment with potential customers

Provided daily accurate forecasts to the sales organization and executive management

Provided input and maintained proper utilization of client relationship management system for communicating client contacts, current targeted project status and known future bidding opportunities

EDUCATION

Lagos State University, Lagos, Nigeria

B.A Degree (His. & International Relations)

Aptech Information technology Institute, Lagos Nigeria (2012 – 2014)

Certification in Structured Query Language (SQL) Database Administration

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA) – MS SQL 2015

MCSA & MCSE 2015 – (Microsoft Certified System Administrator)

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Cloud Infrastructure Foundations (OCIF) 2020 Certified

Contact this candidate