We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Jersey City, NJ

SUMMARY

  • Senior Database Administrator with more than 11 years of experience in high volume/availability environments.
  • Expertise in testing, production and development settings. Great problem solving skills.
  • Thorough understanding of backup & recovery, database cloning and refreshing, security and monitoring configuration using Oracle enterprise manager, golden gate, RAC, performance tuning, PL SQL, data guard, FSFO in data guard & Oracle STREAMS.
  • Extensive experience as an Enterprise Manager (cloud control) administrator. Worked closely with Unix administrators and application developers.
  • Superb communication, interpersonal and leadership skills.
  • Sharp problem solving abilities and goal - oriented attitude.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential - Jersey City, NJ

Responsibilities:

  • Expericence in Golden Gate 12c setup and Troubleshooting
  • Point in time recover and conflict handling
  • Oracle PL/SQL programming and data analysis
  • Dataguard Disaster Recovery (DR) setup, test administration and monitoring. Worked with Fast Start Failover (FSFO) in DATA GUARD
  • Golden Gate Setup, administration, monitoring with hands on Patch testing, vulnerability management, product upgrade, integration testing s and performance testing.
  • Experience with Data Encryption solutions (Database, NAS/Server File System, SAM, Data Transmission etc.) build Data Lakes.
  • Experience on 24*7 environment including on call support as per requirement. Handled tickets. Conversant in handling requests within SLA.
  • Have migrated Oracle databases to AWS EC2 and RDS. Migration from Oracle RAC to Exadata experience.
  • Experience with upgrading OEM from 11G to 12C, Integration of OEM 12c with Exadata, Monitoring of Exadata using OEM 12c, upgraded and patched infiniband switches.
  • Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA).
  • Experience & knowledge on Exadata architecture & features like Storage Index, Flash cache, HCC and IORM Solid exposure of hardware, updated & patched Software and firmware maintenance of the Exadata storage servers
  • Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.
  • Experience and knowledge of logical and physical database design, performance monitoring tools, Unix shell scripting, Perl/Python.
  • Used some leading programming language, like Python, Java, C++ to develop and used Python for machine learning.
  • Experience with Oracle Auto Service Request (ASR), ASR implementation, configuration and Administration
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, Design of DB objects, partitioning, Data modeling, DML(select, insert, update, delete, merge, call, explain plan, lock table), DDL(create, alter, drop, truncate, comment, rename), DCL(grant, revoke), TCL(commit, rollback, savepoint, set transaction) operation (SQL commands)
  • Work closely with other database administrators/developers, OS engineer and subject matter experts to ensure the success of migration of 40T data warehouse from single instance 11gR2 to 12c RAC database by DataGuard; and the integrity and availability of databases and their accompanying application softwares, such as Anthill Pro, NDM and Autosys, building blocks of Supply Chain Management
  • Hands-on Oracle database administration experience with 12c and 11g; both in Unix and Windows environments. Install new versions of the Oracle RDBMS and its tools and any other tools to access the Oracle database, backup and recovery database. Used AVAMAR/DDBOOST, RMAN & CRON.
  • Oracle 12c RAC/Clustering architecture, installation for standalone and multi-node and troubleshooting, perform product evaluation analysis
  • Security check for database by SQL scripts and provide remediation suggestions to meet data security and compliance requirements, interdependencies between Oracle security and Linux security.
  • Oracle Advanced Concepts experience like Parallel Execution, Using Optimizers, Flash Recovery, Advanced Compression
  • Experience with setting Oracle 12c Golden Gate Replication
  • Automated job scheduling with Oracle SQL and/or PL/SQL.
  • Oracle 12c Data guard experience with Oracle 12c CDB with multiple instances and using ASM
  • Experience with MS Office productivity tools, and good knowledge of AIX and/or Linux operating systems, Oracle Enterprise Manager Cloud Control, Cisco (AppDynamics) & Kibana, azure
  • Supported and cooperated with App team/development team.

Oracle Database Administrator

Confidential - Bangor, PA

Responsibilities:

  • Installed Grid Infrastructure Software on new Linux Servers for 2 node RAC and Failover environments and Oracle Grid Control 11g Installation. Removal and Adding nodes to the Oracle Rac.
  • Experienced in Installing OEM agent and hooking up to the grid.
  • Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
  • Worked in troubleshooting RAC and implemented ASM features. Removal and Adding nodes to the Oracle Rac.
  • ETL Tool with appropriate data warehouse tasks like process of extracting data from simple operational data sources or external data sources, transforming basic data which includes cleansing.
  • Install and configure Golden Gate for Teradata, Set up Oracle Golden Gate for propagating information from various databases to Teradata, review of infrastructure components and technologies based on input from Customer/Business group.
  • Aggregation, summarization, integration, as well as basic transformation, and loading the data into some form of the data warehouse using s Tolls. Supply Chain Management Building Blocks.
  • Used AWS (Redshift, DMS), Client Data Centers, new Client dedicated cloud to support development of products, built Data Lake
  • Extensively worked in setting up Oracle physical standby database using Data guard. Worked with Fast Start Failover (FSFO) in DATA GUARD
  • Worked with Client’s division and business unit, application team to perform product maintenance activities
  • Resolving the issues in conflicts between the target and source database in golden gate.
  • Supporting migration and upgrades using Oracle Active Data guard environment using Oracle Data guard Broker, Monitor and fix plans for sub-optimal SQL queries.
  • Implemented Bi-Directional replication in golden gate
  • Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases.
  • Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and Disaster Recovery(DR) databases.
  • Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA). Migration from Oracle RAC to Exadata.
  • Viewing Exadata Database Machine Topology, Drilling Down to Individual Targets, Viewing Exadata Database Machine Alerts, Viewing Exadata Database Machine Metrics, Adding Exadata Components Manually. Know about Luns, Cell Disk and Grid disk and CELLCLI and DCLI, cellsrv process. Implementation & troubleshooting.
  • Applied necessary Patches during installation and also in up-gradation of databases.
  • Handy in utilizing data pump tool for exporting and importing the data between databases. Implements security for the Oracle Databases.
  • Used E-billing as ant script for creating the Oracle Self-Service E-Billing database.
  • Involved and Upgraded Analytical Databases from 10g to 11g, or 12c.
  • Installation and configuration of Golden Gate on 11g database for the replication, perform product evaluation analysis
  • Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
  • Experience with Data Encryption solutions (Database, SAN, NAS/Server File System, Data Transmission etc.)
  • Well Experienced in taking Cold Backup for a very huge 64-Tb Database.
  • Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN. Used AVAMAR/DDBOOST & CRON.
  • Experience of logical and physical database design, performance monitoring tools
  • Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
  • Oracle PL/SQL programming and data analysis
  • Weekly Data Refresh from Production to QA, Development and Test environments using Data Pump export/import, backup and recovery DB.
  • Having good exposure in user management, Table space Management, Session Management, undo Management issues.
  • Experienced in managing space issues in the Database Level for table space and Regular file system cleanup Confidential UNIX level, Unix shell scripting, or Python, other database issues like dead lock, abnormal application lock, contention.
  • Automate database administration used shell scripts
  • Used RDBMS to connect Oracle DB and good knowledge of AIX and/or Linux operating systems, azure
  • Experience with peregrine ticketing tools for resolving the tickets.

Oracle Database Administrator

Confidential

Responsibilities:

  • Configuration, Installation and maintenance of Oracle 11g RAC databases including Golden gate 12c, ASM and CRS.
  • Performed upgrades from Oracle 10g to 11g and applied patches, Software and firmware maintenance
  • Proficient in managing Oracle Instance, database storage structure, schema objects.
  • Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
  • Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC and 11G RAC on a test basis.
  • Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures, Disaster Recovery(DR) databases. worked on Oracle GOLDEN GATE for transferring data between 10g and 11g and exadata, upgraded & patched the InfiniBand switches in the Database machine
  • Involved in Base migration from 10g to 11g in production databases, 11g to 12c in QA and test environment. Knowledge & experience of logical and physical database design, performance monitoring tools, migrated DB to AWS.
  • Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Worked on Features: Data Pump, ASM, AVAMAR/DDBOOST, CRON and RMAN. Data Base Recovery (complete & Incomplete).
  • Installing ASM environment and migrating database from NON - ASM to ASM. Unix shell scripting Experience in Planning Database, Sizing table space, create database, scripts(Shell, Perl/Python, SQL), monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support. Handled tickets. Experience in data warehouse, Oracle PL/SQL programming and data analysis
  • Installation of Oracle database 10g software with RAC using Oracle Cluster-ware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control. Worked with Fast Start Failover (FSFO) in DATA GUARD
  • Install and configure Golden Gate for Teradata, Set up Oracle Golden Gate for propagating information from various databases to Teradata
  • Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage
  • Created Cluster-database, Cloning of Cluster database on Linux, start and stop Cluster database services.
  • Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM (Oracle Enterprise Manager), Import-Export, Auditing, RMAN. Implements and enforces security for all of the Oracle Databases.
  • Generating Stats pack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
  • Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements

Hire Now