PROFESSIONAL SUMMARY:

• Full time Oracle DBA, experience with 7.x — 12c RDBMS.
• Administration of OLTP Mission Critical 24x7 High - Availability databases.
• Implementing System Development Lifecycle SDLC infrastructure.
• DBA tasks: Installation, Configuration, Patching, Backup/Recovery, Migration and Troubleshooting.
• Oracle Middleware: Oracle Data Integrator (ODI); Golden Gate Data Replication using Active-Active, Downstream; Integrated, Coordinated; Oracle Veridata; Oracle Operational Data Store (ODS) and ETL
• RAC databases, Extended-RAC clusters on Solaris and Linux platforms.
• Implement Oracle options: Transparent Data Encryption (TDE), Database Vault, Advanced Compression, Multi-Threaded Server (MTS), Oracle Database Smart Flash Cache.
• Pro vide minimum-downtime Migrating and Patching plan for Production database.
• Proactive Performance Monitoring and Tuning using AWR, Statspack and dynamic v$-views.
• Storage management using ASM Preferred Read Failure Group, Storage Array configurations and RAID levels, SAN architecture and OS features to archive minimum latency and maximise throughput.
• Provide Enterprise Wide Backup-Recovery strategy using Recovery Manager (RMAN) and Data Guard.
• Excellent knowledge of UNIX shell, Oracle PL/SQL, SQL and Utilities (SQL*Loader, Data Pump).
• Perfect knowledge of database structure design and physical database implementation.
• Tuning and patching UNIX (Solaris, Linux, AIX) environment for database performance.
• Hardening OS using JASS; Firewall, ssh, kernel tuning, ZFS, svm, ipmp for PCI DSS.
• Excellent knowledge of UNIX shell scripting and utilities: sh, bash, crontab, sed, awk, perl
• SAN infrastructure implementation using Multipathing. FC Switch zoning.

EXPERIENCE:

Oracle DBA

Confidential

Responsibilities:

• Implementation and support Oracle Fusion Architecture using Oracle Data Integrator, Operational Data Store technics and Golden Gate Database Replication for real-time Data Warehousing. Data Consolidation and Active-Active environment for 7x24 Mission Critical system; Integrated and Coordinated technologies; Downstream, DataGuard and Classic schemes; Performance Monitoring using HP Open View, Cloud Control; Troubleshooting.
• Design and Build database schemas, PL/SQL API (packages, triggers), Job Schedules.
• Installation and configure Oracle Golden Gate Veridata for data verification; Oracle Golden Gate Web Director for replication management. Performance Tuning using AWR, ASH, SQLT.
• Administration Standalone and RAC Databases instances; Performance Monitoring, Tuning and Troubleshooting, Backup and Recovery using RMAN.

Environment: Oracle RDBMS 11g, 12c; RAC 11.2.0; ODI 12cR2 (12.2.1); Golden Gate 11.2, 12.1; Veridata 12.1. IBM AIX 7; Oracle Solaris 10, 11; Oracle Enterprise Linux 6, 7, ORACLE SuperCluster T4-4 and Exadata X5-2 platforms

Senior Oracle DBA

Confidential

Responsibilities:

• Oracle OLTP mission critical 7x24 Database administration for “Open Way” payment system.
• Create and administration Oracle geographically extended RAC. Implement RAC, ASM, iSCSI, GbE bonding options for Distributed Storage configuration.
• Implement database security options: Oracle Database Vault, Transparent Data Encryption (TDE), Fine Grained Auditing for PCI DSS audit. Applying patches and PSU. Hardening.
• Planning and configuring Storage Array Network; Multipathing HBA; FC switches.
• Provide minimum-downtime Migrating and Patching plan for production database.
• Provide Enterprise Wide Backup-Recovery strategy using Recovery Manager (RMAN).
• Pro-active Performance Monitoring and Tuning using AWR and Enterprise Manager .
• Tuning and Troubleshooting PL/SQL code (packages, procedures, functions, triggers).
• Installing and Patching Sun Solaris 10. Provide Fault-tolerant system (ZFS, MPXIO, SVM, Multipathing). Fine-tune UNIX kernel and environment for database performance. Hardening.

Environment: Oracle RDBMS 11.2.0 RAC; Enterprise Manager 11g Grid Control, Sun Solaris 10 on SPARC SunFire E4900, Enterprise M5000, SAN Disk Arrays EMC Clariion; Sun StorEdge 6130; EMC Symmertix DMX-4, Red Hat Enterprise Linux 6; Nagios, HP Operation Manager for UNIX (OMU), Zabbix

Oracle DBA

Confidential

Responsibilities:

• Administration Oracle OLTP mission critical 7x24 database for “Open Way”, “3Card-R” and “SmartVista” payment systems.
• Provide minimum-downtime Migrating and Patching plan for Production database.
• Provide Enterprise Wide Backup-Recovery strategy using Recovery Manager (RMAN), Data Guard.
• Proactive Performance Monitoring and Tuning applying AWR, Statspack and dynamic v$-views.
• Tuning and Troubleshooting PL/SQL code (packages, procedures, functions, triggers).

Environment: Oracle RDBMS 9.2, 10.2, IBM pSeries, p650, p570 servers, Red Hat Enterprise Linux 4, 5, Veritas Cluster Server 5.1, NetBackup 5.0.

Oracle Developer / DBA

Confidential

Responsibilities:

• Administration Oracle OLTP mission critical 7x24 Database for “Open Way” payment system.
• Provide minimum-downtime Migrating and Patching plan for Production database.
• Provide Backup-Recovery strategy using Recovery Manager (RMAN), Standby database.
• Applying Patches on Oracle RDBMS.
• Proactive Performance Monitoring and Tuning applying AWR, Statspack and dynamic v$-views.
• Tuning and Troubleshooting PL/SQL code (packages, procedures, functions, triggers) and streamlining user queries. Write scripts on shell.
• Implementing Oracle Names service, MTS Multithreaded Shared Server.
• Develop reports using Oracle Reports
• Design structure and Build Database using Oracle Designer.
• Develop PL/SQL code using PL/SQL Developer and Platinum SQL-Station.

Environment: Oracle RDBMS 8.1, 9.2, Sun Enterprise 3500, SunFire 4900