SUMMARY

• Over 7+ years of experience as an Oracle Database Administrator and performed tasks like Oracle database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security etc. in production as well as development database on different platforms.
• Expertise in Installation, configuration and cloning of Oracle 9i, 10g, 11g, 12c RAC and standalone in UNIX/LINUX and Windows 2008/2012 R2 environment.
• Duties include Installation, Patching, Upgrading, Performance Tuning, Space allocation and Maintaining Oracle Server according to Oracle OFA Standards.
• Expertise in patch management, cloning, code migrations and release management.
• Worked on Oracle 11g Instances for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, voting disk loss & so on
• Experienced with tools/utilities: OEM, RMAN, TOAD, Embarcadero DB Artisan, SQL* Loader & Data Pump and Strong understanding in Oracle Architecture.
• Professional exposure to upgrade database from 11g to 12c with TDE enabled either Manually, DBUA,DATAGAURD method or Transportable Table space Method.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with TSM Backup.
• Proficient in Database administration activities such as user management, space management, monitoring, creating Database.
• Designed and developed conceptual, logical, andphysicaldimensionaldatamodels.
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL - Tuning Advisor, EXPLAIN PLAN, TK PROF and DBV.
• Experience in database Administration support and troubleshooting, including installPostgreSQLsoftware, patches and upgrades; manage and monitor tablespaces.
• Experience inOracleRAC running onOracleExadata database machine.
• Expert in ExadataAdministration, which includes migration of DBs, Resource Management, Monitoring and Troubleshooting, Storage Management, Performance Tuning, Resource Management, Upgrade and Patching.
• Hands on experience on ODAmachines of 11g databases with 3-node RAC up to 2TB Size.
• Worked on different kind of storages like EMC DMX,OracleZFSSA.
• Oracle Golden Gateexperience with Installation, configuration and troubleshooting of OracleGolden Gate11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Integrated and used BI Publisher (OBIEE) withAPEXfor reports.
• Good system administration skills on RHEL 6/7, AIX, Solaris 10 and windows 2008/2012 including storage administration.
• Proficient in raising SR withOracleSupport and using Meta-link to resolve the bottlenecks in the database environments.
• Implemented nightly ETL processes for loading data from multiple remote systems (Oracle, Sybase, MSSQL, etc.)
• Extensive hands-on experience withOracleIdentityManager (OIM),OracleAccess Manager (OAM),OracleInternet Directory (OID), OracleEnterprise Manager (OEM) and OracleInternet Directory (OID),Oracle Virtual Directory(OVD) and many other products ofOracleIdentityand Access Management.
• Experience in data Migration utilities such as SQL Loader, Golden Gate, SQL Developer, DB Links and Oracle Data Pump.
• Worked with Oracle to resolve Ora-00600, Ora-07445 issues and resolutions.
• Management of 200+ database with sizes ranging from 500GB to 20 TB and a mix of single Instance/RAC Environments.
• Provide first-line investigation and diagnosis of allIncidentsand Service Requestsusing Remedy tool.
• Hands on experience with Switchover/Failover activities.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.
• Expertise in administering Microsoft SQL Server 2005, 2008 and 2012.
• Setup Oracle Enterprise Manager (OEM) 11g in windows server 2012 for database Monitoring/performance/diagnostics.
• 24X7 production Database on Call support.
• Responsible for 24X7 on call support and monitoring and production deployments.
• Goal Oriented, Good Co-Ordination and co-operation with the Team and Management adapt at learning and adaptable to complex work environment.
• Expertise on PCP and middle tier Load balancer setup / troubleshooting.
• Hands on experience working on High Availability Environments.

TECHNICAL SKILLS

OS: RHEL Linux 7,6, Oracle Linux 6,7,Solaris 10, Windows 2012/2008, IBM AIX 6.1, 5.3

Software: Oracle 8i/9i/10g/11g/12c, Oracle 9iAS

Language/Front End: C, Java, Shell Scripting, MY SQL, SQL, PL/SQL, and PHP

Tools: SQL*PLUS, SQL Developer, TOAD, SQL Navigator, PUTTY, OEM, RMAN, SQL*

LOADER, Imp/Exp and Data pump:

Oracle EBS/Middle Tier: 11i, R12 / Oracle 9iAS, 10gAS, Apache

RDBMA: Oracle 8.x, 9.x, 10.1.0.2, 10.2.0.3 - 10 g, 11g 11.1.0.6, 11.2.0.3, 12c,Sybase 15,PostgreSQL 8,9

Tools: /Utilities SQL Loader, OEM, TOAD, Export/Import, Data Pump, AWR, Stats pack, TKPROF, Spot light, RMAN, SQL expert, OBIEE, RAC, opatch, Oracle Reports 10g and Oracle Forms 10g.

ENVIRONMENT: Oracle 11g & 12c, MS SQL Server 2008/2012, OEM Cloud Control 12c, RMAN, 11g RAC and ASM, Sybase 15, SQL Loader, ODA X52, Oracle Access Manager 11g, Oracle Apex 5.0,4.2,OracleZFSNAS, OracleEXADATA X5-2 HALF RACK,OBIEE 11.1.1.7.0 , IBM AIX 6.x, Linux RHEL 6.x/7.x, Windows2012,Oracle Linux, Sun Solaris 10, TOAD 11.6, Shell Scripting, SRDF, PL/SQL, ERWINDataModeler 7.x/8.x, Microsoft Ignite.

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Oracle DBA

Responsibilities:

• 24x7 L3 and L4 production support of Oracle, MSSQL, Sybase and MySQL databases.
• Upgraded oracle database from 11g to 12c and 10g to 11g RHEL6,7.
• Expert in Cloning (With Golden Gate) and patching of oracle databases 11g and 12c.
• Maintain database backup and recovery,database refresh procedure on Sybase databases.
• Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD for administering RAC and ASM instances.
• Migrated to Exadata using Golden Gate replication.
• Implemented Physical standby and ActiveDataguard.
• Implemented RTA (real time apply) inDataguard.
• Cloned and migrated PDB’s in Oracle 12c Multitenant database.
• Created PL/SQLstored procedures, functions and packagesfor migrating the data from staging area to data mart.
• Installed and implemented 11gR2 3 node RAC withDataguard/DG broker.
• Installed and configured OVD as a front-end LDAP proxy server using MS Active Directory (AD) andOracleInternet Directory (OID).
• Creating business users reports based on their requirements and adding functionalities to new and existingAPEXApplications.
• Planned and implementedPostgreSQLbackup & recovery of database through Physical and logical (pg dump/pg restore).
• Designed architectures (Conceptual, Logical andPhysical) for OLTP and OLAP (DW) environments including: creating database structures and loading/importingdatafrom multiple vendors’ databases (Oracle, SQL Server by using ERWIN tool) for consolidation; applied business rules and transformation in ETL to movedatafrom source system to Star or Snowflake Schema.
• Provided Database Administration support (24x7) for 10TB production oracle 11g Databases.
• Migrated Oracle 11g Database from Linux VM single node toExadata.
• Using Shell scripting configured alerts for DB health check, monitoring tables space usage, heap usage in application servers and managing rollback segments.
• PerformedOBIEEAdmin works like new ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Responsible for SQL and Database Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Server-level statistics on both Batch and Database servers (using iostat, vmstat, etc)
• Worked on Database-level statistics by enabling a logon trace trigger, which generates the raw database trace files.
• Reorganizing thedatabaseobjects by archiving the data, moving the tables within the table space and rebuilding the indexes.
• Troubleshoot the products integration with Oracle and Microsoft Sql Server from storage and network perspective.
• Monitoring the critical System parameters and analyzing and resolving any issues found during the monitoring.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Involved in export and import of database objects in order to migrate them from one database to another & copying the export dump file to tape.

Confidential, Washington DC

Oracle DBA

Responsibilities:

• 24x7 L4 production support and administering of Oracle, Sybase and MSSQL databases.
• Develop centralized monitor database activities, scripts such as space management, alert Log, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Table space monitoring, Disk monitoring, etc.
• ClonedOracledatabases to anOracleDatabase Appliance (ODA) for Proof of concept in the Development Lab.
• Created and Administered the Physical Layer, Business Model & Mapping Layer and Presentation Layer in anOBIEErepository.
• Configured 2 clusters on X4-2 Exadata Half Rack.
• Worked on restoring RAC PDB of 12c Oracle database.
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Planned and Implemented Disaster Recovery databases usingDataguard.
• Provided Database Administration support (24x7) for high volume production oracle 11g, 12c Databases.
• Used named queries and named calculations to modify thedatasource view Worked with STAR and SNOW FLAKE schema designs for the data-mart.
• Worked with system administrator for setting ports for the Firewall that will work for Oracle, OBIEE and MSSQL.
• Performed Golden Gate replication monitoring, tuning, and capacity planning.
• Configured Active-Active replication using Oracle Golden Gate.
• Implemented Computations to process certain business logic toAPEXITEMS.
• Converted databases fromZFSfile system to ASM file system and SupportedOracleCluster series usingZFSStorage Subsystem.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for implementing Load Balancing in RAC Database.
• Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.
• Exadata monitoring, Setting up the alerts for database, listener, table space monitoring,ZFSbackups setup from OEM 12c.
• ConfiguredOracleInternet directory as policy store forOracleAccessManager.
• Configured authentication schemes inOracleAccessManagerfor multiple target resources.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning (With Golden Gate) of Database and application from production environment to test environment and application of patches.
• Day to day activities includes providingSybasesupport and troubleshooting of issues like Connectivity, Memory issues, Query performance, Server related, Autosys jobs failures.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Involved in scheduling transaction log backups and notifications.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Worked on SQL explain plans query performance, session tracing.

Confidential

Database Administrator

Responsibilities:

• Provided L3 database support for 100+ production Oracle 11g databases.
• Upgraded oracle database from 11g to 12c and 10g to 11g on RHEL6 and Oracle Linux.
• Involved in Cloning and patching of oracle databases 10g, 11g and 12c.
• Configured web logic forOBIEE, security (LDAP for users, app roles migration using web logic script, BI SQL provider authenticator for groups), and cache in the new Linux environments.
• Develop centralized monitor database activities, scripts such as space management, alert Log, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Table space monitoring, Disk monitoring, etc.
• Used OEM (OracleEnterprise Manager)11g for routine administration, database monitoring, replication process and performance tuning.
• Integrating JavaScript/JQuery/AJAX toOracleAPEX.
• Responsible for Upgrading the Database from 10g to 11g and Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for implementing Load Balancing in RAC Database.
• Responsible for Administering Automatic Storage Management (ASM) by adding Disks to the Disk Groups when needed.
• Set up of SSO and post SSO activities like OID,OVD registration/deregistration for EBS-based applications.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Migrated data from production to development/UAT databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Involved in scheduling transaction log backups and notifications.
• Worked on SQL explain plans query performance, session tracing.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

Confidential

Systems Engineer

Responsibilities:

• Primary production support administrator for Oracle and MSSQL databases.
• Work with Oracle support in resolving bugs, bug fix patches, multiple severity 1 SRs etc.
• Worked as Primary team member to provide 24/7 on all production database support
• Installation configuration and administration of Oracle 11g RAC and Oracle 10g.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Physical Stand by Database Replication.
• Refresh of Database or Schema and applications for development and testing purpose.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups and Performed backup validations using RMAN.
• Installation and configuration of Golden Gate 11g.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Worked on Instance Tuning, memory Tuning and SQL Tuning.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export.
• Setup Golden Gate parameter files for extracting and replication.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning Packs along with AWR & ADDM reports.
• Partitioning of large tables for better performance and manageability.
• Performance tuning of database, oracle instances and applications.
• Finding performance bottlenecks using Explain plan, SQL trace, TKPROF, AWR and ADDM.
• Created users, roles and granted privileges according to the business requirements
• Experience in Configurations, logical models, operational management models and business continuity plan for systems under management.
• Excellent day-to-day administration in every means and monitoring alert log files and trace files.