We provide IT Staff Augmentation Services!

Oracle Database Analyst Resume

Atlanta, GA

SUMMARY:

  • 10 plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.
  • Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support.
  • Conducted workshops to gather user requirements and performed Gap Analysis and translate them to technical requirements.
  • Performed Oracle 8i/9i/10g/11g/12c software and database installation and upgraded various versions.
  • Experience in Implementing Refresh Activities through Traditional Import and Export and Data Pump utilities.
  • Designed strategies for performing database backups and recovery using RMAN.
  • Experience in loading data from flat files using external tables, SQL*Loader.
  • Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching (CPU/PSU) of Oracle Databases 10g/11g and Oracle Applications.
  • Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
  • Experience in Database performance tuning using AWR, ASH, ADDM, Statspack, TKPROF, SQL Trace, and Explain Plan.
  • Worked with Oracle Databases (12c/11g/10g/9i/8i), ASM, RAC and Data Guard on Unix/Linux/Windows platforms.
  • Experience with Standby Database, DataGuard, Replication Active Database.
  • Experience with Oracle Golden Gate installation configuration and maintenance.
  • Good Knowledge in Data Modeling tools like Erwin.
  • Experience in Implementing and configuring OEM, TOAD and SQL Developer.
  • Experience in maintaining Database Security using auditing.
  • Experience PL/SQL Packages, Stored Procedure, Trigger, Function.
  • Result oriented, self - motivated, Team player, ability to work independently and within a team.
  • Ability to function successfully in a highly stressful, 24x7 mission critical environment.
  • Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
  • As part of the Architecture team OBIEE Installation, Configuration and Administrative.
  • MongoDB Database online training from MongoDB University.
  • Flexible in 24x7 production oracle database support.

TECHNICAL SKILLS:

Operating Systems: UNIX, Solaris 5.8/5.9/5.10, IBM AIX 5.2/5.3, HP UX 10.2/11.10/11.20, LINUX, Windows NT/95/98/2000/XP

Databases: Oracle 12c/11g/10g/9i/8, Oracle 11g/10g Real Application Cluster (RAC), SQL Server 2005/2008, DB2

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data Guard, Putty, VMware, CronTab, Erwin, MS Visio.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR,EM,ASH

Application Servers: BEA Web logic, IBM Web Sphere

Language: UNIX Shell Scripting, SQL, PL/SQL, C/C++, Java

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

Oracle Database Analyst

Responsibilities:

  • Performed DBA activities for Oracle 10g/11g/12c, Sun Solaris, HP-Unix, AIX and Windows servers.
  • Performed Performance tuning though AWR, ADDM, SQL tuning Advisor, SQL profiler and Plan Baseline Management and generated SQL Plan though Explain Plan, SQL Trace and AWR.
  • Performed Performance Tuning task on SGA and database level and suggestion different better plan.
  • Performed different refresh activities through Data Pump.
  • Performed different recovery strategies on production support.
  • Used Transportable tablespaces (TTS) for moving large volumes of data between Oracle databases.
  • Management of schemas, objects partitioning the tables & indexes.
  • Created transaction lag strategy & management on Physical standby Data Guard.
  • Provided technical troubleshooting and give consultation to development teams.
  • Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Database Administrator with experience on Unix, AIX and Windows platforms for Oracle (11g, 12c).
  • Provided support to ecommerce databases.
  • Performed Different Upgrade and Migration task from 11G release one and two to 12c release one.
  • Refresh databases using export import and Data Pump.
  • Performed Installation and Upgrade using scripting method as well as silent method.
  • Performed different Cloning activities though RMAN duplicate and RMAN Backup.
  • Implement Different Recovery task in production support.
  • Build many 2 node RAC clusters.
  • Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
  • Performed converting single node instance to RAC and Adding instance to the existing RAC.
  • Worked with Developers, Application, storage, OS and network teams on projects.
  • Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.
  • Build Physical Standby Data Guard for Disaster Recovery project.
  • Build Active Data Guard for Business Reporting applications.
  • Managed databases from command line, TOAD, SQL Developer and OEM.
  • Resolved various performance tuning scenarios using SQL profiler and Plan Baseline Management.
  • Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.

Confidential, Pittsburgh, PA

Oracle Database Administrator II

Responsibilities:

  • Installed, administered and maintained Oracle 11gR2 and 12c databases as per the requirement of the Application/Business.
  • Led the creation and maintenance of various database environments Test, Dev. and Production system.
  • Performed schema refreshes from production to development databases.
  • User Management involving administration & provisioning of roles, privileges and profiles.
  • Designed sound backup strategy by implementing daily incremental/archive backups followed by weekly full backups.
  • Manage 3 Node 11R1 RAC databases on RHEL 6.x.
  • Provide project support involving Architecture reviews, product implementation, capacity planning, schema builds, user provisioning, security implementation, backup strategy.
  • Creating and managing application schemas including Tables, Indexes, Views and Materialized Views.
  • Managed High availability of the database using Oracle Golden Gate Replication.
  • Managed different OGG processes like Extract, Pump Replicate and parameter file Local Trail and Remote Trail file as well as Global.
  • Troubleshoot lag during replication issues.
  • Performed critical data-sync ups between PROD-primary and PROD-DR.
  • Proficient in maintaining Database Security using auditing.
  • Review & recommend suggestions based on analysis of AWR, ASH reports for performance issues.
  • Provide on call support on rotation basis.

Confidential

Oracle DBA/Data Analyst

Responsibilities:

  • Worked with Oracle Databases (11g/10g/9i) on Unix/Linux/Windows platforms.
  • Part of the Data Architecture team, which supports development, test and production databases.
  • Perform root cause analysis on failures.
  • Tracing, troubleshooting with database performance and tuning issues.
  • Monitor and fully analyze performance issues in production Oracle databases by using, Explain Plan, Auto Trace, SQL Trace and TKPROF tools.
  • Work actively on Performance tuning such as AWR, ADDM, and ASH, performance statistics collection, and fine-tuning database wait events.
  • Designing the security and database access strategies.
  • Used TOAD, SQL Developer and dynamic view along with dictionary tables to maintained database
  • Creating and dropping of users, granting and revoking rights as and when required.
  • Responsible for setting and managing user accounts, Granting required privileges to users.
  • Involved in OBIEE upgrade to OBIEE 11g and reporting.
  • 24/7 on-call supports for the production environment.

Confidential

Database Consultant

Responsibilities:

  • Responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities.
  • Participated in a team environment for the delivery and maintenance of data and/or database management systems.
  • Provided technical, interpersonal and administrative skills in performing day to day work
  • Escalated issues in a timely manner and provide mitigation recommendations to Data Team Lead and Project Director.
  • Upgrade and Migration of Database from 9i to 10g Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
  • Resolved different issue like space management, conducting sizing, capacity planning and security.
  • Maintaining schemas and partitioning tables.
  • Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
  • Set up and maintained oracle disaster recovery site using Data Guard.
  • Implemented oracle high availability solution using oracle 10g Physical Standby.
  • Code review of the development work done by all the development teams.
  • Oracle Applications/Oracle E-Business Suite 11i (11.x)/10.x.

Confidential

Software Engineer

Responsibilities:

  • Working as a Forms, Reports, Crystal Reports and PL/SQL programmer and handling all the duties and work assigned to this position efficiently, these duties are as follows:
  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Studied and analyzed the business requirements, designed entity relationship diagram using Erwin.
  • Designed logical and physical data models for star and snowflake schemas using Erwin.
  • Review the data model and designed database tables as per technical specifications
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • In writing PL/SQL code and debugging for triggers, functions, and procedures and packages in the Oracle 8i/9i Database
  • Trouble shooting for the end users requirement and optimizing the Oracle database.
  • Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Designed Data Modeling, Design Specifications and to analyze Dependencies.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Providing support to team member on daily basis.

Hire Now