OBJECTIVE:

• Over 14 years of IT experience, mainly Oracle Database Administration experience including Oracle Enterprise Manager Cloud Control 12c Release 2 12.1.0.2 , 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance Tuning, Backup Recovery, and Database integrity and Security.
• Extensively involved in developing scripts, logical/physical designing of databases in OLTP and Data Warehouse environments.
• Experienced in coding SQL, PL/SQL, and UNIX shell scripting to automate the jobs.
• Expert in using Avamar Data Domain Boost,Export/Import, Data Pump, RMAN, GoldenGate and SQL LOADER
• Experienced in handling multiple tasks, multiple projects and monitoring multiple database and servers.
• Monitor and Tune an Oracle Databases with AWR/STATSPACK Diagnostic Tools.
• Oracle11g Grid Control implementation Configuration.
• Strong work ethics, Oracle DBA skills, team player with excellent communication and interpersonal skills

SKILL SET:

• Hardware: Solaris 8, 10, HP-Unix 11, Win-NT 4.0, Win 2000 Server, Win 2000 Server, Win 2000 Professional, Sun Sparc/Ultra/Enterprise, Linux Red Hat.
• DB Software: Oracle7.3.4.0/8.1.7/9i/10g/11g/12c, Erwin, Data Modeling SQL, PL/SQL, , External tables, SQL LOADER.
• Operating Systems: UNIX Solaris, HP-UX, IBM-AIX , Linux Suse, Redhat, OEL , and MS Windows NT/95/98/2000/2003/XP
• Other Tools And Applications: Jde, Provia, Si, Gis, Webfocus, Vertex, Ifs, Red Prairie, Tms, and Wms, VB5.0, HTML, , PVCS Tracker v7.0, Visual SourceSafe, JDE, Provia, webfocus, GIS and Evavi.

EXPERIENCE

Confidential

Oracle Database Administrator

• Supporting over many databases on 9i, 10g 11g on Linux Solaris environments.
• Support databases for Wahrehouse Management applications, such as Provia, JD Edwards, RedPrairie, Webfocus, GIS, SI, IFS and Evavi environments.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop test database architecture and approve all production schema changes.
• Approve implement all changes to database design/structure.
• Manage movement of complex schema changes into test and production.
• Tune database instances and applications and recommend changes to improve database performance.
• Constantly work with the clients on issues regarding data element changes, including eliminating unwanted data.
• Act as the final link before changes are implemented into production.
• Responsible for the creation of and upkeep of the Database Configuration Management document for application systems.
• Work closely with test and application Development team providing optimal database solutions.
• Maintain backup and recovery procedures.
• Installed and Configured Oracle11.2 RAC on Linux
• Installed and configured Oracle 11 R2 Grid Control for monitoring.
• Also installed and tested Oracle 12c Grid Control still under testing and evaluation.
• Mange RAC databases, instances , ASM and the clusters through SRVCTL and CRSCTL
• Use Automatic Database Diagnostic Monitor ADDM in RAC, Collect Oracle Cluster ware diagnostics.
• Migration of data between different database and oracle versions.
• Provide montly reporting on Capacity Management showing the existing trends od resource usage.
• Handle all the aspects ncluding new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Laison for Security and Compliance team for database audits.
• Provide 24 X 7 support on rotational basis for customers located in Europe, South America, Australia, Middle East, and USA.

Confidential

Oracle Apps Database Administrator

• Duties included Oracle software installation, database design, implementation, management and development.
• Migrated data from Oracle9i to 10g on Solaris 10 HP environments.
• Provided senior DBA-level support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and CR Change Request support for all aspects of maintenance and development.
• Work with production support team to develop test database architecture and approve all production schema changes.
• Coordinated QA meetings for design and implementation of changes to databases.
• Managed movement of complex schema changes into test and production.
• Tuned database instances and applications and recommend changes to improve database performance.
• Assigned and coordinated tasks on production problems to team members/QA.
• Worked with the clients on issues regarding data element changes, especially eliminating unwanted data.
• Implemented data archiving process from production databases.
• Instrumental in providing support to the migration of major portions of data in a data warehouse.

Confidential

Oracle Database Administrator

• Worked on USPS project.
• Duties included Oracle software installation, database design, implementation, management and development.
• Migrated data from Oracle9i to 10g on various platforms.
• Responsible for the creation of and upkeep of the Database Configuration Management document for application systems.
• Activities also included development, test, update, maintenance support of Oracle10g databases across the company.
• Involved in the development and maintenance of large Software systems and databases which were part of the MTMC's Military Traffic Management Command Integrated Booking System.
• Responsible for the creation Management of numerous Oracle9i databases production, development, and test , running on HPUX 11.00 Environment and Windows NT Server.
• Provided senior level Oracle DBA and technical support, including identifying and resolving problems on HP and Windows NT servers.
• Tasks included evaluation of the database, server, installs, adding patches, upgrades, and monitoring, testing and verifying backups.
• Designed and implemented multiple databases. Implemented database auditing and encryption.
• Worked closely with test and application Development team providing optimal database solutions.
• Established backup and recovery procedures.
• Migrated data from Oracle 7.3.4 to 8i, and from 8i to 9i environments.
• Provided support for customers located in Europe, Asia, Middle East and USA.
• Setup database for SOX compliance
• Setup Password verify function to regulate proper password standards.
• Users profiles and resource limit restricting access to databases resources.
• Setup access control to application system tables.
• Setup Logon Triggers for access to special tables.
• Setup auditing on non application users.
• Setup Row-level security.
• Confidential

Oracle Database Administrator

• Provided comprehensive technical and analytical support to the Department of Veterans Affairs VA in 24x7 parallel server environment.
• Administered Development, Test and Production environments on VAX/VMS and Digital Alpha System.
• Administered security create users and responsibilities .
• Performance analysis and tuning on all the databases. Handled database network issues.
• Installed, configured, and upgraded of Oracle 8.0.5 on the Alpha Digital UNIX System.
• Migrated data from Oracle 7.1.6 running on VAX/VMS to Oracle 8.0.5 on Alpha Digital system to Oracle 8.0.5 on Alpha System. Configured Net8.
• Performed weekly online backup of the databases, and daily export backup of constantly used tables.

Confidential

Oracle Database Administrator

• Performed various DBA monitoring and maintenance activities on Sun Solaris 2.5 including, but not limited to, UNIX and database level performance tuning on three existing databases.
• Installed Oracle 7.3.4 and performed data migration from various databases to new systems, as well as managed user accounts and privileges.
• Performed testing of backup and recovery procedures for newly installed databases.
• Provided technical support to the development team, and performed application performance tuning using the TKPROF utility.

Confidential

Junior Oracle Database Administrator

• Participated in the database design and development of a Federal Acquisition Service for Technology FAST Program.
• The FAST Program was a system used by the General Service Administration GSA to provide effective new technologies, to various government agencies. Some of the tables for this system were developed in MS Access 97, and the forms and modules were developed in Visual Basic 5.0 in Windows 95/NT environment.
• Other responsibilities included providing technical support to the development team with an emphasis in creating data base objects and carried out performance tuning on HP-UX 9000.