SUMMARY:

• One real Oracle DBA veteran who has over 13 years of focused experience in high end Oracle database administrative area in various fields like finance, banking and telecom.
• Extensive experiences in Oracle database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Involved with the architect group in designing the logical and physical model of the enterprise level databases.
• Have long term and solid experience in Oracle Exadata, RAC, Grid, ASM, DataGuard, GoldenGate installation, configuration, trouble - shooting, and performance tuning. Have impeccable communication and interpersonal skills and an exceptional team player.
• Over 13 years extensive experiences in Information Technology industry, especially in Oracle Database / Unix - like system administration, software design and implementation area.
• More than 10 years in Oracle databases (9i/10g/11g/11gR2) as Sr. Oracle Database Administrator in Oracle Exadata machine, IBM AIX, Redhat/CentOS Linux, HP-UX, Solaris and Windows.
• Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including 10g/11g RAC, aSm, Physical/Active DataGuard on AIX/Linux(X64) environments.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
• Hand-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (HybridColumnarCompression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• .Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Experience with Oracle 10g/11g new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
• 6+ years experiences and solid hands-on experiences in Installation / Configuration /
• Performance Tuning / Troubleshooting.
• Oracle GoldenGate data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including MS SQL Server to Oracle).
• Proficient 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.
• Highly skilled in SQL Tuning by using Oracle statistics management, Explain Plan, TKProf and necessary SQL code rewrite. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control 12c.
• Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl.
• Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS:

• Oracle Database 9i/10g/11g/12c, MySQL, Microsoft SQL Server SQL and PL/SQL, C/C+ +, Qt, Java,Perl,python, Korn/Bash Shell scripts Oracle X2/X3/X4/X5 full rack Exadata, IBM PowerPC, X64 servers, Sparc, HP-UX Oracle GoldenGate
• Oracle OEM 12c, Zabbix

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle Database Administrator

Responsibilities:

• Used Flashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Working with Development, QA and other teams to resolve the issues.
• Implemented Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience.
• Responsible to develop UNIX shell scripts to automate support tasks.
• Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Created a disaster recovery (DR) document that recommended five different approaches to managing Disaster Recovery, implemented, test and supporting resulting strategy.
• Executing DDL changes, Capacity planning and forecasting Query tuning and optimization.
• Creating and dropping of Users, granting and revoking permissions to users/roles when required.
• Developed Scripts for transferring data from production server to testing/development servers.
• Experience in using Oracle Tools and utilities such as TOAD, SQL* 1Plus, SQL Developer.
• Experience with BMC Remedy tool for all change management process .

Confidential, Englewood, CO

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Goldengate (both Classic and integrated capture) and Shareplex for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.
• Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems. And on Non-EXADATA servers we used separate mining database Goldengate replication and on EXADATA source databases is used as mining database too.
• Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.
• Implemented Goldengate integrated replicat and co-ordinated replicat(available from OGG 12c) to improve the performance of data replication to targets
• Used JAGENT at server level and GG plugin at OEM grid level for Goldengate monitoring and also used crontab scripts.
• Implemented archive and Purge strategy for archiving the inactive data in the historical database and purging the archived data from the primary database as a part of performance improvisation using Goldengate and exp/imp using partitions.
• Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility
• Creating and Maintaining the user accounts and providing required privileges for database access based on the user requests with proper approvals.
• Created and troubleshoot DB Link issues in Oracle for communicating with external databases.
• Used Utilities like Explain Plan, SQL1Trace, TKPROF and Statspack for SQL Tuning Purpose.
• Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Re-definition (with minimal impact to live system ), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.

Confidential

Sr. Oracle DBA

Responsibilities:

• Worked with other DBA's for Capacity planning of new Databases. Data replication between different Oracle databases using DB Links. Setup test environment to simulate the migration process.
• Worked with backup support team to implemented hot/cold backups using RMAN and recovery using RMAN,Export/Import and Data Pump utilities.
• Implemented backup and recovery strategies using export/import, Datapump, RMAN Incremental backups,Traditional hot, cold backups.
• Extensively worked, implemented Oracle Partition strategy on the tables and indexes.
• Responsible to implement tablespace, table and indexes Oracle compression in dev/test and production.
• Responsible for data modeling, metadata management, database design, database administration and support throughout the system lifecycle for project.
• Responsible for build database(s), maintain database baselines, support application requirements, testing and implementations.
• Responsible to monitored database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control, generated reports as needed.
• Responsible to work with system admins to Server virtualization using VMware for Oracle database support.
• Responsible to develop UNIX shell scripts to automate support tasks.
• Extensively used Rational Clear case, clear quest, Toad, SQL developer, SharePoint tools to manage andmaintain Oracle databases.

Confidential, Allen, TX

Oracle Database Administrator

Responsibilities:

• Involved in Installation and customization of Databases (10g&9i)
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting
• Responsible for Oracle implemented backups like LOGICAL & PHYSICAL i.e. Export & import
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, and schemas.
• Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Tuning Oracle 9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment: Toad, Oraclecle9i/10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, Shell Scripting.