Sql Server Support

STEPHEN BALOGUN

Atlanta, GA

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

(404) 893 – 8242

EXPERIENCE SUMMARY:

8+ years total IT experience with 5 plus years of experience as SQL Server DBA on multiple versions like SQL Server 2005, SQL Server 2008, SQL Server 2008R2 & SQL Server 2012 and SQL Server 2014

Experience with Installation, Configuration, Administration, Maintenance, Performance/Tuning.

Migration of databases from SQL Server 2005, SQL Server 2008/2008R2 to SQL server 2012/2014.

Worked on Tuning Long running queries and troubleshooting general bottle necks issues.

Availability) also on the Mirroring for DR (Disaster Recovery).

Experience on Replication for Load balancing and data autonomy purposes

SQL Server Database Backup/Restore processes with SQL native and Quest Lite Speed.

Worked on Excel to make very good reports and also used SSRS to build reports with in the team

SQL Server side Profiler Trace and Quest Tools like Spotlight for identifying query bottlenecks causing performance issues.

Performance Monitor PERFMON used to resolve system hardware bottlenecks and DBCC Utilities for database consistency checks.

Use SQL and system counters to monitor bottlenecks on the Disk IO and throughputs.

Planning/implementing Security: create Logins, setup permissions and assign server roles and database roles as required following security best practice and standards.

Experienced in Architectural design of Databases based on the business requirement

Create Database Maintenance Plans, SQL Agent Jobs, setup Alerts, and Operators. Experience implementing MSX and TSX job module.

Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention, Change Control, Disaster Recovery and High Availability Planning.

Experienced with Building DR plans and Performing DR Test exercises.

On call Production DBA for 24 x 7 in an OLTP Mission Critical Systems/Environment.

WORK EXPERIENCE:

GLOBAL WIRELESS SOLUTIONS (Dulles, VA) JAN 2014 to Present

Consultant SQL Server DBA

Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in SOX audits.

Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active cluster Nodes.

Designed robust backup strategy and implemented Backup plan using Native SQL and Lite Speed.

Resolved and tweaked memory pressures caused during production release.

Worked with customers on Application rollouts and server migrations.

Migrated legacy databases with upgrade from SQL 2008R2 to SQL 2012 and SQL 2014.

Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.

Strong experience in mentoring team members and writing documentation.

Troubleshoot performance problems and fine-tuning of databases.

Re-building indexes and statistics update at regular intervals to improve performance.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

24x7 production support for SQL Server databases on standalone and Clustered nodes with sizes ranging from 10mb to 3.8 TB to achieve maximum performance and uptime in production.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Monitored and modified Performance using execution plans and Index tuning.

Transferring the data (ETL) to Data ware house by SQL Server 2005 and 2008R2 Integration Services.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Implemented and Scheduled Replication process for updating our parallel servers.

Designed and created databases, tables, views, store procedures and triggers.

Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows Server 2008R2.

Batch processes, Import/Export, Backup, Database Monitoring tools and Application support.

SMARTSOURCE INC. (Atlanta, GA) JAN 2011 – JAN 2014

SQL Server DBA

Responsible for Data Center Migration and Disaster Recovery site built.

Ensured Disaster Recovery and Business Continuity for all database related infrastructure components.

Scheduled Full, Differential, and Transactional log backups for users and system databases in production using Quest LiteSpeed tool and SQL Agent.

Setup Transactional and Snapshot Replication and made sure data was in sync.

Setup Database Mirroring in SQL Server 2005.

Created SSIS packages to load data from Heterogeneous data sources.

Monitored disk space usage, memory and connections and Databases for lock escalation, dead lock, resource utilization by sessions, package caching, buffer pool hit-ratios.

Captured SQL/runaway queries using SQL Server Profiler /Performance monitor.

Ran DBCC consistency checks and fixed data inconsistency databases.

Tuned Stored Procedures and T-SQL statements for better performance.

Documented best practices, policies, procedures and standards and Prepared Play-by-Play Documents for data migration.

Deployment of code/Builds into QA and Production environments.

Worked with Development, QA, Application Engineering, Release Management and Project Management Teams.

Implemented users Ad-hoc requests for pulling reports/results.

On call Production Support DBA for 24X7 Critical OLTP/OLAP Systems.

Supported environments such as Development, QA, Stress, and Standalone.

Installed, configured, of SQL Server 2005, 2008 and 2008 R2

Administration and Configuration of SQL Server Security

Created User logins and providing required permissions

Set up Maintenance Plans for DB Backups, DB Integrity Check, DB Re-indexing and Stats Updates.

Scheduling jobs in Autosys and SQL Server Agent

Setting up Log Shipping and DB mirroring for DR Servers

Worked on Data Center Migration of Database Servers from one location to another

Installing and configuration of SSIS and SSRS

Responding to SQL Server alerts for disk space errors, Job failures and performance related issues

Documented best practices for ongoing production support

Automated DB Refreshes from Production to QA/Staging based on user requests

After hours and Weekend Support for any Database maintenance related activity

Worked as on call support DBA in a 24x7 environment on a weekly rotational basis.

SPRINT Wireless

Computer Technician OCT 2008 - DEC 2010

Provide tech support via phone, the internet, or in person at the office

Diagnosed software/hardware problems, responding quickly, clearly, and resourcefully.

Installed and Microsoft Windows Servers as well as Windows Desktop OS

Configured and constantly maintain Windows Active Directory.

Conducted research and collaborated with vendor if necessary for additional patches.

Provided stop gap solutions if possible and acceptable by business and application team

Installed printers in remote and on-site locations

Provide daily customer support to users by troubleshooting issues both on site and remotely for company's other branches

Microsoft Windows Server Administration Windows 2003/2008R2

Microsoft Windows Desktop Administration /Support/Configuration Windows 98/2000/XP/7

AD Support/Administration for Windows 2003 and 2008R2

Maintain Microsoft Windows Cluster Solutions for current OS and previous OS

RSA Remote Access and System Management for Hardware Failures

Service Desk Incidents / Tickets, Request Support System, Change Controls for Mission Critical Server Support and Desktop.

Provide Remote System Administration and Remote Site Support via WAN/VPN

Installing new motherboard/CPU

Configuring personal computers to meet customer’s need

Maximizing resources in Microsoft windows 98/NT/2000/XP for programs to run smoothly

EDUCATION:

University of Ilorin

-B.Sc. Degree in Business Administration 1996

Open University, Kent, London

-Associate Applied Science in Information Technology 2003 – 2005

Koenig

-MS SQL Server Database Implementation and Maintenance Oct 2010

-SQL Server 2005/2008R2

-Microsoft Certified Professional SQL Server 2008R2, 2012/2014

Contact this candidate