SUMMARY

• Strong technical and leadership skills including working as an instructor in areas top universities including Georgetown Univ. DC, George Washington Univ, DC and Virginia Tech., VA. (Teaching Oracle 111G DBA/Application Development) and assisting students in obtaining Oracle certification.
• Ability to work and manage projects independently, wif a proven ability to meet and exceed set goals and deadlines.
• Work TEMPeffectively wif colleagues and clients Confidential all levels.
• Expert PeopleSoft and Oracle Apps DBA.
• Detail oriented multi - faceted skill set, wif exemplary organization and project management skills.
• Strategic thinker and planner, skilled in teh design and execution of TEMPeffective IT solutions.
• Strong skills in business process analysis, relationship development and strategic alliances building.
• Supported Mercury Quality Center, PVCS, Arriba, See beyond, STAT, Team Track and PeopleSoft application.
• Working experience of Microsoft SQL Server clustering, replication & mirroring.
• Expert in RAC (Real Application Clustering) and expert in RMAN (Oracle recovery Manager)

TECHNICAL SKILLS

Products: PIA, BEA Tuxedo, Application Servers,Confidential WebSphere5.2, Web Logic 8.1, Quest STAT

RDBMS / DBMS: Oracle 11g/10g/9i/8i/8/7.x, DB2, SQL Server

Component Interface: SQR, Business Object.

Oracle Tools: OEM, RAC, RMAN, Erwin, Export/Import, SQL*Loader, Data pump.

Languages: C/C++, JAVA, Java Script, XML, JDBC, Java, J2EE, JMS, CORBA, SOAP, ASP,VB Script, JavaScript, JBoss

Application Server: Oracle Application Server, Oracle 9i AS

Operating Systems: Linux, Sun Solaris, HP UX, AIX, and Windows 2003/XP/NT

Hardware: Sun, AIX, Digital Alpha server 1200, Compaq Server, Pentium

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior Oracle DBA

Responsibilities:

• Successfully Designed, Implemented, and Administering Oracle 12c/11g R2 RAC on Oracle/Linux. Installed Oracle 11g data guard between two data centers for Disaster recovery plan.
• Hands on experience working wif Oracle 12c multitenant Container Databases (CDB) and Pluggable Databases (PDB)-unplug a PDB from a CDB and plug it back into another CDB. Working as lead Oracle DBA in OLTP/DSS environment, Oracle Fusion middleware.
• Backup and restore using RMAN, Data pump, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environments. Created RMAN cronjobs for backup. Expert in DSS (Data warehouse) and OLTP systems. Experience using Oracle Warehouse Builder (OWB) to build, manage and maintain data integration processes. Involved in full/incremental data load. Used Oracle Streams for table level replication.
• Working closely wif Customers, functional and Development team. Resolving day to day issues in Development/Production environment. Acting as a mentor for teh oracle Developers. Involved in iterative/incremental Agile software development. Time Boxed iterative approach for adaptive planning, evolutionary development and delivery. Running jobs through Autosys. Working on Terabyte databases.
• Applied Oracle Security Vulnerability/SQL injection patches, CPU & PSU patches. Lead teh Migration activities - AIX to Linux Platform (HIGLAS) project.Designed architect layout of all servers. Changing Oracle Database character set using CSSCAN/CSALTER. Worked as Change management Admin.
• Configured and Installed Oracle 11g Grid Control (Cloud Control) day to day administration, maintenance and Performance tuning. Involved in real-time data integration using Golden gate. Involved in Golden Gate installation, configuration, replication, tuning, maintenance, patching, and problem diagnosis and resolution.
• Extensively used Oracle AWR, ASH, RDA, SQLT, RAT, ADDM, SQL Optimizer and explain plan. Performance tuned all cost intensive processes. Worked wif Data Vault/ encryption. Lead DBA for Oracle Discoverer.
• Worked as lead DBA to implement/maintain Oracle Spatial to store and retrieve geographical/location information. Creating materialized views and partitioning large tables (using Range-Hash, Range-List, Range-Range, List-Range, List-Hash) for performance improvement. Closely working wif development team.
• Supporting Teradata/Exadata prod/non-prod databases including correcting issues, supporting routine/ad-hoc change requests, creating documentation, implementing and monitoring daily/nightly maintenance jobs, and monitoring/diagnosing/responding to system failures. Improve system performance, including reducing system downtime.
• Hands on experience working as an Oracle APPS DBA on EBS R12.2.4- Installation, cloning, patching.

Environment: Oracle 12c/11G, AIX, Linux, Sun Solaris, Windows NT server, Toad, SQLPLUS, Data Guard, RMAN

Confidential

Senior Oracle DBA

Responsibilities:

• Design, test, document & implement teh RMAN backup and recovery strategy for all teh databases and develop scripts for seamless integration wif automated backup. Implementing Oracle Internet Directory (OID) and migrating from onames to oid.
• Implemented strategy for partitioning, compression and management of historical data tables. Experienced in Oracle Portal for building, deploying, and managing enterprise portals. Implemented new Oracle Security features.
• Monitor system resources and estimate teh hardware/software resources needed to run Oracle DB.
• Worked wif new features of Data pump to improve data import performance. Work closely wif developers to design databases objects, tune SQL/PLSQL statements, and resolve data migration/import issues. Expert in PL/SQL subprograms (Procedures/Function/Packages/Triggers).
• Expert in data migration, data load. Worked on TERA database migrations. Expert Using Data Integrator to extract data, creating staging database and using Extract/Transform/Load to populate teh Target Database. Used Oracle Data Migration Assistant for migration data across databases. Managed Exadata databases. Involved in migrating, Patching, Upgrade and monitoring Exadata databases.
• Database re-org carried out Confidential regular intervals in order to optimize space and avoid tablespace fragmentation these includes tablespace design and management, modifying object sizes etc.
• Installing Web logic (Fusion Middleware/SOA) and working as a support Web logic Admin. Involved in single sign-on integration between Oracle and ERP applications (PeopleSoft, SAP). Experience in Oracle Rapid - installing file system, database files, multi-node system, load balancing and shared APPL TOP.
• System performance tuning which includes constant monitoring of teh database through dynamic system, tables, oracle parameters and UNIX shell scripts. Auditing teh database, tables, users, and sessions through audit utility of Oracle.
• Automate database administrative process including job scheduling, logs, events & alerts. Proactively monitor, diagnose, and rectify database related problems.
• Install, configure, maintain SQL server Databases. Involved in backup and database clone.
• Installed, configured and maintain Oracle Grid Controller 12c to assist wif WebLogic changes, WebLogic server cloning and server backups.
• Expert Oracle Apps DBA-Installed/Configured Oracle HTTP Server Oracle Application Server Containers for J2EE /Oracle Application Server Web Cache/Oracle Application Server Forms Services/Oracle Application Server Reports Services/Oracle Business Intelligence (OBIEE).

Environment: Oracle 11G/10G, Linux, Sun Solaris 10, AIX, SQLPLUS, Toad, Oracle Apps, Oracle Rapid.

Confidential -Virginia

Senior Oracle DBA

Responsibilities:

• Senior Oracle administrator, involved in 24/7 day-to-day administration. Responsibilities include monitoring oracle RAC databases, ASM, RMAN and Data Guard.
• Involved in database migration across data centers.Building oracle database servers across data centers and testing failover.Involed in Oracle database and environnent setup, Installation, design, Testing, Capacity Planning, Space Management and administration.
• Performed logical/physical database backups using various methods, including exports, data pump, cold backups, hot backups, and Oracle Recovery Manager backups. Involved in oracle partitioning and creating materialized views.Used SQL*LOADER for loader data.
• Involved in performance tuning, Load balancing, improving data load, optimizing queries.Used AWR, ADDM, SQL Optimizer tools for performance improvment.
• Involved in database security.Creating roles for diffèrent user groups
• Conducted installation, configuration & administration of an Oracle 10g RAC wif ASM as shared storage and SAN as shared storage sub-system.
• Expert in oracle RAC databases (ASM, Oracle Clusterware). Perform RAC database upgrade and patch (All-Node Patch wif minimum downtime). Responsible for adding/deleting nodes to/from existing RAC setup.
• Tuned long running queries & queries having high CPU. Involved in monitoring and performance of batch jobs. Resolving alert log errors.
• Re-organized heavy transaction tables and temp tables in separate tablespaces as part of database re-org to improve performance wif uniform extent size and NOLOGGING for temp tables.
• Automated Refresh of non-production databases from production environment.
• Experienced in teh development and implementation of sql/unix scripting. Expertise in SQL tuning including PlSql programming, stored packages/procedures/functions.
• Logical and physical database/data modeling using tools designer. Apply database patches (this includes periodic CPU patches and specific problem related)
• Setting up databases for new applications in Development, QA and Production. 24*7 on call DBA blackberry pager support. Setting up jobs through Autosys.
• Creation and maintenance schema objects (Users, Tablespaces, Tables, Constraints, Synonyms, Sequences, Roles, Privileges and Triggers). Implementation and Scheduling of scripts for purging teh old data from tables.
• Tuning PlSql packages, procedures and functions (used for teh batch jobs). Implementing DATPUMP scripts to export teh data across environments.
• Used Oracle Enterprise Manager (OEM) wif Oracle WebLogic Server Management pack to diagnosis issues wifin Oracle Fusion Middleware server components.
• Physical and logical designing of database wif teh distribution of data-files on different disks. Created and Maintained environmental documentation by updating documentation, in a timely fashion, to reflect infrastructure changes, tuning procedures, other techniques.
• Responsible for teh maintenance of installation of Oracle Identity Manager 11g create and maintain users, groups and roles.
• Expert PeopleSoft DBA - Configuring Web logic/Appserver/Process Scheduler. Tuning SQR/People code/App Engine. PeopleSoft HR/Financial - Tools 8.5, Application 9.1

Environment: Oracle 11G/10G, AIX, Linux, Sun Solaris, Windows NT server, Designer, DBArtisan, Toad, Rapid SQL

Confidential, Washington DC

Senior Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 11G.Data Migration using SQL Loader.
• Developed Database packages, procedures, functions, and database triggers.
• Involved in Oracle database level performance tuning and backup and recovery using RMAN. Extensively used Oracle AWR, ADDM, SQL Optimizer, Explain plan for over all Database performance analyzing tables, using explain plan, adding optimizer hints, TKPROF and SQLPLUS Auto trace. Developed PL/SQL stored procedures and triggers.
• Expert Oracle RAC (Real Application Clustering).Setting up Oracle Data Guard.
• Responsible for CRS installation and RAC database creation, adding/deleting nodes to/from existing RAC setup, backing up restoring and multiplexing of Voting Disk and OCR files, monitoring RAC specific wait events.
• Installation of Oracle on unix and Windows platforms. Created and configured teh Instance, Tablespaces/datafiles, RBS, Schemas, Users and Roles for Development & Test database.
• Coded conversion packages using PL/SQL stored procedures, functions and views to convert teh data. SQL tuning including PlSql programming, stored packages/procedures/functions.
• Performance Tuning, Backups and Recovery wif RMAN, RAC, Security Management, Database Administration and Monitoring.
• Expert Confidential teh installation, creation, up-gradation, configuration, administration, and tuning of multiple databases wifin mission-critical, 24x7 production environments.
• Setting up databases for new applications in Development, QA and Production. Setting up traditional cron jobs for tablespace monitoring/ alerts/ exports/ hot backup and archives.
• Helped development team in Forms/Reports errors.
• Involved in database upgrade. Worked as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular working hours. Involved in database refresh, backup, restore and recovery.

Environment: Oracle, AIX, Linux, Windows 2003 server, Forms/Reports, SQL*PLUS, TOAD.

Confidential - Virginia

Senior Oracle DBA

Responsibilities:

• Worked as lead Oracle DBA managing multiple production/test databases.Spécialise in Oracle, Advanced PL/SQL queries, DBMS, RAC installation, Data Guard databases for multiple applications, performance tuning.
• Involved in database installation, configuration, creation, tuning, maintenance and user management.
• Sr. IT Specialist and responsible for supporting multiple clients for production support of Oracle databases including 3rd party software’s.
• Involved in supporting production/test/development databases. Responsible for refreshing of teh development databases from production database.
• Implemented Data Guard, maintain primary and standby database.
• Responsible for database backups and recovery as and when required including testing disaster recovery using RMAN.
• Tuned long running queries & queries having high CPU. Involved in 24/7 monitoring and performance of batch jobs.
• Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups. Involved in oracle partitioning and creating materialized views.
• Expert in PL/SQL packages, stored procedures functions and triggers.
• Involved in Oracle 10g database level performance tuning and backup and recovery using RMAN. Extensively used Oracle 10g AWR, ADDM, SQL Optimizer, Explain plan for over all Database performance.
• Developed and proposed new backup strategies in accordance wif customer needs. Apply Oracle database releases and patches.
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning teh performance.
• Worked on creating troubleshooting documents for production support as reference document for other members of teh team.
• Developed and automated UNIX shell scripts to backup both logical and physical backups to tape using teh OS backup.
• Implemented materialized views in Oracle Teradata database. Worked as lead DBA in DSS systems.
• Automated Refresh of non-production databases and PeopleSoft file system from production environment.
• Creating new databases for new application upgrades or for new application testing.
• Writing SQL &, Shell Scripts to automate batch jobs and performance monitoring.
• Worked as a team member in implementing and Configuring Oracle Real Application clustering (RAC).
• Resolve network issues for oracle databases, tnsnames.ora, sqlnet.ora, listener.ora
• Worked extensively wif PVCS - change management tool.
• Oracle 11G instructor Confidential George Town University.

Environment: Oracle 10/11G, HP UNIX, Linux, Sun, PL/SQL, SQL*Plus, Windows XP, NT, ERP (PeopleSoft), Oracle Reports.

Confidential -Washington DC

Oracle DBA

Responsibilities:

• Upgrade oracle database, expert in database tuning/space management.Upgraded databases from 9i to 10g.
• Expert in data conversion and performance management.
• Managing Database Structure, Storage Allocation, Building objects Table/Index segments, Views, Constraints, Database Access, Security Roles and Privilèges.
• Tuning and running simultaneous data conversion.
• Expert in PL/SQL packages, stored procedures functions and triggers.
• Involved in Oracle Database refresh/clone, database creation, rman configuration, Data Guard configuration.
• Wrote PERL scripts to run jobs through teh Crontab.Developed shell scripts to execute and automate to run SQL loader & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs
• Applied required oracle patches and fixes. Maintenance of Oracle Databases, Capacity planning.
• Configure production and QA databases wif new performance monitor database.
• Involved in Configuring and maintaining Oracle Real Application clusterning (RAC).
• Used RMAN for oracle backup recovery/recovery and database clone.
• Worked extensively wif internal and external auditors to get Sarbanes Oxley certification.
• Worked wif Ascential ETL mappings in reference to creation of ODS and correcting errors for FSCM destructive/incrémental loads.
• Perform Export and Import of User, Tables, Schemas and Database. Monitoring data files, archive log files space issues.
• Meet wif teh customers to define requirements.Constant monitoring of database space and space management.
• Create Partitions by range, list and Maintained Partitions, Rebuild Indexes, Coalesce tablespaces.
• Create new oracle release demo, dev and QA databases. Also refresh of non-production oracle databases from production database.
• Installation, configuration, managing Quest STAT for version and change management tool for PeopleSoft/Oracle applications.
• Provide necessary training to new team members and troubleshoot issues for developers.

Environment: Oracle 9i/10G, Sun Solaris, PL/SQL, SQL*Plus, Windows 2000, ERP (Peoplesoft), Oracle Reports, Oracle Enterprise Manager Grid control.

Confidential

Oracle DBA

Responsibilities:

• Worked as technical Lead for oracle database upgrade, database tuning, space management.
• Performe performance tuning Confidential database/memory/SQL level.
• Oracle 10g database performance tuning and backup and recovery using RMAN in RAC environnements.
• Create Development, QA, UAT Databases for IMF Implementation.
• Device Project Plan and Execute a Data Migration projects for migrating data from application PeopleSoft7 onto PeopleSoft8 HRMS.
• Intégration of Development, QA efforts and Implementation into production.
• Monitor performance and tune where appropriate using Statspack, OEM, UTLBSTAT/UTLESTAT, TKPROF, SQL Trace and teh Plan table
• Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups.
• Performed database refresh from global database to local development databases.
• Responsible for applying patches to teh Oracle environnements.

Environment: Oracle 8i/9i, HP UNIX, PL/SQL, SQL*Plus, Windows XP, NT, ERP.

Confidential, Virginia

Oracle DBA

Responsibilities:

• Served as Oracle administrator on HP-UX and AIX wif responsibility for installing, configuring, tuning, and maintaining entire 3-tier environment.
• Created and implemented detailed systems document wif all teh directory structures of their PeopleSoft Internet Architecture.
• Used SQL*LOADER to load teh data into teh tables.
• Monitoring of hot backups, exports on both UNIX and Windows
• Performed backup and recovery for both hot and cold backups wif/wifout using RMAN
• Performed database tuning which included changing teh entire SGA, increasing number of rollback segments, restructuring location of data files, changing size and location of redo log files and setting up archive logging to improve database performance.
• Responsible for Installation, Configuration and Support of teh Application servers
• Provided 24/7 support for teh Oracle production databases.

Environment: Oracle 8/9i, HP UNIX, PL/SQL, SQL*Plus, Windows NT, Peoplesoft.

Confidential

Oracle DBA

Responsibilities:

• Involved in design, development, enhancement and maintenance of multiple Oracle databases.
• Interfaces and Conversions, Migrations and Reporting.
• Analysis, Coding, Writing Specifications and Interacting wif Users for Application Implementation, Upgrade, Customizations and Enhancements.
• Develop new scripts to suit teh user requirements and needs.
• Created Queries reports as requested by department managers.
• Migration of different applications from development database to test database and tan to production database.
• Making teh process automated for taking nightly Backups of all teh development and test databases.
• Responsible for refreshing of teh development databases from production database and to mask teh data.
• Made kernel configuration recommendations and assisted in teh tuning of teh HP kernel, which resulted in a dramatic improvement in system, performance and teh ability to handle increased user activity.
• Administered Oracle Inventory Management & Financial Application databases.
• Implemented Oracle Enterprise Manager on 3-tier scale; setup jobs/events and agent configuration.
• Worked in custom scripts and Custom Queries.
• Developed vendor interfaces, customized applications by creating new records/views and granting security.
• Design and develop new day-to-day backup/recovery techniques.
• Setup new users and grant/revoke privileges to restrict and enable user access.
• Designed and Configured teh Symmetric Replication as a pilot project for teh Inventory Confidential 4 of teh warehouses, wif 1 central Master definition site & 4 other Master definitions sites wif 8 tables under teh replicated environment for teh online-transaction replication. This is performed for Oracle 8 on Windows NT platform.
• Handled tasks like space management, User & Resource management, backup monitoring, and Recovery management.
• Reorganized teh existing databases for better performance.
• Ported Data to Oracle Databases from/to oracle as well as non-oracle databases using SQL Loader.
• Configured Standby databases for teh most critical production database.

Environment: Oracle 6, Sun Solaris, PL/SQL, SQL*Plus, Windows