We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume Profile

Minneapolis, MN

SUMMARY

  • Over 8 years of experience in Information Technology as an Oracle DBA on Linux, UNIX and Windows operating system environments.
  • Experience in working and administrating ORACLE Golden Gate.
  • Experience as a Production support/Operations DBA with Multi-Terabyte 24x7/large databases and as a Development Engineer/Data Warehouse DBA.
  • Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes 5TB.
  • Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version's 8i, 9i, 10g 11g.
  • Configured and maintained Real Application Clusters environment for high availability and scalability.
  • Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery RMAN .
  • Experience in configuring Data Guard -- Physical Standby and Logical Standby Databases.
  • Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc.
  • Experience in implementing Automatic Storage Management for simple storage interface.
  • Experience in installing and configuring/Monitoring Enterprise Manager Grid Control.
  • Experience in configuring and Installing/using various Quest Tools- Foglight, TOAD.
  • Experience in working with IBM OPTIM tool.
  • Knowledge on various ETL, Reporting, and Database development tools like IBM Optim, SQL Server, and Oracle with strong SQL coding skills.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan
  • Strong knowledge and experience in using Oracle Configuration and Provisioning Pack.
  • Expertise in SQL and PL/SQL, writing stored procedures, triggers and functions.
  • Extensive knowledge in working with the tools like Grid Control, Oracle Portal, Oracle Enterprise Manager, TOAD, SQL developer, Datapump, Exp/Imp.
  • Extensive knowledge in writing various Shell/PERL Scripts for automation and monitoring of databases.

TECHNICAL SKILLS

Database: Oracle 8i, 9i, 10g, 11g , MS SQL 2000/2005

Operating systems: Sun Solaris, AIX, HP-UX, Windows 2000/2003/2008, Windows NT, Redhat Linux, UNIX

Programming

Scripting languages: C, C , C , SQL, PL/SQL, Oracle Forms 10g, 9i, 6i, 4.5 /Reports 10g, 9i, 6i , T-SQL, Shell/Perl scripting

Tools: Oracle Grid Control 5, SQL Loader, RMAN, Toad, Quest tools, Sql developer, Statspack, Golden Gate, TKPROF, Data-pump, DBCA, DBUA, IBM Optim, WinSql, Agginiti.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

  • Manually Upgrading 9i, 10G and 11.2.0.1 databases to 11.2.0.3 on AIX 64-bit servers.
  • Installing 11.2.0.3 Oracle Software for the Oracle upgrades.
  • Installing OPatch utility of version 11.2.0.3.4 and applying PSU 14275605 for 11.2.0.3 upgrades.
  • Manual creation of 11.2.0.3 database.
  • Setting up logical back-up exp and imp by making use of pipes.
  • Migrating schemas from Oracle database to the other.
  • Tracing out the SQL s in prod databases using tkprof and tuning them by making use of SQL profiles using OEM.
  • Creating materialized views for resultant tables and refreshing them to eliminate the full table scans in the SQL.
  • Making use of SQL Advisor to identify indexing and partitions using OEM.
  • Tuning SGA and PGA parameters.
  • Identifying performance issues by making use of diagnostic pack by generating AWR, ASH and ADDM reports.
  • Monitoring table-spaces using IBM Tivoli Enterprise Portal to resolve space issues.
  • Working with IBM Center for any production database changes.
  • 24X7 On-call support for the databases once every week and once in weekend every two months.
  • Installed Golden gate, installed Oracle sequence objects, Installed DDL support scripts
  • Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
  • Upgrade oracle 10g databases to 11.2.0 version
  • Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases Maintenance.
  • Configured Automatic Storage Management ASM for 10g RAC databases for reducing disk
  • Performing Database Refreshes using Exp/Imp, Datapump, Sql Loader and RMAN.
  • Installed, configured Oracle 10g 11g RAC with advanced features
  • Very good experience with Oracle 10g RAC administration
  • Setup the Oracle Advanced Replication using DB links materialized views.
  • Good experiences with UNIX shell scripting.
  • Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
  • Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc
  • Experience in Installing and configuring IBM Optim.
  • Experience in test data management process design and working on IBM Optim.
  • Good understanding of test data management concepts such as Data Masking, Data Sub setting and Data Manufacture. Ability to independently write, maintain complex SQL queries, stored procedures for one or more databases. Oracle, DB2, SQL Server, etc.
  • Identifying and securing sensitive data records using data masking or data de-identification methods.

Environment: Oracle 9i/10g/11g, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN.

Confidential

Sr. Oracle DBA

Responsibilities:

  • 24x7 Oracle Database Administration of Production, Development, Testing databases.
  • Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using Dataguard.
  • Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
  • Involved in Data Modeling, Design, Implementation and Creation of Databases.
  • Worked closely with System Administrators, Network Administrators to build the RAC environment.
  • Involved in setting up of ORACLE 10g RAC Databases for test prototype environment with three nodes-clusters on Red hat Enterprise Linux 4.
  • Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
  • Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
  • Documented the procedures for adding a node for current DATAGUARD environment.
  • Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
  • Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
  • Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.
  • Configured and performed automated and various levels of backups using RMAN.
  • Installed ORACLE Enterprise Manager GRID CONTROL and configured it server targets for a centralized monitoring system.
  • Monitored databases Performance using ORACLE Enterprise Manager OEM and Grid Control.
  • Monitored and maintained Security by managing Roles/Privileges for users of the databases.
  • Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
  • Responsible for Instance Tuning, I/O Tuning, Identifying and fixed contention waits.
  • Used ORACLE Wait Interface, to identify the top most wait events and their causes.
  • Used advisor, tasks like ADDM, SQL Tune, Access Tune and Undo Advisors for performance tuning.
  • Resolved several performance bottlenecks and poorly tuned Ad hoc SQL Statements.
  • Installed and updates critical security Patches using Enterprise Manager and O PATCH.
  • Worked extensively with tools like SQL Loader, Datapump, Exp/Imp, for loading data into database and monitoring and querying databases using TOAD etc.
  • Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc as per the given structures, operations, data in the tables for increased performance.
  • Documented the entire core procedures required for the oracle database maintenance.
  • Created Materialized Views/Snapshots for replications and increase query performance.
  • Partitioned Tables, Index for increased query performance and easier maintenance.
  • Analyzed query plan using Plan Table, Explain Plan, optimizer Hints and for estimating CPU Query costs.
  • Refreshed PROD, DEV, UAT databases using Datapump, RMAN, Transportable Tablespaces etc.
  • Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
  • Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.

Environment: Oracle 8i/9i/10g, Oracle 10g/9iOAS, Solaris 9, Red Hat Enterprise Linux, Unix, RAC, Windows 2003, Grid Control 2, TOAD, and SQL developer.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Created check point table, did Data load using Expdp/Impdp for replication in Golden gate.
  • Implemented Oracle Data pump and stream instantiation, created single and multiple source environments, managed LCR s in Oracle Streams.
  • Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
  • Translating technical and Business requirements into efficient Logical and Physical data models.
  • Installed configured Weblogic server on UNIX platform and deployed applications.
  • Contention and providing centralized management for Disks.
  • Supported installation and setup of ORACLE Cluster's and RAC database.
  • Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
  • Good experience with multi master replication setup Administer with Golden Gate tool.
  • Setup reporting server using ORACLE Streams from various data sources.
  • Performed database Migration from Windows platform to Linux using RMAN Convert and Datapump.
  • Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
  • Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
  • Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
  • Resolve database performance issues, database capacity issues and other distributed data issues OLTP .
  • Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
  • Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
  • Performed Table, Index Partitions for increased performance and for better storage management.
  • Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
  • Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
  • Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.
  • Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
  • Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
  • Performing Backups BLI, Full, Cumulative, Differential , Recoveries using RMAN-Netbackup.
  • Used Flashback technologies-Flashback Table, Flashback Query Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
  • Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
  • Performing Database Refreshes using Exp/Imp, Datapump, Sql Loader and RMAN.
  • Writing Triggers and debugging Stored Procedures and Functions-PL/SQL.
  • Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.
  • Performed Backup and Refreshed SQL SERVER 2005 Databases using SSMS.
  • Performed Export and Import utilities in SQL SERVER databases.
  • Monitored Performance of databases and Administrated user security of MS SQL 2005.
  • Monitored SQL SERVER Databases, assisted developers in debugging T-SQL Procedures.

Environment: Oracle 8i, 9i/10g/11g, SQL SERVER 2005, Oracle ASM, Solaris 10, REDHAT Linux, Unix, Oracle Grid Control, SAN, Datapump, RMAN, Golden Gate, SQL Loader, Exp/Imp, Remedy and Toad.

Confidential

Oracle DBA

Responsibilities:

  • Database Administrator for Production, Development and UAT databases and provided on-call production database support.
  • Configured Dataguard disaster recovery procedure using Physical Standby Databases.
  • Monitored Standby Databases and performed switchover and failover mechanisms of Dataguard.
  • Installed ORACLE 9i/10g software's on Windows and Unix Platforms.
  • Supported CRS/RAC Database installation for HA, Scalability of databases.
  • Setup and Upgraded ORACLE 9i databases to ORACLE 10g databases.
  • Setup backup procedures for various PRODUCTION databases based upon SLA.
  • Took Full/Incremental backups using ORACLE Recovery Manager RMAN .
  • Administrated database regarding space related issues- monitoring Tablespaces, users' security of data accessibility and Configuring Archive log destinations and Flash Recovery Area FRA .
  • Loaded/Refreshed data into database's using Exp/Imp, Network Links and Datapump etc.
  • Wrote Stored Procedures and Packages in PL/SQL that are called by Java code to perform back end processing.
  • Tuned SQL and PL/SQL code using Oracle Enterprise Manager OEM Tools, Query Analyzer and Explain Plans.
  • Applied various patches on regular basis to oracle software homes.
  • Monitored Alert log and wrote scripts in SQL for quick health check of the databases.
  • Monitored databases using Enterprise Manager and resolved issues based upon severity level.
  • Created Clone and Duplicate databases for load testing, Acceptance testing etc using RMAN.
  • Created Materialized Views/Materialized Views Logs for data replications.
  • Analyzed databases using AWR, Statspack Report and resolved issues to maintain performance.
  • Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
  • Monitored and tuned rollback segment, temporary Tablespaces, redo log buffer, sort area size.
  • Assuring Load balancing, monitoring disk I/O statistics, Data file I/O statistics read/write ratios and fixing problems.
  • Create Triggers and defined constraints to maintain the data integrity in the databases.
  • Installation and configuration of ORACLE SQL NET, and Net8 for client-server connectivity.
  • Managed and resolved design issues during development stage. Worked closely with developers.
  • Wrote Perl/Korn shell script for many databases tasks- backing up databases, Info about CPU/System Stats etc.

Environment: Oracle 10g/9i/8i, Sun Solaris 8, AIX 5L 5.3, Windows 2003, TOAD, RMAN, OEM, ERWin Designer.

Confidential

Oracle DBA/ Developer

Responsibilities:

  • Performed Installations of Oracle software on various Windows and UNIX servers.
  • Designed and developed Web-enabled Oracle Forms Reports. Including Forms based on stored procedures.
  • Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
  • Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
  • Installed, configured Oracle 9i RAC in Red Hat Linux servers.
  • Migrated the databases from Oracle 9i to 10g in cross platform.
  • Contributed to team effort by accomplishing related results as needed.
  • Responsible for optimizing the queries and application tuning.
  • Performed PL/SQL tuning and assist developers with coding PL/SQL.
  • Controlling and monitoring user access to the database for new and existing databases.
  • Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
  • Involved in numerous Shell Scripting pertaining to the activities of the DBA.
  • Performing Management tasks on Schemas and objects using TOAD
  • Using SQL Loader, Export, Import in order to Extract and Load Data.
  • Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
  • Worked with database export import scripts to backup database structures and automation procedures.
  • Planning and scheduling for the backup of database information using Crontab jobs.
  • Generated daily, weekly and monthly reports regarding total revenue management.

Environment: Windows 2000/NT, Oracle 8i/9i, 10g, Redhat Linux, UNIX, TOAD, Export/Import utilities

Hire Now