Sql Server Maintenance

OLA OLADAPO

*********@*****.***

424-***-****

SENIOR DATABASE ADMINISTRATOR (VOGO TECHNOLOGIES)

MAR 2010 – JAN 2018

•Microsoft SQL Server DBA with 8+ years of experience in design, Development and Administration using MS SQL Server 2008, 2012 database environments.

•Extensive experience on both SQL Server Administration and T-SQL Application Development

•Knowledge of Normalization/ Denormalization techniques for OLTP and OLAP environments.

•Used SQL Indexes for improving query performance, lower storage and maintenance cost.

•Experience in optimization tools such as SQL Profiler, Dynamic Management Views (DMVs)

•Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

•Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances.

•Good experience in user management for DBs, maintaining of databases, and providing SQL

•Server security by assigning logins, server and database roles and server permissions.

•Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) and Database Mirroring.

•Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans.

•Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.

•Proficient in developing business application logic using SQL Stored Procedures, Functions and • T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments.

•Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes,

•Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.

•Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL

•Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.

•Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.

•Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility

•Experience in n-tiered client/server computing technologies

•Experience in data warehousing technology

•Expert in fundamental database administration and security

•Experienced in interfacing with archival backup systems, i.e. Commvault, Networker, DPM, also SCOM

•Maintained high availability of the customer's data

•Performed tuning and optimized performance throughput the solution as it pertains to the architecture of the system mon platform.

•Monitor the database's health and performance. Server and application level database administration.

SQL-SERVER DATABASE ADMINISTRATOR

O2 Telecommunications London United-Kingdom

2007 to 2010

•Creating of Databases, Database Instances

•Performance Tuning and Monitoring

•Assigning users required rights and privileges to databases and sql instances

•Generating Backup Report daily, and re-running backups before Production goes live

•Capacity Planning and Database Growth Tracker(Monthly basis)

•Training on New Versions and Features of Sql Server

•Knowledge of data communications and network infrastructure • Expert in setting up maintenance plans, creating jobs, database mail.

•Expert in E.T.L TOOLS (S.S.I.S, B.C.P, Import & Export Wizard).

•Expert in SSRS

Contact this candidate