We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Jersey City New, JerseY

SUMMARY:

  • Seventeen years plus experience in Oracle database administration, performance tuning and design and development in Oracle 7.x thru 8i, 9i, 10g, 11gR2, 12c on UNIX platforms.
  • Four plus years of experience working on Oracle Exadata platform Exadata V2, X2 - X6 hardware, managing large TB sized databases, Exadata patching/upgrades/migrations
  • Oracle Active Data Guard (ADG) implementation as Disaster Recovery solution (Standby database) for production database
  • Involved in Disaster Recovery event for critical production database in which Exadata Storage Cells on production cluster were lost and quickly failed over to Data Guard Physical Standby to restore production database to meet SLA
  • Refresh QA/UAT databases using RMAN Active Duplication feature
  • Oracle Real Application Cluster (RAC) install/upgrade from 11gR2 to 12cR1, ACFS, DBFS
  • Oracle ZFS Storage appliance for Exadata Backup & Recovery
  • Oracle database upgrade from 10gR2 to 11gR2, 11gR2 to 12c, Oracle RAC PSU patch install
  • OEM 12c Cloud control to remotely manage, monitor/tune and deploy database systems
  • Oracle Transparent Data Encryption (TDE) to encrypt application tablespaces
  • Migrate large Oracle databases from Legacy platform to strategic platforms(DHP) for Credit-Suisse
  • Database migration and database refresh using transportable tablespace/RMAN Convert
  • Implemented Oracle Advanced Compression to reduce storage cost
  • Storage based ASM database migration as part of Hardware migration project
  • BCV and SRDF storage based replication as Backup/Recovery and DR site implementation for production
  • Migrated 1TB Oracle 10.2.0.3 database from Windows 2003 to Solaris 10 UNIX platform
  • Upgrade Oracle9i database to 10gR2/R3
  • Out-of-Box database monitoring with AWR and STATSPACK tool, Exawatcher, OSWbba
  • Develop database code and tune with Oracle SQL Developer tool (aka Project Raptor)
  • Data load using External Tables and SQL*Loader
  • Database Performance Tuning and application SQL code optimization
  • Backup and Recovery using RMAN, Online and offline backups, Data Pump export/import
  • Developed migration plan and rollout plan for database migration from Oracle8i to 9i R2
  • Install Oracle patches to resolve the reported development/production bugs
  • Database replication using Oracle Golden Gate
  • Upgrade database from 10gR2 to 11gR2 using Oracle streams to have little downtime
  • Materialized Views based data replication
  • Study the features of new oracle releases and advice upgrade/migrate database to new releases.
  • Install/Upgrade/Manage DB2 UDB v9.5/9.7 databases
  • SQLServer 2008R2 migration from SQL2000
  • Application migration from Forms 3.0 on Oracle 7.1 to Forms 4.5 on Oracle 7.3.4 under HP-UX 10.20 and Forms 4.5 to Forms 6i on HP-UX 11.0
  • Analysis, design and development of client/server application using oracle/D2K/informix under HP-UX 10.20 and Windows NT.
  • ETL - DataStage 7.5/8.1 administration
  • Unix Shell Programming, awk, make utilities, SSH setup
  • Oracle troubleshooting
  • SCME/Sablime Configuration Management System, nmake utilities

TECHNICAL SKILLS:

Database: Oracle 7.x/8.x/9.x/10gR2/11gR2,12c, Exadata RAC 11gR2/12cR1DB2 UDB 9.5/9.7, SQLServer 2000/2008 R2, Informix 7.x

Tools: OEM 12c Cloud Control, DBArtisan, Oracle SQL Developer, Oracle Forms6i, Designer 2000, Pro*C, TOAD, Oracle 10gR2/11gR1 EM Grid Control, RMANData Pump Export/Import, Sql*Loader, Informix SQL

ETL: DataStage v7.5/v8.1, Abinitio v2.15/3.0

Hardware: Oracle Exadata V2, X2-X6 systems, Oracle T4-4 server, M5000, HP V2500 with XP-512 Disk Array, HP N4000, HP 9000 (RISC Based) servers and Workstation, Sun Sparc E15K/T5240/M5000/Fujitsu servers, Compaq Proliant servers

Operating System: HP-UX 11.0, HP-UX 10.20, SCO UNIX, Sun OS 5.8/5.9/5.10 , Linux 5.6/6.5Linux on z/OS, Windows NT/2003, OS/2 WARP

Languages: Oracle PL/SQL, Informix 4GL, C

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, New Jersey

Senior Oracle Database Administrator

Environment: Exadata X3 Full Rack, Oracle RAC 11.2.0.4/12.1.0.2 on Linux 6.8, OEM 12c Cloud

Responsibilities:

  • Provide Oracle Platinum DBA support for databases running on Exadata platforms
  • Oracle Exadata RAC install/upgrade/patching large databases
  • RAC upgrade from Oracle 11.2.0.4 to 12.1.0.2
  • Database upgrade to Oracle 11.2.0.3 to 11.2.0.4
  • Implement Oracle Active Standby as DR for production database
  • Developed DBwallet tool for Oracle 11.2.0.4 to store SYS password credentials in Oracle Wallet to facilitate Data Guard switchover via DGMGRL without SYS password
  • Create role-based RAC services for Reporting module to connect directly to Active Standby
  • Setup weekly auto refresh of QA/UAT databases from production using RMAN active duplication method, Schema/Tables refresh using Data Pump Export/Import
  • Implement DBRM (Database Resource Manager) to limit resource utilization
  • ACFS and DBFS file systems setup
  • ASM Disk group reorg
  • Oracle Transparent Data Encryption (TDE) to encrypt application tablespaces as per Bank
  • OEM 12c Cloud Control to proactively monitor database availability, ASM Disk Group utilization, Database storage utilization and send OEM alert
  • Performance monitoring and tuning with AWR/ASH, database reorg based on segment advisor
  • Monitor OS performance data and trend analysis using ExaWatcher
  • Provide DBA support during application release by following Bank Change Control guidelines

Confidential, New York J an

Senior Oracle Database Administrator

Environment: Oracle 2-node RAC 11.2.0.3 on Solaris 10/T4, Oracle 10.2.0.5/11.2.0.3 on

Responsibilities:

  • Oracle RAC install/upgrade/manage large DW databases (30 TB size)
  • Storage based ASM migration/upgrade to Oracle 11.2.0.3 as part of Hardware migration to T4
  • Oracle RAC PSU patch install to resolve critical database issues raised by application
  • Deploy database changes for the application releases to production with change control procedures
  • Oracle EM Grid control 10gR2/11gR1 to proactively monitor database availability, tune and generate performance reports for databases/hosts
  • Performance monitoring and tuning with AWR, database reorg based on segment advisors
  • Monitor OS performance data and trend analysis using OSWatcher Black Box tool (OSWbba)
  • Proactively monitor ASM database storage utilization and raise storage WO to add storage to ASM Disk Groups/rebalance
  • Refresh non-production databases with production databases using ASM copy / RMAN active duplication, RMAN clone and data pump export/import based on the refresh requirement
  • Database upgrade and migration from Legacy platforms to DHP (strategic platform RHEL 5.6 64-bit) standard set by Credit-Suisse
  • Developed migration methodology for large databases migration to perform cross-platform Oracle 11.2.0.2 upgrade from source Solaris 64-bit (10.2.0.5) to target RHEL 5.6 64-bit (11.2.0.2)
  • Open SR (Service Request) with Oracle metalink support for production or development oracle problems and to study and finalize the right upgrade method
  • Work with application team in helping with resolving query performance issues
  • Developed Oracle Data Pump Export/Import scripts to speed up the data import
  • Developed Strategy to use Oracle Streams/Oracle Golden Gate tools to perform cross-platform 11gR2 upgrade with minimal downtime
  • Database performance monitoring and tuning via OEM 10g Grid control
  • Oracle Physical Standby Data Guard / BCV site for Production RMAN backup/recovery / SRDF for High Availability Disaster Recovery (DR) solution
  • Oracle 11.2.0.2.6 RAC/DB upgrade from 11.2.0.1
  • Upgrade RAC cluster from 11.2.0.1 to 11.2.0.3.2
  • Upgrade RAC database from 11.2.0.1 to 11.2.0.3.2
  • Oracle RAC 11.2.0.3.5 PSU patch upgrade

Confidential

Senior Database Administrator

Environment: Oracle 10gR2/11gR2 on Solaris 10 Zones (T5240/M5000 hardware) under VCS

Responsibilities:

  • Oracle physical database design to support Development, Testing and production environments
  • Maintain and deploy database schema changes for various ongoing release deployments
  • Oracle database upgrade from 10.2.0 to 11.2.0.1/11.2.0.2
  • POC on Oracle Advanced Compression and implementation
  • Maintenance of Partitioned tables/indexes/archiving old partitions
  • Setup Oracle10g EM Grid Control based Centralized oracle monitoring, managing and deployment for various environments
  • Oracle Physical Standby Data Guard as Disaster Recovery strategy for fail-over database capabilities
  • Provide on-call production DBA support on schedule basis for Sev-1 Oracle alerts
  • Monitoring/tuning databases with AWR/ADDM reports
  • Database cloning using RMAN, Backup and Recovery Procedures using RMAN Online/Cold backup, Data Pump export/import
  • Refresh development/test databases with production copy using transportable tablespace feature
  • Database replication and system migration using materialized views
  • Database Upgrade using Oracle Streams to have zero downtime
  • Test the Database performance before & after upgrade using RAT (Real Application Testing) tool
  • Data loading using External Tables capabilities and Sql*Loader tool
  • Study and apply the latest Oracle patch for bug fixing
  • Write Unix Shell scripts and PL/SQL scripts for interface automation/data loading/data purging
  • Enforce controlled access to application schema by end user/developer using separate db login/roles/permission models
  • Monitor Unix resource utilization using prstat, top, swap, vmstat commands
  • Application SQL tuning with Oracle SQL Developer using v$sql plan data dictionary view, DBMS XPLAN/AUTOTRACE and SQL TRACE/TKPROF, dbms profiler tools
  • Gather database statistics using DBMS STATS package
  • Writing Shell scripts to automate the daily processes using Oracle dbms scheduler and Autosys scheduler

Confidential

Senior Database Administrator

Environment: Oracle 9.2.0.6/Oracle 10.2.0.3 on Solaris 2.8/2.10, Data Stage 7.5 for ETLData Guard, Shareplex 4.5, Web logic 8.1, Business Objects 6.5,

Responsibilities:

  • Oracle physical database design to support Development, Testing and production environments
  • Maintain and deploy database schema changes for various ongoing DBOR release projects
  • Oracle upgrade from 9iR2 to Oracle 10gR3 and upgrade from 10gR2 to 10gR3.
  • Provide primary/backup on-call production DBA support on schedule basis for Oracle alarms and sev-1 pager requests
  • Oracle10g EM Grid Console based oracle monitoring, managing and deployment for various environments
  • Oracle9i Data Guard as Disaster Recovery mechanism for fail-over database capabilities, design/implement data availability using flip-flop schema mechanism
  • Monitoring/tuning databases with STATSPACK tool
  • Database cloning using RMAN, Backup and Recovery Procedures using RMAN, Online/Cold backup, Export/Import tool
  • Refresh development/test databases with production copy using transportable tablespace feature
  • Database replication and system migration using materialized views
  • Data loading using External Tables capabilities and Sql*Loader tool
  • Study and apply the latest Oracle patch for bug fixing
  • Write Unix Shell scripts and PL/SQL scripts for interface automation/data loading/data purging
  • Enforce controlled access to application schema by end user/developer using separate db login/roles/permission models
  • Monitor Unix resource utilization using prstat, top, swap, vmstat commands
  • Application SQL tuning with Oracle SQL Developer using v$sql plan data dictionary view, DBMS XPLAN/AUTOTRACE and SQL TRACE/TKPROF, dbms profiler tools
  • Gather database statistics using DBMS STATS tool
  • Writing Shell scripts to automate the daily processes using oracle dbms job and UNIX cron job

Confidential

Oracle Database Administrator

Environment: Oracle 9.2.0.6/10.2.0.3 on Solaris 8.0, iPlanet web server, Web logic App serverJava 1.4

Responsibilities:

  • Oracle physical database design to support Development, Testing and production environments
  • Maintenance of Database (Production, Test and Development)
  • Oracle10g EM Grid Console based oracle monitoring, managing and deployment for various environments
  • Monitoring/tuning databases with STATSPACK tool
  • Oracle upgrade from 8i to 9i, apply Oracle 9.2.0.6 patchset and CPUJAN2006 security patch
  • Database cloning using RMAN, Backup and Recovery Procedures using RMAN, Online/Cold backup, Export/Import tool
  • Refresh development/test databases with production copy using transportable tablespace feature
  • Database replication using materialized views
  • Data loading using External Tables capabilities and Sql*Loader tool
  • Advise application team to use database centric approach (example, saving session state in the database table rather than web server session)
  • Study and apply the latest Oracle patch for bug fixing
  • Oracle upgrade plan to 10gR2
  • Develop and maintain database schema conversion scripts for application deployment for various releases
  • Write back end DB code (packages, stored procedures/views/triggers) to support the application development or database automation needs
  • Write Unix Shell scripts and PL/SQL scripts for interface automation/data loading/data purging
  • Enforce controlled access to IOM application schema by end user/developer using separate db login/roles/permission models
  • Monitor Unix resource utilization using prstat, top, swap, vmstat commands
  • Application SQL tuning with Oracle SQL Developer using v$sql plan data dictionary view, DBMS XPLAN/AUTOTRACE and SQL TRACE/TKPROF, dbms profiler tools
  • Gather database statistics using DBMS STATS tool
  • Writing Shell scripts to automate the daily processes using oracle dbms job and UNIX cron job.

Confidential

Oracle Database Administrator

Environment: Oracle 9.2.0.3 on Solaris 8.0, Orbix 2000, Java 1.3, Tomcat web server

Responsibilities:

  • Physical Oracle9i database design to support Development, Testing and production
  • Tested and implemented Oracle9i Data Guard as Disaster Recovery mechanism for fail over database capabilities
  • Design and develop and maintain schema conversion scripts for application deployment for various releases
  • Use XML DB in storing, accessing and updating XML data in native format
  • Developed shell scripts and PLSQL scripts to do database purge of old data
  • Suggest development team to follow the best practices in writing efficient oracle code
  • Study and apply the latest Oracle patch for bug fixing
  • Maintenance of Database (Production, Development and Test)
  • Monitoring database activities using STATSPACK tool, Oracle Enterprise Manager, written SQL scripts for monitoring Unix memory usage, IO, monitor JDBC connections to database, poor performing queries, table locking
  • Monitor Unix resource utilization using prstat, top, swap, vmstat commands
  • Performance monitoring and tuning SQL statements using Oracle tools autotrace, tkprof, dbms profiler package
  • Analyze the database using DBMS STATSPACK to take advantage of good query plan for queries to run faster
  • Implemented new Oracle9i dynamic SGA sizing
  • Backup and Recovery Procedures using RMAN, Online/Cold backup, Export/Import tool
  • Writing Shell scripts to automate the daily processes using cron job.

Confidential, NJ

Database Administrator

Environment: Oracle 8.1.7.3 on HP-UX 11.0, Oracle9iAS 1.0.2, iPlanet Web serverOrbix 3.0, MQ Series 5.1.0, C++, Java 1.2, Oracle Developer 6i

Responsibilities:

  • Physical database design to support Development, Testing and production
  • Oracle9iAS environment setup and configuration for the application to access database
  • Design and develop and maintain schema conversion scripts for application deployment for various releases
  • Develop shell scripts and stored procedures, DB triggers, PL/SQL scripts to support Web development and one time migration
  • Suggest development team to follow the best practices in writing efficient oracle code
  • Developed migration and rollout plan to move forward ward with Oracle9i DB Rel 2.
  • Deployment of Database and Application to IT, System test and production
  • Maintenance of Database (Production, Development and Test)
  • Support test team in patching binaries on system test environment and control environment
  • Creating users, defining roles, GUI permission grants & DB access Confidential Oracle and Unix level.
  • Developed and maintain tool to support CDAT and GAT for application administration
  • Upgraded the oracle database from 8.1.7.0 to 8.1.7.3
  • Recreated the databases to move from Dictionary Managed tablespaces to Locally Managed tablespaces (LMT) for effective space management.
  • Creating database objects with tables, views, indexes, stored procedures, triggers etc
  • Using Hash table partitioning and index partitioning
  • Monitoring database activities using STATSPACK tool, Oracle Enterprise Manager, written SQL scripts for monitoring memory usage, full table scan, poor performing queries, table locking
  • Monitor Unix resource utilization using HP Glance Plus, top, swapinfo, vmstat commands
  • Performance monitoring and tuning SQL statements using Oracle tools autotrace, tkprof, dbms profiler package
  • Analyze the database to take advantage of good query plan for queries to run faster
  • Rollback segment sizing and monitoring
  • Maintenance of Backup and Recovery Procedures using Veritas backup, Online and offline backup, Export/Import tool.
  • Maintenance of standby database and disaster recovery procedures.
  • Setup database replication using Oracle Replication mechanism.
  • Writing Shell scripts to automate the daily processes using cron job.
  • Oracle Troubleshooting

Confidential

Database Administrator

Environment: Oracle 8i, Sql*Loader, HP-UX 11.0

Responsibilities:

  • Installation and configuration of Oracle 8.1.5 on HP-UX 11.0
  • Physical database design and implementation
  • Database cloning
  • Database table normalization
  • Creating users, defining roles, quotas, grants & providing access to resources, Confidential Oracle & Unix level
  • Creating database objects (tables, views, indexes etc) with proper storage parameters
  • Monitoring user access to the database
  • Capacity planning and database performance tuning
  • Creation of Database links to copy the tables from one database to another
  • Tuning SQL statements using SQLTrace, ExplainPlan and TKPROF tools.
  • Designed migration methodology to migrate existing system data from Foxpro to Oracle database
  • Backup and recovery using Hot backup, Cold backup and Recovery Manager
  • Oracle Troubleshooting

Confidential

Oracle DBA & HP-UX admin

Environment: Oracle 7.3.4, HP-UX 10.20, X-Windows and Exceed

Responsibilities:

  • Installation of Oracle 7.3.4, Developer 2000 on HP-UX 0 Servers
  • Migrating Oracle database from Oracle 7.1 HP - UX 9.0 to Oracle 7.3.4 HP-UX 10.20
  • Migrating Forms 3.0 Oracle 7.1 to Forms 4.5 Oracle 7.3.4 under HP-UX 10.20
  • Oracle database design, capacity planning and tuning
  • Creating databases, deciding on tablespaces, their physical location, splitting I/O across disks, sizing the roll back segments, redo log buffer & defining the necessary procedures for archive log mode
  • Database cloning
  • Data replication using snapshots, Creation of DB links
  • Monitoring Oracle database performance
  • Management of tablespaces, which included isolating tablespace fragmentation, monitoring free space on a weekly basis
  • Defining backup & recovery procedures, using Unix Shell Scripts and recovering databases in case of media failures either by full database back up or Export/Import
  • Developed scripts for automatic startup and shutdown database
  • Provide Oracle bronze technical support to Confidential
  • Interacting with the development teams and troubleshooting Application Problems
  • HP-UX installation and configuration and loading of patches
  • File system management
  • Deciding File system Vs raw devices benefits analysis
  • User maintenance
  • Monitoring disk space usage
  • Monitoring Unix performance using sar, top, vmstat, Glanceplus
  • Auditing unix log files
  • HP-UX OS tuning
  • Implementing system security on OS level
  • Writing shell scripts, awk and utilities
  • Backup using tar, dd, cpio and fbackup and recovery procedure

Confidential

Oracle DBA

Environment: Oracle 8, Sql*Loader, Windows NT4.0

Responsibilities:

  • Oracle installation, designer 2000 installation, database design and customization, normalization and denormalizations of database tables
  • Design of logical database, which included identifying entities & relationships, documenting various attributes, estimating sizes of entities using designer 2000.
  • Design of physical database, which included creating tables, views, synonyms, indexes, procedures, triggers, links
  • Creating users, defining roles, quotas, grants & providing access to resources, Confidential Oracle & NT level
  • Tuning SQL statements using Lecco SQL Expert tool, SQLTrace & ExplainPlan
  • Designed migration methodology to migrate existing system data from Foxpro to Oracle database
  • Performance tuning and monitoring
  • Designed Backup and Recovery methodology
  • Oracle Troubleshooting

Hire Now