Database Architect Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Oracle Exadata Database Machine Certified Specialist
- 19 years experience as an Oracle DBA/Architect and 23 years of IT experience
- 23 years in UNIX (Solaris/Linux/HP/AIX/SCO)
- Excellent experience in Designing, implementing and supporting Exadata, Oracle RAC, Data Guard and ASM
- Excellent experience in database design, implementation, performance tuning, EM (Grid Control), backup and recovery
- Extensive experience in designing and implementing Disaster Recovery plans for Oracle databases
- Expertise in designing very large database systems with high availability and scalability needs
- Have strong inter - personal skills, good written/verbal communication and logical thinking
- Adept at crisis management, trouble shooting, problem solving and negotiating
- Deep understanding of Technology with focus on delivering business solutions
PROFESSIONAL EXPERIENCE
Confidential
Database Architect
Responsibilities:
- Responsible for providing Exadata Database Machine support for many Managed Services clients at Confidential . Currently working with Home Depot on providing support on their Exadata Machines.
- Responsible for managing Managed Services clients at Confidential including interacting with executives and resolving issues/escalations.
- Provided database maintenance and support to 250+ (PROD/QA/TEST/DEV) (RAC / non-RAC and Exadata / non-Exadata) running mission critical applications on Oracle 10g/Oracle 11g for all Managed Services clients.
- Designed and implemented solutions for cross platform database migrations for various Managed Services clients
- Responsible for recommending and implementing new database technologies for all Managed Services clients
- Designed and implemented many Oracle 11g/Oracle10g RAC clusters (Real Application Clusters) for mission critical applications for Managed Services clients
- Designed and implemented solutions for PSU/CPU (Critical Patch Updates and Patch Set Updates) patching and11g upgrades for around 300+ databases at various Managed Services clients
- Designed and implemented Data Guard solutions for Managed Services clients
- Designed and implemented Grid Control solutions for Managed Services clients
- Designed and implemented backup and recovery strategies using Grid Control/RMAN for various Managed Services clients
- Designed and implemented Disaster Recovery plans for Oracle databases for our Managed Services clients
- Provided database tuning for various Managed Services clients
- Provided Remote DBA service reports to all our Managed Services clients on a weekly/monthly/quarterly basis
- Recommended and influenced Managed Services clients to apply security updates (Critical Patch updates) and Patch Set Updates (PSU) on Oracle infrastructure
Confidential
Senior Database Administrator - Oracle
Responsibilities:
- Designed and implemented Oracle RAC (Real Application Clusters) and Data Guard databases for many mission critical applications at Confidential
- Responsible for setting database standards, recommending/ implementing new database technologies within Confidential
- Lead Architect on the Database architecture team which is responsible for setting database standards, recommending/ implementing new database technologies within Confidential
- Designed and implemented Disaster Recovery plans for all Oracle databases within Confidential
- Designed and implemented Enterprise level backup and recovery strategies using Netbackup/RMAN
- Responsible for setting service level agreements for the DBA department
- Primary/Lead DBA on many mission critical databases for Confidential including Confidential .com database, Data Warehouse database for Network Revenue Management, Flight schedule database and Customer Notification System database
- Provided database maintenance and support for 150+ (PROD, TEST and DEV) databases running on Oracle 8i, 9i and 10g.
- Created new databases/schema’s as required by new applications that are implemented at Confidential
- Implemented Oracle databases on NetApp Filers, using NetApp snapshots as backup methods for databases
- Responsible for tuning Oracle databases and teaching developers in writing efficient SQL statements
- Implemented Oracle Internet Directory within Confidential
- Upgraded databases from Oracle 9i to Oracle 10g and from Oracle 8i to Oracle 9i
- Provided 24X7 production support for high availability and mission critical airline systems
- Team Lead for one of the Oracle teams consisting of 8 DBA’s
Confidential
Senior Database Administrator - Oracle
Responsibilities:
- Support and maintenance of PeopleSoft HR and PeopleSoft Financials databases running on Oracle 8.0.5 and Oracle 7.3.4
- Designing the logical and physical layouts for databases
- Converting MS SQL Server databases to Oracle 8.0.5
- Reorganization of databases at regular intervals to keep the database healthy
- Designing and implementing of backup and recovery strategies
- Performance tuning of databases
- Capacity planning for new and existing databases
- Administering security for the databases
- Development of stored procedures and database triggers
- Providing support for installation and upgrade of FLS software on the PeopleSoft Human Resources database
- Providing database support for PeopleSoft Upgrade from 4.0 to 6.0