Resume

Sign in

Sql Server Technical Support

Location:
Duluth, Georgia, United States
Posted:
April 24, 2018

Contact this candidate

Resume:

Michael Lawal

Atlanta 470-***-****

ac48ex@r.postjobfree.com

I am a SQL Server DBA who has been supporting database applications in various environments. My core experience spans:

Data Migration Disaster Recovery Performance Tuning Backup and Recovery Database Security High Availability Solutions Database Upgrades patches Reporting Services Integration Services Database Clustering Database Security

Skills Summary:

● Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.

● Responsible for improvement and maintenance of the databases to include release rollout and upgrades

● Experience managing multiple MS SQL 2000, 2005, 2008R2, 2012, 2014 web-based, and ad hoc transactions.

● Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers

● Experience in Design, Architecture and production support of 4000+ databases (SQL 2000 thru 2016) instances running on various versions of Windows Servers 2003 thru 2012R2.

● Experience with monitoring and troubleshooting 24x7 operations.

● Experience with database upgrades, Patches and applying service packs.

● Experience in Implementing and managing various DR strategies. EDUCATION:

Philosophy (B.A)

University of Lagos

First Step Program

Computer Literacy

NIIT Lagos

1

WORK EXPERIENCE:

Database Administrator

Davinchie Technologies LLC

Atlanta, Georgia May 2016

● Perform DBA duties including: database backups, restores, performance tuning, and capacity analysis.

● Generate the weekly, monthly, and quarterly reports.

● Develop, modify, and optimize complex stored procedures, triggers to handle complex business rules, history data and audit analysis, in conjunction with Developers

● Utilize SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code

● Manage the Production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

● Design, implement and maintain SQL Server 2000, 2005 and 2008, 2008R2, 2012, 2014 databases for mission-critical business.

● Develop and optimize stored procedures, triggers and functions.

● Troubleshoot database Performance issues using SQL Profiler trace, Performance monitor

(Perfmon),and other third party tools.

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

● Assisted in the design, coding, testing and implementation of SQL databases instances.

● Develop and document SQL coding guidelines.

● Manage and execute maintenance jobs that ensure the stability and performance of the database servers.

● Establish and enforce all database standards.

● Analyze all informational requirements of new or production systems.

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

● Experience with large volume data extraction, transformation and loading (ETL) logic and tools using T-SQL, DTS Packages and SSIS projects.

● Experience with monitoring and performance tools (Spotlight, Sitescope, SCOM and SQL Sentry)..

● Hands on implementation and support for Always ON using SQL 2012 and SQL 2014, as DR solutions.

● Experience with virtualization VMWare and SQL Server virtualized databases

● Experience using Microsoft Azure in Development. 2

Lagos State Health Service Commission.

Lagos, Nigeria August 2014 – Sep 2015

IT Support

● Created and maintained standards and best-practices for installing and maintaining database in all environments

● Installed, configured and upgraded SQL server software and related products

● Established and maintained sound backup and recovery policies and procedures

● Performed Oracle and SQL server database design and implementation

● Implemented and maintain database security using privileges, roles and profiles.

● Performed Database tuning and performance monitoring

● Undertook application tuning and performance monitoring

● Planned for database growth and changes by undertaking capacity planning

● Worked as part of a team that provides 7x24 support when required

● Undertook general technical troubleshooting and gave consultation to development teams Database Administrator

Globacom Limited Nigeria

V/I, Lagos Nov 2012 -April 2014

DBA (Remote Support)

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

● Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

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

● 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 2000-2016 databases for mission-critical business.

● Optimized stored procedures and triggers.

Troubleshoot databases and custom application issues.

● Experience with VMWare and SQL Server virtualized databases.

● Implemented HA solutions such as Always On, mirroring and Log Shipping. 3

IT Business Support Officer Nov 2010-Sept 2012

Union Bank Of Nigeria Plc

•Provide online technical supports to 350 branches having hardware, software networking and other computer related issues

•Installing, configuring and administering Microsoft® Windows 2000 Suite, XP, Vista, Window 7, Server 2003 Enterprise Edition and application softwares (MS Office, Flexcube, Oracle Client, Stallion Express, MoneyGram, BDC, RMS, OCS)

Configuration and Troubleshoot the Desktop Environment

•Provide technical support assistance to the entire LAN and computer labs

•Install, configure, test enterprise applications (client/server) and also provide users support and training for branches’ Computer Administrators for effective 1st level technical support and systems management.

•Saved travel time to remote location office several hours away and quickly solved user problem by deploying new remote-control software (pcAnywhere and Remote Desktop Connection) solutions to resolve/diagnose users issue.

4



Contact this candidate