Database Administrator Resume Brentwood, Tennessee - Hire IT People

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, Tennessee

Database Administrator

Responsibilities:

Acted as first line of database support to the Development, Implementation, and Application Support teams.
Responsible for performance monitoring, database updates, ad - hoc SQL & PL/SQL packages and SQL tuning using Oracle Enterprise Manager 12c, SQL Developer, and Toad.
Refreshed development schemas using Data Pump.
Scheduled jobs using Oracle Scheduler and Automic.
Provided onsite support for new customer WMS application implementations and application re-implementations.
Attended weekly Scrum meetings and provided direction for the Development team for new or modified database objects.
Participated in CIRT endeavors to resolve urgent issues.
Promoted code releases to production (and sometimes reverted them) via Automic.

Confidential, Tennessee

Database Administrator

Responsibilities:

Began by tuning existing Oracle 7.3.4 database resulting in 32% improvement in performance.
Assisted in the upgrade of Oracle Forms and Reports from release 5 to 6i, then to 9i.
Assisted in the setup of Oracle 10gR2 Application Server for the Oracle 9i Developer Suite.
Participated in Cognos mentoring program at LBMC in Brentwood, TN to assist the developers in the creation of efficient Cognos Catalogs and Cubes.
Recovered four production databases after four separate disasters.
Created audit triggers to provide a before and after view of numerous tables in the Glovia ERP system for Sarbaines/Oxley compliance.
Upgraded all databases starting from release 7.2.0.3 to release 11.2.0.3 including all PSUs as released over the course of 13 years
Changed character sets of all production databases to AL32UTF8
Assisted in the upgrade of the Glovia ERP system to G2 release
Backed up all production databases nightly using RMAN as well as Snap Manager for Oracle (NetApp tool). Also retained month-end and year-end copies.
Migrated all databases to Red Hat Linux 6.4 from HP-UX and began the certification process for Red Hat System Administration to act as backup for the Sysadmin.

Confidential, Atlanta, Georgia

System/Database Administrator

Responsibilities:

Database and system administrator for Oracle 7.3.4 database on an IBM RS6000 running Banner application by SCT.
Responsible for daily backups and disaster recovery readiness
Upgraded OS and application twice
Responsible for Y2K readiness. No problems encountered after 1/1/2000.
Wrote numerous programs written in Sqlplus and UNIX shell script to monitor performance and enhance Banner application.

Confidential, Nashville, Tennessee

Database Administrator

Responsibilities:

Responsibilities included all maintenance, new releases, development, production support, and acquisition support of the D&B Financial Suite, which includes General Ledger, Fixed Assets and Accounts Payable.
Trained as Database Administrator and PeopleSoft to be lead DBA for the new PeopleSoft Financial suite on Sun E5000 and E6000 machines with UNIX (Solaris) OS using Oracle 7.3.2
Responsible for all production support, backup strategy, database upgrades, assisting developers with problem SQL code, and ensuring the standards and procedures were followed.
Upgraded Production database to release 7.3.4.5 and was preparing for Oracle 8.0 conversion and PeopleSoft upgrade when the company was purchased.
Installed and implemented Oracle 7.3.4 database on NT 4.0 for CRM application by TCS.
Abilities include SQL, Oracle Enterprise Manager, OEM Performance Pack, UNIX Shell Programming, and PeopleTools.