We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Boston, MA

SUMMARY

  • Experience in configuring and managing Oracle Real Application Cluster (RAC) with ASM, Data Guard for Oracle High Availability.
  • Experience upgrading Oracle databases from 9iR2 to 10gR2, 9iR2 to 11gR2 and 10gR2 to 11gR2 11.2.0.2.2 on RHEL, AIX and Solaris 10 SPARC 64 - bit systems.
  • Experience in Oracle Patching for 9i, 10G and 11G.
  • Experience as Oracle security DBA- worked extensively in rolling out auditing across a wide environment.
  • Real time experience in remediating all the Oracle DBs to comply with industry security standards.
  • Configuration and Management of Data Guard.
  • Knowledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata X2-2 servers
  • Configuring Oracle Golden Gate for replications.
  • Experience in using Golden Gate during Disaster Recovery scenario
  • Experience in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1 from 11.2 to 12.1.2.1.0
  • Experience in setting up DDL/Bi-directional replication between source and target databases. Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1.
  • Have Relative Professional Experience on Oracle Siebel Architecture.
  • Worked extensively on Very Large Databases (VLDB) ranging from 200 GB to 8 TB
  • Migrating databases from cross platforms windows, Solaris and Linux.
  • Experience in Migration of Database from 9i to 10g, 10g to 11g.
  • Planning and scheduling Backups using RMAN (hot, cold and incremental backups)
  • Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
  • Installation and configuration of Recovery Catalog for multiple Databases.
  • Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
  • Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX & Windows Environments.
  • Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, and SQL TRACE.
  • Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
  • Implementation of Flashback Technology.
  • Having experience with Data dictionary.
  • Managed Database Structures, Converted Logical data to Physical data, Storage Allocation, Table/Index segments, Rollback and undo segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
  • Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.
  • Experience using Erwin as a Data Modeling tool & Designing the ETL processes
  • Experienced in loading data from flat files into database tables using SQL*Loader and ETLTools like Informatica, Data flux, Data Stage
  • Worked closely with Development, QA teams to recommend appropriate changes to applications and coordinate in reduction of down time for the conversion.
  • Experience in UNIX Shell Scripting for automating the DBA tasks.
  • Strong Understanding on Principles of Data Warehousing.
  • Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN) and Oracle ZFS storage.
  • Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
  • Hands on Experience working with Database Resource Management and Capacity Planning.
  • Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.
  • Excellent communication skills, with strong troubleshooting, and problem solving ability.

TECHNICAL SKILLS:

Databases Skills: Oracle 9i/10g/11gR2/12c, SQL Server 2005, Backup planning and Implementation, Performance Monitoring, Analysis and Tuning, Install, Patch and Upgrade, Disaster Recovery planning and implementation, Partitioning, Replication.Database Advance Feature RAC, Data Guard, ASM, Standby Database, Oracle Golden Gate, Advanced Replication/ Materialized View, Grid Control, OEM (GC), Tivoli, TOAD, SQL Developer, logminer, Cron tab

Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, DataPump (expdp, impdp), SQL*Loader, DGMGRL, ASMCMD, OID.

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

Languages: C, C++, UNIX shell scripts, PL/SQL, SQL, Perl

Project Management Tools: Project Scheduling (Microsoft Project), Microsoft Office Suite 2013, Minitab, Proplanner, SPC, FMEA, Design Of Experiments, Six Sigma, Lean Manufacturing, Quality Analysis.

Operating Systems: Sun Solaris 5.8, 9, 10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Oracle Database Administrator

Responsibilities:

  • Installed and configured 12.1.0.1oracle database software on LINUX 6.4 using silent installation.
  • Setting up Enterprise wide RAC implementation strategies for client.
  • Installed 27 Real Application Clusters on Linux platforms for System-test, Development and Production Servers.
  • Build and developed, tested, staging, production, RAC and standby databases for OLTP systems.
  • Performed Database build, designed and implemented creation of databases and set up monitoring tools based on the business requirement.
  • Responsible for the design, implementation and maintenance to support large mission critical databases.
  • Migrated NON RAC databases to RAC databases using RCONFIG and manually.
  • Used RACCHECK utility to monitor health of clusters, created services and troubleshooting issues in RAC.
  • Applied patches in rolling passion on RAC upgraded and maintained and troubleshooting cluster ware components in RAC environment.
  • Installed GoldenGate on 11.2.0.3 on Amazon Web Server and implemented Two-directional replication.
  • Setup active-active replication between two availability zones and Hooked up Golden Gate monitoring to central EM.
  • Troubleshooting and resolved issues in GoldenGate environment.
  • Installed and setup Oracle 12.1.0.1 Enterprise Manager for cloud on AWS.
  • Hooked up all CDBs/PDBs and other AWS instances that reports status to Enterprise Manager.
  • Performed monitoring of databases using OEM 12C. Generated AWR, ADDM, ASH and taken Backups using OEM.
  • Responsible for performance tuning and identifying system bottlenecks / blocking and resolving in a timely manner.
  • Configuring Database to schedule Database monitoring scripts.
  • Supported development teams by providing SQL statement tuning and removing load and Query performance bottlenecks by using tools Explain Plan, AWR, ADDM, ASH, Statspack and TKPROF.
  • Created Import/Export scripts for migrating data and data refresh activity.
  • Created scripts for taking backups and exporting dump files to EC2 Storage which is on Amazon Web Service (AWS).
  • Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguard Exadata clusters for maximum availability.
  • Disaster recovery of Exadata Dataguard Physical Standby.
  • Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of data file testing.
  • Use of RMAN for backup operations with Exadata.
  • Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
  • Setup Oracle wallet keystore on an AWS instance and enabled schema encryption using Oracle Advanced Security.
  • Identified data auditing requirements, implemented audit policies at column level. Also created mechanism to easily access audit data.
  • Separated data schema from application logic schema.
  • Created service accounts for application use, utility schema for logging, exception handling and audits, standard template for Packages and Stored Procedures with Change Log in header.
  • Created Data Access Security policy, user accounts, user profiles and assigned roles, permissions.
  • Created and set up VPD policy (virtual private database) for roles defined in business requirements
  • Created generic logging utility. Enforced logging utility is used in all PL/SQL development.
  • Created an utPL/SQL environment and a guideline document on how Unit Tests will be done in PL/SQL development.
  • Static code analysis and code coverage. Identified applicable rules for static analysis and customize stored rules.
  • Made static code reports analysis publish as part of continuous build.
  • Hooked up PL/SQL compilation and code coverage reports as part of Continuous Integration.

Environment:Oracle Database 12c, Oracle GoldenGate 11i, Oracle RAC 11g, LINUX 6.4, RHEL 6.2, Toad 12.1, Oracle Enterprise Manager 12.1.0.1, Oracle Database Import/Export utility, Oracle Support, RACCHECK, AWR, STATSPACK, ASH, ADDM, JIRA(Code Integration, Ticketing tool).

Confidential, San Diego

Oracle DBA

Responsibilities:

  • Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) Grid Control.
  • I was responsible for constructing RIS FDW a Data warehousing Project that provide RIS (Retirement and Investor Services)
  • Install Oracle audit scripts across all high profile and low profile categorized servers over GMRT region (Global Markets and research technology).
  • Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
  • Applied patches and CPU regularly to keep the databases in current version.
  • Work with oracle support to report and resolve issues in production databases.
  • Handling Tickets assigned via remedy queue and Oracle severity for critical DB Applications.
  • Configured and maintained Oracle Goldengate instances for replication of database.
  • Responsible in installing and setting-up Golden Gate from source to target to provide active data replication
  • Responsible in configuring Golden Gate using User Exit and Voltage encryption to encrypt the data before being delivered into Golden Gate Trail file.
  • Worked on very wide environments including Linux, Sun Solaris, and IBM AIX.
  • Installed and rolled out auditing on over more than 1000 oracle instances including RAC/Non RAC.
  • Configure the initialization parameters and later bounce the production DBs during weekends and during weekdays for Dev/QA/UAT and staging databases.
  • Use Fog-light monitoring system to address issues relating to the file system growth, database health status and acknowledge/resolve the alerts raised.
  • On-call Production support for the Oracle issues severity 1 & 2.
  • Ensure that the OS level and DB level backups are configured correctly via the BMS (Backup management system).
  • Configure and schedule backups using RMAN and setting up EMC data domain deduplication backup storage on certain critical applications.
  • Work with the Banks oracle engineering team in making changes to scripts and identifying the compatibility on all different versions of oracle systems.
  • Setup Audit maintenance Jobs across in cleanup up the audit logs created in the adump dir.
  • Studying the impact of auditing on DB performance and log generation activity by performing load testing.
  • Creating links for any low space Unix/Linus file systems and this is used for future log scooping.
  • Apply patch updates using the BBDA tool- BMC Blade logic database automation tool.
  • Setup Jobs over the Autosys instances using the Autosys iXp tool and setup crontab jobs on some legacy Merrill Lynch servers.
  • Work closely with System Administrators to recommend appropriate Hardware Changes (Server Level) during the implementation of the Real Application Cluster
  • Work closely with Development, QA teams to recommend appropriate changes to applications and coordinate down time for the conversion
  • Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
  • Responsible for creating shell script to export and import schemas from production to development

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5 Tikanga, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC, Golden gate, Grid, Data guard, Fog-light monitoring, AutoSys Job Scheduling, BMC Bladelogic Automation tool, EMC Data Domain, Net-Backup, Nexus Ticketing System

Confidential, MEMPHIS, TN

ORACLE DBA

Responsibilities:

  • Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
  • Configured GOLDENGATE unidirectional in classic capture mode on LINUX
  • Installed, Configured and monitored GOLDENGATE replication and installed VERIDATA tool for comparing data synchronization between SOURCE and TARGET
  • Responsible in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1
  • Responsible in configuring/setting up Golden Gate from scratch in non-prod and deployed the same in production environment
  • Installed and monitored STREAMS one-way replication
  • Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
  • Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
  • Involved in the Migration projects Extensively using Data pump and RMAN utilities
  • Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
  • Excellent in writing SQL scripts using SPOOL command
  • Expert in using Data pump
  • Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
  • Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
  • Experience in moving the data from one server to another server using SFTP,FTP and SCP
  • Building new databases and schemas from the scratch on Linux and UNIX Boxes.
  • Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
  • Schema Refreshing of databases using normal copy method and exp/imp utility.
  • Cloned database and schemas using Data pump for 10g and 11g versions.
  • Cloned 10g and 11g databases using RMAN duplication(with and without backup)
  • Involvement in space management, rectification of lock problems, user management.
  • Responsible to provide 24 x 7 database administrative activities over different database servers
  • Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
  • Configured Oracle Data guard for Oracle Disaster recovery on standalone database
  • Troubleshooting ORA errors when occurred
  • ASM Disk storage and user Management
  • Performance Tuning for the SQL queries by scrutinizing the long running sql queries
  • Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
  • Scheduled Oracle Jobs and Backups using CRONTAB.
  • Experience in Online and Offline backups and recovery.
  • Experience in backups and recovery using RMAN shellScripts.
  • Performed Schema as well as Table level Replication using Oracle Streams.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Implemented Oracle database backup &recovery solutions using RMAN.
  • Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
  • Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
  • Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
  • Worked with Data pump to take the logical backups of databases.
  • Experienced in performing Point in time recovery using RMAN.
  • Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names.
  • Involved in designing logical and physical data models using Erwin.
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Confidential

Oracle Database Administrator

Responsibilities:

  • Installation and configuration of oracle database 8i (8.1.7), 9i (9.0.2) on various OS platforms like HP-UX, Linux and Windows NT, 2000.
  • Creating and Maintaining of databases.
  • Creating table spaces, tables, indexes, data files etc.
  • Responsible for setting and managing user accounts, Granting required privileges to users.
  • Managing, troubleshooting and resolving oracle database and applications issues.
  • Perform capacity planning required to create and maintain database environments.
  • Helping to the developing team and data warehousing team.
  • Prepare the documents of the process and knowledge transferring about the project to the new team members.
  • Writing complex queries and procedures using sql *plus and toad.
  • Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Monitoring the background processes activity, setting the appropriate number of DBWR processes, changing the INIT.ORA parameters etc.
  • Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Monitoring table space size, resizing table space, relocating data files for better disk I/O
  • Managing archive logs, DB-links, partitions.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases
  • Maintain Oracle schemas and SGA region.
  • Guiding and leading warehousing team for better performance.
  • Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 8i/9i, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Import/Export and Linux, HP-UX, Windows NT/2000