We provide IT Staff Augmentation Services!

Oracle Dba Resume

2.00 Rating

OH

SUMMARY

  • With 8 years of experience in Oracle Database Administration in different versions of Oracle Products inEnterprise(9i, 10g &11g, 12c).
  • Proficient in performance tuning in largeOLTP(1.8 TB) and data warehouse environments
  • Oracle Enterprise Manager Grid (10g, 11g) - upgraded 10g (10.2.0.4) to 11g (11.1) (including agents upgrades, etc.)
  • Experienced in devising backup and disaster recovery(including RMAN) strategies
  • Involved in data access rules and security (role based access)
  • Implemented Change Tracking File with RMAN and reduced the backup time significantly
  • SQL & DB Tuning,Proficient in Application and Database Performance Tuning (SQL Profiles, AWR,ADDM, Tuning Memory, Tuning I/O, Wait Event, used 10046 trace levels to track SQL statements, analyzed high CPU spikes, etc)
  • Implemented and configuredASM, Data Guard, Data Guard Broker
  • Built Oracle RAC environment in mission critical largeOLTPsystems
  • Involved with Standards, Capacity planning (trend analysis - monthly/quarterly growth)
  • Recommendations for Strategy for Patch Implementation (CPU’s & PSU’s) - including patch conflicts
  • Trainedfundamentals and advanced replication withGolden Gatesoftware, working with users to resolve replication issues and implemented Oracle Streams for data replication
  • Interacted closely with Change Management Team, Configuration Management Team, Development & Testing teams, etc. - Implementation of DB schema changes as per approved Work Request
  • Extensively usedOracle Enterprise Manager (OEM),Toad and SQL navigatorfor maintaining and monitoring databases
  • Excellent understanding ofOracle Internals, Architecture,Data Dictionary,Data Management,Automatic Storage Management (ASM)and System Management
  • Implemented Cross Platform Transportable Tablespaces to move large databases across platforms
  • Created, Upgraded & Maintained Oracle databases on different flavors of UNIX & Windows environments
  • Experienced in Cloning the database using cold and hot backups
  • Worked in Maximum Availability Architecture environment
  • Good problem solving,communication, interpersonal and superior team skills.
  • Co-ordination with other IT team managers and support teams to ensure the Business Ops are not impacted
  • Knowledge of DB2, SQL Server, etc.
  • Comfortable with managing large Oracle database

TECHNICAL SKILLS

Operating Systems: AIX, Linux, Red HatEnterpriseLinux, HP-UX, SCO, Sun Solaris (5.6/5.7/5.8/5.9 ) and Windows 2000/NT/XP, Mikrotik

RDBMS/Databases: Oracle 12c,11g,10g, 9i, 8i, DB2, SQL Server

Storage Technologies: Oracle ASM,VeritasNetbackup

Virtualization Technologies: VMware, Oracle Virtual Machine

DR Technologies: Oracle Data Guard, Data Guard Broker Oracle Streams,Golden Gate

Backup recovery Tools: RMAN, flash recovery

Programming Languages: SQL, PL/SQL, UnixShell Programming, Java, VBScript, C, C++, HTML.

Tools: Oracle Enterprise Manager (OEM),, Oracle Performance pack,, TOAD,Visual Basic, Office 2000/XP, Oracle 9i Developer suite 9.0.2, Oracle 11,SQL developer,, TIVOLI, Symantec ESM(Enterprise Security Manager), IBM Guardium, Control - M, EMC TimeFinder.

Utilities: SQL Loader, Exp/Imp, Data Pump,Expdp/Impdp, TKPROF,TRCAandStatspack, 10046 Trace, Oradebug

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle DBA

Environment: Oracle 10g,11g,RAC 10g,11g, AIX 5.x,6.x, Linux RHEL 5.x,SQL developer, Symantec Enterprise Security Management (ESM) tool for oracle database,IBM Guardium,Control-M for job automation, ITSM for change management, LDAP server 3.0,Cyber-ark Privileged Identify Management system, Enterprise Change Management System(ECMS), Enterprise Manager 11g Grid control, AIX System Performance Monitoring, VERITAS Net backup, UNIX Shell Scripts, TOAD, TKPROF and SQL*Net

Responsibilities:

  • Provided 24X7 database administration supports for production and QA/UAT/ DEVELOPMENT databases for customer clients.
  • Migrated databases 10g databases to 11g from AIX to Linux platform using data pump.
  • Assist in the evaluation of Oracle database and OEM technologies within company standards.
  • Installed grid 11.2.0.2 infrastructure software, ASM and 11.2.0.2 Oracle RDBMS software on RHEL 5.4 platform.
  • Applied various patches to cluster ware as well as Oracle RDBMS software.
  • Implement Grid based monitoring solution for large Databases.
  • Closely worked with Oracle support in resolving ORA-600, ORA-7445 and ORA-3113 issues.
  • Installed and configured OEM agent software.
  • Databases build on different platforms.
  • Configured ASM and Maintaining ASM Disks, Disk Groups, Instances.
  • Upgraded oracle 10g database to 11g database.
  • Used CSSCAN utility for character set migration from US7ASCII to UTF8 and closely worked with the dev team to fix the associated data loss issues.
  • Maintained both logical and physical standby databases using Data Guard.
  • Upgraded the grid/ASM infrastructure from 10.2.0.4 to 11.2.0.2.
  • Database Upgradation from 10.2.0.4 to 11.2.0.3
  • Installation and configuration of Symantec Enterprise Security Manager (ESM) for oracle databases.
  • Created Oracle External Tables (Flat files, CSV files, ASCII files) and handling issues related to External tables.
  • Resolved issues related to Materialized view refresh, performance and db-links.
  • Wrote scripts to manage db-links(private and public db links creation, password changing and dropping)
  • Tuned SQL queries with performance issues using tools like AWR, ADDM, TKPROF and Explain plan for optimum performance.
  • Monitor database security violation discovered by security compliance tool (ESM) and remediate issues as needed.
  • Implemented LDAP based name resolution method across all data-warehouse servers and managed the TNS entries.
  • Troubleshooting, Maintaining, Restoring and Recovering Clusterware components like OCR, VOTING DISK.
  • Wrote scripts for Tablespace Point In time Recovery (TSPITR) and carried out TSPITR to prevent blotched update operations.
  • Used Transportable Tablespace to move tablespace one database to another.
  • Analyzing the growth of tables and undertaking necessary re-organization of the database when required.
  • Responsible for providing application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple development applications.

Confidential, Bloomington, IL

Oracle DBA

Responsibilities:

  • Capacity planning, Install, configureOLTP, Data warehouse (DSS) databases( Oracle 9i & 10GR2) Either in shared environment/standalone environment as well as on VMware virtual machines.
  • Involved indatabase upgrade from 11.1.0.6 to 11.1.0.7for DEV and TEST environments.
  • Experience in configuring and maintaining OracleReplicationby usingOracle streamsfor Data replication from production system to Data warehouse on RAC Environment.
  • Implemented the database withASMstorage, skilled towards database tuning and hands on experience in database security (auditing), recovery, archival concepts and procedures.
  • Configured and ManagedASMdisks and disk groups through Grid Control utility.
  • Upgradethe production and development databases from9i to 10g
  • Created and maintainedstandby databasesusing databasereplication(Data Guard)for high availability.
  • Installed, Configured & Administeredgolden gate.
  • Cloned the database using scripts, cold/Hot backups and using RMAN
  • Regular monitoring of the databases withOracle Enterprise Manager, Grid Controlfor operational databases with high sensitivity alerts
  • PerformingSQL*Loaderjobs for loading data from text files
  • Actively worked onperformance tuningofinstance(SGAandPGA) andPhysicaldatabasethat included resolving fragmentation and disk contention. UsePartitioning and indexingfeature of Oracle 10g to improve performance.
  • ImplementedOLAPData warehouse.
  • Disaster recovery planning; implemented databasebackups and disaster recoverystrategies usingRMANanddata pump export, import.
  • Supported very large database with heavyOLTPand batch activities, Writing and testingPL/SQL procedures(stored procedure, triggers, function, cursors and packages) for maintaining tables, retrieving data from tables and managing users. Responsibilities included working with developers to tune the PL/SQL, SQL.
  • Designed and Implementeddatabase securityusingOracle roles and privileges.
  • Experienced in optimizing SQL andPL/SQL tuningusingCBO,explain plan,TKPROF, STATSPACK, ADDM, and AWR.
  • Involved Inquery optimizationand using rule based optimizers and cost based optimizers
  • Work with a geographically dispersed team forround-the-clockmonitoring ofproduction systems

Environment: Oracle11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, PL/SQL,RMAN,TOAD and SQL *Plus, Golden gate.

Confidential, Omaha, NE

Oracle DBA

Responsibilities:

  • Migration of 20TB database from existing 4-node RAC cluster (having 4 node DR) to new 4 node Cluster having its 4 node DR.
  • Writing PL/SQL code, having procedures function to migrate WAMU(Washington Mutual ) data into JPMorgan Chase databases .
  • Tuning of the queries in PL/SQL procedure to run efficiently
  • Migrated datafiles from one server to another using DBMS FILE transfer package.
  • Configured Streams on 2 node RAC cluster using Local capture and downstream capture.
  • Extensively worked on Streams environments, fixing day to day streams related errors, synchronizing table, restarting capture and apply process, monitoring streams lag and many other streams related activity.
  • Configured Table level and Schema level streams replication.
  • Worked on Table partitions tasks such as exchange partition, split partition etc.
  • Creating local and Global indexes and rebuilding indexes on table partitions .
  • Written shell scripts for archivelog destination monitoring, alert log monitoring for specific ORA errors, scheduling jobs using crontabs and DBMS scheduler.
  • Upgradation of databases from 9i to 10g.
  • Generating AWR reports to deal with performance issue.
  • Written scripts to monitor tablespaces, file systems .
  • Applied CPU patches and other patches for bug fixing.
  • Providing on-call support for database monitoring
  • Loading data from flat file to tables using SQL loader.
  • Transferring data using DB-Links, SQL Loader, import-export and datapump.
  • Creating SR with Oracle Support.
  • Scheduling backups using RMAN and creation of catalog databases.
  • Installed OS watcher on new servers.
  • Installed grid control Agents on new servers.
  • Provided 24X7 on call support having pager.

Environment: Oracle 10g,11g, Sun Solaris 5.9/5.10, AIX 5.3, RAC and Dataguard, Streams, OEM (Grid Control), RMAN, AWR, ADDM, ASM, PL/SQL, TOAD, SQL *PLUS, WinScp, F-secure.

Confidential, Portland,ME

Oracle DBA

Responsibilities:

  • Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms.
  • Backupof database Logical and Physical (hot and cold) procedures and also usingRMAN.
  • Perform database monitoring, capacity planning andperformance tuning.
  • Recoveryof database in case of database crash, disk/media failure, etc.
  • Provided System support for both development and24/7production environment.
  • Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux andDATAGUARDimplementation.
  • Performed capacity planning and sizing of databases based on input from business.
  • Taking care of allalerts for space issuesand user requests.
  • Created and Managed the Server Parameter file.
  • Managingdatabase security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Analyzed the database so as to allowOracle optimizerto choose best plan in executing the queries.
  • Configuration oftnsnames.ora, listener.oraand sqlnet.ora files afterupgradingdatabases.
  • Performed databasecloningfrom old system to new system.
  • UsedEXPORT/IMPORTfor table level and full database de-fragmentation.
  • Transported tablespacesbetween production and development databases.
  • Running scripts to check the status of databasessuch as growingtable sizes,extent allocation,free space, used space, fragmentationetc.

Environment: Oracle 10g, 9i RAC, Oracle 10ginterMedia, Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0,AIX,HP-UX,Solaris Windows Server 2000,VERITAS Net backup, UNIX Shell Scripts, TOAD, TKPROF and SQL*Net

We'd love your feedback!