We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

5.00 Rating

Ann Arbor, MI

PROFESSIONAL SUMMARY:

  • Oracle DBA with around 8 years of professional experience in large - scale production environments across multiple platforms.
  • Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.Hands-on experience withOracleReal Application Clusters (RAC), 10g/11g/12c, Golden gate and Data Guard.
  • Experience as anOracle DBAin various domains to deliver new products, upgrades withOracle 12c/11g/10g/9ion Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIXandWindows platforms.
  • Experienced in Installation of high availabilityRACenvironment(2, 3 and 4 node clusters)and upgradedstandalone databases to10g/11g/12c RACenvironment.
  • Experience with data migration from physical server to virtual machines.
  • Familiar with fitting up virtual machines for oracle 12c/11g/10g installations.
  • Experience inReal Application Clusters (RAC)setup, configuration, and cluster interconnection withAutomatic Storage Management (ASM), configured user log on load balancing and failover onRACdatabase for high availability.
  • Experience in upgrading databases (10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
  • Planned and implementedDR & high availability solutionsusingOEL 10g Standby DatabaseusingOracle Data Guard,11g and 10g RAC.
  • Experience in building Standby databases. ImplementingFSFO(Fast start failover) on databases and configuringdisaster recovery siteusingDataguard. Also proficient with new 11g features such asActive DataguardandSnapshot standby database.
  • ImplementedGoldenGatefor Standby Configuration and developed procedures for Replication.
  • Performed data replication, transformation and delivery of database transaction usingGoldenGatereplication tool.
  • Implemented Active-Active Oracle Streams Replication for 99.99% database high availability over WAN.
  • Worked with Golden Gate Active-Active (Bidirectional) Replication.
  • Proficiency with Installation and maintenance of replication toolGoldenGateby creating extract process, extract pump, and replicate.
  • ImplementedGoldenGatefor data recovery and data migration forOracle 11gR1 RACmulti nodes onIBM AIXand debuggingGoldenGateissues such as extract, replicate rebuild and abend.
  • Proficiency with creatingGoldenGateextracts process, extract pump, fan out pump, and replicate.
  • Laid hands on new tools and experienced features likeData Replay, Log MinerandFlashback data Archive, Schema Management, Data guard and RMANin Oracle 11g.
  • Experienced in using11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
  • Experience in using OEM, TOAD, and Data Migrations using export/import, ATG, benchmarking using Load testing tools.
  • Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
  • Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution and Defrag scenarios across diverse environments.
  • Extensive knowledge in Database Cloning usingRMAN, VERITAS, Net Backup, IBM Tivoli Storage Manager (TSM).
  • Strong experience inHot/Cold BackupsandPoint-in-time Recoveryproceduresusing RMAN.
  • Proficient in administration activities likeInstallation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
  • Experience inbasicandadvanced replicationusingOracle Streamsand experience in usingOEM, TOAD, data Migrationsusingexport/import, benchmarkingusingload testing tools.
  • Hands on experiencein SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
  • DeliveredSQLand Database performance tuning services viaV$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps for9i/10g/11g.
  • Extensive experience onOEM, TOAD(Tools for Oracle Application Developers),SQL*PlusandSQL*Loaderas well as traditional UNIX command that requires for Oracle DBA.
  • Worked on POC on OEM 12c Cloud, installed in all our non - prod databases, have good knowledge on 12c.
  • Worked on building and rolling out new 12c databases for test/dev./qa environments.
  • Documented all Oracle 12c installation/upgradation work and derived KT to all team peers
  • Experience inData Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
  • Engineeringof the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
  • Experienced with installing, configuring and administeringSQL server 2000/2005/2008 databasesincluding migration fromMS SQL server to oracle.
  • Good experience inMSSQL server 2000/2005/2008 , T-SQL with knowledge ofServer Clustering, SQL Profiler, Execution plan,LogShipping,andDatabase Mirroring.
  • Experienced in day-to-day DBA activitiesincluding schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs,UNIX Shell Scripting.
  • UsedCronjobs to automate many DBA tasks.
  • Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
  • Transferring compressed files onFTP servers, onUNIXplatform.
  • Participated in24x7on-call rotation, off-hour production problem resolution activities.
  • A self-motivated, responsible and reliable team player with a set of strong technical skills.
  • Excellent analytical, interpersonal and communication skills.
  • Eagerness towards learning new technologies.

TECHNICAL SKILLS:

RDBMS: Oracle 9i/10g/11g/12c, Oracle 10g/11g RAC, Performance Tuning, Backup and Recovery using Cold, Hot and RMAN and Other Utilities

Operating Systems: HP: UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Red Hat Linux 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005, Windows 98/ME/NT/2000/XP

Languages: C, C++, Java, VB, PHP, XSLT, XML, SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Golden Gate, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Oracle Virtualization, Migrations.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH.

EXPERIENCE:

Confidential, Ann Arbor, MI

Sr. Oracle DBA

Responsibilities:

  • Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)&11g Release 2(11.2.0.2,11.2.0.3) upgrades on all the environments (in a procedural approach Dev., Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
  • Setup Oracle VM 2.2 and 3.0 environments for Development and Production. Installed Oracle VM manager, setup and configured all VM Server hosts and VM Server guests.
  • Managed VM's using VM Manager and OEM Grid 12c. Production was initialized using OEM 12c Virtual Pack.
  • Setup management of Virtual Environment with OEM Grid 12c. Upgrade 2.2 to Oracle VM 3.3 configured all Monitoring via Grid Control and VM Manager.
  • Experience with data migration from physical server to virtual machines.
  • Supported Oracle 11g databases for Sap and PeopleSoft applications.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
  • Experience in Oracle OEM Grid Control 12c.
  • Experienced in installing and setting up Oracle12c, 11g R1/R2, 10g, 9i databases.
  • Worked on POC on OEM 12c Cloud, installed in all our non - prod databases, have good knowledge on 12c.
  • Experience in Oracle RAC 11.2.0.3, built and supported 45 RAC Databases with 2-node Cluster for MCA Applications.
  • Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafiles testing.
  • Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Setup and Configured 11.2.1.0 GoldenGate replication on Exadata V2.
  • Oracle Golden Gate 11g replication (implement & manage active/passive & active/active)
  • Setup Active-Active (bi-directional) replication using Golden gate with conflict resolution.
  • Softwareand firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching.
  • Softwareand firmware maintenance of the InfiniBand switches in the Database machine including upgrades and patching.
  • Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
  • Upgraded oracle database on Exadata V2 cluster using oracle export/import utility.
  • Experience with Replication concepts and used Golden Gate Software to do the replication.
  • Implemented backup policy using oracle RMAN.
  • Managing, troubleshooting and resolving oracle database, RAC and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose
  • Was involved in developing a disaster recovery (DR) plan.
  • Performed Switchover and failover using both OEM and Dataguard broker.
  • Performing Backup/Recovery of all the Oracle databases using RMAN.
  • Performed RMAN backups including Full, and level 0and level 1 Incremental Backups as required.
  • Expert scripting experience in Perl and all UNIX shell scripting variations.
  • Experience on Storage migration from SSD to ZFS appliance.
  • Reading Alert Logs and User trace Files and Diagnosing the Problem.
  • Created Physical Standby Database for Active Production Databases.
  • Managed Golden Gate Databases and worked with application team/Development Team in Troubleshooting Issues.
  • Reading Alert Logs, GGS Error Logs and User trace Files and Diagnosing the Problem

Environment: Oracle 12c, 11g, 10g, RAC, OLTP, EMC Storage, Oracle Golden Gate, LINUX - Redhat, UNIX - AIX, Grid Control, Oracle Virtualization, AWR, Spotlight, TOAD, SQLT and SQL Backtrack. Import/Export,Datapump, Oracle dataguard.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

  • Involved in the installation, configuration and support ofOracle 11g R2databases.
  • Supported production and 300 plus development and testing databases with database ranging from 2TB to 16TB.
  • Installed Oracle VM Manager 2.2 and 3.0.2, installed VM Servers, configured networking and SAN Storage, setup multi-pathing.
  • Installed HA availability with Server Pools to enable failover and live migration.
  • Setup Oracle OEM Grid 11g to monitor and provision VM servers. Setup backup and recovery and all performance tuning. Upgraded VM 2.2 to 3.0
  • Experienced in utilizingGolden gate replicationtechnology for ORACLE Upgrades.
  • Installed Oracle 10g onProduction DB Servers, applied Opatch to fix the known bugs.
  • Involved in assessing client’sData Warehousing requirements, system analysis, and simulation of events using aDecision support system.
  • Involved in System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System
  • Demonstrated experience in managing Oracle9i and 10g RACenvironments using theOEM Grid Control tools.
  • Actively participated in installing of11g RACon Linux environment with two nodes andASMas storage.
  • Upgrade and Migration of Databases from10g R2 to 11g R1and applying patches as per requirement.
  • Worked withGolden Gateto move large volumes of data between oracle servers.
  • InstallingASMenvironment and migrating database from NON-ASM to ASM
  • Performed advanced replications using Oracle Streams
  • Worked on Distributed Database Configuration, Creation of Database links and Snapshots usedStreamsfor 2 wayreplicationof data.
  • Extensive experience inGoldenGateinstallation/setup/administration/troubleshooting and tuning.
  • UsedGoldenGatein moving large amounts of transactional data with minimal impact to online systems and performingGoldenGateon process of extract and replication of single instance as well asRAC Databases
  • ImplementedGolden Gatefor data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debuggingGolden Gateissues such as extract or replicate rebuild and abend.
  • Performed documentation forClusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.
  • Highly experienced in usingSTATSPACK, AWRreports to check health of database & hardware.
  • Good Intensive Knowledge in using operating system command line utilities likeSAR, TOP, MPSTAT, VMSTAT
  • Proficiency in using tools suchas TKPROF; EXPLAIN PLAN, ORADEBUGandTRACE FILEto tune SQL Queries.
  • Performed databaseCloningusing hot backup and cold backup to setup test and development database.
  • Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
  • Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.
  • Created Parameters and Environment variables to run the same job for different schemas
  • Experienced with all kinds(Status, Performance, Trend Analysis) ofDB MONITORING
  • Experienced withSRVCTLfor monitoring and configuring RAC Environment.
  • Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
  • Designed and Generated shell scripts to automate the processes and to proactively monitor the database.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Appliedcritical patch updates (CPU)released by oracle quarterly.
  • Experienced withDATA GUARDimplementation and Point in time Recovery.
  • Implemented oracle high availability solution usingoracle 10g PHYSICAL STANDBY.
  • Importing data from flat files into database using SQL loader and External Tables.
  • Designing and implementation of database backup/restore methodologies,troubleshooting performanceandnetworking issues. General OS administration.
  • Developed scripts for startup/shutdown, Disk Monitoring health check of databases and scheduling of backups.
  • Installing 12c grid and monitoring PROD databases/applications.
  • Provide support in the daily administration of SOX monitoring tools deployed within the client Oracle Applications environment.
  • Provide after-hours support during critical activities such as month end closing/opening procedures.
  • Was involved in developing a disaster recovery (DR) plan.

Environment: Oracle 11g,10g, RAC, OLTP, EMC Storage, Windows 2000, Oracle Golden Gate LINUX - Redhat, UNIX - AIX, Grid Control, AWR, Oracle Virtualization, Spotlight, TOAD, OSW, SQLT and SQL Backtrack. Import/Export, Datapump, Oracle dataguard.

Confidential, Jersey city, NJ

Sr. Oracle DBA

Responsibilities:

  • 24x7Oracle Production Database Administration including Oracle10g/11gRAC.
  • Installed, configuredand maintained Oracle Databases.
  • Installed and configuredOEM GridControl to monitor all databases.
  • Establishing standards, policies and procedures forGoldenGatereplication administration.
  • Responsible for installing and configuringGoldenGate 9.5 on Oracle Servers
  • Managing, troubleshootingand resolving oracle database, RACand applications issues.
  • Involved inUpgrade/Migrationof the oracle databases from Oracle10g to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux).
  • Implementation of High Availability solutions withOracle 10g RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Golden Gate.
  • Developed back-end logic for business applications, e.g.Views, procedures, functions, packages, triggers.
  • Developedscripts and reportsusing SQL, PL/SQL andPerl.
  • Designed and implemented OracleReal Application Clusters (RAC)on Solaris withEMC Storagefor anOLTP applicationwithTransaction Application Failoverandhigh transaction volume.
  • Established best practices and best procedures for database administration. Responsible for Software life-cycle support to includemigrationof all custom application changes through four different instances to production.
  • Standby Database (Data Guard)setup and configuringDB links.
  • Developed 2 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
  • Monitored/managed2 node RACenvironments, databases usingOEMGridcontrol, and RMAN database backup and recovery.
  • Migrated databases using cross platform transportable tablespace feature and RMAN convert functionality to perform database conversion.
  • Worked on agent related issues inOEM.
  • Working alongside programmers and contributing to the development process; Enabling and analyzingtrace files
  • Defining and Settingbackup and recoveryprocedures.
  • Performed and tuned using AWR,OEMGridand tkprofOracleDatabases.
  • Tuningthe database usingstatspackand custom scripts.
  • Responsible for continuous database monitoring and reorganization for ensuring performance
  • Tuningand balancing I/O by monitoring file system and tablespace I/O statistics.
  • Experienced inTuning SQLstatements usingExplain Plan, SQL Trace, TKPROF and STATSPACK
  • WritingShell Scriptsfor managing day-to-day activities andautomation of backup.
  • Optimal Space utilizationin tablespace by avoidingfragmentation.
  • Usage ofPartitionsto improve the queryperformance and manageability.
  • Installation ofOracle RDBMSserver software andversion upgrades.
  • Backup of Database(Making Backup Schedules depending upon Business Strategy: DailyBackup, weeklyBackupetc.)
  • SQL and PL/SQL Programming.
  • Installation and configurationof Oracle Client software and Tools.
  • Analyzed the user requirements anddesigned partitioned tablesfor improving performance of Data marts.
  • Analyzed the user requirements andDesigned views using STAR schemafor improving performance of Data marts.
  • Performedpartition maintenanceand automated the process ofcreating new partitionsas and when required.
  • Automated the process of analyzing table spaces every night.

Environment: ORACLE, SQL*Plus, OEL 10g/11g, Red Hat Linux 4.x, RAC, Solaris 10, IBM AIX 5.3,Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp.

Confidential

Oracle DBA

Responsibilities:

  • Supported 24x7 Oracle Production Databases of RDBMS10g/11g on SAN with different RAID levels.
  • Installed and configuredOEM GridControl and centralized the monitoring for all databases.
  • Managing, troubleshooting and resolving oracledatabaseissues.
  • Refresh/Cloning of Database for development and testing purpose.
  • Setup and configure MSSQL Server2005 for other business functions.
  • Performed Oracle Database upgrades from10g R1 to 11g R1.
  • Involved inUpgrade/Migrationof the oracle databases.
  • MigratedDatabasefrom Oracle10g to 11g R1 RAC to achieve high availability of production database.
  • Standby Database(Data Guard) setup and configuration.
  • Working with programmers at early design stage to choose right data model relationships, creating required indexes and materialized views.
  • Developed back-end logic for business applications, e.g.views, procedures/functions, triggers.
  • Coded and implementedPL/SQL packagesto perform ApplicationSecurity and batch job scheduling.
  • Performing monitoring and performance tuning
  • PerformedOracle Streamsreplication monitoring and tuning.
  • Implementation of High Availability solutions withOracle 11g RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Oracle Streams.
  • Played active role inmigrating database servers from Solaris 11.5.8 to 11.5.10 version.
  • Defining and Setting backup and recovery procedures.
  • Enabling and analyzingtrace files for any errors occurred while database runtime.
  • Performing monitoring and performancetuning using different tools like AWR, SQL trace, TKPROF, Explain plan.
  • Responsible for continuous database monitoring and reorganization for ensuring performance.
  • Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
  • Made use of the REF CURSORS in stored procedures for report generation.
  • Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
  • Expertise in Tuning SQL statements usingExplain Plan, SQL Trace, TKPROF and OEM.
  • WritingShell Scriptsfor managingday-to-day activitiesandautomation of backup.
  • Optimal Space utilization in tablespace by avoiding fragmentation
  • Usage ofPartitions to improve the query performance and manageability.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files).
  • SQL and PL/SQL Programming
  • Installation and configuration of Oracle Client software and Tools.
  • Data migration from legacy systems to Oracle Database for large Data warehouse with Multiple Data marts.

Environment: Oracle /10g/11g, PL/SQL, Oracle 11g RAC, Solaris, HP-UX,IBM AIX,EMC, Red hat Linux, NetApp, Streams, MS SQL Server 2005.

Confidential

Oracle DBA

Responsibilities:

  • Involved in the analysis, design, build, and testing phase of the life cycle for the project.
  • Developed PL/SQL packages to capture end of day transactions.
  • Implemented UTL HTTP oracle built in package to acquire data from external websites.
  • Preparation of design specifications document.
  • Involved in designing the database, identification of the objects and creating tables.
  • Designed and created database objects such as Tables, Views and Indexes.
  • Tested and corrected errors and refined changes to data base.
  • Implementing Database Security, Management of role-based security.
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Wrote scripts for Loading Data using SQL*Loader and Import/Export Assisting the developers in tuning the SQL for optimized performance.
  • Handling day to day activities along with schema and space management.
  • Creating primary database storage structures (tablespaces, datafiles, tables, indexesetc)
  • Planning for storage spaces requirements and placing them for optimum I/O performance.
  • Cloning databases using scripts as well as HOTBACKUP.
  • Extensively used Explicit Cursors in stored procedures.
  • Established database backup/recovery strategy for different databases.
  • Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER, Cronjob Oracle forms.

We'd love your feedback!