SUMMARY:

• More than 10 years’ experience in Information Technology with emphasis as an Oracle Core DBA and Applications DBA.
• Perform database design, implementation and maintenance of database security (create and maintain users and roles, assign privileges).
• Perform Oracle and software patch management and version control.
• Perform database and application tuning and performance monitoring with tools such as Toad, Grid Control and Panorama.
• Restore, recover and clone databases using RMAN.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC/ ASM
• Add or Remove Node from RAC.
• Tune existing PL/SQL code to enhance application performance with increasing data.
• Wrote PL/SQL code to interface with Java classes for web - enabled applications with CMMI level III compliance.
• Experience in installing single node as well as multi-node 11i and R12 E-Business Suite.
• Experienced in EL-T and ETL tools like INFORMATICA and ODI
• Experienced in Oracle Databases Versions (11gR2, 10g, 9i), Oracle Apps Database Administration (R12.1.3, 11.5.10.2, 11.5.10, 11.5.9), Weblogic Administration (10.3.6)
• ORACLE GOLDENGATE v11v 12
• EXADATA and EXALOGIC certifications.
• Managed a SUN SOLARIS for the development environment.
• US Citizen with Current Public Trust Clearance.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Solaris, Red Hat Linux ES 5.4, AIX, Windows 95, NT 3.52, 4.0, 2000; HP-UX 10.20, 11.20 Sun SPARC 2.5.1

PROGRAMMING LANGUAGES: SQL, SQL*PLUS 3.3, PL/SQL, BASIC, Java Servlets, Server-side Java RMI, JAVA 1.2.2, C/C++, JavaBeans, EJB, JDBC, JNDI, ASP, ColdFusion

TOOLS: /UTILITIES: Oracle Forms 6.0, Report Writer 3.0, Designer 2.11, SQL*net 2.1, OEM 2.0, SQL*loader, ProC, SQL*DBA, DBA Studio, Reflection X, Server Manager, SAM, GPM, Java Caf, Visual C, Oracle (7, 8, 8.1.7,8i, 9i.10g, 11g), Oracle 10G RAC, Oracle Grid, PeopleSoft, SAP R/3; SAP BW, Visual Source Safe, Informatica, Linux ES 4.0, Oracle Security Vault, Oracle ASM, OLS Labels

PROFESSIONAL EXPERIENCE:

Confidential, McClean, Virginia

Responsibilities:

• Analyzed infrastructure and proposed a new layout for a Database Systems.
• Installed ORACLE 11GR2 on several RAC clusters.
• Installed and configured RAC on AWS systems for performance testing.
• Installed and configured several RAC clusters on virtual environments.
• Worked with AWS DevOps Team to fine tune performance of the systems.
• Installed Golden Gate on ORACLE 11GR2 and on 12C to address parallel replicates groups with three REPLICAT. Upgraded GG v11 to V12
• Installed RMAN repository for NetBackup.
• Performed several installations in ATT virtual environments.
• Oversaw ETL processes that perform daily loads into the databases interfaces with BO and CDC.
• Wrote shell scripts to monitor the database and monitor Golden Gate processes.
• Provide off hours support and maintenance as required, part of the 24x7 operations support on call.
• Set up and implemented backup and Revocery strategy using RMAN and Veritas software.
• Oracle installations, upgrades, and installing patches.
• Restored Clusters from GRID and ORACLE crashes or Node evictions.
• Installed and configured Oracle 12C.
• Supervised and mentored Junior DBAs.
• Reported infrastructure changes, improvements to Government TAR.
• Member of the ARB ( Architecture Review Board)

Confidential, McClean, VA

Oracle Core DBA

Responsibilities:

• General DBA duties.
• Created, implemented a Backup Strategy for all DB in Win and LINUX environments.
• Created Standby databases on LINUX environment using DATAGUARD.
• Created ORACLE DR Systems on Windows using ORACLE FAIL SAFE.
• Cloned databases and Application servers as needed.
• Installed and upgraded WebLogic 11G in Unix environment for deployment of applications.
• Created Shell scripts in Win and LINUX to dynamically created databases with a uniform structure across the environments.
• Manage the process to promote database objects to production
• Develop database procedures, functions and triggers
• Assist developers with database activities and Tune database queries as needed.
• Monitor application related jobs and data replication activities
• Performed Oracle documentation of Processes, Policies and Procedures.
• Trained Junior DBAs on task and set repetitive task in Cron.

Confidential, McClean VA

Oracle Core DBA

Responsibilities:

• Managed day to day DBA activities for more than 100 databases.
• Installed Oracle 10g and 11gr2. Migrated 9i and 10g databases to 11g.
• Managed day to day MDM activities for the FDA projects.
• Installed and managed WebLogic, TOMCAT on LINUX.
• Managed logical and Physical database models using ERWIN for existing and new database installations.
• Managed day to day DBA activities for more than 100 databases.
• Installed Oracle 10g and 11gr2. Migrated 9i and 10g databases to 11g.
• Managed day to day MDM activities for the FDA projects.
• Installed and managed WebLogic, TOMCAT on LINUX.
• Managed logical and Physical database models using ERWIN for existing and new database installations.
• Installed and Set ORACLE ASM in RAC environments .
• 24x7 on-call support on production systems.
• Performing the jobs of System Administration for Oracle Application.
• Creation and maintenance of menus, Users, Responsibilities etc.
• Creation and maintenance of Customize Applications.
• Administration and maintenance of Concurrent managers.
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Registration of Forms, Reports, Concurrent Programs.
• Supporting development teams, general troubleshooting & support in administration of Product & Test instances.
• Monitoring Concurrent managers and its operations like starting and stopping the concurrent managers, troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Monitoring tablespaces for space usage and adding required space whenever it reaches threshold.
• Installing products like APACHE TOMCAT.
• Convert normal databases to Container enabled database in 12C.
• Installed,Configured and implemented Golden Gate on Oracle11G and MSServer. In a peer-to-peer and one-to-many configuration.

Oracle/SQL DBA Database Administrator

• Install Oracle 10g and 11gr2. Migrated 9i and 10g databases to 11g. Migrate databases from SUN Solaris to Linux.
• Work on Database design, implementation and maintenance of database security (create and maintain users and roles, assign privileges).
• Install and configure RAC.
• Perform Oracle and software patch management and version control.
• Analyze systems for Data Guard recommendations.
• Analyze systems for Migration from SQLSRV and Sysbase to Oracle databases.
• Plan database migration to Exadata.
• Implementation of OLS (Oracle Label Security, Data Masking, DataVault).
• Work very closely with developers to build better scripts and stored procedures that improve performance.

Confidential, Lanham, MD

Lead Oracle Database Administrator

• Member of Architecture Review Board (ARB) and Planning and Testing group (PAT).
• Reviewed technical requirements for setting up a PBOCS system for the US Census 2010.
• Worked in close collaboration with data architect to produce and maintain ER diagrams for the PBOCS system.
• Restored and recovered and cloned databases using RMAN. Implemented a backup and recovery strategy.
• Worked on database design, implementation and maintenance of database security (created and maintained users and roles, assigned privileges).
• Recommended and implemented the topology for a 4T database system including a 10g SOA middle-tier.
• Installing and configuring of Oracle E-business Suite 11.5.9, 11.5.10, 11.5.10.2, R12.1.2, Oracle Fusion Middleware Products of Weblogic 11g, and SOA 11g Cluster, and Fusion Applications.
• 24x7 on-call support on production systems outages and with client interaction.
• Cloning of Oracle Apps, Peoplesoft, Agile Production environments to QA, DEV, and Test environments using NetApp Filers, Delphix, and RMAN.
• Expertise in Schema and Object refreshes using Oracle Datapump
• Created and configured over 50 databases to run on 8-node Oracle RAC/Linux on GFS file system.
• Maintained batch jobs for nightly feeds into the databases.
• Created and configured down streams as a method of replication between databases.
• Troubleshot and resolved varied database issues.
• Created and monitored materialized views.
• Performed rolling upgrades to Oracle software from 10.2.0.1 to 10.2.0.4.
• Performed database and application tuning and performance monitoring with tools such as Toad, Grid Control and Panorama.
• Implemented Oracle Data Guard.

Confidential, Lanham, MD

Lead Oracle Database Administrator

• Monitored performance with tools like Oracle Statpak, Tkproof, Xplan, AWR, ADDM, 10 GRID Control etc.
• Planned and executed Oracle backups and cloning for Development, Test Validation and Production environments. Maintained ER diagrams for consistency and integrity.
• Installed and upgraded Oracle 10g on Unix RAC (4 nodes and 2 nodes) and Windows platforms. Used Oracle 10g ASM to manage storage.
• Installed a 3 tier RAC on Linux. Configured RAC for logical and physical standby databases. Configured and managed Oracle Data Guard.
• Added two more nodes and additional services to an existing RAC cluster for scalability.
• Used Informatica v8.1 and SQL*Loader to Extract Transform and Load (ETL) from flat files.
• Managed OLTP, OLAP Oracle Databases. Created services for DW.
• Performed capacity evaluations and planned system backup and recovery strategy and maintenance.
• Built database objects and generated object DDL form Erwin.
• Tuned existing PL/SQL code to enhance application performance
• Wrote PL/SQL code to interface with Java classes for web-enabled applications with CMMI Level 3 compliance.
• Developed PL/SQL packages, procedures, and functions.
• Performed 24X7 on-call rotations with a team of 4 DBAs.
• Prepared documentation for all processes to meet government standards.
• Installed and evaluated Oracle 11g for 10gr2 upgrade, reported findings to management.
• Upgraded Oracle 10gr2 to Oracle 9i to 11g in Development environment.

Confidential, Lanham, MD

Senior Database Administrator

• Installed and upgraded databases Oracle 8i, 9i, 10g on Sun, Tru64 and AIX 5L, Linux ES 4.0.
• Supported PeopleSoft and SAP in Test, Development and Production environments.
• Responsible for database integrity of production databases.
• Provided on-call support 24X7 call rotation regarding production databases.
• Upgraded Oracle Grid Control, OMS and Agent and all other Cluster RAC Databases Management Agents for easy uploads.
• Installed Oracle Management plug-ins to monitor the storage usage, object status for daily job.
• Provided performance tuning, ran ADDM, Snapshots/AWR and I/O tuning SGA/PGA tuning via OEM for 10g RAC.
• Performed SQL Tuning using Explain Plan, Tkprof with SQL trace, SQL Tuning Advisor, segment advisor, memory advisor and SQL access advisor.
• Wrote new and tuned existing PL/SQL procedures, functions and triggers.
• Performed all duties with an emphasis on achieving maximum stability and security, while maintaining performance and customer satisfaction.
• Installed and configure oracle 10g RAC database 10.2.0.3 on windows servers with cluster failover 4 nodes.
• Loaded data using Oracle Export/Import to migrate and refresh data across Production, Test, Development environments.
• Successfully designed and implemented Oracle database hot and cold backup strategy to backup all production databases with other environment to Legato tape library.
• Setup backup and recovery procedures for the high availability database of all production systems and strictly adhered to data integrity procedure with use of NAS and IBM storage.
• Installed Oracle statspack to monitor database activities like waits, consistent gets, latches, buffer hits, sequential reads, disk reads (physical and logical) and recommended solutions.
• Optimized database performance and successfully tuned instance parameter with an increase in performance for more than 100% improvement from the existing database.
• Setup Unix Cron Jobs with Shell (Kshell) scripts to analyze database objects daily and refresh other reporting database.
• Used Informatica in ETL processes.
• Trained Junior DBAs.