Senior Oracle Dba Resume
CA
Objective:
- A Oracle DBA position with challenging responsibilities
Skills:
- Over 18 years of Oracle DB experience along with some recent experience in Mysql and MS sqlserver
- Over 15 years of that as an Oracle DBA; include OLTP, Data Warehouse, Oracle BRM and Financials
- Worked with31gRAC, 10gRAC, 10g, Oracle 9iRac, Oracle 8 and 8i, Oracle 7
- RAC experience includes 9i RAC, 10G RAC and 11G RAC and covers 4 years
- Experienced in Linux, Solaris UNIX, HPUX; Shell coding skills
- DB Tools utilized; Enterprise Manager, DB Artisan and TOAD. EM for MS sql server
- Performed performance tuning at the DB, SQL, Server, Storage, OS, and Network levels
- Setup DB Access Management system; SOX compliance, PCI Compliance
- Replication tools used; Shareplex, Materialized Views, Data Guard
- Performed Capacity Planning and Space Management
- Carried out Backup and Restores, Cloning; RMAN, wrote/used scripts. Worked with Netapps snapshots
- Performed installation and upgrades; 11g RAC, 10gRAC, 10g, oracle 9, oracle 8 and 8i, oracle 7
- Worked with Oracle Financials; installation, patches, upgrades (11i, 11.03, 10.7)
- Discoverer, Application Server 9iAS; installation, upgrades, patches
- Concurrent Manager Administration, WF tools
- Also worked on MYSQL databases + formal training and MS sql server
Accomplishments:
- Stabilized unstable DB systems through drive towards identifying root causes,
- ... implementing security systems and setting up effective monitoring systems
- Over-hauled with standardized architecture for improved performance and ease of management
- Prevented App or DB issues through disciplined and regular monitoring
- Maintained none to minimal issues during patches, upgrades and installs
- SOX compliance, PCI compliance and Standards Application
- All of these done through detailed planning, verbal and written communication,
- ... and through hands-on Project Management
Professional Experience:
Confidential,
Westwood, Ca
- September 2008 thru January 2010
- Senior Oracle DBA/ Hands-on DBA Manager for Oracle BRM, Engineering and DW/reporting Systems
- Worked with Oracle 10g and oracle 9i on Linux OS
- Performed Capacity Planning, Set-up Monitoring System, Carried out Backups, Restores and Cloning
- Developed Data Warehouse system; worked with SAP Front End tools - Managed Jobs and Users
- Participated in Oracle BRM application upgrade
- Performed SQL level, DB level and Server level tuning; index rebuilds, table analyze, etc
- Developed and Monitored security systems
- Helped trouble-shoot application issues; thru Web server, App Server, DB server
- Used Toad, EM and self-designed monitoring tool
- Replication with Materialized Views, BCP with RMAN, Data Guard
- Also worked with MS sql server 2000, 2005 and 2008, and Mysql databases
- Storage systems from Netapps, Toshiba and EMC
- Project Managed PCI security compliance, Overhauling of DEV/QA/SYS DBs and servers
- Project Managed DB Server Upgrades, Data Center relocation, MS sql server take over
- 24*7 Support
Confidential,
Acquired by Virgin Mobile, Sprint) Westwood/Pasadena, Ca
- Jan 2007 thru July 2008
- Senior Oracle DBA; Billing Systems (600 GB), DW (2 TB), Content serving systems
- Oracle 9, 10g, 10g RAC, 11G RAC on Solaris and Linux OS
- DB architecture design; 11G RAC design, install and setup - SAN versus NFS performance tests
- Administered 10G RAC based Revenue Management (3 nodes), and Data ware house (3 nodes) DB
- Security Systems; Defined/Documented policies, implemented on critical systems
- Monitoring systems; server and sql level - Wrote and implemented monitoring systems
- Performance tuning; server, I/O and sql; Analyzed tables, Rebuild indexes
- Standards; define and implement - team based
- Partitions Management
- Backup Management; Used RMAN and imp/exp utilities
- Application deployment; DB components
- Storage systems; EMC SAN and Netapps NFS - Raw and Veritas FS
- Tools used; Enterprise Manager, Toad, DB Artisan
- Oracle workshops - 11G and OEM
- Installed and configured Oracle Enterprise Manager; and set up over 60 client targets (DB)
- Mysql DB management; backups, restores, replication setup, space tracking, alerts management
- 24*7 Support
Confidential,
Ca
- Sept 2000 thru Nov 2006
- Senior Oracle DBA; Data Warehouse, Ad Serving DBs, and Oracle Financials
- 9i, RAC, 10g RAC, Oracle 9, Oracle 8 and 8i
- Data Warehouse DB
- Responsible for Advertiser system; 50 TB (Primary responsibility)
- This one also doubled as an OLTP DB for advertisers
- Monthly partitions management, Performance tuning,
- Backup/Restore (RMAN), Capacity Planning, BCP
- EMC SAN and Netapps NFS
- 24x7 Support
- Advertisement serving DBs;
- Geographically spread-out through-out the world
- Shareplex replication, Data Guard, Space Management, Performance Management
- Added Nodes to 9i RACs, Cloned them on a monthly basis
- Statspack, OS Watcher implementation
- 24x7 Support
- Oracle Financials/ 600 GB (Primary responsibility)
- Install, Patching, Upgrades, numerous Cloning
- Performance Tuning, Backup, Restore, Capacity planning
- Concurrent Manager administration
- Installation of modules such as HR, WF tools
- Security Management
- 24x7 Support
Confidential,
Ca
- April, 1996 thru Sep, 2000
- Lead/Senior Oracle DBA for Oracle Financials; 10.7 and Oracle 7
- Managed 5 DBAs; each responsible for specific application oracle databases
- Also assisted in administrating Manufacturing and Engineering oracle databases
- Performed Installation, Upgrades, Performance tuning, Capacity planning
- RMAN/export/import - Backup/Restore
- Developed DB/OF application Access System
- Installed developer, designer tools and support them
Confidential,
Ca
- August, 1993 thru April, 1996
- Systems Engineer
- Responsible for complete Oracle DB/server installations at customer sites
- Provide on-going DB/software/hardware support
Confidential,
- May 1991 - July 1993;
- Application Software Support; Oracle DB based Medical Claim processing application
- Provided software support to the hospitals through-out the USA.
- Develop/utilize Oracle sql scripts
- UNIX (AT&T); Shell scripts, Communication utilities.
- Hardware trouble shooting and support - provided on the AT & T computers.
- Designed and performed numerous tests to ensure software/hardware system functionality and reliability.
Education:
- MSEE curriculum; Course work in Logic Design, Digital Comm. and Digital Systems; Loyola Marymount University, LA
- MBA courses at California Lutheran University, Thousand Oaks, Ca.
- B.S. Degree in Physics, Gujarat University, India
- Course work in Microprocessors and Programming at UCLA and UC Irvine
- Oracle DB certification, Oracle Ware, Oracle Office, Oracle Mail
- Oracle Financials Suite; 11.03, 10.7 classes
- Mysql classes by Sun Microsystems
- UNIX classes at UCLA/Learning Tree and SCO Unix and Unixware certification
Other Education:
- Time Management at UCLA
- Presentation Skills at Xerox Learning Center
Other Skills:
- Action and Result oriented
- Passionate, Organized and Self-motivated
- Effective in both, individual and team environment
- Good software and hardware trouble shooting skills
- Good customer issue management skills
- Good verbal and written communication skills
- Good interpersonal skills
- Good training and presentation skills