OBJECTIVE:

• Actively seeking a more challenging Oracle DBA opportunities that utilize my broad hands - on technical training and work experience to build infrastructures, add IT support value and deliver costly efficient cutting edge technology solutions.

SUMMARY:

• Active Secret & Top Secret Clearance
• Provide administrative support for all applications that use oracle database 9i, 10g, 11g and 12c
• Experience with 11g RAC, ASM, DATAGUARD, RMAN and EM Grid Control
• Identified, resolve, or provide recommendation to different kinds of performance problems using AWR, STATSPACK, EXPLAIN PLAN, SQL Trace
• Performs general DBA duties (install software, create databases, tablespaces, add redo log files, apply patches and upgrades, migrate databases from Windows to Linux, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing using RMAN duplicate
• Excellent troubleshooting skills
• Identify and make recommendations per database performance issues
• Knowledge of managing Oracle on Windows, Linux & UNIX
• Prepare documentation for DBA department
• Implements/maintains database security with roles and system privileges
• Create, develop, review, and support physical and logical models
• Experience working in a help desk and call center environment.
• Demonstrated ability to quickly diffuse heated customer situations.
• Excellent troubleshooting and logical problem solving skills.
• Creative ability to solve unusual or difficult problems when logical methods have failed.
• Demonstrated ability to meet deadlines and set priorities.
• Strong communication and interpersonal skills.
• Ability and desire to learn new technologies quickly.
• OS Platforms: Windows Vista, XP, 2000, 98, 95, SQL*Plus Oracle (Linux/Unix), Mainframe .

TECHNICAL SKILLS:

Oracle Tools: Oracle Enterprise Manager ( 11g and 12c OEM ) with Diagnostics, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Oracle Net Manager, SQL*Plus and iSQL*Plus, Recovery Manager, Data Pump, TOAD, Netca, STATPACK SQL*Loader, Oracle VM Manager, and Command-line tools, PeopleSoft, EBS, VERITAS Netbackup, Informatica application, PHIRE migration.

PROFESSIONAL EXPERIENCE:

Senior Oracle and Peoplesoft database admin

Confidential

Responsibilities:

• Proactive Monitoring of PeopleSoft Production Environment
• Applying PeopleSoft patches, Tax updates and upgrades.
• Coordinate and install product fixes to current releases of PeopleSoft
• Implement database auditing tools to proactively collect database
• Support and coordinate implementation of major technical projects such as system upgrades of PeopleTools, PS applications (Tax updates and bundles).
• Configure and maintain all PeopleSoft production, test and development environments and instances.
• Maintain the PIA, Application Server, Web Server, and the Process Schedulers.
• Perform periodic environment refreshes.
• Perform project migration to Production system and maintain migration procedures to ensure change control.
• Conduct performance tuning and proactive monitoring of Web Servers, Application Servers, and Process Schedulers.
• Performed Oracle DBA duties in a full life cycle Oracle and systems development project to upgrade and modernize the Department of State, HR platforms.
• Installed, configured and administered oracle 9i, 10g, 11g and 12c RAC for PeopleSoft using Grid Control .
• Assisted in executing tasks to upgrade 11g to 12c RAC (3 nodes) on 11g ASM.
• Experience troubleshooting production, development and test databases downtime and administration problems by replicating production database using data pump and UNIX BASH scripts.
• Use phire to migrate Peoplesoft object and codes.
• Managing standby databases by making sure that the primary is syncing up with the standby databases
• Performing continuation of operations and disaster recovery by performing switchovers and failovers depending on the situations.

Senior oracle peoplesoft database administrator

Confidential

Responsibilities:

• Support and coordinate implementation of major technical projects such as system upgrades of PeopleTools, PS applications (Tax updates and bundles).
• Configure and maintain all PeopleSoft production, test and development environments and instances.
• Maintain the PIA, Application Server, Web Server, and the Process Schedulers.
• Perform periodic environment refreshes.
• Perform project migration to Production system and maintain migration procedures to ensure change control.
• Conduct performance tuning and proactive monitoring of Web Servers, Application Servers, and Process Schedulers.
• Develop and maintain monitoring scripts to monitor systems. Experience with applications like Quest Foglight is desired.
• Configure and maintain database Security of the production ecosystem.
• Document and communicate project activities to the manager on a regular basis.
• Proactive Monitoring of PeopleSoft Production Environment
• Applying PeopleSoft patches, Tax updates and upgrades.
• Coordinate and install product fixes to current releases of PeopleSoft
• Implement database auditing tools to proactively collect database

Oracle Database Administrator

Confidential

Responsibilities:

• Performed Oracle DBA duties in a full life cycle Oracle and systems development project to upgrade and modernize the Department of State, HR platforms.
• Installed, configured and administered oracle 9i, 10g and 11g RAC for PeopleSoft using Grid Control .
• Assisted in executing tasks to upgrade 10g to 11g RAC (3 nodes) on 11g ASM.
• Experience troubleshooting production, development and test databases downtime and administration problems by replicating production database using data pump and UNIX BASH scripts.
• Configure, monitor, and manage RMAN backups for all database instances
• Applied ASM patch to remediate ora-0600 ASM bug not deleting files.
• Capable of evaluating and reporting client Rating, Trading and Reporting database consumption, general use, growth patterns and proficient at researching and recommending alternative solutions that decrease costs
• Deep knowledge on installing, upgrading and patching Oracle systems.
• Monitor all systems and respective databases structures and adjust where required to ensure optimum performance and prevents unneeded financial investments.
• Served as primary DBA liaison interfacing with business users and internal development team for daily issues, negotiating options and solutions.
• Performed periodical Production releases.
• Identify and implement solution that monitors and reports usage, performance metric’s ( CPU high water marks, Memory high water marks, and critical applications usage ) across all critical Back Office systems.
• Performed database migration using ETL technologies such as Informatica

Oracle and peoplesoft Database Administrator

Confidential

Responsibilities:

• Installs the Oracle server and Oracle client software applications using
• Created and managed oracle accounts, roles, privileges and profiles to maintaining database security in accordance with compliance and Assurance policies
• Perform backup and recovery for numerous Oracle 9i, 10G, 11G databases using
• Generated STATSPACK performance and tuning reports.
• Worked with developers to generate Explain Plan for specific SQLs identified in Statspack reports.
• Managed Oracle schemas and space through managing tablespaces, tables.
• Performed daily database administration on production and development environments.
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Ensure daily RMAN and export backups are completed and valid for restore and recovery
• Proactive Monitoring of PeopleSoft Production Environment
• Applying PeopleSoft patches, Tax updates and upgrades.
• Coordinate and install product fixes to current releases of PeopleSoft
• Implement database auditing tools to proactively collect database

Jr. Oracle Database administrator

Confidential

Responsibilities:

• Worked under senior oracle staff and management supervision.
• Followed and executed daily and weekly oracle DBA management tasks.
• Responsible of executing weekend database health check.
• Install Oracle databases for development and testing purposes
• Maintain databases for each environment
• Create database objects for data models and schedules batch jobs
• Resolve daily issues and requests through ticketing systems.
• Manage and monitor DB storage usage by creating tablespaces, adding and resizing datafiles to existing tablespaces.
• Write SQL scripts to create tables, indexes synonyms, views and other objects
• Assisted senior DBAs with data models, development and delivery of technology-based systems for a wide range of applications of different customer groups.
• Installing, configuring, and maintaining all database servers, working with network and system engineers to configure robust and scalable systems for our clients
• Configuring EZConnect and TNSNAMES.ora file to access databases
• Troubleshoot and manage Oracle processes, tune memory allocation and contention and I/O