SUMMARY:

• 15+ years of experience in as Oracle Database Administrator and knowledge in Performance Tuning, Data Integration, Development, and Documentation at various levels.
• Performed Oracle 8i/9i/10g/11g software and database installation and upgraded various versions.
• Experience in administering, tuning and monitoring database using Toad, OEM, and command line methods
• Designed strategies for performing database backups and recovery
• 5 years of experience supporting databases in compliance with Sarbanes/Oxley
• Development and debugging with procedures, Function, Triggers, Packages and other PL/SQL objects
• Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask
• 24x7 on - call Production support for database activities.

TECHNICAL SKILLS:

Databases: Oracle 8/9/10/11/12 (RAC/ASM), MS-SQL, Access, MySQL, Lotus Notes.

Oracle Applications: Oracle Fusion Middleware, Oracle HTTP Server, Application Express

Security: Oracle Advanced Security, Encryption, Wallet, PKI, Oracle Connection Manager, Oracle Secure Backup

High Availability: Real Application Clusters (RAC), Data Guard, IBM HACMP, Advanced Replication.

Networking: SSH Tunneling, IPTables Firewall

ERPs and Other Applications: Peoplesoft, SAP R3 & BW, Oracle Apps (BI), Apache.

Operating Systems: Solaris, AIX, Red Hat Linux, Oracle Enterprise Linux, Windows Server.

Programming Languages: PL/SQL, XML, HTML, UNIX Shell Scripting.

Database Tools: Toad, OEM, DBA Studio.

Data Modeling Tools: Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Aberdeen Proving Grounds, MD

Oracle Database Administrator

Responsibilities:

• Oracle Database Administration
• Installation, configuration, and management of Data Guard Environment in support of Army Contracting Command (ACC)
• Set up of Oracle Virtual Machines related to ACC project

Environment: Oracle 11g, Oracle Advanced Security (Encryption), Oracle Data Guard, Solaris 11

Confidential, Columbia, MD

Software Engineer

Responsibilities:

• Implemented Oracle Cloud Control and rolled out agents to 11.1 and 11.2 instances.
• Apply various patches and CPUs to database and operating system patches via RHN.
• Maintain production database (space management, user creation, privileges, roles etc.).
• Implement Data Guard for High Availability and Disaster Recovery.
• Manage hot backups using a combination of incremental, differential and full RMAN backups.
• Trace and resolve database performance issues.
• Tune SQL queries and debugging of Oracle PL/SQL packages, stored procedures and functions.
• Detect and resolve issues related to corruption.
• Performed upgrades from Oracle 11.2 to Oracle 12.1
• Installed Application Express 4.2 and set up listeners using mod plsql on Oracle HTTP Server 12
• On call support 24x7.

Environment: Oracle 11g, Oracle Cloud Control 12c, Oracle Advanced Security (Encryption), Oracle Connection Manager, Red Hat Linux, Windows Server.

Confidential, Baltimore, MD

Senior Oracle Database Administrator

Responsibilities:

• Maintain and support BPD RMS database containing over 2 terabytes of sensitive data.
• Manage Linux Operating System on 3 Node Oracle RAC Cluster and 2 Node Middleware environment
• Apply various patches and CPUs to database and operating system.
• Maintain production database (space management, user creation, privileges, roles etc.)
• Monitor, manage, and tune Oracle Real Application Clusters (RAC) environment with ASM.
• Manage hot backups using a combination of incremental, differential and full RMAN backups.
• Trace and resolve database performance issues.
• Integrate Oracle Data with Lotus Notes, MS-SQL, and other external systems.
• Oracle Middleware (Oracle Forms and Reports) Support.
• On call support 24x7.

Environment: Oracle 11g (RAC/ASM), Oracle OEM 11g, Oracle Fusion Middleware 11g, SQL Server, Oracle Enterprise Linux 6, Windows Server.

Confidential, Towson, MD

Senior Technical Analyst (Database Administrator)

Responsibilities:

• Managed more than 40 instances from sandbox to production.
• Installed 10g/11g databases.
• Upgraded 9i/10g/11g and applied various patches and CPUs.
• Installed and Configured Oracle Enterprise Manager 11.
• Cloned databases for test and development via RMAN, Data Pump, Commvault Commcell Console, and manual methods
• Implemented SAP data dictionary changes including new tables and indexes as well as object updates
• Managed database security and change control policies in compliance with Sarbanes-Oxley
• Maintained production and development databases (space management, user creation, privileges, roles etc.)
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Maintaining archive data on appropriate storage devices.
• Traced and resolved database performance issues.
• Migrated data from remote locations due to data center consolidations
• Tuned SQL queries and debugged Oracle PL/SQL packages, stored procedures and functions.
• Detected and resolved issues related to corruption.
• Provided secondary support for MS-SQL databases
• Implemented Oracle Index Key Compression to improve space usage and performance in certain tables
• On call support 24x7.

Environment: Oracle Server 9i/10g/11g, AIX, Windows Server, SAP, Peoplesoft, Manugistics, Oracle BI, Cognos.

Confidential, Baltimore, MD

Database Engineer

Responsibilities:

• Installed 9i/10g databases.
• Upgraded oracle 9i /10g and applied various patches and CPUs.
• Created standby databases.
• Maintained production and development databases (space management, user creation, privileges, roles etc.)
• Cloned databases for test and development via RMAN, Data Pump, and manual methods
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Traced and resolved database performance issues.
• Tuned SQL queries and debugged Oracle PL/SQL packages, stored procedures and functions.
• On call support 24x7.

Environment: Oracle Server 8i/ 9i/10g, Solaris, Peoplesoft

Confidential, Towson, MD

Oracle Database Administrator

Responsibilities:

• Installed 8i/9i databases.
• Upgraded oracle 8i/9i and applied various patches and CPUs.
• Designed and implement the Disaster Recovery solution.
• Used Oracle Dataguard for creating the standby database.
• Automated the process of oracle backup.
• Maintained production and development databases (space management, user creation, privileges, roles etc.).
• Cloned databases for test and development via RMAN, Data Pump, and manual methods.
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Traced and resolved database performance issues.
• Tuned SQL queries and debugged Oracle PL/SQL packages, stored procedures and functions.
• On call support 24x7.

Environment: Oracle 8i/ 9i, Solaris, Windows NT, Toad, Peoplesoft, Blackboard, Maximo.

Confidential, Towson, MD

Senior Technical Associate

Responsibilities:

• Applied various patches and security updates.
• Designed database for Graduate School Admissions Application using Erwin.
• Maintained database (tablespace management, user creation, privileges, roles etc.).
• Automated tape hot backups using a combination of incremental, differential and full RMAN backups.
• Database performance and tuning issues.
• Administered Graduate School’s IIS2 web server and Windows NT File Server.
• Developed MS Access database applications with forms and reports.
• Provided general application and hardware support to Graduate School staff.

Environment: Oracle 8i, Windows NT, Erwin, IIS, MS Office Suite

Confidential, Aberdeen Proving Ground

Program Manager

Responsibilities:

• Designed and prepared helpdesk statistical reports.
• Hired employees, gave performance reviews, managed timesheets and other human resources duties.
• Established helpdesk standards and policies and provided to helpdesk staff.
• Served on Year 2000 compatibility committee and assisted hardware and software testing and applying necessary patches.

Confidential, Aberdeen Proving Ground, MD

Lead Microcomputer Specialist

Responsibilities:

• Configured microcomputers for direct and remote network access via TCP/IP protocol on an Ethernet network at the US Army’s Aberdeen Proving Ground Edgewood Area.
• Assessed and resolved network connectivity issues of both PCs and printers to determine the source of the problem and implemented solutions.
• Installed and supported Windows and Windows NT-based software applications.
• Installed, configured and tested compatibility of modems, sound cards, CD ROMS, network cards, scanners, and hard drives in PCs and notebooks in Windows 9X and Windows NT-based PCs .

Confidential, Baltimore, MD

Microcomputer Specialist

Responsibilities:

• Microcomputer support which included loading of Windows operating system and assorted software packages, installation of all hardware, connection via LAN or dialup, and general troubleshooting.
• Helpdesk support for software applications, UNIX, and VMS.