We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Buffalo, NY

SUMMARY:

  • Oracle Database Administrator with over 5years of experience which includes Installation and Configuration, Migration, Database Backup & Recovery, Data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 10g /11g R2/12c databases and documentation in heterogeneous environments. Worked on various Oracle versions like10g, 11g, 12c Databases across various platforms such as Linux, Solaris, AIX and Windows.
  • Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
  • Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
  • Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
  • Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
  • Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
  • Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
  • Experience in Multitenant Databases (Oracle 12c Container and pluggable databases)
  • Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
  • Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
  • Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
  • Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
  • Expertise in maintaining Database Security using auditing.
  • Experience in Data Migrations.
  • Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
  • Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
  • Extensively implemented Datapump, conventionalExport/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
  • Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
  • Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 12c, 11g, and 10g

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE:

Confidential,Buffalo, NY

Oracle Database Administrator

Responsibilities:
  • Upgraded the databases to version 12c from 11g and 10g
  • Up-gradation and Migration of Database from 10g to 11g and then to 12c and also applying patches whenever required.
  • Applying upgrade patches, maintenance and interim patches on all the databases.
  • Successfully implemented 10g RAC on nodes for high availability.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g and 12c environments.
  • Involved in construction of DR sites for all the Production environments.
  • Installed 12c database
  • Worked on Multitenant databases.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing, RAC and stand alone database
  • Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Responsible for the smooth functioning of all ecommerce activities of the organization.
  • Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
  • Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the database.
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.
  • Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, and operating system.
  • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of Oracle OLTP environments.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential,Chicago, IL

Oracle DBA

Responsibilities:

  • Performed Installation and configuration of Oracle 11.2.0.1 database on HP-UX platform.
  • Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7 supports for all the production and development databases.
  • Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2..
  • Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
  • Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  • Monitored the production Oracle alert logs for database errors and data issues.
  • Used EXPORT/IMPORT to do table level and full database defragmentation
  • Managed RAC Linux servers running Oracle in cluster environments.
  • Performed patching of Oracle databases with latest patches from Oracle.
  • Install and configure block change tracking to work with RMAN Merged incremental backups.
  • Applied patches 11.2.0.2 and 11.2.0.3, 11.2.0.4.
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Administration of ASM storage, services, addition and deletion of nodes.
  • Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
  • Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
  • Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
  • Provided OS (RAM, I/O, CPU) tuning for Oracle Database.
  • Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
  • Applied patches both Server side and Client side.
  • Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
  • Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloned databases using scripts as well as RMAN.
  • Installation, setup and configuration of Data guard.
  • Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
  • Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues

Hire Now