Sr. Oracle Dba Resume
2.00/5 (Submit Your Rating)
Los Angeles, CA
SUMMARY:
- Seeking the position as Senior Oracle DBA or Oracle Architect.
- I have over 16+ years of experience as an Oracle DBA (12c/11g/10g/9i/8i/8/7) on different platforms including Sun Solaris, AIX, Linux and Windows.
- I have an active secret security clearance.
TECHNICAL SKILLS:
Database Admin: ORACLE 12c/11g/10g/9i
RDBMS: Oracle, Microsoft SQL Server 2000 2005
High Availability: ORACLE RAC, Dataguard, ASM
Languages: SQL, PL/SQL, SHELL Script
Operating System: HP UX, Sun Solaris, IBM AIX, Linux (Red Hat), Windows, VMware, Oracle VM Server
Database Tools: OEM Grid control, RMAN, Toad
PROFESSIONAL EXPERIENCE:
Confidential, Los Angeles, CA
Sr. Oracle DBA
Responsibilities:
- Role is to administer Exadata clusters and various RAC databases on Oracle Exadata x4 - 2, x3-2 machines.
- Maintaining about 32+ RAC databases on a day-to-day basis.
- Participated in various aspect of database administration activities and week end maintenance activities.
- Actively working on database performance tuning. Setup Active Data guard for multiple prod databases.
- Upgraded databases from 11.2.0.3 to 11.2.0.4 and then to 12c, upgraded GI from 11g to 12c.
- Also providing day-to-day support for Microsoft SQL Server 2008 and 2012 databases.
- Providing support for J D Edward databases as well.
Senior Oracle DBA
Responsibilities:
- Installed Oracle 11g Grid Infrastructure and Oracle Real Application Clusters, administer Clusterware, RAC, ASM.
- Setup and administer DataGuard. Support Data warehouse system (Oracle 11g & Oracle 12c), worked to improve the efficiency of data warehouse application through the use of indexes, materialized views and other techniques
- Assist Business Objects report team to tune and write better queries and join the objects.
- Support OLTP & DSS systems.
- Implementation, support, documentation of migrations/upgrades/installation from Oracle 9i, 10g databases to Oracle 11, 12c.
- Resolve backup and recovery issues with RMAN.
- Participated in the implementation of TDE (Transparent Data Encryption) on sensitive data/table columns for off-site backup tape storage etc.
- Shell scripting to maintain Oracle dump/audit directories space. My shell scripts will successfully delete Oracle dump files and audit files several months old. Shell scripts are run as cron jobs.
- Effective performance tuning/SQL tuning.
Senior Database Administrator (Oracle DBA/Oracle Applications DBA)
Responsibilities:
- Responsible for Oracle Systems and UNIX Servers
- Experienced on Oracle technology architecture Oracle E-Business Suite/ Oracle Application DBA.
- Installation and Configuration of FUSION Middleware.
- Communicating Between Vendors Users & Management
- Working with Oracle Support and writing tars and solve the problems
- Installation, configuration and support, upgrade of Oracle Applications
- Management of Production database systems, migration of Database and Disaster Recovery
- Performance monitoring, Instance tuning, SQL tuning
- Hot/Cold backup mechanisms for weekly and daily backup
- Oracle Concurrent Managers Configuration and management
- Oracle Apps Patch Management and Patch Migration Process
- Unix Administration, Instance cloning
- Provide future direction and guidance on application deployment/support plans
- Porting of Oracle Database across different OS Platforms
Oracle DBA
Responsibilities:
- Install/configure/administer Oracle 10G RAC 3 node cluster on Linux.
- Setup Oracle 10G DataGuard (both physical and logical standby).
- Database design -- converting logical to physical design using Erwin.
- Proactive & reactive performance tuning. SQL tuning on table joining, applying different sorting algorithm, add/rebuild index & hints to improve query performance. I have tuned one script from running 4 days (before tuning) to within one hour (after tuning).
- Installation, upgrade on various versions of Oracle databases.
- Regular Security patching on oracle products and interim patching for various bug fixes on database products.
- Worked on VMware.
- Administer SQL Server 2005.
- Implement replication with Quest Shareplex.