Senior Oracle Dba Developer Resume Profile
2.00/5 (Submit Your Rating)
OBJECTIVE
- Accomplished Technical DBA and Systems Architect with 20 years' experience, Exadata, Exalogic, Goldengate and EBS Migration and Upgrade Expert
- Hands on experience on Oracle e-Business Suite EBS R12/11i Installation, configuration, maintenance troubleshooting and support
- Hands on experience with applications/tech stack/database upgrades, cloning, patching, and backups/recovery I can setup the database and software, monitor and performance tune the end product. I have excellent communication and writing skills. I have migrated across every platform, and have worked on RAC nodes up to 4 node clusters
- Responsible for day-to-day administration of 30 non-production and production databases.
- This includes database administration, backup and recovery, performance tuning and database security.:
- Installing, configuring patching Oracle software versions 10g 11g 12c
- Installing, configuring patching Oracle RAC 10g/11g
- Strong experience installing, upgrading and supporting Oracle 11g databases. Hands-on experience with implementation, administration and usage of Oracle Real Application Clusters and Oracle Enterprise Manager Grid Control. Experience on UNIX AIX, SUSE Linux SLES 9, 10 RedHat 5 6 7 and Windows platforms
- Heavy RAC, ASM, and Dataguard environment
- Oracle RAC Real Application Clusters
- Knowledge of Advanced Replication
- Good Working experience of Installation administration of RAC 9i, 10g Real Application Clusters .
- Good knowledge of 11g features as OEM, Data Pump, ASM and Flash back recovery.
- Upgrading Oracle software version from 10g to 11g and 12
- Oracle Enterprise Management Grid Control 12c installation and administration experience.
- Oracle ASM Automatic Storage Management installation, configuration administration
- Backing up and restoring Oracle databases using RMAN
- Oracle Data Guard / Oracle Streams/ Partitioning
- Organize / perform support and trouble shooting of Oracle Database Server and Oracle products
- Performance, analysis and fine tuning of databases/applications.
- Oracle 11g Grid OEM for administration, monitoring performance analysis of Oracle instances
- Working knowledge of Linux Windows 2003/2008 Operating Systems
- Unix shell/Perl scripting
.Skills Summary
- 16 years of experience as Oracle DBA
- Exadata Experience
- Oracle Real Application Clusters RAC 10g 10.2.03 AND 11g
- DataGuard replication technologies
- Table partitioning
- Solid in RAC, ASM, Dataguard
- Oracle Exadata, using RAC and DataGuard and OID.
- Competent in ChangeRelease Management
- 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
- Skilled in Oracle ASM administration
- Experienced in Clusterware GRID Infrastructure - CRS management and configuration
- Strong Oracle11gR1R2 RAC experience including build, general administration, troubleshooting BreakFix and L3 performance tuning skills
- Flashback technologies
- 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
- 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
- Oracle PL/script SQL development
- 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.
- Experience in implementation and maintenance of ''High Availability'' RAC Oracle Database and Application server Architecture.
- Expert knowledge in Recovery Manager RMAN Experience working on different flavors of UNIX AIX, LINUX
- Linux/Unix, Shell and Perl scripting
- Working knowledge of SSO, OID, and Microsoft AD
- Oracle Identify Management Suite 11g
- Interfacing and communications with external customers
- Project Management, time management, scheduling and coordination
- Oracle WebLogic
- Oracle Technical support
- Roll out new build version/releases for databases/instances
- Oracle tools
- 10 years of experience in Database Performance Tuning
- Database code and query optimization
- Resolving performance issues of databases.
- Expertise in SQL Database Level performance tuning skills
- Expertise in backup and recovery and migration using RMAN, datapump and export/import.
- Experience in Oracle Exadata, Golden Gate replication
- Experience on Solaris, Linux and AIX OS including strong shell scripting skills.
- Expert knowledge of database scripting and automation technology
- Excellent written and verbal communications
- Experience working with offshore vendors
- Expert knowledge of Oracle Partitioning.
- Knowledge of management packs.
- Experience in upgrading from 10G to 11G.
- Golden Gate Experience defining new primaries and replicas and support of Golden Gate.
- RAC experience setting up and adding nodes
- Experience with Oracle 12C.
- Experience with upgrading from 11G to 12C.
- Set up/ support new and existing people soft environments both Financials and HRMS Install, configure, tune, support of existing People Soft application components Upgrade/apply patches of People Tools 8.5.1 Migrations between environments Refresh PeopleSoft production to non-production environments. Performance Tuning of PeopleSoft environments
- Intermediate to advanced knowledge of SQL and ability to write, troubleshoot queries
- Hands on experience to create ad-hoc queries, reconcile sub-modules to GL
- Design, implementation, administration, optimization and maintenance of Oracle
- VERITAS clustering
- UNIX shell scripting skills
- UNIX OS, Solaris 8, 10.
- troubleshooting Break/Fix
- Storage diagrams for both ASM and non-ASM environments.
- SQL Database Level performance tuning skills
- Solaris, Linux and AIX
- PSU patching.
- PostgreSQL on Red Hat Linux
- Perl Scripting
- Performance analysis and tuning
- Oracle/ Linux Red Hat / VMWare environment
- Oracle RAC
- Oracle ASM administration
- Oracle 11gR1/2, Oracle 11gR1/2 RAC
- Oracle Very Large Database VLDB
- Oracle Unified Directory OUD
- Oracle Traces TKPROF, Trace Analyzer and stats pack
- Oracle RMAN Grid control/ EM
- Oracle Partitioning.
- Oracle Monitoring Custom Shell/Perl/SQL Scripts
- Oracle Internet Directory OID
- Oracle HR Suite 11.5 Oracle Partitioning
- Exalogic
- Oracle Exadata
- Oracle Enterprise manager.
- Oracle E-business Suite
- Oracle Database migration experience
- Oracle Database Appliance ODA
- Oracle Data Vault, Advance Security, Data Encryption.
- Oracle Data Guard, Disaster recovery design and solution
- Oracle Applications Manager OAM including Workflow and Autoconfig
- Oracle and Sybase P T utilities.
- Oracle analytics
- Oracle 11g
- Oracle 10 11 Database Oracle Enterprise Manager OEM
- OBIEE
- Migrations
- Linux
- L3 performance tuning skills
- Infrastructure upgrades for servers, storage devices.
- Hardware and Operating System monitoring
- Golden Gate
- Flash back/ Flash Recovery Features/ Flash back query
- Finance and Supply Chain modules - GL, AP, AR, PO, INV, OM, Order information Portal and iReceivables.
- EMC/Oracle Performance Disk tuning
- EMC , ASM PL/SQL
- EBS Migration and Upgrade
- Disk replication technologies SRDF
- Database upgrades -Oracle 9i/10G to 11G.
- Database tuning and optimization
- Database security
- Database administration
- Data warehousing concepts, terminology, and architecture
- Data Guard
- CRS management and configuration
- Clusterware GRID Infrastructure
- Clustering, HA solutions.
- Backup and recovery and migration.
- AWR/ADDM/ASH
- ASM instances
- ASM based database storage
- Excellent knowledge of Linux
- Experience to administer PeopleSoft security creating user profiles, roles, permission lists
- Goldengate middleware.
- Troubleshooting GoldenGate issues
- Goldengate configuration and optimization on RAC environment on Oracle
- Database Machine Exadata v1 and v2 .
- Goldengate Bi-directional Active-Active , Broadcasting and Unidirectional
- Goldengate patching,upgrade and solutions for compressed and encrypted tables
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle DBA Developer
- Oracle DBA Technical Support in a UNIX and Windows infrastructure
- Set up OEM 12c and converted OEM11g over to OEM12c.
- Used VERITAS clustering for Oracle
- 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
Confidential
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
Confidential
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.
- Used VERITAS Cluster Server for Oracle
- Oracle Architecture Design including capacity planning, storage, clusters, servers ability to offer solutions for high availability, disaster recovery and scalability
- Handled Data Warehouse design and construction, ETL, performance tuning, and front-end tool
- Experienced with Golden Gate for Oracle Replication
- Experienced in a Solaris environment
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported
- E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- EBS Migration and Upgrade from 11 -12
- 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
Confidential
Senior Oracle DBA
- DB-2 support on both mainframe and UNIX/AIX platforms
- Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported
- E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
- EBS Migration and Upgrade from 11 -12
- Oracle Architecture Design including capacity planning, storage, clusters, servers with the ability to offer solutions for high availability, disaster recovery and scalability.
- 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
Confidential
Oracle Financials/Oracle E -Business Suite Database Administrator Contractor
- 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.
.Confidential
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