Manager Maintenance

ILESANMI GBENGA JOSEPH

Microsoft SQL Database Administrator

Atlanta, GA 404-***-**** E-mail: *************@*****.***

PROFESSIONAL SUMMARY

Database administrator (DBA) with several years of experience in managing and supporting database solutions in MS SQL Server 2012, 2014, 2016 and 2017 environments. My SQL Server Administration experience includes:

Experience with Software installation and Maintenance

Experience with managing back-ups, indexes and recovery procedures

Administer and test new upgrades and databases

Monitor system's health and performance

Create custom monitoring and maintenance plans

Data Extraction, Transformation, and Loading

Experience in troubleshooting and resolving database problems

Ensure high levels of performance, availability, sustainability and security

Maintain server configuration, migration, and other implementations

Assist developers with query tuning and schema refinement

Perform scheduled maintenance and support release deployment activities after hours

Ensure audit trails are maintained and documented

Experience with SQL reporting services including creating, modifying, and managing custom reports

Up-to-date on the latest industry trends; able to articulate trends and potential clearly and confidently

Excellent analytical, quantitative, and organizational skills

PROFESSIONAL EXPERIENCE

Grana solution Inc. – Atlanta, GA

MS SQL Database Administrator (March 2017 - Present)

- Works closely with infrastructure team for patching and hardware upgrades, and ensures that both production and test servers are up to date by applying Windows and SQL Server patches.

-Responsible for administering and maintaining over 150 database servers of Production and Test environment.

-Upgrades servers as required from SQL Server 2005 to SQL Server 2008 and 2012.

-Assists application team in the creation of databases, construction of queries, modification of database tables, and troubleshooting data issues.

-Monitors and troubleshoots production environments using Idera SQLdm.

-Reviews security, performance, and disk space and recommend corrective actions where needed.

-Usage of scripts and SQL agent jobs to automate database maintenance tasks.

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

-Updating Service packs and Security patches for the Servers.

-Troubleshoot performance-tuning issues by running SQL server Profiler, creating trace and run these traces in SQL Server Database Engine Tuning Advisor and analyzing the reports.

-Designing process flow and creating templates for each and every service used and provided.

-Planning and Implementing High Availability and Disaster Recovery solution without interruption.

-Responsible for database objects like tables, views, indexes, stored-procedures, triggers, cursors scripting,using T- SQL.

-Setting up and managing transactional replication, mirroring, and log shipping.

-Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, constraints, indexes, functions, views, rules, defaults and complex SQL statements.

-Using native and third party monitoring and troubleshooting tools (Quest software SQL LiteSpeed, Quest software Spotlight, Quest Foglight.

- Experience in MySQL, cloud and PostgreSQL

CYCLECT HOLDINGS PTE LTD – Singapore and Malaysia

SQL Database Administrator (February 2010 – December 2016)

-Installation and configuration of MS SQL Server 2005/2008/2012/2014 7.0 versions administration.

-Create and implement best backup and recovery strategies (Full Backup Model with transaction logs backups).

-Monitoring tables, disk utilization, database fragmentation, trace files and validate database issues.

-Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.

-Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, etc.), and database integrity checks.

-Used scripts and SQL Agent jobs to automate database maintenance tasks.

-Configure and install Windows Server 2016 clusters and SQL Server 2016 clusters.

-Responsible for database objects like tables, views, indexes, stored-procedures, triggers, cursors using T- SQL.

-Import and export data (Dev to QA, QA to Prod).

EDUCATION

University of Ado Ekiti – Ado Ekiti, Ekiti.

Bachelor’s in Business Administration (B.A), 2006.

Osun state polytechnic, Iree, Osun.

Higher National Diploma (H.N.D) 2002.

CERTIFICATION

Microsoft SQL DATABASEADMINISTRATOR 2017

Contact this candidate