We provide IT Staff Augmentation Services!

Sr.oracle Dba Resume

Lake Forest, CA

SUMMARY:

  • Accomplished Oracle DBA with 9+ years of experience in Oracle Database Administration in large - scale production environments across multiple platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) 10g/11g, Data Guard and golden gate. Ability to work both as an individual contributor and as a member of a team.
  • Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Enterprise Linux (RHEL) and Windows.
  • Experience in Design, Creating and maintaining the Oracle Database.
  • Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad.
  • Experience in installation and maintenance of Oracle RAC using ASM.
  • Experience working on Golden gate for replication and data migration.
  • Experience in configuring Data Guard. Implemented Physical Standby in latest project.
  • Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
  • Monitoring and optimising the Database Performances through Database Tuning, System Tuning, Application/SQL Tuning.
  • Planning and scheduling Physical Backups (offline/online) and Logical Backups (with Export/Import utilities).
  • Expertise in Unix shell Scripting (Bourne).
  • Good at Implementing PL-SQL Coding Standards and writing policies and procedures like Hints, Indexes and Views.
  • Experience in application design using Unified Modelling language (UML), Sequence diagrams, Case diagrams, Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD).
  • Involved in logical and physical data modelling and schema design using Erwin tool.
  • Provided support for implementing and upgrading various new and third party application in client site.
  • Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
  • Experience in working with Large Tables and VLDBs.
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
  • Hands on experience working on High Availability Environments.
  • Working experience on VMWARE.
  • Experience in Data Transfer from Flat Files and other DBs to Oracle Database.
  • Experience in applying Patches on database.
  • 24 X 7 Production Database on Call Support.
  • Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Linux, Unix shell scripting, C, C++

RDBMS: Oracle 9i, 10g, 11g

Tools: Oracle Grid control, Oracle Enterprise Manager(OEM), TOAD, PUTTY, SQL Plus, SQL Developer, SQL Access Advisor, SQL Tuning Advisor

Utilities: SQL Loader, Export / Import, Expdp / Impdp, AWR, RMAN, STATSPACK

Operating Systems: RHEL 4/5, Sun Solaris 5.8, 5.9, Windows 98/NT/2000/2003/XP/7, AIX

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, Telnet

Office Packages: Word, Excel, Power point, Access

Web Tools: HTML, XML

Database Modeling: ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Lake Forest,CA

Sr.Oracle DBA

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
  • Migration of database from one server to another server.
  • Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
  • Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
  • Installed, Configured and Administered Golden gate.
  • Configured parameters for the Bi-directional replication.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Done migration of non ASM database to ASM database.
  • Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
  • Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
  • Data Refresh in Test and Integration Databases using Transportable Table spaces.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
  • Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
  • Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
  • Daily Health Check Up of the Database using AWR, ADDM.
  • Perform Daily Monitoring of Oracle Instances, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
  • Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
  • Replication of tables to cross platform and Creating Materialized Views.
  • Configured and Implemented Cold/Hot Backups.
  • Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
  • Also configured database cloning using RMAN.
  • Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
  • Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
  • Developed Scripts for transferring data from production server to testing/development servers.
  • Shell scripting and PL/SQL programming to resolve business problems of various nature.
  • Managing databases on multiple servers.
  • Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 10g, 11g, Linux 4/5,Solaris, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Dataguard, SQL*LOADER,RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential, Willmington,DE

Sr.Oracle DBA

Responsibilities:

  • Installation, Configuration and Administration of Oracle 10g/9i databases on various Operating Systems.
  • Implemented Data Guard on Oracle 10g and 9i with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
  • Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
  • Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
  • Developed generic package for partition maintenance job for multiple environments.
  • Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
  • Configured RMAN and performed daily backups.
  • Conducted daily routine checks on alert logs and trace files.
  • Creating the Database, tablespace, Control files, log files and user profiles.
  • Installed, Configured and Administered Oracle Streams.
  • Designed Logical and Physical Data Modelling using Erwin.
  • Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
  • Scheduled Oracle Jobs in the database.
  • Analyze the schema and tables.
  • Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 9i versions in RAC.
  • Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
  • Securing the data by using Oracle data vault.
  • Extensively used SQL Loader to load data from flat files to the Oracle Database.
  • Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
  • Responsible for network configuration and involved in a Client - Server environment using TNS, LISTENER, Net Configuration Assistant and other configuration files.
  • Created and configured database manually using Oracle Database Configuration Assistant.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).
  • On call 24X7 Production Support.

Environment: Oracle 10g/9i, Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, RAC.

Confidential

Oracle DBA

Responsibilities:

  • Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem.
  • Recognition and resolution of database issues.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Oracle Grid Control Management Server Installation.
  • Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
  • Implementation of 10g Data Guard.
  • Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  • Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
  • Performed application migrations to non-cluster databases to cluster databases.
  • Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
  • Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
  • Applying security patches both Server side and Client side and Performed testing.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
  • Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/9i, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential, San Francisco,CA

Oracle DBA/Developer

Responsibilities:

  • Responsible for installing, upgrading and configuring the Oracle server.
  • Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and .
  • Involved in logical and physical data modeling and schema design using Erwin tool.
  • Created database manually.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Creating databases, objects, roles and privileges. Partitioned large tables to increase the performance.
  • Responsible for Data load on different databases using SQL*Loader.
  • Export and import of database objects using EXP and IMP.
  • Table partitioning to improve I/O access.
  • Implemented Data Guard on Oracle 9i.
  • Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
  • Using database level triggers code for database consistency, integrity and security.
  • Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
  • Configured Oracle streams on Linux.
  • Worked on performance and tuning on SQL queries.
  • Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
  • Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Environment: Oracle 10g/9i, Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, ASM, RMAN,AIX, Erwin.

Confidential

Oracle Developer/ DBA

Responsibilities:

  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
  • Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
  • Modified Korn shell scripts as per technical specifications.
  • Prepared Data Flow Diagrams for existing PL/SQL code.
  • Involved in coding of data extraction scripts as per technical specifications.
  • Analyzed the table structures using Analyze command.
  • Involvement in all phases of the project life cycle.
  • Designed database tables as per technical specifications.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 9i, windows 2000/2003, Linux