FRANCES S. LEWIS Greater Atlanta Area *****

www.linkedin.com/in/frances-lewis • ac4a4v@r.postjobfree.com

CAREER PROFILE

Information Technology Leader experienced in database administration, database & resource monitoring, backup/recovery, migrations, upgrades and performance tuning. Exceptional skills include experience with a vast array of operating systems, relational databases, applications, and tools. Specialty is proactively maintaining and monitoring database infrastructure and database objects.

SKILLS

Database

Oracle (8i/9i/10g/11g/12c), RAC, RMAN, ASM, GoldenGate, Data Guard, Amazon RDS/AWS, Redshift, Microsoft SQL Server, Oracle Enterprise Manager, SQL Query Analyzer, Quest Toad, SQL / Transact-SQL, SQL*Loader

Applications & Utilities

PeopleSoft, Veritas NET Backup, WebLogic, UNIX Shell, Glance, Top, Active Directory

Operating Systems

Linux (Red Hat & SUSE), Solaris, HP-UX, AIX, Windows Server

PROFESSIONAL EXPERIENCE

8/2016 - present NATIONAL RAILROAD PASSENGER COMPANY (AMTRAK), Atlanta, GA

Lead Oracle Database Administrator – Provide project and operations database administrator support for Oracle databases on local and AWS /Redshift cloud servers. Manage databases and coordinate changes between application and infrastructure teams. Primary application teams supported are Consumer Mobile, SAP and EDW. Administer Oracle databases (rel. 11g/12c) on Linux and Solaris operating systems. Additional responsibilities include:

Migrated 80+ Oracle databases from Solaris to Linux platforms.

Build Oracle 12c databases following corporate database operational standards.

Reduce database incidents 60% by proactively monitoring.

Upgrade Oracle databases to 12c.

Monitor database storage utilization proactively, requesting storage as needed.

Analyze security scan results and devise remediation plans.

Provide DBA support for application software upgrades.

Manage database partitions.

Monitor database performance and provide SQL, Memory, and I/O tuning.

4/2014 - 08/2016 GENERAL MOTORS, Roswell, GA

Oracle Database Administrator – Provided project database administrator support for 15+ project teams. Bridged the gap between the application, operations, infrastructure, and engineering teams. Primary application teams supported are PeopleSoft and Siebel teams. Administer Oracle databases (rel. 11g/12c) on Linux, Solaris & HP-UX operating systems. Additional responsibilities included:

Built Oracle 11g/12c databases according to corporate standards.

Provided DBA support for application software upgrades (PeopleSoft, Siebel, OneSource).

Applied database patches and provided data/database migrations and refreshes.

Configured database replication using Data Guard and GoldenGate to insure high availability.

Diagnosed and resolved performance issues.

Configured database backups and monitored their successful completion.

Proactively monitored database storage.

8/09 - 12/2013 GENPACT LLC, Atlanta, GA

Sr. Database Administrator – Provided Oracle database support for 100+ databases some as large as multi-terabyte sized databases for large International energy corporation, General Electric. Administer Oracle databases (rel. 10g/11g) on Solaris, Linux & HP-UX operating systems. Additional responsibilities included:

Built ASM disk groups and Oracle RAC databases.

Led and influenced CIO project teams in database architecture, design, and testing.

Provided advocacy/liaison between project teams and global DBA teams.

Assessed database storage areas proactively.

Reduced cycle time required to build database project environments by 50%.

1/09 - 4/09 MATRIX RESOURCES, Atlanta, GA

Sr. Database Administrator – Provided production and development database monitoring and performance tuning for leading paper distributor, Unisource Worldwide. Administered Oracle databases (8i / 9i/ 10g) on HP-UX operating systems. Additional responsibilities included:

Automated manual database procedures where possible.

Provided database support for data conversions.

Managed database partitions and provided database capacity planning/storage management.

Followed change management procedures for code migrations to production/stage databases.

12/07 - 10/08 KINETIX, Atlanta, GA

Sr. Database Administrator – Sole DBA in the Americas region for International pharmaceutical corporation, UCB. Proactively managed 50+ Oracle (8i/9i/10g) and MS SQL Server (2000/2005) databases. Oracle database operating systems were Linux RHEL 5 and Windows Server 2003. Applications supported included SAP, PeopleSoft, Government Pricing, Mercury, E-Pedigree (product serialization), ETL Insight, and varied other applications. Additional responsibilities included:

Proactively monitored databases to prevent outages.

Validated and improved backup & recovery strategy.

Designed Oracle architecture for new application projects.

Monitored performance and implemented improvements..

Planned, installed & configured all new database servers.

4/07 - 9/07 AFFLIATED COMPUTER SERVICES, INC., Atlanta, GA

Technical Architect – Provided remote PeopleSoft & Oracle DBA support on a lift & shift project for multinational pharmaceutical firm, GlaxoSmithKline. Supported PeopleSoft (PeopleTools/HRMS) applications on Oracle databases on Solaris, SQL Server 2005 & Windows 2003 platforms. Additional responsibilities included:

Designed PeopleSoft-Oracle architecture.

Planned, configured & monitored peoplesoft databases, appservers, and webservers (i.e. Tuxedo, WebLogic, PeopleTools).

Initiated and maintained relationship with software vendors.

Coordinated resources as needed on UNIX, Storage, Systems, Networking teams to support PeopleSoft Development, Testing, Business Objects, Portal and interface teams.

5/06 - 1/07 CORNER OFFICE CONSULTANTS, Atlanta, GA

Sr. Database Administrator – Sole DBA in the Americas Region for an International construction and development corporation, Lend Lease. Proactively managed 100+ Oracle (9i /10g) and MS SQL Server (2000/2005) databases. Applications supported included Oracle Financials and PeopleSoft. Additional responsibilities included:

Planned, installed, configured and performed upgrades of Oracle RDBMS.

Installed Oracle Server 10gR2 and required patches to support the Upgrade project.

Installed MS SQL Server (2000 and 2005) and required service packs.

Performed database recovery and upgrades & resolved backup and RMAN errors.

Prepared and documented disaster recovery (DR) procedures and provided support.

Refreshed databases and provided performance tuning support as needed.

9/05 - 4/06 COMPREHENSIVE COMPUTER CONSULTANTS, Atlanta, GA

Database Administrator – DBA for Oracle (rel. 8i – 10g) and MS SQL Server (2000/2005) databases supporting PeopleSoft, Oracle Financials, and various vendor applications for major electric utility company, Southern Company Services. Followed change management procedures/processes and insured database tasks were compliant on databases of Key Financial applications as outlined by Sarbanes Oxley policies. Provided tuning & UNIX scripting as needed. Additional responsibilities included:

Upgraded databases to Oracle 10g.

Created databases and provided refreshes, backups & recoveries, and moves as needed.

Monitored database alerts and tablespace growth.

Utilized tools such as TOAD & Erwin Data Modeler to provide ERD diagrams.

Coordinated resources as required such as UNIX, Storage, or Systems requests.

1/05 - 9/05 CLARISIE CONSULTING (Consultant), Atlanta, GA

Database Administrator – Provided DBA consulting on an as needed basis offering services such as performance analysis, backup & disaster recovery analysis, and PeopleSoft Tools upgrades.

1/04 - 1/05 SUREBRIDGE, INC. (Consultant), Atlanta, GA

Database Administrator – Proactively managed database environments (Oracle / MS SQL Server) providing a high level of technical service oriented support to resolve remote Southeast client issues. Additional responsibilities included:

Managed database backups and recovery (SQL Server, Oracle).

Installed, configured, and tuned PeopleSoft applications

Maintained & administered NT security (Citrix & Windows Server 2000).

Provided UNIX scripting as needed.

Identified and implemented solutions that improved performance.

11/00 - 12/03 RANDSTAD NORTH AMERICA, Atlanta, GA

Oracle PeopleSoft Database Administrator – As a corporate employee, provided development & production support for database, application and web servers: daily management and configuration of Oracle databases and PeopleSoft applications. Additional responsibilities included:

Provided performance tuning, system planning, and database sizing on Oracle 8i & 9i databases.

Performed database backup/recovery and upgrades.

Installed, configured, and tuned PeopleSoft applications & utilities

Upgraded PeopleSoft PeopleTools and applications.

Designed initial infrastructure evolved from multiple legacy systems.

PREVIOUS PROFESSIONAL EXPERIENCE

ORACLE CORPORATION, Atlanta, GA

PEOPLESOFT, Atlanta, GA

MELITA INTERNATIONAL CORPORATION, Norcross, GA

INTERNATIONAL BUSINESS MACHINES CORPORATION, Atlanta, GA

GENERAL MOTORS WAREHOUSING & DISTRIBUTION, Flint, MI

CERTIFICATIONS/EDUCATION

Bachelor of Science - Computer Science - Grambling State University

Oracle 8i Database Certification

ITIL Foundation Certification

AWS Solutions Architect (certification in process)

Contact this candidate