Resume

Sign in

Sql Server Oracle

Location:
Douglasville, GA
Posted:
April 29, 2014

Contact this candidate

Resume:

TORRANCE LEMAR BARNUM

404-***-****

acdwqi@r.postjobfree.com

SENIOR DBA

. Over 21 years DBA expertise with Oracle RDBMS platform

. Over 18 years of DBA expertise with SQL Server RDBMS platform

. Over 13 years of DBA expertise with MySQL/Sybase RDBMS platform

QUALIFICATIONS

< Sr. Level DBA with hands expertise with database performance analysis,

design, performance tuning, upgrades, replication, High Availability

implementation, Backup & Recovery implementation and database capacity

planning expertise.

< Proficient in Windows 2008-2012, Sun Solaris, Red Hat Linux, HP-UX,

AIX, T-SQL, SQL*Plus, PL/SQL, C/Unix, C++, C#,VB .NET, VMARE, UNIX

Shell Programming, Oracle, SQL Server, MySQL, Sybase, Sybase IQ, ASA,

Unidata, Oracle 8/8i/9i/10g/11g, Oracle Enterprise Manager

(OEM)/Oracle Grid Control, Oracle E-Business Suite, Oracle Apps,

Oracle Access Management, Oracle Hyperion, Big Data, RMAN, Oracle RAC,

Data Guard, Oracle Steams, Export/Import, Data pump, SQL SQL Server

versions7/2000/2005/2008/2012/2014 SQL Server Cluster, Business

Analysis, Oracle Business Objects, SQL Server Business Objects, SSIS,

SSRS, SSAS, Java, and HTML. MCITP SQL Server DBA Certified, Microsoft

Stack development tools, Crystal reports, MS Dexterity IDE, MS

Dynamics GP.

PROFESSIONAL EXPERIENCE

ISS Atlanta, GA

DBA Architect Consultant Oct 2006-

Present

< Serve as DBA Architect Team Lead.

< Provided data modeling, database schema design, Big Data visualization

packages and database management policy and procedures documentation.

Implement Oracle Apps, PeopleSoft, Maximo, MS Dynamics (Great Plains),

Oracle E-Business, Business Objects etc.) And SQL Server BI Components

and Business Objects for Data warehouse environment. Implemented MySQL

to SQL Server migration process, SQL Server to MySQL migration

process, and SQL Server to Oracle migration process and Oracle to SQL

Server Migration process. Implementation of Sybase, Sybase IQ, Sybase

ASE, ASA and MySQL Cluster. Used DB Artisan and Toad as third party

DBA admin tools.

< Implemented Database Audit and Security Policy & Procedures

documentation.

< RDBMS DBA support for Oracle databases, SQL Server databases, OLAP

databases, Oracle Financials, PeopleSoft, Hyperion, developed Hyperion

reports, CRM and internal applications. Installed, configured and

administered Prod, QA and Test Oracle RAC environment for high

availability. Vmware configuration. Configured SQL Server SSIS, SSRS

and SSAS.

< Installed, configured and administered Production, QA and Test SQL

Server Cluster 2012, AlwaysOn, SQL database mirroring, SQL Server

replication and Geo Clustering environment for high availability

implementations.

< Set up stand by servers for Reporting/data warehousing and Disaster

recovery plan for Oracle & SQL Server MySQL RDBMS environment.

< Worked on Oracle, SQL Server, MySQL, DB configuration and Performance

Tuning.

< Implemented Oracle Data Guard, Oracle streams, Golden Gate

Replication, backup and recovery plan policies and procedures.

< Installed and setup replicated instance of Oracle database for

supporting Internet application and reporting.

< Designed and developed data model for application enhancements.

< Re-organized database and re-architected application server to resolve

performance issues. Monitored database and application, tuned SQL

queries, indexes, Oracle initialization parameters, and clustered

application servers.

< Supported application administrators, application developers with

application and system design/architect, business analyst and

configure PHP applications and db connections.

< Designed, developed reports using SSRS, and implemented Data Warehouse

/ DSS systems using Oracle Gather and analyze production database

performance to ensure proficient performance on all production

databases. Databases supported on Windows, Unix and Linux. Unix

scripting and crontab scheduling.

ISS- Weather Channel Atlanta, GA

Sr. DBA Architect Consultant March 2004-

Oct 2006

< Serve as DBA Architect Team Lead.

< Provided data modeling, database schema design, and database

management policy and procedures documentation. Implemented enterprise

apps such as PeopleSoft, Oracle Financials, Maximo and Great Plains.

< Implemented Database Audit and Security Policy & Procedures

documentation.

< Installed, configured and administered Prod, QA and Test Oracle RAC

environment for high availability.

< Installed, configured and administered Production, QA and Test SQL

Server Cluster environment for high availability.

< Set up standby Oracle, SQL Server, Sybase, ASA and MySQL database

servers for Disaster recovery.

< Created and modified physical database objects.

< Upgraded Oracle instance from Oracle 8i to Oracle 9i.

< Upgraded SQL Server instance from SQL Server 2000 to SQL Server 2005.

< Backup and recovery of databases and documented the procedure.

< Create test databases from the production environment.

< Create and maintain users, privileges, views, tables, synonyms,

sequences and indexes in Oracle 8i, 9i, 10g SQL Server 2000 and SQL

Server 2005 as per the need.

< Managed stand-alone report servers and their jobs.

< Provided 24x7 on-call support for OLTP database and disaster recovery

support.

NAMB Location Alpharetta, GA

Sr. DBA March 1999-March 2004

< Served as Team Lead.

< Implemented Database Management Policy & Procedures documentation.

< Managed Oracle, SQL Server, and Sybase databases for both Production

and Development environments.

< Served as DBA Manager over 5 DBA's.

< Developed strategic database architecture plans and data modeling for

Oracle, SQL Server and Sybase databases.

< Developed and implemented database triggers, T-SQL and stored

procedures within Oracle,

< SQL Server and Sybase.

< Managed and maintained Oracle instances and SQL Server 6.5, 7.0 & 2000

Databases both production and development environments.

Previously employed as DBA Manager with City of Atlanta (April 1997-March

1999); Database Analyst with City of Atlanta (April 1996-April 1997);

Programmer with Fulton County Mental Health Department (October 1994-May

1995); Systems Analyst with Travelers Insurance (April 1993-October 1994);

Systems Analyst with Department of Banking and Finance (February 1990-April

1993).

EDUCATION\Certifications

FMU A.S. Degree CIS 1991, FAMU B.S. Degree CIS, 1996

MCITP SQL Server 2008 DBA Certified

AFFILIATIONS

Prince Hall Masonic Masonry Fraternity Omega Psi Phi Fraternity Inc.



Contact this candidate