We provide IT Staff Augmentation Services!

Database Architect,resume Profile

3.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
Experience

Confidential

Database Architect

  • Responsible for providing Exadata Database Machine support for many Managed Services clients at BIAS. Currently working with Home Depot on providing support on their Exadata Machines.
  • Responsible for managing Managed Services clients at BIAS 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

  • Designed and implemented Oracle RAC Real Application Clusters and Data Guard databases for many mission critical applications at Delta Airlines
  • Responsible for setting database standards, recommending/ implementing new database technologies within Delta Airlines
  • Lead Architect on the Database architecture team which is responsible for setting database standards, recommending/ implementing new database technologies within Delta Airlines
  • Designed and implemented Disaster Recovery plans for all Oracle databases within Delta Airlines
  • 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 Delta Airlines including delta.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 Delta Airlines
  • 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 Delta Airlines
  • 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

  • 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

Confidential

Member Technical Staff

  • Database maintenance and support to PROD/QA/DEV databases running on Oracle 7.x
  • Creating new databases as and when required and handling refreshes on DEV and QA databases from production database
  • Designing the Logical and Physical Layouts for databases
  • Administering security for the database
  • Proper sizing of SGA and Reducing Row chaining
  • Backup and Recovery of the database
  • Tuning the application SQL using Plan Analyzer
  • Reorganization of the Database at regular intervals to keep the database healthy
  • Development of stored procedures and database triggers for application

Confidential

Database Administrator

  • Support and maintenance of databases running on Oracle 7.x and Ingres 6.x
  • Defining all entities and attributes using Designer/2000 to form the logical design
  • Physical database design using Database wizard of Designer/2000
  • Estimating and Defining Table/Index sizes and defining all storage parameters
  • Database creation and maintenance
  • Backup and Recovery of the database
  • Tuning the database and the application SQL
  • Reorganization of the Database at regular intervals to keep the database healthy
  • Writing database triggers and stored procedures as required by the application
  • Installing Oracle and Ingres executables on Solaris, HP and SCO UNIX environments

We'd love your feedback!