Sr. Oracle Dba, Account Lead Resume
2.00/5 (Submit Your Rating)
Irving, TX
SUMMARY
- A highly skilled ORACLE Certified DBA / Data Architect with 20+ years database experience encompassing ORACLE RAC, Data Guard, GoldenGate, relational and multidimensional database designing and implementation. A self - motivated, goal-oriented individual not only has the capabilities of working well in a team environment, but also has the initiative to lead a team.
TECHNICAL SKILLS
- ORACLE RAC, Data Guard and GoldenGate configuration, installation, administration, and tuning OEM GC installation, configuration and monitoring
- Database center migration
- ORACLE database administration for version 7.3, 8, 8i, 9i, 10g, 11g and 12c
- Database to database migration amount ORACLE, MS SQL Server and DB2
- Database support and database model implementation on different databases
- Relational and multidimensional database designing and implementation
- DB2 and SQL Server administration
- RH Linux, AIX, Solaris, HP-UX and Windows
PROFESSIONAL EXPERIENCE
Confidential, Irving, TX
Sr. Oracle DBA, Account Lead
Responsibilities:
- Lead a major customer account for 24X7 PROD support.
- Support, install and upgrade Oracle 11g/12c/18c RAC DB/Data Guard/GoldenGate in DEV/QA/PROD environments.
- Oracle OEM 12c installation, configuration and monitoring.
- Deploy database change for application.
- Perform DR test.
- Oracle RAC 11g/12c/18c DB performance tuning.
Confidential
DBA Team Lead, Application Service Management
Responsibilities:
- Lead onshore and offshore DBA teams responsible for 24x7 production database operation support, database problem management, database release management, and database.
- Support database maintenance, deployment, tuning in PROD/DR/PE/TEST/DEV environments.
- Implement and maintain Oracle RAC, Data Guard, GoldenGate, ODI, etc. database software package.
- Create and review database standard operation procedures, database security procedures and TDE implementation procedures.
- Make and implement database capacity plans and database version upgrade plan.
- Drive database tuning capabilities for better database performance.
- Setup and support database monitoring, manage production database P1/P2/P3 issues.
- Evaluate new database technologies to improve enterprise database performance, manageability and availability.
Confidential
Sr. Oracle DBA
Responsibilities:
- Provided 24*7 Confidential Home Loan production/dev/test database support.
- Installed Oracle 11G Enterprise Manager Grid Control; developed Used Defined Metrics/Reports.
- Migrated databases from data center in Irving to Little Rock.
- Supported, installed, patched and upgraded Oracle 9i, 10g and 11g databases in development, testing and production environment, including RAC.
- Provided performance tuning and database trouble shooting.
Confidential
Consultant
Responsibilities:
- Supported application upgrading for database.
- Tuned database and reduced application upgrading time from seven days to couple hours.
- Administered and tuned ORACLE production, development and QA databases. Developed OLTP, OLAP data models and ORACLE Cubes with ORACLE Analytic Workspace.
- Provided capacity planning for production, development and QA environments.
- Installed, administered and tuned ORACLE 10g, 11g databases. Backup production database and restore it to development and QA environment.
- Created and implemented relational and multidimensional database.
- Developed and implemented database monitoring program and data encryption project with ORACLE Wallet.
- Designed and developed ORACLE Cubes with OAWM.
- Migrated data from old application to new one.
Confidential
Sr. Oracle DBA/ Data Architect
Responsibilities:
- Designed logical and physical data model for IdM application.
- Served as primary point of contact of ORACLE database support, tuning and problem solving for R&D, QA teams and customers.
- Installed, administered and tuned ORACLE RAC, which played important role in winning a key customer.
- Performed Oracle tuning by using index strategy, Oracle parameters and execution plan.
- Created security procedures for data transformation, access control, encryption and privileges.
- Backup Prod DB and restore it to Dev and QA environment with RMAN.
- Created and implemented relational and multidimensional database.
- Executed capacity planning by profiling current database environment. Developed scalability plan for transaction scaling and data scaling for IdM database.
- Took the responsibility of database tuning at various areas in dev, QA and Prod database.
- Created high availability architecture for IdM by using RAC, DataGuard.
- Developed IdM database upgrade patches for IdM release.
- Installed and administered DB2 and MS SQL Server databases; migrated Oracle objects between these databases.
Confidential
Oracle DBA
Responsibilities:
- Designed and developed ORACLE relational database and data mart for e-business application.
- Responsible for ORACLE database development and testing.
- Installed and administered DB2 and MS SQL Server databases.
- Supported production database; backed up database with RMAN.