We provide IT Staff Augmentation Services!

Sr. Oracle Dba/performance Lead Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Around 25 years of database administration, architecture, advanced oracle troubleshooting(AOT), advanced SQL tuning (AST), development, design data architect and data modeling (on various flavors of databases OLTP, Warehouses as well as blend of both i.e. Hybrid) & Consulting, Project Lead/Technical Management experience in the arena of full life cycle projects.
  • Experience includes administration of database system, analysis, performance monitoring &tuning, design, specifications, development, operations experience, problem resolution/debugging/troubleshooting, implementation & expertise in Oracle 7.x/8.x/8i/9i/10g/11g/12c/18c (Stand Alone &RAC) Database Administrations (DBA).
  • Expertise /Sound knowledge of Oracle Internals, Advanced Oracle Troubleshooting (AOT), Advanced SQL Tuning (AST), ORACLE Multitenant Architecture and DBA tasks.
  • Functional as Oracle DBA on Oracle Financials Databases, PeopleSoft Databases, OFSA Databases and custom application databases.
  • Sound knowledge of Big Data, Hadoop Ecosystem and Cloud Technologies
  • Conversant with Structured Design and Development methodologies.
  • Good Application knowledge in major applications systems like:

TECHNICAL SKILLS

  • ORACLE RDBMS 19c,18c,12, 11g, 10g, 9i, 8i, 8.0.x, 7.x
  • ORACLE RAC 11gR1 11gR2, 10gR2, 10gR1
  • Oracle Data Guard, Oracle Standby Database
  • Oracle Transparent Gateway
  • Oracle Applications 10.6(SC), 10.7(SC), 11.X
  • Oracle Enterprise Backup Utility (EBU) and RMANOracle Forms, C, FORTRAN
  • BMC Patrol, Oracle Enterprise Manager/ Grid Control /Cloud Control and DB Artisan.
  • HP 9000 K260 and K460, HP 9000 G - series
  • HP-UX V2600, HP UX 9000 series 64bit version 11.0
  • SUN Ultra-2, SUN4M-10, SUN E 4500, SUN E6500
  • SUN E420, SUN E220, SUN E250
  • IBM 7025-F50, IBM 7042/7043 ED
  • PCL Sever, DEC Alpha
  • HP-UX 10.10, 10.20
  • SUN SOLARIS 2.4, 2.5, 2.6, 2.7, 2.8 Solaris 10
  • IBM AIX 3.1, 4.1, 4.2
  • LINUX (Red Hat 3.0-7.0)
  • XENIX, SCO UNIX
  • Windows-NT Windows 2000 Windows XP Windows 2012

PROFESSIONAL EXPERIENCE

Sr. Oracle DBA/Performance Lead

Confidential

Environment: Red Hat Linux 5/6/7, Oracle 12cR2, Oracle 12cR1, Oracle19C

Responsibilities:

  • Primary responsible for Oracle Troubleshooting, Monitoring, Tuning of the database hosting application data.
  • Primary responsible for RMAN Backups and Recoveries of various flavors i.e. Complete, DB PITR, TSPITR, Table PITR, Recovery across incarnations
  • Setup and Configuration of multitenant architecture in Oracle 19C.
  • Multitenant - TDE setup, Clone PDBs, Refreshable PDBs, Partial Clones, No data Clones, PDBs Archives, PDB Relocate PDB Plug/Unplug, PDB Snapshot Refresh. Non CDB to PDB migrations as well as upgrades
  • Setup and configuration of separate Recovery Catalog Database as well as maintenance of it.
  • Responsible for upgrade of Grid/Oracle 11gR2, 12cR1,12cR2 on prod/test/dev env.
  • Responsible for Capacity Planning and sizing up the database .The current database sizes range from 100G to 5 TB and growing.
  • Responsible for configuring and Setting up the Oracle 11gR2/12cR1/12cR2 databases on dev/test/QA enc.
  • Was actively involved in implementation of the database Oracle 11.2.0.2 and subsequent upgrades of existing Oracle 11.2.0.4 Databases from application compatibility in functionality and with respect to performance.
  • Monitoring Scripts in prod env for performance and certain jobs/important events.
  • Data management using Partitioning options in Oracle 11g/12c e.g. Range Partitions(Using Time component as partition key), Composite Partitions and ListPartitions.
  • Very Large Object Management, assist in data loads, data movements etc.
  • Parallel Query Servers and Bulk Processing Techniques like CTAS, IAS, DirectPath Load etc. utilized to improve DB throughput and Performance.
  • Utilization of AWR ADDM ASH Reports, Top-N SQL Reports for statistical analysis and corresponding tuning of the Database.
  • SQL tuning, partition pruning, histograms and other new feature implementations on Oracle 11g/12cR1/12cR2
  • Database Duplication/Cloning using various methodologies Active/Backups/Target less etc.
  • Evaluations of new features to be implemented in prod env like Flashback technology
  • Setting up Disaster Recovery Solution (Data Guard) in Oracle 11.2.0.2 from scratch
  • Securing in flight data(using SSL or Oracle Native Encryption) and data at rest using TDE
  • Data Masking to prevent data proliferation
  • Systematic approach for advanced Oracle troubleshooting and performance tuning
  • Oracle, OS interaction and using OS-level tools for troubleshooting Oracle from “outside”
  • Use of pstack, strace O/S debuggers and oradebug
  • Troubleshooting crashes, ORA-600’s and complex hangs
  • Troubleshooting latch and mutex contention
  • Troubleshooting enqueue lock contention and deadlocks
  • Troubleshooting Oracle private, shared and OS memory problems
  • Troubleshooting Oracle cursor management and library cache problems
  • Troubleshooting buffer cache, logical and physical I/O problems
  • Troubleshooting undo errors, excessive redo and transaction related problems

Confidential

Sr. Oracle DBA/Performance Lead

Responsibilities:

  • Primary responsible for Performance Tuning of the database hosting application data.
  • Responsible for upgrade of Oracle 8.1.7.4 to 10.2.0.3 on prod/test/dev env.
  • Responsible for Capacity Planning and sizing up the database .The current database sizes range from 500G to 1.5 TB and growing.
  • Responsible for configuring and Setting up the Oracle 8i 10g 11g databases on dev/test/QA enc.
  • Was actively involved in implementation of the database Oracle 10.2.0.2 and subsequent upgrades of existing Oracle 8.1.7 Databases from application compatibility in functionality and with respect to performance.
  • Monitoring Scripts in prod env for performance and certain jobs/important events.Statements
  • Database Instance configuration with Automated Undo Management and TablespaceSpace Management.
  • Data management using Partitioning options in Oracle 8i/10g e.g. Range Partitions(Using Time component as partition key), Composite Partitions and ListPartitions.
  • Very Large Object Management, assist in data loads, data movements etc
  • Defrag database and recover space after archival of old data
  • Parallel Query Servers and Bulk Processing Techniques like CTAS, IAS, DirectPath Load etc utilized to improve DB throughput and Performance.
  • Cost Based Optimizer, Stored Outlines for Plan Stability, Bitmap Indexes,Partition-wise Joins, Function Based Indexes, Star Transformations and queryrewrite features used for optimum performance for data mining.
  • Utilization of STATSPACK, DBMS STATS, AWR Reports, Top-N SQL Reports for statistical analysis and corresponding tuning of the Database.
  • SQL tuning, partition pruning, histograms, CBO implementations and other new feature implementations on Oracle 8i as well as 10g
  • Evaluations of new features to be implemented in prod env like Flashback technology
  • Setting up Disaster Recovery Solution (Data Guard) in Oracle 10.2.0.3 from scratch
  • Installing & Setting up Oracle RAC 10.2.0.1 (two node) on Oracle Enterprise Linux 4.7 with ASM for evaluation purposes
  • Evaluation of New Oracle Features like AWR, ADDM, Scheduler, Real Application Testing(RAT),RMAN checksyntax (10g),READ ONLY tables(11g),RMAN Cloning using active database (11g),Data Recovery Advisor(11g),Flashback Database and Flashback table using restore points, Data Pump in 11g compress etc.

We'd love your feedback!