SUMMARY:

• 5+ years solid Oracle database (9i / 10g / 11g / 12c) administration and hands - on experiences in high-end enterprise environments (database size from 1 TB to 60 TB).
• 5+ years experience in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as financial service, telecom, manufacturing, online transaction field.
• 5+ solid hands-on experience and excellent troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g / 11g / 12c RAC / ASM / Data Guard / OLTP / OLAP environments.
• 5+ solid hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and Oracle to SQL Server).
• 5+ years solid experience in Data Pump / ASM / ASH / AWR / ADDM / Grid Monitoring / Oracle Enterprise Manager.
• 5+ years solid experience in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• 5+ years solid experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by AWR / ADDM / Explain Plan / Autotrace / Statspack.
• Strong organizational, administrative and problem solving skills, statistical analysis skills, proficient with analytic and quality assurance.
• Proficient knowledge in business/user process and procedure, guidelines and documentation and project management, experience in managing multiple projects simultaneously.
• Good Written and verbal communication skills, self-motivated team player and good analytical thinking.

TECHNICAL SKILLS:

• DATABASE: Oracle 9i/10g/11g/12c
• LANGUAGE SQL, PL/SQL Perl, Bash Shell, python, Java, C/C++
• PLATFORM Oracle Exadata, Redhat Linux, IBM AIX, HP-UX, Oracle Solaris, and Windows
• DATA REPLICATION Oracle Golden Gate
• MONITORING Oracle OEM
• TOOLS SQL/Plus, RMAN, OEM, EXP/IMP, Data Pump, Golden Gate, Data Guard, TOAD, SQL Developer, Informatica, EXPLAIN PLAN

PROFESSIONAL EXPERIENCE:

Confidential, Issaqquah, WA

Senior Oracle Exadata Administrator

Responsibilities:

• Installing, configuring, maintaining and supporting Oracle 11g and 12c (NON-CDB) Databases.
• Installing and configuring High Availability Oracle Golden Gate systems on Oracle 12c RAC environments. (Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X5 Full Rack).
• Performing Zero Downtime migration upgrade of Oracle database from 11g (11.2.0.4) to 12c (12.1.0.2) using Golden Gate.
• Setting up Golden Gate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to warehouse system. On Non-Exadata Servers we use separate mining database Golden Gate replication and on Exadata source database is used as mining database too.
• Troubleshooting common OGG technical problems such as unique key violation / transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from SQL Server to Oracle Exadata).
• Managing database security by creating new users, roles, profiles and providing privileges for implementation and maintenance of user security.
• Installing ASM instance and migrating the database from a Filesystem to ASM storage.
• Using RMAN for backup/recover strategy for different database. Applying different recovery procedures for complete and incomplete recovery depending on the type of failure.
• Building Oracle 12c Standby database, both active Data Guard for real-time replication and normal Data Guard for disaster recovery. Working on Disaster Recovery by converting physical standby databases to Snapshot standby database and open in the read/write mode for testing without interrupting the primary production database.
• Writing many automation UNIX shell scripts for database refresh, monitoring, consolidated report, reconfigure Data Guard, switchover/switchback of database etc.
• Replicating all non-production databases on Exadata server based on the Data Warehouse development project’s requirement. Using Oracle HCC to compress large volume partition table.
• Managing, monitoring, patching and upgrade of Exadata. Responsible for designing of solution and setup of Exadata with its components like, RAC, Management Node, Infiniband Partitions, Storage Cell configuration.
• Combining Exadata monitoring into existing IT monitoring framework. Provide and implement performance tuning recommendations of all components in the Exadata machines.
• Applying the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using Opatch.
• Performing Database and SQL tuning by using SQL Tuning / AWR / ADDM / ASH utilities.
• Establishing performance tuning best practices used by the DBA and Development teams.
• Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN.
• Working extensively on Performance Tuning of Queries by maintaining partition, indexing, and use of statstics.
• Providing 24x7 on-call support and provide on-call and day-to-day support.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Built and supported 11gR2 RAC, 12C standalone database on different OS platforms (AIX/Linux/Sun Solaries servers) and raw / ASM file systems.
• Upgraded the RAC and standalone database from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g (11.2.0.4) to 12c (12.1.0.1).
• Installed, upgraded, configured and troubleshoot GoldenGate 11gR2/12c software.
• Migrated Oracle database from Non-Exadata machine to Exadata using datapump and Golden Gate.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion need of the company.
• Implemented 12c/11g Data Guard with one physical database.
• Created, configured and setup RMAN Catalog databases and register target Databases with the Catalog.
• Used TDE (Transparent Data Encryption) for encrypting the sensitive data using column encryption and tablespace encryption, also used TDE for Golden Gate replication.
• Created, scheduled databases’ maintenance tasks like tables/indexes analysis, index rebuild, materialized views refresh, exports and janitorial day-to-day tasks.
• Refresh QA/DEV databases from the source production databases on a regular basis using exp/imp utility.
• Performed database tuning using AWR / ADDM / ASH / OEM and used OS utilities (NMON, VMSTAT) to analyze the CPU, RAM, DISK performance.
• Installed Administer and managed ASM instances on a RAC environment like creating instance including create and configure diskgroups and also redundancy levels.
• Developed UNIX shell scripts & SQL scripts to perform the daily Database & OS monitoring, Server validation & health check.
• Assisted application development team in query tuning & optimization, partitioning, explain plan recommendations.
• Worked with system administrators for various OS level administrative tasks, and modify existing UNIX backup shell scripts as per the environment.

Confidential, Silver Spring, MD

Oracle Database Administrator

Responsibilities:

• Worked in a Team with more than 20 clients for Production support and working in day-to-day maintenance of DEV/QA databases.
• Created new databases under different environments and maintained different oracle homes in the same servers.
• Performed installation, configuration, maintenance, and upgrades of Oracle development, QA, and production databases, including installation and upgrades for client/server software.
• Installation & Creation of Oracle Database 9i/10g on IBM AIX and Redhat Linux. Upgraded and migrated the PROD/DEV/QA database to different version depending on Business requirements using exp/imp utility.
• Installed and Configured Oracle 9i/10g RAC, worked on multiple RAC clustered environments ranging from 2 nodes to 3 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting disk of 10g RAC.
• Upgraded the database from Oracle 10.1.0.3 to 11.2.0.4.
• Implemented Oracle 11g Active Data Guard for Disaster Recovery Solution, and used Data Guard Broker for switchover and failover using utility DGMGRL.
• Implemented Oracle 11g Golden Gate for replication.
• Installed, upgraded and maintained database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.
• Implemented the incremental and full RMAN backup for each database to have space management and effective recovery.
• Managed table spaces, added data files, resized data files, reorganized table spaces to claim the space and to improve the performance. Monitored and tuned rollback segment, temporary table space, redo log buffer, and sort area size.
• Table Partitioning, created Index Organized tables, created locally managed table spaces, Database sizing, rollback table space, Transaction Management, Security Administration.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Tuning of Oracle Database (for locking, Wait Events using statspack, AWR, ADDR reports).
• Develop UNIX shell script to automate morning health checks.

Confidential, Seattle, WA

Oracle PL/SQL Developer and DBA

Responsibilities:

• Collaborated with application team to code, test and develop Oracle SQL and PL/SQL packaged procedures and functions in support of department store and warehouse Physical Inventory system spread across ten database.
• Installed and Configured Oracle 9i/10g RAC.
• Migration of Oracle Database 10g includes the migration from windows to Linux using Transportable tablespaces.
• Tested and tuned SQL queries, structure of the code and performed refinement of the database design in different environments (DEV, QA and PROD).
• Involved as a key member for Requirement Analysis during the design phase and interaction with the client.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized the existing procedures and SQL statements for better improvement in system response time and efficiency.
• Involved in creation of unit test cases, test case review and testing.
• Providing 24x7 on-call production database administration support.