OBJECTIVE

• I am an Oracle certified professional DBA with over 15 years of experience in Oracle database administration and development.
• I have the experience of implementing, supporting and maintaining large Oracle databases, and have used and implemented different Oracle technologies.
• I am interested in big data projects and challenging environments with mission critical databases.

SUMMARY

• Creating, upgrading, and migrating Oracle databases of 12c, 11g, 10g and 9i on different operating systems as well as configuring and administrating Oracle ASM and Grid Infrastructure
• Knowledge of Oracle Database 12c, including creating Multitenant databases
• Knowledge of creating and administrating Oracle Real Application Clusters (RAC)
• Experience of working with Oracle Exadata including data migration from non - Exadata environments
• Oracle backup and recovery using RMAN on disk and tape, creating Recovery Catalog, using the FLASHBACK technology and creating duplicate databases for production and non-production purposes
• Experience of Oracle Data Guard for creating physical standby databases
• Creating and supporting Oracle databases on cloud using Amazon Web Services (AWS)
• Creating Oracle logical data replications using Golden Gate and SharePlex
• Partitioning tables and indexes especially for data warehouse databases and implementing online schema redefinition
• Oracle database, SQL and PL/SQL performance tuning
• Monitoring databases using DBA scripts and using Oracle Enterprise Monitoring (OEM)
• Installing Oracle patchsets and upgrading Oracle databases
• Developing modules on Oracle using PL/SQL (Store Procedures, Packages, Triggers, etc.)
• Experience of Data Modeling and SQL generation using different modeling applications
• Installing and configuring Oracle/Redhat Linux, CentOS and Oracle Linux especially for database installations
• Knowledge of UNIX/Linux shell scripting
• Knowledge of creating and managing Oracle databases on virtual environments
• Ability to work in challenging environments and comfortable to provide database support 24/7 as part of a rotation

TECHNICAL SKILLS

Database Management Systems: Oracle Database 12c, 11g, 10g, 9i PostgreSQL 9.x, MySQL MS SQL Server

Environment: Exadata, Oracle Linux/Redhat/CentOS Solaris, Vmware, VirtualBox, Windows Server, Amazon EC2

DBA Applications: Oracle Enterprise Manager 12c/11g, RMAN, SQLPlus, ASMCMD, SQL*Loader, DataPump, SharePlex, GoldenGate, TOAD, SQL Developer, SQL Navigator, EMS SQL Manager, pgAdmin III, Putty

Programming/Languages: PL/SQL, SQL, Delphi, Java, Bash Scripting, Python, JDeveloper, NetBeans

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

• Supporting and administrating Prod, QA and Dev Oracle databases on Exadata (Oracle RAC 12c)
• Managing ASM and monitoring space allocations for Data Warehouse databases
• Migrating production databases from non-Exadata and consolidating individual databases into Exadata machines
• Optimizing the databases and working closely with the development team to tune SQLs and PL/SQL codes for Oracle 12c and Exadata
• Partitioning large tables and archiving old partitions using HCC (Hybrid Columnar Compression) online
• Monitoring the databases using Oracle Enterprise Manager Cloud Control 12c
• Monitoring tables, indexes, statistics, histograms and execution plans for the best possible performance
• Creating shell scripts (bash and ksh) for monitoring the databases, and generating notifications and alerts
• Configuring and running Exadata backups and recoveries on ZDLRA (Zero Data Loss Recovery Appliance)
• Improving the performance of the database and daily data warehouse jobs
• Supporting the production and project databases remotely during non-working hours

Oracle Database Administrator

Confidential

Responsibilities:

• Installed and supported Oracle RAC and standalone databases, Grid Infrastructure and ASM on Linux servers and Amazon EC2 Cloud environment
• Improved the performance of the databases by reconfiguring or redesigning the existing structure
• Tuned the performance of the production databases as well as optimized SQL and PL/SQL modules
• Implemented Oracle RMAN backup and recovery strategies for production and QA databases
• Exported and imported Oracle schemas using Data Pump utility
• Installed and configured Linux servers for Oracle, PostgreSQL and MySQL databases
• Implemented and configured SharePlex for logical data replication on production databases
• Upgraded and installed patches for production, staging, and development databases
• Migrated test and production databases to ASM from file system
• Migrated production databases from Oracle to PostgreSQL and vice versa
• Reverse engineered the databases using database modeling applications
• Worked closely with the application teams to resolve development and performance issues
• Implemented health check scripts (shell scripts) to monitor the activities on the servers and databases
• Provided 24/7 database administration support

Oracle Database Administrator

Confidential

Responsibilities:

• Supported and managed Oracle production, UAT, and development databases for daily activities and projects including RMAN backup and recovery, Active Data Guards, RAC servers, Fine-grained access controls, DB and SQL performance tuning
• Upgraded Oracle databases from 10g to 11g Release 2 including the ASM and installed the latest patch sets for Oracle 10g and 11g databases
• Partitioned huge tables and created automated partitioned tables for data warehouse databases
• Created duplicate Oracle databases for application development and test purposes
• Designed and implemented RMAN full and incremental backup strategies as well as FLASHBACK technology
• Created several Data Guard standby databases for production with Real Time Apply configuration
• Designed and developed a PL/SQL application to monitor standby databases
• Designed and developed an application for archiving Oracle data into Sensage (a Text-based database) with PL/SQL and Java
• Worked with clients to address their performance issues and cooperated with development teams for PL/SQL and SQL codes optimization

Oracle Database Administrator and Developer

Confidential

Responsibilities:

• Designed and developed multi-tier applications based on Oracle solutions for different industries
• Created schema objects like tables, indexes, views, packages, procedures and functions using Sybase PowerDesigner and Oracle Designer
• Created and upgraded Oracle databases on Linux and Windows from 10g to 11g
• Supported Oracle databases including creating, patching and upgrading as well as performance tuning, database migration and creating Data Guard standby database on Linux and Windows servers
• Managed RMAN daily backups and created duplicate databases for development team

Database and Application Developer

Confidential

Responsibilities:

• Developed applications using PL/SQL and Delphi on Oracle 8.05, 8i, 9i platforms
• Designed database structures using Sybase PowerDesigner
• Worked as part of the R&D team for designing multi-tier applications using Delphi, Oracle and SQL Server