Oracle Database Administrator Resume
Harrisburg, PA
SUMMARY
- 9 years of experience in Oracle Database Administration.
- Perform various tasks like Database Design, installation, configuration, upgrades, patches, migration, performance tuning, backup and recovery, production support, cloning, space management, database security in production as well as development databases on variety of platforms for Business solutions.
- Extensive experience in Oracle Database Administration on 24x7 critical production and large databases using Oracle 12c,11gRAC, 10g RAC, and 9i.
- Implementation of high availability solutions with Oracle 10g RAC, 11g RAC, 12c RAC.
- Management of schemas, objects and Partitioning the tables & indexes.
- Experienced in creating USERS, GRANT privileges and ROLES to users.
- Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
- Installed and configured oracle Grid control (12c and 11g).
- Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
- Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Having extensive experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, up gradation and administration.
- Configured parameters for the unidirectional, Bi - directional replication.
- Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
- Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
- Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc).
- Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import.
- Experienced in using 12c, 11g features Data pump; Flash-Back Recovery, AWR, ASM, ADDM, and Grid Monitoring.
- Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, ASH.
- Working experience in both OLTP, OLAP environment.
- Excellent knowledge in tuning an OLAP system.
- Excellent Performance management skills on multi- terabyte Database environments.
- Very good knowledgeable on data guard physical standby databases, working, and managing of partitions and clustering of tables.
- Proficient in Oracle Architecture and concepts to support Data Warehouses.
- Extensive performance tuning experience, specializing in instance tuning, Oracle9i, 10g RAC, 11g RAC, 12c tuning and SQL optimization.
- Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
- Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
- Excellent experience using Oracle Real Application Testing (RAT).
- Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
- Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, and applied the data model changes in database.
- Installed and configured bi-directional Golden Gate for High data availability and Operational reporting.
- Trouble shooting and performance tuning golden gate replication.
- Experience with designing the existing architecture based upon the business requirement and applying the best Golden Gate Practice.
- Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process in heterogeneous environments like Oracle, DB2.
- Installation, Configuration and maintenance of Oracle 11gR2/12C on Exadata x2-2, x3-2, x3-8, X4-2.
- Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines.
- Experience in performance tuning, troubleshooting on Exadata machines. Gained Working knowledge of Linux, storage and network administration in relation to Exadata machines.
- Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines. Provided support for OS upgrades on Exadata running on Linux.
- Provided support for altering hardware on Exadata machines.
- Performed migration of databases from single instance database to Exadata machines.
- Knowledge on Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers.
- Configuring IORM/DBRM and Implementing Oracle Exadata best Practices.
- Upgrade the existing Golden Gate version environment to Golden Gate version 11.2.1.0.
- Prepare Golden Gate parameter files for Extraction and Replication.
- Investigate Replication failures using Log Dump utility.
- Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby databases and also to ensure disaster recovery, high availability and data protection.
- Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager.
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
- As Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience creating data mapping documents, writing functional specifications, queries.
- Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
- Good working knowledge in tuning the oracle databases.
- Expert in configuration of 11gRAC, 10gRAC, 9i on Linux, HP-UX and Solaris using ASM and RAW devices and Oracle CRS.
- Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
- Worked extensively with configuring database backups in RMAN environments using TSM, Net backup and CommVault backup utilities.
- Experience in ETL concepts and tools, expertise in performance monitoring and tuning.
TECHNICAL SKILLS
Databases: Oracle 8i/9i/10gRAC/11gRAC/12C.
Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP/7.
Languages: SQL, PL/SQL, UNIX Shell, Perl, C, C++, XML.
Tools: /Utilities: RMAN, OEM, TOAD, SQL*Loader, SQL Plus, Data pump Export/Import, Query builder, oracle golden gate 10.x, 11.x
DB Management: TOAD, OEM, DBArtisan, OEM Grid Control, SQL Developer.
Database Modeling: ERwin r 7.1/7.2/7.3/8, ER Studio V8.0.1 and Oracle Designer
Tuning Tools: TKPROOF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH.
Hardware/Storage: Exadata x2-2,x3-2,x3-8,X4-2, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers, VERITAS Net Backup, Tivoli Storage Manager (TSM).
PROFESSIONAL EXPERIENCE
Confidential, Harrisburg, PA
Oracle Database Administrator
Responsibilities:
- Implemented all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.
- Performed Installation, Configuration, troubleshooting, performance tuning and production support of Oracle 10g, 11g, 12C (Single Instance and RAC) databases on Sun Solaris, Red Hat Linux, and HP-UX environments.
- Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
- Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
- Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
- Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.
- Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
- Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, and applied the data model changes in database.
- Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility. Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures.
- Installed and configured oracle 12c and 11g Grid control.
- As Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience creating data mapping documents, writing functional specifications, queries.
- Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
- Performed Upgrade/Migration of Databases from Oracle 11g to 12C.
- Excellent experience using Oracle RAT. Used Database Replay to capture production workload on test systems.
- Creating new user accounts, profiles, and roles and assigning them to users.
- Assigning users to groups and granted privileges and permissions to appropriate groups.
- Worked on Performance management of multi- terabyte Database environments.
- Proficient in Oracle Architecture and concepts to support Data Warehouses.
- Worked closely with developers in schema design and SQL tuning, performed database capacity planning, performance tuning at system level, database level, and SQL level.
- Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
- Installed, Configured and Administered Golden gate.
- Configured parameters for the unidirectional, Bi-directional replication.
- Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
- Worked on Oracle Exadata Backup Configuration utility.
- Disaster recovery of Exadata Data guard Physical Standby.
- Experience with Oracle EXADATA machine deployment & Migrations.
- Good understanding of Oracle Exadata and HCC (high columnar compression ratio).
- Explored optimum utilization of Exadata cell index & HCC (COLUMNAR COMPRESSION).
- One Command configuration on Exadata.
- Configure Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
- Troubleshooting Exadata smart scan/offloading issues.
- Bare metal restore of Exadata DB node and CELL node.
- Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology
- Configuration, Administration and tuning of Golden Gate.
- Fixed performance issues in Golden gate by adding more processes and using Range distributions.
- Configured Golden Gate parameters for DDL Replication.
- Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
- Investigate Replication failures using Log Dump utility.
- Fixed performance issues in Golden gate by adding more processes and using Range distributions.
- Reporting and resolving all serious Oracle alert log messages.
- Installed and Implemented Backup & Recovery procedures. Implemented Hot and Cold Backups, Exports, Imports, Data Guard, Flashbacks.
- Successfully developed and implemented monitoring scripts, health check scripts, Database backup scripts.
- Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, LOGICAL STANDBY and PHYSICAL STANDBY databases.
- Involved in I/O tuning by moving data files and redo log files to faster disks.
- Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
- Proactively monitored the database systems to ensure secure services with minimum downtime.
- Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
- Conducted impact analysis on upgrades, security.
- Rollout database builds in various production and non production environments.
- Designing and managing logs, back-ups and recovery procedures using RMAN.
- Writing PL/SQL triggers, procedures, and functions.
- Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
- Optimized the query result cache for best performance.
- Performed logical and physical database design to support client customers.
- Ability to manage multiple instances in Dev/QA/Stage/Production.
- Prepared database structure and configuration for high-performance/high-availability through analysis and optimization.
- Performed database monitoring utilizing a combination of Oracle Grid Control and UNIX shell scripts.
- Provided 24*7 Production Support.
Environment: HP-UX 11.11, Oracle 12C, 11g, 10g and 11g RAC, Exadata x3-2,3-8,x4-2,4-8, golden gate 11.x, Sun Solaris, Red Hat Linux, TOAD, ERWIN r7/r8, RMAN, Data pump, SQL server, OEM, Grid Control, Data Guard, STREAMS, TKPROF, STATSPACK, Diagnostic and Tuning Advisors.
Confidential, Madison, WI
Oracle Database Administrator
Responsibilities:
- Performed Installation, Configuration, and Designing, troubleshooting, performance tuning and production support of Oracle 10 g, 11g, and RAC (10g and 11g R2) databases on Sun Solaris, Red Hat Linux, and HP-UX 11.11.1. Installation, Configuration, Designing and Maintaining of ASM on Oracle 10g.
- Installed and administered Real Application Cluster (10g RAC, 11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
- Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
- Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
- Performed replication using Oracle Streams.
- Tuned SQL queries & PL/SQL Applications using AWR, ADDM, STATSPACK and Execution Plans.
- Applied Patches on RAC, Standalone, Standby databases.
- Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
- Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
- Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
- Excellent Performance management skills on multi- terabyte Database environments.
- Very good knowledgeable on oracle streams, data guard physical standby databases, working, and managing of partitions and clustering of tables.
- Proficient in Oracle Architecture and concepts to support Data Warehouses.
- Wrote scripts for Backup of databases, export of databases and maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
- Used Data Pump for export and import.
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
- Installed and configured oracle Grid control. Assisted in management and database administration of Oracle database applications on Exadata platforms.
- Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
- Assisted in integration of Exadata applications into current IT actionable events and solutions.
- Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
- One Command configuration on Exadata. Maintaining Exadata hardware.
- Troubleshooting Infiniband/RDS performance issues.
- Migrating databases to Exadata. Setting and Monitoring Exadata using EM12c.
- Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
- Database Refreshing / Replication from production to testing using hot backup.
- Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
- Designed and Implemented replication solution in Oracle Databases using Golden gate 11.1
- Setup Active-Active (bi-directional) replication using Golden gate with conflict resolution.
- Set up monitoring, auto start, and auto restart in bi-directional replication in Golden gate.
- Fixed performance issues in Golden gate by adding more processes and using Range distributions.
- Troubleshooting Golden Gate issues such as process abending, and lag on replication environments.
- Investigate Replication failures using Log Dump utility.
- Fixed performance issues in Golden gate by adding more processes and using Range distributions.
- Involved in Data Warehousing, Data Modeling, Database Design and Creation.
- Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and STATSPACK snapshots and reports.
- Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
- Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
- Planned and configured disk layout, mount points and capacity requirements for servers.
- Provided maintenance of user accounts, privileges, profiles and roles.
- Managed undo segments, processes, memory, online redo log files, data files.
- Involved with OLTP relational databases system analysis, design, implementation and management.
- Used Erwin software for data modeling.
- Created logical and physical design, installed and upgraded databases.
- Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN).
- Documented the Standard Processes for peers to follow.
Environment: AIX 5.3, HP-UX 11.11.1, Sun Solaris 10 and Red Hat Linux, Oracle 11g, 10g, 9i, 10g RAC, Exadata x3-2,3-8,TOAD, OEM, RMAN, ERWIN r7.1/7.2, Data Pump, oracle golden gate 10.x, 11.x, Diagnostic and Tuning Advisors, SQL*Plus, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, AWR, ADDM, Data Guard.
Confidential, Augusta, ME
Oracle Database Administrator
Responsibilities:
- Installed and configured oracle 9i, 10g RAC on UNIX and windows environments.
- Responsible for administering and supporting production and development Oracle 9i, 10g Databases.
- Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
- Responsible for setting and managing user accounts, Granting required privileges to users.
- Creating primary database storage structures (table spaces, rollback segments, etc.)
- Monitoring Scheduled jobs of the daily activities for the performance of all the databases
- Prepare the documents of the process and knowledge transferring about the project to the new team members
- Applied patches, keeping applications software bug free, and improving data integrity.
- Developing, Testing and Implementing Sound Backup and Recovery Strategy.
- Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
- Developing Hot/Cold and logical backup scripts to automate the backup procedures.
- Planning for storage spaces requirements and placing them for optimum I/O performance.
- Tuning the databases for optimal performance.
- Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
- Applied High priority, security patches downloaded from MetaLink
- Monitoring the Database storage and Day to Day activities.
- Configured scripts to monitor activity with database.
- Cloned Environments to create Patch Test, Development and QA Environments
- Partitioned large tables to increase the performance.
- Created PL/SQL procedures (jobs) to automate maintenance tasks.
- Participated in Disaster Recovery Drills, documented database and application validation steps
- Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
- Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
Environment: Oracle 9i/10g RAC, Sun Solaris, Red Hat Linux, HP-UX, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, ERWIN, RMAN, ASM.
Confidential, Irving, TX
Oracle Database Administrator
Responsibilities:
- Worked as a team member for 24x7 supports inboth production and development environments.
- Installation and creation of 9i and 8i databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
- Applied High priority, security patches downloaded from Metalink.
- Performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
- Taking Backups on scheduled time and monitoring scheduled backups.
- Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAINPLAN.
- Experience with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
- Created UNIX Shell scripts for different database tasks and export/import for data transfer.
- Enabled security in creation of Database users, roles, privileges, profiles.
- Creating primary database storage structures (tablespaces) once developers have designed an application.
- Perform other regular DBA activities including schema management, space management and performance monitoring.
- To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
- Database maintaining including backups, recovery, imports/exports.
- Monitoring the database daily activities.
- Created materialized views, table partition for Tuned databases.
- Involved In query optimization and using rule based optimizers and cost based optimizers.
- Implemented Oracle security features and audit mechanisms for Fine grained access control.
Environment: IBM-AIX, Sun Solaris, Oracle 8i, 9i, 10g RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting, ERWIN.
Confidential
Oracle DBA/Developer
Responsibilities:
- Involved in production support activities 24/7 during on call and resolved database issues.
- Backup Script creation and Standardization. Performed Database Installation and up gradation.
- Created materialized views, table partition for Tuned databases.
- Created indexes, rebuild indexes and maintained indexes.
- Involved in user creation and user access control. Involved in Schema creation and management.
- Implemented Oracle security features and audit mechanisms for Fine grained access control.
- Maintained the RMAN repository and customized recovery catalog.
- Customized Data Guard as a tool for Disaster Planning and implementation.
- Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
- Performed database tuning for daily loads and slow response issues.
- Used Triggers for database activities, like delete, update triggers.
- Used STATSPACK, TKPROF utilities for Tuning and analysis.
- Involved in session management and monitored the critical wait events in the database.
- Involved In query optimization and using rule based optimizers and cost based optimizers.
- Used SQL* Loader for data import from remote databases
- Written the control files in SQL*Loader to load the files into database tables.
Environment: ORACLE 8i, 9i, SQL, PL/SQL, Toad, SQL plus, Import/Export, UNIX AIX 5.1, Windows NT, ERWIN.