We provide IT Staff Augmentation Services!

Oracle Dba Resume

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

Hire Now