Sql Server Management

Olamiju Olagbegi, MCTS, MCITP

*** ********** ****, *** ***, Lilburn, GA 30047• Phone: 470-***-**** • Email: *******.********@*****.***

PROFESSIONAL SUMMARY:

Olagoke is a dynamic SQL Server DBA with over 5 years invested in the management of complex SQL Server database

systems. Well experienced in the area of data migration, database consolidation, database performance tuning, backup and

recovery, management of database security, high availability solutions, SSIS, data warehousing, database and application

upgrades and patches as well with SQL Server.

AREAS OF STRENGTH:

SQL Server Installation and Implementation Disaster Recovery Performance Tuning

Database Security Backup & Restore Replication

Database Mirroring Log Shipping Database Maintenance

Extract Transform Loading (ETL) – SSIS, SSRS, SSAS Data Migration T-SQL

PROFESSIONAL EXPERIENCE

• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and

recovery, index maintenance in a very large high-transaction and fast pace environment.

• Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering,

database security configuration, and database continuity.

• Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.

• Design and implement SQL Server 2005, SQL Server 2008 R2 & 2012 databases for mission-critical business.

• Design and implement Data migration from one DBMS/instance to another.

• Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.

• Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data

and audit analysis.

• Use Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools

of SQL Server to populate data from various data sources, creating packages for different data loading operations for

application.

• Configure and support SSIS and SSRS for SQL Server 2005 and 2008 R2.

• Troubleshoot databases and custom application issues.

• Knowledge acquired to work with end users to define, implement, and maintain their reporting requirements.

• Assists in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.

• Develop and document SQL coding guidelines.

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

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

• Experience working in virtual environment

• Knowledge with monitoring and troubleshooting in 24x7 operations.

• Willingness to learn new Database Management Studio

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Technology Specialist 2013

Microsoft Certified Technology IT Professional 2013

PROFESSIONAL EXPERIENCE

IBK Construction Company February 2013 – Present

MS-SQL DBA

• Supporting SQL Server 2005, 2008r2 & 2012 production environments in a 24x7 on-call basis

• Installed and configured multiple SQL Server instances in production environments

• Implementation and support of High Availability Solutions by configuring log shipping and mirroring across

multiple SQL Server instances

• Engaged in disaster recovery (DR) strategic planning and implementation in SQL Server

• Implemented and support very large clustered production environments using SQL Server ACTIVE/PASSIVE

and 4 nodes failover clustering

Olagoke Olagbegi, MCTS, MCITP Page 2 of 3

• Implemented backup and recovery strategies that ensure that backups meet the recovering requirements using the

RESTORE VERIFY option when creating backups

• Performed data refreshes on SQL Server production and test databases

• Responsible for the Production support of more than 200 SQL Server databases

• Managed SQL Server database security by granting permissions on securable to the principals

• Performed several SQL Server database cloning

• Proactively engaged in various tuning techniques to maintain high performance production database environments

and ensuring minimal to zero downtime

• Automated various routine maintenance tasks like backups, index reorgs, index rebuilds on all production

databases

• Responsible for the daily maintenance tasks and Health Check of all SQL Server databases

• Developed and maintained complex SSIS packages

• Ensured that all database related trouble tickets are delivered upon within the SLA

• Identified issues inhibiting the attainment of project goals, developed and implemented corrective actions

• Interfaced with Microsoft and other vendors for technical support through service Request tickets and technical

Assistance (TARs)

• Responsible for managing the tickets tasks queue for the DBA team and effectively managed a balanced work

load among the DBA team on continual basis

• Developed and put in place database standards and procedures and enforced these to enhance conformity with the

ISO requirements

• Mentoring new hired DBA(s) so as to get them acquainted with company’s standards and procedures

COMCAST, Atlanta February 2012 – October 2012

MS-SQL DBA

• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.

• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.

• Generated the weekly, monthly, and quarterly report by using SQL Reporting Services.

• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules,

history data and audit analysis.

• Managed the products and development databases including performance tuning, capacity planning, SQL Server

clustering, database security configuration, and database continuity.

• Designed and implemented SQL Server 2005 databases for mission-critical business.

• Developed and optimized stored procedures, triggers, and SSIS packages

• Troubleshoot databases and custom application issues.

• Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases.

• Work with end users to define, implement, and maintain their reporting requirements.

• Develop and maintain complex SSIS packages.

• Participated and coordinated the creation, modification and maintenance of database structures with minimal

supervision.

• Assisted in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases

instances.

• Wrote, evaluated and optimized complex SQL codes, stored procedures and scripts for maintenance and reporting

purposes

• Developed and documented SQL coding guidelines.

• Demonstrated an understanding of database internals and application database components (e.g. triggers,

functions, packages)

• Performed other duties assigned by management

• Mentoring new hired DBA(s) so as to get them acquainted with company’s standards and procedures

JOIN Group Consulting, Rio Rancho, NM April 2009 – Dec 2011

MS-SQL DBA

Olagoke Olagbegi, MCTS, MCITP Page 3 of 3

• Created, administered & maintained SQL Server databases (production, development, test and staging

environment) for various groups such as developers, QA, DA and users and ensured the availability of the

database server in a 24/7 environment.

• Worked with a team of 14 professionals (6 remote and 8 onsite) and coordinated them to achieve project goals and

objectives.

• Used Red-gates and SQL-Centry for Database/SQL Server performance tuning and query optimization

• Trained MS DBAs and BI Administrators before deployed to customer sites for optimum relationship

• Managed the development, design, and implementation of new applications, as well as changes to existing

hardware systems and software packages resulting in high performance for clients

• Provided remote support to SQL Servers on customer sites of various companies to prevent downtime

• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node for high

availability.

• Writing, debugging, and tuning T-SQL, ETL and stored procedures for developers and customers

• SQL Server database physical model creation and implementation (data type, indexing, table design)

• Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users in SharePoint

• Set up and administered SQL Server Database Security environments using profiles, database privileges and roles.

• Database administration including installation, configuration, upgrades, capacity planning, performance tuning,

backup and recovery for high availability

• Determined and managed reports, root cause analysis, adhocs and designed reports weekly, monthly and based on

KPIs

• Ensured definition and development of database documentations and standards for easy continuity

• Ensured regular data base performance monitoring and tuning to prevent downtime

• Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss

• Implemented security policy design for current and new applications to prevent data corruption and theft

• Coordinated team meetings with groups for new design/strategies.

• Created database design for new projects support

• Worked with light-speed application for optimizing queries and database performance

• Coordinated change review meetings and facilitated in the management of incidents according to SLAs

EDUCATION

New York University, NY

Diploma in Construction Management 1998

Yaba College of Technology 1997

BS Equivalent Construction Management

Federal Polytechnic Ado-Ekiti, Ekiti

Associate Construction Management 1993

Contact this candidate