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