Post Job Free

Resume

Sign in

Database Administrator

Location:
McDonough, GA
Posted:
November 04, 2014

Contact this candidate

Resume:

Obj***

Adewale George

P.O. Box ****

Mcdonough, Georgia

678-***-****

acgl34@r.postjobfree.com

Professional Summary

More than 4 years practical experience in MS-SQL DBA Database Administration for

diverse industries including Financial Institutions, retail and high-tech environment and a

record of increased responsibility with 10 mins MTTR SLA with our clients. Proficient in

prioritizing and completing projects and assigned tasks in accordance with budget and

time schedule, yet flexible to multitask when necessary.

Areas of EXPERTISE:

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

Education

International Business Machines (JOIN Group Consulting)

Microsoft SQL Server 2012 Database Administration

McDonough, GA Graduated

August 2014

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 databases for mission-

critical business.

Knowledge of Disk and Server configuration through Raid for SQL Server.

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.

Knowledge with monitoring and troubleshootingin 24x7 operations.

Saint Thomas Christian University

Doctorate/ Divinity

Jacksonville, FL Graduated

April 2014

Employment History

JOIN group Consulting LLC

MS SQL DATABASE ADMINISTRATOR

McDonough, GA January 2013 –

Present

Client: Bank of America

SQL Server DBA

Utilizing Epic software to monitor, manipulate, and secure databases. Completed

documentation of patients’ information in a timely manner.

Create, assign, accept and manage all incidents in BMC Remedy

Configuring and setting up of Disaster Recovery (DR) and High Availability (HA)

using Always on High Availability solutions for customers

Design, implement and administer High Availability solutions, (clustering, log

shipping mirroring and replication)

Provide 24/7 remote support to SQL Servers on customer sites of various companies

to prevent downtime

Writing, debugging, and tuning T-SQL and Stored Procedures for system performance

SQL Server database physical model creation and implementation (data type,

indexing, table design)

Using SQL-Century and light-speed application for optimizing queries and database

performance

Setup and administering SQL Server Database Security environments using profiles,

database privileges and roles to prevent data theft and increase data integrity

Database maintenance, replication and tuning

Migration of systems data from different databases and platforms to MS-SQL

databases

Database administration including installation, configuration, upgrades, capacity

planning, performance tuning, backup and recovery in managing clusters of SQL

servers

Designing, Implementing and maintaining database schema, entity relationship

diagrams, data modeling, tables, stored procedures, functions and triggers,

constraints, indexes, functions, views, rules, defaults and complex SQL

statements.

Generate complex stored procedures and functions for better performance and

flexibility

Ensure database performance monitoring and tuning is regularly accomplished

Design backup and restore strategies and Disaster Recovery solutions

Implement security policy design for current and new applications

Coordinate team meetings with groups for new design/strategies

Create database design for new projects support

Responsible for maintenance, Backup & Recovery, testing, alerts (job failures,

database & server capacity, etc), and database integrity checks

Review logs, update database statistics and index management

Troubleshoot application performance issues, database maintenance & configuration,

patching, and upgrading

Security, auditing, configuring, documenting, enhancement & corrective changes,

emergency changes

Participate in DBA On-call monthly and document environments and processes where

applicable

Work with other DBAs and Developers team members and various application teams

JOIN group Consulting LLC

MS SQL DATABASE ADMINISTRATOR

McDonough, GA January 2010 –

January 2013

Client: International Business Machine

Database Administrator

Used Red-gates and SQL-century 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 database 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

References

Holselyn Wedlowe

Business

JOIN group Consulting LLC

404-***-****

acgl34@r.postjobfree.com

Gwendolyn Dumas

Business

Zion Embassy Ministries International Inc

478-***-****

acgl34@r.postjobfree.com

Qualification & Certification

Microsoft SQL Server 2012 Database Administration Certificate August

2014

JOIN Group Consulting

McDonough, GA

Professional Association for SQL Servers (PASS)

CLIENTS

Retail and Manufacturing



Contact this candidate