Senior Oracle Dba Resume
4.00/5 (Submit Your Rating)
New York, NY
SUMMARY
- Accomplished Technical DBA and Systems Architect with 20 years' experience, Exadata, Exalogic, Migration and Upgrade Expert
- Hands on experience on Oracle e - Business Suite (EBS) R12/11i Installation, configuration, maintenance troubleshooting and support
TECHNICAL SKILLS
- Oracle Real Application Clusters (RAC) 10g (10.2.03) AND 11g
- DataGuard replication technologies
- Table partitioning
- Solid in RAC, ASM, Dataguard
- Flashback technologies.
- RMAN experience in Oracle 11g
- Shell scripting skill
- Database partitioning, patching, and cloning experience
- Oracle support in Java environment
- Experience with SQL Server and DB2 Connect Gateway
- Proficiency in PL/SQL
- Experience with SQL Server and DB2 Connect Gateway
- Strong Oracle11gR1R2 RAC experience including build, general administration, troubleshooting (BreakFix) and L3 performance tuning skills
- Experienced in Clusterware (GRID Infrastructure) - CRS management and configuration
- Skilled in Oracle ASM administration
- Experienced in maintenance and management of databases using Oracle Enterprise Manager Grid Control Experienced on Solaris, Linux and AIX OS including strong shell scripting skills
- Competent in ChangeRelease Management
- Oracle Exadata, using RAC and DataGuard and OID.
- Oracle RAC and Dataguard in mission critical database environments
- Knowledge of Oracle's Maximum Availability Architecture standards and strategies
- A good level of Unix shell scripting
- Oracle PL/script SQL development
- Exposure to multi-tenant, shared-service Oracle environments hands on experience on Oracle e-Business Suite (EBS) R12/11i Installation, configuration, maintenance troubleshooting and support
- Proficient in using applications utilities ADADMIN, ADRELINK, ADCTRL, ADPATCH, FNDLOAD
- Concurrent Managers, Programs/Executables/Request Groups
- Good Understanding of Storage, Network, server technologyDatabase
- Export/Import,Backup/Recovery.
- Oracle DBA possesses knowledge on Oracle Golden Gate, Exadata & OEM Grid control.
- Migrated existing databases from Oracle 10gR2 Solaris to 11gR2 on Linux Exadata.
- Help design and implement active-active & active-passive site to site replication using Golden Gate, character set conversion for few databases from us7ascii to utf8.
- Proactive Performance tuning of applications to leverage Exadata features for optimal application performance, security, capacity management and automation.
- Strong pl/sql and sql coding skills to mentor developers.
- Help facilitate database migration from 10g to 11gR2 and work with development team to test application, modify code to take advantage of new 11g features and Exadata features.
- Help implement conflict resolution techniques for bi-directional asynchronous replication with Golden Gate.
- Participate in database infrastructure/future-state design planning and implementation.
- Understand & analyze software compatibility issues with Oracle 11gR2 (Ex: Weblogic to Oracle RDBMS compatibility, Drivers compatibility etc).
- Possess strong working knowledge of High Availability, Backup and Recovery options and help to implement solutions.
PROFESSIONAL EXPERIENCE
ConfidentialSenior Oracle DBA
- Oracle DBA Technical Support in a UNIX and Windows infrastructure
- Used VERITAS clustering for Oracle
- Set up OEM 12c and converted OEM11g over to OEM12c.
- Upgraded databases: Oracle 9i - 11g Oracle 10 - Oracle 11G
- Provided daily reactive Incident and Service Request support for Oracle Databases globally via hotline and ticketing systems. Performed triage, initial troubleshooting, and escalation
- Worked in Solaris environment
Senior Oracle DBA
- Upgraded databases: Oracle 9i - 11g Oracle 10 - Oracle 11G
- Experienced with Oracle 12c. Implementation on multiple Linux servers
- Handled daily reactive Incident and Service Request support for Oracle Databases globally via hotline and ticketing systems. Perform triage, initial troubleshooting, and escalation
- Performed VERITAS clustering for Oracle
- Proactively supported the ongoing maintenance and optimization of preventative maintenance activities
- Interfaced with other Infrastructure support teams such as UNIX, WINTEL, Network, IT Facilities, Backup, Storage, Monitoring, Security etc.
- Supported application development teams with Version upgrades, application releases, and cloned / created copies of existing databases for testing and development purpose.
- Supported day to day maintenance and operation of databases including table space maintenance, providing expertise and recommendation on performance tuning, and consultancy requests where application development teams require Oracle DBA expertise.
- Worked with other global Oracle team members to provide follow-the-sun support and drive global consistency
- Solid Oracle 11gR1/R2 RAC experience including build, general administration, troubleshooting (Break/Fix) and performance tuning skills
- Experienced in Clusterware (GRID Infrastructure) - CRS management and configuration
- Skilled in Oracle ASM and DataGuard administration
- Experienced in a Solaris environment
Senior Oracle DBA
- Supported State of Texas and several state banks as part of the overall support contract. Oracle Architecture Design including capacity planning, storage, clusters, servers; offered solutions for high availability, disaster recovery and scalability.
- BANKING application support for the State of Texas.
- Used VERITAS Cluster Server for Oracle
- EBS Migration and Upgrade from 11 -12
- E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported
- Experienced in a Solaris environment
- Experienced with Golden Gate for Oracle Replication
- Handled Data Warehouse design and construction, ETL, performance tuning, and front-end tool
- Oracle Architecture Design including capacity planning, storage, clusters, servers; ability to offer solutions for high availability, disaster recovery and scalability
- Strong knowledge of security, compliance, and regulations SOX auditing and HIPAA requirements.
- SQL server maintenance
- Experienced with setting up Exadata and Golden Gate Replication
- Oracle database architecture installation, configuration, tuning, review, and troubleshooting on versions 9i, 10g, and 11g.
- DB-2 Support on both mainframe and Unix/AIX platforms
- Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and Recovery solutions including RMAN, Backup Scripts and SAN based backups. Oracle Monitoring with OMS and Grid Control. Strong knowledge of all primary Oracle platforms including UNIX, Linux and Windows.
- RAC-Set up and maintained a three node Linux (RedHat based) cluster using CRS (Cluster Ready Services), ASM and Oracle RAC enabled software.
- Programming in: Unix Shell Scripting, PL/SQL. 11gR2/10g RDBMS on Unix and Linux, RAC (Exadata), Data Guard, Performance Tuning, RMAN, CRS, ASM, OEM Grid Control, Data Pump, Partitioning, high volume OLTP systems
- Used UNIX Korn/Bourne Shell scripting for automation.
- Reviewed, recommended, tested, and implemented Oracle application data model creations and/or changes.
- Tuned at the instance and SQL statement level and supported test and development database environments.
- Knowledge in Advanced Replication/Materialized Views Partitioning DataGuard Streams.
- Supported SQL Server 2005, 2008 as DBA with Installation replication data modeling and moving data around and backup procedures
Senior Oracle DBA
- Oracle Architecture Design including capacity planning, storage, clusters, servers with the ability to offer solutions for high availability, disaster recovery and scalability.
- EBS Migration and Upgrade from 11 -12
- E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported
- DB-2 support on both mainframe and UNIX/AIX platforms
- Supported SAP ERP systems running under Aix operating system and Oracle database 9i.
- Oracle database architecture installation, configuration, tuning, review, and troubleshooting on versions 9i, 10g, and 11g.
- Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and Recovery solutions including RMAN, Backup Scripts and SAN based backups. Oracle Monitoring with OMS and Grid Control. Strong knowledge of all primary Oracle platforms including UNIX, Linux and Windows.
- RAC Set up and maintained a three node Linux (RedHat based) cluster using CRS (Cluster Ready Services), ASM and Oracle RAC enabled software.
- Strong Programming skills including at a minimum: Unix Shell Scripting, PL/SQL.
- E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.
- Proficiency in installation, configuration and administration of RAC clusters (including Oracle Clusterware, Server side load balancing, Service based connectivity, Automatic Storage Management (ASM), Physical and Virtual network address management, patching.
- Extensive use with Oracle Enterprise Manager Grid Control for monitoring, administration and performance tuning (including installation and configuration of OMS and mass agent deployment, custom alerting through Grid).
- Expertise with Oracle Data Guard using Real-Time Apply in a physical and logical standby environment.
- Knowledge in Advanced Replication/Materialized Views Partitioning DataGuard Streams.
- Installed and Configured SQL Server 2005 2008.
- Supported SQL Server 2005, 2008 as DBA with Installation replication data modeling and moving data around and backup procedures.
- Created Database Snapshots.
- Worked in in a Solaris environment
Oracle Financials/Oracle E Business Suite Database Administrator
- E-Business Suite system support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.
- Supported both single instance and RAC enabled oracle databases
- Oracle Database Administration experience in production, including installing, patching, upgrading Oracle databases.
- Monitored and tuned a database to provide a high availability service and optimum storage capability, including: query optimization, init.ora configuration, memory optimization, tablespace storage optimization, table/index analysis, tuning long-running processes.
- Fluent with Oracle 10G and RAC environment and configuration.
- Fluent with RMAN backup and configuration
- Used Netbackup software for all RMAN backups and recoveries.
Senior Software Engineer/Oracle DBA
- Functioned as both a DBA and /HPUX/SOLARIS 8-9/AIX/LINUX System Administrator in support of a PeopleSoft 8.4.4 ERP environment.
- Assisted with the setup of App Servers, Web Servers to support PeopleSoft 7 8.
- Helped with MULTIPLE PeopleSoft migrations.
- Managed Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
- Cloned Oracle Instances using both RMAN DUPLICATE technology and prior to ORACLE 9i, using manual techniques of duplicating instances and recreating control files.
- Oracle DATAGUARD implemented for Disaster Recover.
- Used both Physical and Logical Standby Databases.
- Implemented Virtual Private Databases (VPD) on Oracle 9i.
- Installed Bind NameServers, NFS and LDAP on Linux and UNIX Servers.
- Wrote advanced shell scripts using Perl, SQL, Bash, Ksh and Csh, Sqlldr, export/import, datapumputil