E. O. EMMANUEL, MCITP, MCTS

**** ********** **. **** ***, Pine Lake, GA 30072

Phone: 404-***-****(H) 678-***-****(c) E-mail: acuz94@r.postjobfree.com

EXPERIENCE SUMMARY

SQL Server Database Administration/Developer Professional with over 7 years of contracting experience within a Technical environment. Strong ability to quickly adapt to new environments and function as a team player. Highly proficient in configurations and programming technologies. Areas of expertise include:

Data Migration

Data Performance Tuning

Backup and Recovery

Data Warehousing

Database Upgrades

High Availability

Database Monitoring

Database Security

Disaster Recovery

TECHNICAL EXPERTISE

Tools: Backup Utility, SQL Lite Speed, and Red gate (backup-pro7) T-SQL & ANSI SQL,

Operating Systems: Windows 2000/2003/2008/2008R2/2012/2014 Server

TECHNICAL CERTIFICATIONS

Microsoft Certified IT Professional (MCITP)

Microsoft Certified Technology Specialist (MCTS)

EDUCATION

Pacific Institute of Technology - McDonough, GA Certificate in Database Management

Tulane University - New Orleans, LA Master of Public Health

Miles College - Birmingham, Alabama Bachelor of Science - Business Administration

SKILLS SUMMARY

Experience with implementation of disaster recovery (DR) and strategy planning

Maintained understanding of company’s hardware/software security policies and procedures, as well as enterprise architecture

The ability to write and troubleshoot SQL Code and design (stored procedures, tables, views)

Trouble-shoot poor performing stored procedures, tune database & query performance.

Provide database design assistance for system enhancements and new systems development

Experience with delivering high availability solutions using database mirroring, log shipping and server clustering in a SQL SERVER 2005,2008,2008R2, 2012,2014 environment

Experience with implementation of backup and recovery strategies in SQL SERVER 2005/2008/2008R2 2012,2014environments.

Create & review databases and coordinate changes during deployment.

Provide data entry, storage, and retrieval techniques and technologies; integrate databases into software systems.

Management of high performance production CLUSTERED SQL SERVER database instances using ACTIVE-PASSIVE Clustering

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Experience in a multi-site environment data center environment clustered environment

Proficient in logical and physical database modeling

Setup and administration of SQL SERVER database security environments by assigning permissions on Server Securable to principals

Strong in SQL SERVER scripting and creating Packages, stored procedures and functions using T-SQL in a SQL SERVER2000/ 2005/2008/2008R2 environments

Extensive knowledge in Microsoft SQL Server databases, as well as SSIS, DTS packages, T-SQL, performance tuning, database design

Experience with cross-platform database migration and database instance consolidation

Experience with database upgrades and applying service packs

Prepared data load files and complete uploads for ECC and other auxiliary systems in a highly dynamic environment

Knowledge of other databases like MySQL, Oracle, and In-memory databases

Experience in creating, monitoring, backup, recovery, performance and tuning SQL Server databases in a multi-platform environment.

Experience with the Always On AVAILABILITY, Clustering, database Mirroring, Log shipping and Replication. Experience in SQL Server and Windows performance tuning and optimization in 2008R2, 2012

Update and maintain job knowledge by participating in education, reading detail oriented publications, maintaining personal networks, share knowledge with other IT staff

Experience with the BCP transformation and Load processes

Ability to install and configure SQL Server 2008, 2008r2, 2012 and 2014.

Customer service focuses with strong interpersonal and communication skills.

PROFESSIONAL EXPERIENCE

FIS Co Jacksonville, Florida SQL Server `DBA March 2016 May 2016

Implemented and enforced appropriate SECURITY measures for the database

Assimilated organizational objectives into operational action plans.

Knowledge and experience with capacity planning as it pertains to databases.

Developed, tested, and maintained a BACKUP and recovery process to ensure proper system continuity in the case of an unforeseen event.

Assisted in development of a data warehouse that is similar to a feed repository of agent and merchant financial

Responsible for all technical and operational activities associated with the DBA function(s) in a HIGH-AVAILABILITY and complex RDBMS environment.. Managed all aspects of database systems analysis including design, development, installation, and maintenance.

Wrote complex relational database queries and query optimization for very large datasets.

Made changes to production databases, such as creating new accounts, scheduling jobs, password changes, and modifications to server configurations.

Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.

Installed database applications on servers and develop installation procedures for client installations to be performed by the desktop support staff as requested or required

Experience with Data Transformation, Data Warehousing, and Data center

Migrate SQL server instances between Virtual servers

Extensive experience with VMWare and SQL Server virtualized databases

ALFA INSURANCE CO. Brentwood, TN. SQL Server DBA /Developer August/2014 Feb/ 2016

Managed all aspects of database systems analysis including design, development, installation, and maintenance.

Wrote complex relational database queries and query optimization for very large datasets.

Made changes to production databases, such as creating new accounts, scheduling jobs, password changes, and modifications to server configurations.

Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.

Installed database applications on servers and develop installation procedures for client installations to be performed by the desktop support staff as requested or required

Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.

Monitored server activities, I/O, memory usage using system monitor/PROFILER to determine the cause of database/application slowness. Established data and user security policies.

Maintained and optimized Company’s transactional database via proper INDEX usage, de-fragmentation, and statistics updates, etc. Analyzed future disk space requirements, and usage to project hardware upgrade needs.

Managed night job data processing for ongoing success- troubleshoot and rectify any production related issues.

Designed, developed and troubleshooting SSIS packages that implement complex ETL processes.

Implemented and enforced appropriate security measures for the database.

Designed and developed ETL solutions as well as debugging, monitoring and troubleshooting ETL solutions

Generated trend analysis reports to proactively project resource requirements

Built and support database models to support ETL, reports, dashboards, reports and BI packages

Assisted users with problems and resolves issues independently

Create & review databases and coordinate changes during deployment.

Created test plans, test cases, test scripts and performs testing of the BI and related environments

Developed and/or maintenance of SSIS packages, SSRS reports, and T-SQL processes.

Deployed of SQL Server SSIS packages, SSRS reports, and T-SQL code to QA and production environments.

Researched and stayed current with SQL Server,PL/SQL methodologies and new technologies.

.

Tools/ Platform: SQL Server 2005, 2008, 2008R2, 2012,2014,Active/Active and Active/ Passive cluster, Database mirroring, Database mail, DTS, SSIS, SSRS, Backup/Restore, DR plans, Cog no’s reporting Services, Always On Availability and with MS EXCEL

IBM Co Atlanta, GA SQL Server Database Administrator May/2011-July/2014

Developed and maintained ETL scripts for efficiently loading and extracting data from the database when necessary.

Developed DTS/SSIS packages to perform ETL operations from various data sources.

Performed and monitored all database backups and restore database in response to minor and/or major database failures.

Implemented and enforced appropriate security measures for the database.

Designed and developed ETL solutions as well as debugging, monitoring and troubleshooting ETL solutions

Generated trend analysis reports to proactively project resource requirements.

Developed, tested, and maintained a backup and recovery process to ensure proper system continuity in the case of an unforeseen event.

Provided 24 X 7 production database support to help resolve production and application related issues(Sev1/se2)

Responsible for all technical and operational activities associated with the DBA function(s) in a high-availability and complex RDBMS environment.

Prepared data load files and complete uploads for ECC and other auxiliary systems in a highly dynamic environment

Managed all aspects of database systems analysis including design, development, installation, and maintenance.

Wrote complex relational database queries and query optimization for very large datasets.

Experience with Microsoft SQL Server database mirroring, log shipping and replication. Experience in SQL Server and Windows performance tuning and optimization in 2005, 2008, 2008R2, 2012.

Worked closely with BI analysts to deliver effective global BI architecture in a timely manner.

Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.

Monitored server activities, I/O, memory usage using system monitor/PROFILER to determine the cause of database/application slowness. Established data and user security policies.

Maintained and optimized Company’s transactional database via proper INDEX usage, de-fragmentation, and statistics updates, etc. Analyzed future disk space requirements, and usage to project hardware upgrade needs.

Managed night job data processing for ongoing success- troubleshoot and rectify any production related issues. .

Wachovia Bank Atlanta, GA SQL-Server Database Administrator February 2004- February 2008

Developed and maintained ETL scripts for efficiently loading and extracting data from the database when necessary.

Ensured that database solutions for application systems are developed in a way that complies with architectural standards and established methodologies and practices.

Installed, configured, and administer Oracle and Microsoft SQL database instances.

The ability to OPTIMIZE stored procedures, performance tuning and index tuning using index tuning wizards and SQL Profiler.

Participated in development and execution of Finance team key profitability ANALYSISand REPORTING objectives for the business portfolios

The ability to write and troubleshoot SQL Code and design (stored procedures, tables, views)

The ability to document standard operational procedures.

The ability to CREATE data dictionary and Microsoft Visio diagrams for current production databases.

Understood current capacity issues and the capacity planning processes.

Participated in Disaster Recovery exercises (if available remotely).

Provide Daily status reports of the work activity to Project managers

Tools/ Platform: SQL Server2000, 2003, 2005, 2008, 2008R2, Active/Active and Active/ Passive cluster.

T-SQL & ANSI SQL and MS EXCEL

PROFESSIONAL AFFILIATIONS

PASS – The Professional Association for SQL SERVER

Who’s who Among Students in American Universities and Colleges

Contact this candidate