We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

NY

SUMMARY:

  • Over 13 Years of experience in the Information Technology field with extensive experience on Oracle Database Administration.
  • Good experience in Database designing, setting up the complete Database with Security Implementation troubleshoots.
  • Expert in Administering 24 X 7 OLTP, Data Warehouse, OLAP, and Hot Standby (Data Guard) databases. Ability to analyze, plan and execute to perfection.

TECHNICAL SKILLS:

Database Administration: Oracle 8i/9i/10g/11g/12c,SQL Server 2005 - 08, MySql, Sybase, Teradata, DB2, MongoDB, Hadoop casandra

Oracle Tools and Utilities: OEM, Grid Control,RMAN, SQL*Loader, SQL*Net, Toad, Oracle Streams, Data Replications, BEA, JDE, Golden Gate 11/12, Oracle Veridata, Oracle Golden Gate Application Adapters for Flat File and Java, Java API, Data Guard, SQLNET,JDBC, Weblogic12c, Oracle SOA, AVAMAR, TSM, Netbackup, Oracle RUEI,JMS, DGMGRL, Statspack, AWR,ADDM, ASH, Oracle Application Express, Oracle 11.5 E-Business, Confidential, Tuning Advisor

Operating Systems: Windows, HP-UX, Linux (RHEL), AIX, Solaris

Programming Languages: SAP, ABAP, ECC6.0 C, C++, Java, VB6.0,Pl/SQL,T-SQL, PeopleSoft, .net, C#, Hadoop, pig, hive

ETL Tools: Data integrator, Erwin, Power Designer, DbArtisian, Data Stage, Informatica, AbInitio etc

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Oracle Database Administrator

Responsibilities:

  • Leading OLTP Database migration and up-gradation projects.
  • Develops new standard operating procedures (SOPs) for Oracle EBS application software installation and configuration including high availability and disaster recovery solutions.
  • Administered Oracle EBS Application.
  • Subject matter expert for Oracle golden gate and Oracle Veridata.
  • Leading Golden gate replication projects.
  • Using Oracle Veridata for checking data consistency.
  • Compare database by using Oracle Veridata after upgrade/migration.
  • Compared Source and target data through Veridata.
  • Created Golden gate performance monitoring script.
  • Migrated Oracle 11g databases to Oracle 12c.
  • Upgraded Oracle 11i databases.
  • Upgraded Oracle 11.2.0.2 to Oracle 11.2.0.4 databases.
  • Upgraded Oracle 11.2.0.4 to Oracle 12.1.0.2 databases.
  • Upgraded database from 11g to 12c by using oracle golden gate.
  • Building Oracle data guard platform for replication.
  • Install Oracle Application Express.
  • Created Physical standby, logical standby databases.
  • Switching primary and physical standby databases for DR testing.
  • Enable Fast Start Failover for critical application supporting databases.
  • Build Linux server for database migration.
  • Worked on Infrastructure project.
  • Configured Backup thru AVAMAR tool.
  • Build ASM, Cluster ware on Linux.
  • Working with Engineering team for Exadata establishment.
  • Worked on Performance tuning related to new migrated databases.
  • Assisted with review of Oracle Golden gate replication architecture.
  • Implemented Oracle Golden gate in non-prod and prod environments.
  • Monitoring and compare data report by using Oracle Goldengate Veridata.
  • Configured Golden gate capture process in source and target.
  • Configured pump, trail discard file, replicate and extract process in Golden gate.
  • Supported in go-live activities.
  • Created Golden gate performance monitoring script.
  • Provided 24*7 supports during production implementation.

Environment: Windows, Linux, AIX, Solaris, Oracle 11g/12c, OEM, Data Guard, Golden Gate11g/12c, JMS, TDE, Oracle Golden gate Veridata, RMAN, RAC, ASM, AWR, ADDM . Oracle EBS, Oracle Application Express etc.

Confidential, Wilmington, DE

Sr. Database Administrator

Responsibilities:

  • Oracle subject matter expert and technical lead for major finance projects on HA/MAA Oracle RAC/Oracle Advance security.
  • Leading Oracle Golden Gate and infrastructure project.
  • Configured Goldengate 12c RAC -- RAC Active configuration with 12c database.
  • Upgraded Oracle database to 12.1.0.2 by using various techniques (Golden gate, Data Pump, Data guard).
  • Assist in installation and configuration of audit vault and database vault in oracle 12c in single instance and cluster database (2-3 node).
  • Work with Architecture, Development, and Business teams to identify Privileged Account Management and Multi-Factor functionality that can be enabled and integrated to improve security or performance.
  • Design and build platforms in Confidential for new environments.
  • Worked with different teams of SMEs to design technical solutions for Confidential integration.
  • Design/engineering, administration, and third-level support of the Privileged Account Management infrastructure components for Confidential .
  • SME for Oracle golden gate and Oracle Veridata.
  • Created data Redaction Policy in Oracle 12c OEM.
  • Extensively involved in collaborating with testing team in performing load testing which will help in capacity analysis of databases to scale up to concurrent load from end users.
  • Gathering statistics on databases using stats pack to analyze database bottlenecks.
  • Created OLTP/Warehouse Oracle 11g and Oracle 12c databases on Linux/AIX with failover mechanism.
  • Provide 24*7 support if required.

Environment: Solaris, AIX, Linux, Unix, Windows, Oracle 11g/12c, TDE/Database Vault/Audit Vault/FW, SQL Server 2005/08, Exadata, Oracle Golden Gate 11/12., Oracle Golden gate adapter for Java and Flat files. SQL Loader, RAC, JMS, Oracle Veridata, AWR, ASH, ADDM, TOAD, JAVA, PL/SQL, JDBC, Confidential, SQLNET, Peoplesoft etc.

Confidential, CA

Lead Oracle DBA

Responsibilities:

  • Assisted with review of Oracle Golden gate replication architecture.
  • Implemented Oracle Golden gate in non-prod and prod environments.
  • SME for Oracle golden gate and Oracle Veridata.
  • Upgraded Oracle 11.1.0.7 to Oracle 11.2.0.4 by using Oracle Golden gate with near to zero downtime.
  • Monitoring and compare data report by using Oracle Goldengate Veridata.
  • Reviewed Golden Gate Parameter files.
  • Review Golden Gate process and parameters for Transactional Data Delivery to WebLogic Java Messaging Service (JMS).
  • Configured Golden gate capture process in source and target.
  • Reviewed pump, trail, discard file, replicate and extract process in Golden gate.
  • Supported in go-live activities.
  • Supported once GG process is up and running.
  • Reviewed golden gate process and suggest modification.
  • Compared Source and target data through Veridata.
  • Created Golden gate performance monitoring script.
  • Provided 24*7 supports during production implementation.

Environment: Windows, Linux, Solaris 10, Oracle 11g/12c, OEM, Golden Gate11g/12c, JMS, TDE, Oracle Golden gate Veridata, RMAN, RAC, ASM, AWR, ADDM etc.

Confidential, Wilmington, DE

Senior Database Administrator

Responsibilities:

  • Leading couple of high availability projects.
  • Oracle subject matter expert and technical lead for major finance projects on HA/MAA Oracle RAC/Oracle Advance security.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • Worked with Oracle for X3-2 half rack configuration(eight database server with 2 8-core Xeon processors and 256 GB of RAM, fourteen storage servers, 168 disk drives).
  • Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Leading Oracle Golden Gate and infrastructure project.
  • Configured Goldengate 12c RAC -- RAC Active configuration with 12c database.
  • Assist in installation and configuration of audit vault and database vault in oracle 12c in single instance and cluster database(2-3 node)
  • Enable Advance security feature in Oracle 11g/12c (TDE, Data Vault, Data Redaction, Application Security, Wallets, database firewall policy).
  • Monitoring events and audit logs by consolidating Oracle Audit Vault and database firewall.
  • Applying Advance compression.
  • Enable Oracle ASM Cluster File System encryption to protect log and configuration files.
  • Configure Oracle Key Vault to centrally manage oracle Wallets with AES256 and TDE/ACFS master key.
  • Configure Data Redaction in Oracle 12c for cardholder data/national identifiers/personal identity/medical record etc.
  • Provided presentation to higher management for Oracle security features( av, dv, dbfw, data redaction, wallets, TDE etc..)
  • Created data Redaction Policy in Oracle 12c OEM.
  • Leading DR and HAA exercise during production deployments.
  • Implemented Oracle advance security features(av, dv, dbfw, wallets, TDE) in Oracle 11g.
  • Extensively involved in collaborating with testing team in performing load testing which will help in capacity analysis of databases to scale up to concurrent load from end users.
  • Gathering statistics on databases using stats pack to analyze database bottlenecks.
  • Created OLTP/Warehouse Oracle 11g and Oracle 12c databases on Linux/AIX with failover mechanism.
  • Performing checks on CPU, Memory and Storage while load testing is being performed as the loads are of different types which flood the database.
  • Performed Cross plateform migration by using oracle golden gate.
  • Migrated SQL server 2008 database to Oracle 11g by using Golden Gate.
  • Migrated single instance database from AIX(Single instance) to Linux (RAC 2 node) by using Golden Gate and Monitored thru Veridata.
  • Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
  • Planned GoldenGate setup to achieve Unidirectional and Bidirectional replication.
  • Prepared GoldenGate parameter files for Extraction and Replication.
  • Tested initial Data Load option of GoldenGate during environment build.
  • Investigated Goldengate Replication failures using LogDump utility.
  • Goldengate 11gR2 Integrated Capture and Advanced compression features testing.
  • Designed and developed several mappings to load data from source system to ODS and then to Data Mart.
  • Creation of AWR, ADDM, ASH reports to detect bottlenecks in database if loads running multiple high volume queries take long time to execute.
  • Executing plans for TOP SQL to tune them and avoid hard parses and waits.
  • Knowledge of OEM 12C architecture pieces Oracle Management Agent, Oracle Management Service, Oracle Management Repository, Oracle Management Plug-ins and Enterprise Manager Cloud Control Console.
  • Active management of Oracle Weblogic Server through OEM 12c cloud control.
  • Proactively installing OEM agents and monitoring databases through OEM 12c cloud control.
  • Performing Index analysis and rebuilding Indexes on objects if broken and creating them if missing.
  • Refreshing databases in DEV and QA with new builds.
  • Maintenance of Oracle Database parameters (SPFILE) with values to support application needs.
  • Created documentation and separated data, indexes, LOBS from schema objects and migrated them to their specific tablespaces in PROD database for better management and faster access.
  • Migrated Oracle 10gR2(10.2.0.4) databases on AIX to Oracle11gR2(11.2.0.3) on RHEL along with application schemas.
  • Performed database upgrade from 10.2.0.4/11.2.0.2 to 11.2.0.3.10 and 11.2.0.4 on all databases in DEV, QA and new PROD VMs
  • Proactively creating housekeeping scripts and monitoring databases and objects using them.
  • Patching of database and grid home with latest patch set updates(PSU).
  • Developed POC doc for database backup using hot backup scripts and RMAN, tested recovery scenarios and implemented it .
  • Familiarity with SOX compliance process.
  • Worked on internal POC for integration of Cassandra with Hadoop and HDFS.
  • Installation of CassandraDB version 2.0.
  • Migration of transactions from Oracle to Cassandra.
  • Using Remedy to log tickets and resolving them.
  • Knowledge of creation of CR (Change Request)/CM through Unicentre and REMEDY after gathering information from concerned teams and getting approval.
  • Expertise in creating and maintaining documentation and prepare report.

Environment: Windows, Unix, Linux, Solaris, AIX, SQL Server 2008, Oracle 10g/11g/12c, Peoplesoft, TOAD, OEM, Golden Gate11g, Exadata, Golden Gate Adapter, Veridata, JMS, MViews, SQLNET, Oracle Streams, GPFS, RMAN, STATSPACK,TOAD, RAC, ASM, Microstregy, AWR, ADDM, TKPROF, Grid Control, Control-m, TSM,SAP HR, Peoplesoft, Weblogic, Hadoop, Cassandra2.0, Golden Gate 11gR2/12c, Oracle Veridate and SDLC etc.

Confidential

Senior DBA

Responsibilities:

  • Worked in multiple project related to finance, ecommerce, Payment accounts, Digital IT, Clarity, Banking etc.
  • Providde DBA support to development/implementation projects as assigned, doing installations, database loading, conversions, testing etc.
  • Protecting sensitive data using TDE column encryption and protecting entire application using TDE tablespace encryption.
  • Applying Advance compression.
  • Enable Oracle ASM Cluster File System encryption to protect log and configuration files.
  • Configure Oracle Key Vault to centrally manage oracle Wallets with AES256 and TDE/ACFS master key.
  • Lead DR setup for High availability database.
  • Supported Production, Development, QA, Testing Oracle and ms-sql databases.
  • Analyzed source system data like Business Hierarchy, Commodity Hierarchy and Geographical hierarchy, sites, Utilization and produced mapping document.
  • Configuration planning and installation of Oracle servers and Server upgrades and conversions.
  • Performance and general health / capacity monitoring.
  • Implementation of traditional relational and dimensional modelling standards along with naming conventions provided by data governance committee ensures sustainable growth.
  • Interacted with Business and finalized data elements.
  • Prepared Data Migration document and test data based on business rules.
  • Developing a backup and recovery strategy and tested several recovery scenarios Perform ongoing database administration, maintenance, troubleshooting, tuning, installation, backup / recovery Management of table spaces for different users by granting quota on Default & Temporary tables paces.
  • Worked on various data migration activities using Export/Import utility and SQL * Loader Database security, job scheduling and documentation investigating suspicious database activity using Auditing.
  • Working with Oracle regarding troubleshooting with SR creation.
  • Working with UNIX Team regarding DR Testing, new server installation, memory configuration etc.

Environment: Windows, Unix, Linux, Solaris, AIX, Oracle 8i/9.2i/10g/11g, Sql Server 2005/08, NCR Teradata V2R6.2, TOAD, OEM, Golden Gate, Exadata, RMAN, STATSPACK, Data integrator, RAC, ASM, Crystal Reports, AWR, ADDM, TKPROF, Control-m, TSM.

Confidential, TN

Database Administrator Team Lead/Manager

Responsibilities:

  • Responsible for providing data base management services that may relate to data monitoring, data management and programming.
  • Managed organize, and design databases (e.g. Object Oriented Data modeling, ER data modeling, UML), table structures and data schema, logical and physical design, reports and forms development, naming conventions and other issues related to systems planning and data migration.
  • Managed team of 4 database administrator.
  • Provided data base consultations in a timely and professional manner.
  • Allocated New Project to DBA’s and explain them functionality.
  • Worked as Oracle DBA with database and application design and support.
  • Worked with VLDB (Very Large Databases) with understanding in large table partitioning.
  • Developed custom utilities to automate manually intensive tasks including mass schema changes, repartitioning tables and rewinding/restarting GoldenGate to recover from trail file corruption.
  • Administered single-node and RAC 9i, 10g and 11g Oracle databases on Linux, Solaris and Microsoft
  • Windows hosts.
  • Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files (OMF) and Recovery
  • Manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
  • Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
  • Configured Oracle golden gate with oracle team.
  • Provided basic support and troubleshooting for several database environments and SQL 2005/2008.
  • Implemented SAP application by using Oracle 10g database.
  • Designed Logical & Physical Data Model /Meta data/ data dictionary using ERwin for development teams.
  • Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
  • Designing and populated reporting tables, views and stored procedures
  • Implemented partitioning to handle tables with over 500 million rows.
  • Physical data model definition, design and implementation.
  • Worked on Database Physical, Logical Design, Physical and Logical Data Modelling.
  • Worked on 3/4/6 Node Clustering environments.
  • Configured ASM, RAC with 4 nodes.
  • Configured oracle streams, sharplex and Oracle golden gate for replication.
  • Worked with in UNIX, Linux, Solaris, AIX environment.
  • Worked for Oracle database performance and tuning.
  • Worked with OEM (Oracle Enterprise Manager) for administration.
  • Worked SQL and PL/SQL tuning.
  • Configured Backup and Recovery tool OBACKTRACK.
  • Worked with pl/sql developer team for designing and coding of sql.

Environment: Windows, Unix, Linux, Solaris, AIX, Oracle 9i/10g/11g/12i, Pl/sql, T-Sql, OEM, RMAN,AWR,ADDM, RAC, ASM, OBACKTRACK,SAP ECC 6.0, VERITAS, Sybase, SQL Server, Ab Initio, Data Stage, Informatica, Disaster Recovery, Erwin, DbArtisian, Power Designer13.0, Data Modelling, Oracle Golden Gate and Oracle streams,SDLC

Confidential,Richmond, VA

Oracle DBA

Responsibilities:

  • Back up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
  • Experienced in RMAN, GRID, Physical and Logical Standby, Failover methodologies and Disaster recovery(DR)
  • Performed status checks by monitoring the status of databases, logs, archived redo logs etc.
  • Applied ARCHIVE logs.
  • Worked as part of a team and provide 7x24 support when required
  • Involved in testing phase of implementation of RMAN for various advanced backup and recovery options.
  • Planed and Implemented backup and recovery of the oracle database.
  • Completed DR Site User Location maintenance for any major disasters
  • Created of the Test and Production Oracle 8i/9i/10g databases Maintenance and support of the Oracle Applications and Oracle Databases Cloning of production database to the test environment using Recovery Manager (RMAN).
  • Resolved Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant Implementation of Security of database down to cells by creating users, groups, profiles.
  • Database Administration and Planning including logical design, physical design, backup & recovery Applied various patchsets and upgraded databases from 9.1.0 to 9.2.0.6 Installed Oracle 10g on Solaris and Linux platforms.
  • Implemented Tivoli Storage Manager for RMAN PL/SQL Coding and modifying packages, procedures and functions RMAN copy from Prod database to development, Snapshot refresh, Schema Refresh.
  • Managed Application user profiles and managing concurrent managers, concurrent processing, load balancing etc Creation of rollback segments and planning application activities accordingly to enhance system performance.
  • Copied databases, monitoring system performance, SGA tuning, rollback segments, space usage Database & Application Tuning through TKPROF & Explain plan Adept in Advanced Replication techniques using Materialized views.
  • Tuned test and production database by altering the parameters Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.
  • Worked with Oracle regarding troublshooting with SR creation.
  • Worked with Capacity Planning team.
  • Worked with UNIX Team regarding DR Testing and performed failover process.

Environment: Windows, Unix, Linux, Solaris, AIX Oracle 8i/9.2i/10g/11g, 10gr2 RAC, TOAD, OEM, RMAN, STATSPACK, Data integrator, RAC, ASM, Crystal Reports, AWR, ADDM, TKPROF, Control-m.

Confidential, NJ

Oracle DBA

Responsibilities:

  • Data loading in oracle from different sources.
  • Configuration of system databases like dbccdb, sybsecurity for monitoring and dbcc operations.
  • Involved in troubleshooting of oracle servers and capacity planning.
  • Responsibled for fixing log full/tempdb issues.
  • Supported database performance in SAP environment.
  • Checked storage on Oracle databases regularly.
  • Performed changes in packages after migration.
  • Designed file system with Oracle Optimal Flexible Architecture (OFA).
  • Taken care of Crontabs & writing Unix Shell-scripts for data extract.
  • Created and modifyied Scripts for user manage hot backup.
  • Allocated system storage and planning future storage requirements for the database.
  • Databases Patching.
  • Implemented Database Backup (Physical and Logical) and Recovery strategy.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections.
  • Creating Database objects like (Tables, views, indexes, procedures, triggers etc).
  • Created, monitoring tablespaces and re-org them.
  • Tuned Oralce9i database server using tools dynamic, dictionary views, Statspack, Diagnostic and tuning packages.
  • Planed and Implemented backup and recovery of the oracle database.
  • Created & Configured RMAN recovery catalog.
  • Closely worked with SA.
  • 7x24 support when required.

Environment: Win 2K, Win 2003 Server, Unix, Oracle 9.2/10g, TOAD, OEM, RMAN, STATSPACK,SAP 4.7 & ECC 6.0, Data integrator, Oracle Discoverer

Confidential, GA

Oracle DBA

Responsibilities:

  • Installation, upgrading, configuration and maintenance of 9i/10g on both Windows NT and UNIX environments
  • Having Good exposure for oracle 10g.
  • Created and Maintained Roles and assign necessary privileges to users according to business rules.
  • Allocated system storage and planning future storage requirements for the database
  • Build and monitoring events.
  • Implemented Database Backup (Physical and Logical) and Recovery strategy
  • Configured TNSNAMES.ORA and LISTENER.ORA for Client-Server connections
  • Created Database objects like (Tables, views, indexes, procedures, triggers etc)
  • Monitored Alert Logs
  • Choosing different types of data storages (Locally managed tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
  • Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Diagnostic and tuning packages.
  • Created & Configured RMAN recovery catalog.
  • Performance tuning for the production databases.
  • Back end Programming using SQL and PL / SQL.
  • Coordination with front-end developers in designing complex queries.
  • Help users in creating database objects, and enrolling users.
  • Coordinate all system changes with the Operational DBA.
  • Worked as part of a team and provide 7x24 support when required.

Environment: UNIX, AIX, Win NT/03, Oracle 9.2/10g, PL/SQL, OEM, RMAN, Shell Script, Oracle Form 6i.

Confidential

Oracle DBA

Responsibilities:

  • Created users and Creating Roles, and assigning privilege in it, grant to the role to the users, and Profiles
  • Monitoring the alert logs regularly
  • Coordinated with clients, in their regular activities in troubleshooting.
  • Storage management, sizing the database objects, monitoring file Systems and tablespace growth
  • Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
  • Performed status checks by monitoring the status of databases, logs, archived redo logs etc.
  • Applied ARCHIVE logs.
  • Involved in testing phase of implementation of RMAN for various advanced backup and recovery options.
  • Planed and Implemented backup and recovery of the oracle database

Environment: Oracle 8i, Windows NT

Hire Now