• Design, implementation, and support Golden Gate data Replication for real-time Data Warehousing • Data Consolidation and Active-Active replication for 24x7 Mission Critical system; 20+ Databases 0.5-20TB sizes, up to 1TB/hrs redo rate with SLA 60 seconds. • Integrated and Coordinated technologies; Downstream and Classic schemas • Performance monitoring using HP Open View, Cloud Control. • Design and Build database schemas, PL/SQL API (packages, triggers), Job Schedules. • Implement test and development SDLC environment • Installation and configure Oracle Golden Gate Veridata for data examination • Performance Tuning and Monitoring using AWR, ASH, 10046, 10053 events and SQLT. • Tuning SQL queries using hints, indexes, partitions and session parameters. • Administration Standalone and RAC Databases instances; Backup and Recovery using RMAN

• 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 Solaris operation system to implement Logging, Integrity Control, and Auditing • 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) • Proactive Performance Monitoring and Tuning using AWR and Enterprise Manager • Tuning and Troubleshooting PL/SQL code (packages, procedures, functions, triggers) • Installing and patching Sun Solaris • Configure Fault-tolerant options (ZFS, MPXIO, SVM, Multipathing Fiber Channel) • Fine-tune UNIX kernel and environment for database performance. • Hardening Solaris, Implement security recommendations

• 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) • Tuning SQL queries using hints, indexes, partitions and session parameters.

- Administration ORACLE OLTP mission critical 7x24 high-availability database for Front-End / Back-Office “Open Way” in Sun High Availability Cluster Server platform. - Hardening OS Solaris. - Provide minimum-downtime Migrating and Patching plan for Production database. - Provide Backup-Recovery strategy using Recovery Manager (RMAN), Standby database. Providing crash recovery. - Installing and Patching OS Solaris. Provide Fault-tolerrant system (Disk mirroring, PowerPath). Provide hardening OS. Tuning UNIX kernel and environment for ORACLE RDBMS for performance. - Installing and Patching Sun Solaris 8. Provide Fault-tolerrant system. Provide hardening OS using JASS. - Applying Patches to ORACLE RDBMS. - Clone Test and Production instances. - 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. - Implement system Monitoring using MRTG and RRDtool. - 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; Netra Servers - HP EVA5000, XP128 disk arrays