DOLAPO ODUSAMI

*** ******** ***** ************ *******, 30214 USA

acwdxw@r.postjobfree.com Cell: 770-***-****

To obtain a SQL Server DBA position in which my current analytical and technical skills with over 4 years of supporting enterprise database applications. I am a team player who is attentive to details and able to work in a fast-paced enterprise environment. Ability to make decisions independently and quickly with little or no supervision. Excellent verbal and written communication and problem solving skills.

My core experience is in the area of:

Data Migration, Database Backup and Recovery/Disaster Recovery, Database Upgrades/Patches, Performance Tuning/Troubleshooting, Security, High Availability Solutions.

PERSONAL & PROFESSIONAL SKILLS SUMMARY

Experience debugging and tuning Transactional SQL and SSIS stored procedures.

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

Responsible for troubleshooting and problem solving of SQL Server.

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

Experience managing multiple MS SQL RDBMS on web-based transactions.

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

Maintenance and tuning of database and replication.

Experience with setup and administration of SQL Server Database Security environments using database Privileges and Roles.

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

Third party tools worked with includes but not limited to: Redgate, Quest Litespeed, Idera, BMC Remedy.

A disciplined Financial/Investment /Business Analyst, Equity and Fixed Income Securities trader(with experience in Private equity, Investment Banking, Corporate Banking, Commercial and retail Banking) with a zeal to learn, and proven ability to exceed goals in a high-pressure market condition.

Good leadership and interpersonal skills, coupled with a proven ability to manage a team in providing excellent customer relation and achieving growth.

Capable of communicating effectively in spoken and written English.

I am a motivated, energetic and goal focused professional with a consistent desire to Installed and Upgrade from SQL Server 2000 and 2005 to SQL server 2008 R2 on Various Production Servers.

Migrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring HA solutions and replace with Always On solution.

Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.

Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.

Used Policy Based Administration feature (SQL Server 2008 R2 and 2012).

Worked With 'insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).

Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008 R2 and 2012.

Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.

Worked in Active-Active Cluster environment as a High availability solution.

Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Created complex stored Procedures, Triggers, Tables and other SQL Joins and Statements for Applications by using T-SQL

RDBMS

MS SQL Server 2000/2005/2008/2008R2/2012/2014

PROGRAMMING LANGUAGES:

SQL, T-SQL, BATCH SCRIPT

OPERATING SYSTEMS

Windows NT/2003/2008/2011

PROFESSIONAL EXPERIENCE:

TATA Consulting Services Atlanta, GA

2014 till Present

SQL Server DBA

Created complex stored Procedures, Triggers, Tables and other SQL Joins and Statements for Applications by using T-SQL

Implementing and Maintaining Log Shipping Databases Clustering Mirroring Always On (AAG) across multiple Servers

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.SQL Server Virtualization & Consolidation

Managed security on Production and Development environments.

Monitored the complete environment for resource utilizations and to avoid any bottlenecks.

Creating and maintaining various databases on Production and development environments using SQL Server 2005/2008/2008R2/2012/2014

Created jobs to import/ export data obtained from various States to update the GIS servers.

Installed and configured SQL Server SSIS, SSRS and SSAS for the various Services.

Experienced in using SSIS for data transfer

Extensive experience implementing migration of SQL Server and Databases

Extensive Experience in Designing and Implementing Database Backup Restore & Disaster Recovery Strategy

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

SQL Server Database Monitoring with DDL Triggers SQL Server Profiler Event Notifications

Schedule SQL Jobs SQL Server across multiple Servers

Performance Tuning; Execution plan, Profiler, Performance Monitor, Extended Events and Resource Governor

Checking Database Health by using DBCC Commands and DMV

Extensive experience in documenting Disaster Recovery plan and procedure layouts

Extensive experience in disaster recovery solutions Plan, Design and Scheduled Database Maintenance & Administrative Tasks Conversion of DTS Packages to SSIS

Table Partitioning, Index maintenance

Expert in Using DMVs, Performance dash board, Mirroring and tracking Performance Counters.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Implemented High Availability & Disaster Recovery solutions such as AlwaysOn Availability Groups, Clustering (Both Active-Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping and mirroring

Implementing high availability with AlwaysOn Availability Groups and failover clustering.

Installed SQL Server and configured 2014/2012/2008R2/2008 on Windows Clustered environment Database Mirroring, Transactional Replication and Log Shipping and mirroring

Experience Installing, configuring and managing SQL Server 2008 Reporting Services (SSRS).

Experience Creating, configuring and administering Windows Servers specifically to run Microsoft SQL Server from 20008, 2008R2, 2012 and 2014

Experience Migrating DTS to SSIS packages.

Upgraded/Migrated SQL Server 2008, 2008R2 databases to SQL Server 2012 and SQL Server 2014

Experienced in Setting up and Maintaining and monitoring transactional replication, Database mirroring, log shipping on Production, QA and Dev servers.

RDBMS

MS SQL Server 2005/2008/2008R2/2012/2014

PROGRAMMING LANGUAGES:

SQL, T-SQL, BATCH SCRIPT

OPERATING SYSTEMS

Windows NT/2003/2008/2008R2/2012

PACIFIC SYSTEMS INC. Atlanta, GA

2012 - 2014

SQL Server DBA

Checking Database Health by using DBCC Commands and DMVS.

Expert in Performance Tuning of the Stored Procedures.

Monitored and modified Performance using execution plans and Index tuning.

Experience in Database security and integrity planning.

Used log shipping for synchronization of databases.

Prepared Documentation for the Disaster Recovery plan.

Designed Data Integrator jobs with Error Handling and email notifications.

Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Daily routine DBA tasks like handling user's permissions and space issues on Production and Test servers.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Performed the migration of SQL Server 2000 to SQL Server 2005.

Configured the servers on 32 bit and 64 bit clustered and standalone server environments

Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.

Responsible to Monitor and troubleshooting Log Shipping.

Implemented and maintained Database mirroring as a Disaster Recovery Solution.

Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration

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

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

Involved in Analyzing and Upgrading SQL Server 2000 servers to SQL Server 2008R2.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using Native SQL and BUR and EMC DDBoost

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 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration.

Supported 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.

Expertise in designing databases and capacity planning.

Experience with rebuilding the indexes and statistics update at regular intervals for better performance.

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

Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Worked extensively with 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 warehouse with SQL Server 2005 and 2008R2 Integration Services.

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

Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites.

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

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

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

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

RDBMS

MS SQL Server 2005/2008/2008R2/2012/2014

PROGRAMMING LANGUAGES:

SQL, T-SQL, BATCH SCRIPT

OPERATING SYSTEMS

Windows NT/2003/2008/2008R2/2012

CERTIFICATIONS:

Microsoft Certified Technology Specialist (MCP)

EDUCATION:

Devry University (Keller Graduate School of Management) / Atlanta, Georgia

Masters of Science in Accounting

Summe Cum Laude

Brenau University / Gainesville, Georgia

Bachelor of Business Administration

Magna Cum Laude

NAIA Award

Contact this candidate