SUMMARY

• Sr. Database administrator and systems programmer with more than 18 years of IT experience.
• 3 years IT management experience.
• 3 year UNIX Administration experience
• Developed expertise in Oracle database disaster recovery, performance tuning and systems programming
• Expertise in Oracle 12c/11g/10g database administration in production environments
• Expertise in Oracle RAC configuration and Administration on Linux
• Expertise in Oracle Goldengate configuration and Administration
• System resource management including bottleneck detection, database wait analysis, tuning and sizing of SGA, CPU, Memory and I/O etc.
• Experienced in setting up physical standby databases for DR and fail - over purposes using Dataguard
• Ability to prioritize and meet operational deadlines in fast paced environment
• Very good unix shell scripting to include korn, bourne and C shell. Scripts created for both conventional and RMAN hot backups, application environment refreshes which used Oracle exporting and importing of databases.
• Perform Daily Monitoring of Oracle instances using tools including Oracle Enterprise Manager 10g Grid Control, Statspack, ADDM, AWR and TOAD.
• Created numerous SQL scripts and PLSQL procedures to meet business requirements.
• Expertise in architecting database solutions to meet application and business requirements. This also includes capacity planning and trend monitoring.
• Expertise installing Oracle software and applying patches
• Design, development, and testing of backup and recovery to ensure complete recoverability. Completed numerous Sungard disaster recovery tests of our production environments
• Security management for database, network, and operating systems. Created the necessary scripts and triggers to enforce security policies
• SQL Net installation/configuration/troubleshooting (Server and Client side).
• Storage Management including fragmentation detection, tablespace growth and trending
• Excellent interpersonal and strong analytical, problem-solving skills.
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
• Experience working with high-transaction OLTP systems.
• Experience in working with large datawarehouse system greater than 12 terabytes

TECHNICAL SKILLS

Programming Language: SQL, PL/SQL, VB script, UNIX Shell scripting, PHP, Perl, RPG, TCL,C/C++, JavaScript, JSP, JSTL

Software: SMS MedSeries4, Cloverleaf, Cerner HNAM, Quest Toad, Quest Spotlight, Oracle Enterprise Manager 11g Grid Control, Manage Engines Application Manager

Operating Systems: RedHat Linux, Ubuntu Linux, AIX, AS/400, Windows Server, HPUX/Itanium, Solaris, SUN

Databases: Oracle 7.3, 8, 8i, 9i, 10g, 11g, 12c and Mysql 5.0

PROFESSIONAL EXPERIENCE

Confidential - Monroe, LA

Senior Lead Database Administrator

Responsibilities:

• Administered and performed data migrations in multi-terabyte DataWarehouse Exadata environment
• Created new multi-node OLTP RAC environment
• Performed cross platform data migration to RAC environment
• Performed database conversion and migration to ASM
• Configured and implemented Oracle Goldengate for data synchronization

Confidential - Monroe, LA

Senior Production Oracle DBA

Responsibilities:

• Production Database Support including issue resolution, performance tuning, capacity planning
• Performed monitoring, scripting and problem resolution in 800 database environment

Confidential

Senior Oracle DBA

Responsibilities:

• Setup maintenance procedures as needed.
• Setup configured data ETL operations to Data Warehouse
• Coded, tested and implement PLSQL development procedures to accommodate business requirements.
• Provides subject matter expertise as it concerns database development to development teams.
• Provides as needed performance tuning expertise to resolve batch and online application issues using ADDM, AWR Reports, unix server statistics and session tracing for performance tuning.

Confidential - Monroe, LA

Oracle DBA Manager/Tech Lead

Responsibilities:

• Responsibilities included management of eight database administrators supporting 138 enterprise databases. 39 of these databases were production databases.
• Our team was a part of our operations team which consisted of a server support team, TSM/SANS storage team, infrastructure team and security team. We supported ongoing systems and projects to meet the business needs.
• Worked with the project management office to determine and meet resource requirements to meet project demands
• Defined database standards, policies and procedures which included SOX and PCI security standards.
• Responsible for evaluating new system database project requirements
• Designed and configured MYSQL databases for successful VOIP and IVR projects
• Defined and configured monitoring and backup solution for MYSQL databases
• Setup and configured Oracle Grid Control 10g for monitoring all of our enterprise databases
• Designed and implemented enterprise wide RMAN database backup solutions
• Assisted in the design and implementation of two production Dataguard fail-over solutions for web environments
• Designed and architected Datawarehouse environments to store minutes of use data (6TB)
• Provided performance tuning support for developers and mentored all junior DBA’s
• Created Oracle 10g upgrade roadmap and currently in the process of implementing
• Trained and mentored junior DBA staff members

Confidential - Monroe, LA

Oracle DBA / Tech Lead

Responsibilities:

• Primarily supported Ensemble Billing Environment which consisted of a three multi-terabyte databases
• Upgraded environments from Oracle 8i to 9i
• Created conventional backup and recovery scripts
• Performed disaster recovery tests at Sungard sites
• Performed performance tuning in online environment which consisted of 1000 users
• Supported application team release and upgrade efforts - which required environmental refreshes and code tuning
• Designed and implemented database re-organization plan for OLTP databases.
• Worked in on-call rotation
• Diagnosed problems and applied necessary Oracle patches.
• Worked issues with Oracle support and oracle Metalink services
• Create UNIX scripts to store and trend OS metrics and monitor the databases

Confidential - Monroe, LA

Oracle DBA / AIX Administrator

Responsibilities:

• Supported four non-production databases and one production database that resided on two H50 RS6000s in a high availability cluster environment. As well as apply database updates, I also applied the OS updates and firmware updates.
• Migrated all instances to Oracle 8.1.6 and installed M50 RS6000’s.
• Monitored database environments using BMC monitoring agents, Unix scripts and SQL scripts. Created scripts to capture trend data.