We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

5.00 Rating

Stamford, CT

PROFESSIONAL SUMMARY:

  • Around 9 years of experience as Oracle DBA. Worked extensively on Oracle 11g, 10g, and 9i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
  • Expertise in installation, setup and configuration of Oracle 11g, 10g, & 9i on SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS, LINUX
  • Expertise in Oracle Enterprise Manager (OEM) and setup of Oracle Grid Control
  • Implemented RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
  • Implemented and delivered core edge technologies of Oracle 11g (EM Grid Control, and RAC)
  • Having strong knowledge in 11g RAC
  • Installed Oracle 11g & 10g RAC software with ASM & OCFS2 file systems.
  • Worked on large-scale databases with size more than 10 TB in large system environments
  • Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS NetBackup
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise on various platforms..
  • Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g
  • Worked as a team member to provide 24x7 on-call production database support
  • Logical and physical modeling using Erwin
  • Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
  • Datacenter transfer on various version and platform.
  • Performance tuning of teh database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
  • Expertise in maintaining and reinforcing standards for change management, database security plan and auditing
  • Proficient in raising TAR with Oracle Support and using Metalink to resolve teh bottlenecks in teh database environments
  • Worked on different types of storage structures (SAN/NAS)
  • Management of Schemas, Objects & Partitioning teh tables & indexes
  • Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)
  • Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views
  • Experience in Load and Performance testing of teh database servers and application servers, analysis and documentation of results
  • Database replication using snapshots, materialized views and advanced Replication methods
  • Excellent communication and interpersonal skills
  • Excellent analytical, problem solving, communication, managerial and interpersonal skills with teh ability to interact with individuals at all levels. Good interpersonal skills, self-motivated and fast ability to absorb new technology.

TECHNICAL SKILLS:

HP: UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,6.1 Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 98/NT/2000/2003/XP

RDBMS: Oracle 11g/10g/9i/ Oracle 10g (RAC, Data Guard), SQL Server 2005

LANGUAGES: SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, ERwin, TOAD, Data Pump (expdp, impdp), Shareplex, Autosys, Query Analyzer, Crystal Report, ETL (Informatica 8.5), VERITAS NetBackup, Developer 2000, SQL*Plus, SQL*Loader

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

  • Manages and maintains data in all production and non-production databases and replication servers. Maintains security database; generates reports, queries and documenting. Works with project teams to identify database changes needed to implement project
  • Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production.
  • Support of Oracle 9i,10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux, AIX, Sun Solaris.
  • Implemented ASM on RAC. Managing disks and disk groups with ASM.
  • Implemented SharePlex on 11gr2 database on Red Hat Linux
  • Performed migration activities from 10g to 11g R2 for large databases.
  • Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
  • Keeping teh databases up to date with respect to Latest PSU’s and very comfortable in applying patches
  • Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
  • Monitored and trouble shooted database issues with OEM grid control.
  • Built physical standby using RMAN Active duplication method as well for Disaster recovery site
  • Performed database recovery using GRP (Guarantee Restore Point) .
  • Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • Automated routine DBA tasks like backup’s and stats by using Grid control job’s
  • Provided Assistance to application team at teh time of SQL tuning in applications.
  • Creation, configuration and setting up of RMAN catalog databases and registering target databases with teh catalog.
  • Create and implement backup and recovery strategies using RMAN configuration.
  • Create Clone databases using user-managed as well as RMAN.
  • Database refreshes with Datapump/RMAN Utilities.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
  • Additionally, part of rotation oncall DBA to support databases 24X7

Environment: OEM Grid Control, Oracle 9i, 10g, 11gr2, RMAN, Import & Export, Datapump, Data guard, oracle 10g/11g RAC, ASM, CRS clusters, TOAD 8.2/10.1, SunOS 5.10, HP-UX 11.11,RHEL 5.6/6.2, AIX

Confidential - Stamford, CT

Oracle DBA

Responsibilities:

  • Responsible for administration and supporting Oracle 11g, 10g and 9i databases in DEV, QA, UAT and Prod environments
  • Installation and Setting up of 11g RAC in AIX environment and 11g ASM on RAC databases
  • Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to teh FRA
  • Downsizing and defragmenting teh Large Databases by export/import, cloning those using RMAN duplicate features and tan upgrading them to Oracle 11g
  • Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection
  • Proactive database monitoring using 11g grid monitoring tool.
  • Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
  • Applied patches to Oracle Databases and Oracle Applications.
  • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
  • Worked on Automatic Storage Management (ASM) for managing data in SAN
  • Monitoring and resolving tickets in different environments
  • Export and Import of database objects to copy from one database to another database between different environments
  • Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
  • Created UNIX shell scripts to automate batch jobs through Cron
  • Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Environment: IBM-AIX, Sun Solaris, Oracle 11g, 10g, and 9i, Oracle RAC (11g), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Confidential - Chatsworth, CA

ORACLE DBA

Responsibilities:

  • Supported Oracle 11g, 10g and 9i databases
  • Installed and created 11g databases
  • Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
  • Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g
  • Installed Oracle 10g RAC software with ASM & OCFS2 file systems
  • Configuration, maintenance and tuning of 10g RAC
  • Setup of Disaster Recovery databases (Data Guard)
  • Refresh schema-using Export/Import. Creating teh database, table spaces, tables, indexes, setting privileges and user logins
  • Installing and Configuring Recovery Manager (RMAN)
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
  • Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
  • Experienced in migrating databases to higher releases including incremental migrations
  • Migrated database from 9i to 10g and 11g across teh platform and supporting various incremental releases
  • Performed Conversion of data from Post Gre SQL to Oracle
  • Query optimization for reporting and ETL
  • Created & Managed Jobs using AutoSys Job Scheduler
  • Extensive UNIX Shell scripting in csh, Pro*C
  • Planned version control of production source code using Clearcase
  • Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
  • Security User Management, Privileges, Role, Auditing, Profiling, Autantication
  • Made performance improvements to teh database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
  • Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
  • Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary
  • Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
  • Used Oracle Internet Directory to leverage teh scalability, high availability and security features of teh Oracle Database
  • Taking Hot and Cold Backups, Exports etc
  • Data Modeling, Database Design and Creation using ERwin
  • Created Triggers for multimaster replication

Environment: HP-UX, Windows 2000/2003, and Linux, Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clearcase, SQL*Plus, PL/SQL, Post Gre SQL, SQL*Loader

Confidential . - FORT LAUDERDALE, FL

ORACLE DBA

Responsibilities:

  • Installation and configuration of Oracle Database Software 9i.
  • Creation and configuration of database.
  • Performance tuning of application by identifying teh SQL, which are not written well; providing inputs to teh application programmer; correcting and implementing teh right components.
  • Upgrading database from Oracle version 8i to 9i and migration of data.
  • Integrated teh Backup Status Reporting for all teh databases in teh enterprise to enable teh web reporting using Oracle SQL and PL/SQL.
  • Worked with UNIX scripts for monitoring and backup of teh database.
  • Communicating with Oracle to get teh necessary patches required to fix up teh database changes needed using TAR support and coordinating teh patches and implementing teh necessary changes.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
  • Identifying issues/ bottlenecks dat could potentially cause issues, involving teh right teams (such as server admins or application developers) and take a corrective action to rectify teh issues.
  • Written extensively UNIX Shell Scripts & PL/SQL Stored Procedures and Triggers.
  • Performance tuning for Oracle Day-to-day maintenance and management of teh different databases in development, test and production environments.

Environment: ORACLE 9i, AIX 4.3, OEM, RMAN, Tkprof, PL/SQL, UNIX

Confidential - Clinton,MA

Senior Oracle DBA

Responsibilities:

  • Installation and configuration of Oracle 9i on AIX 5.2.
  • Creation and configuration of database.
  • Participation in designing data model for administration system.
  • Upgrading database from Oracle version 8i to 9i and migrate data on diverse platform.
  • Troubleshoot Database performance issues using TKPROF, STATPACK, EXPLAIN PLAN. Tuned database for optimum performance.
  • Develop difficult PL/SQL script to perform error managing and reporting.
  • Change databases designs for many purposes such as data migration, data warehouse, and online transactions.
  • Installation of software on a wide range of platforms, for large number of clients.
  • Schedule jobs in Crontab including RMAN backup and other memory maintenance, security jobs.
  • Maintain and monitor multiple databases using Oracle Enterprise Manager.
  • Provides services in teh identification and resolution of database issues.
  • Setting up of RMAN configuration on teh database to perform necessary back-up.
  • Proactively monitoring production environment for any exceptions/ issues.
  • Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers.

Environment: ORACLE 9i/10g, OEM, SQL, PL/SQL, RMAN, TKPROF, AIX 5.2, WINDOWS 2000.

Confidential, FL

Oracle DBA

Responsibilities:

  • Installation, configuration and troubleshooting of Oracle Database Software 9i and 10g on RHEL 3.0 and 4.0 environment and RAC setup with ASM.
  • Upgrading database from Oracle version 9i to 10g and migration of data.
  • Worked on backup, recovery and disaster recovery strategy using RMAN.
  • Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
  • Integrated teh Backup status reporting for teh entire database in teh enterprise to enable teh web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
  • Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
  • Extracted data from Oracle database into XML format for EDI requirement.
  • Worked on logical backup using and full/ partial export/import and Data Pump.
  • Involved in disaster recovery planning; detailed out teh processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
  • Involved in applying patches as per teh requirements of teh client and upgrade Oracle and DBMS software under Oracle and SQL server.
  • Performance tuning of application by identifying teh SQL, which are not written well; providing inputs to teh application programmer; correcting and implementing teh right components.
  • Tuned Production database performances and instrumental in SQL tuning dat improved application response and supported teh Production DBA Team and analyzed each project in teh production environment.
  • Involved in teh project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g.
  • Developed and maintained logical schema, physical records and SQL queries for Oracle applications 9i databases.

Environment: Oracle 9i, HP-UNIX, Sql-Loader, UNIX Shell Programming, SQL, PL-SQL, Stored Procedures, Functions and Triggers, TOAD

Confidential - NJ

Oracle DBA

Responsibilities:

  • Installed and supported Oracle 9i for Production, Test and Development databases.
  • Upgraded from Oracle 8i to Oracle 9i.
  • Performed cloning to create test and development databases.
  • Developed scripts for database backup and recovery including HOT and COLD backup with and without RMAN.
  • Set up RMAN catalog for all teh databases.
  • Involved in teh process of tuning and refining SQL queries and analyzed TKPROF, Explain Plan outputs for improving teh performance.
  • Achieved replication by creating and refreshing SNAPSHOT/Materialized Views.
  • Configured listeners with Net Manager and created SQL*NET server configuration files such as tnsnames.ora and listener.ora and started teh listener for making database available to users.
  • Created databases using DBCA, OMF and manually.
  • Provided security and implemented various auditing techniques.
  • Created table spaces, tables, indexes, triggers for custom applications.
  • Database export/import using export and import utilities.
  • Performed data loads from flat files using SQL loader utilities.
  • Performed database administration tasks like space management, users, roles, profiles, schema management.
  • Wrote scripts to monitor teh alert log and listener.log files for ORA errors.
  • Compiling invalid objects using utlrp.sql.
  • Monitored database for fragmentation and corrected them.
  • Experience in writing Shell scripts to run various Cronjobs.
  • Involved in maintenance tasks at sever level.
  • Involved in contacting Oracle support about technical issues through Metalink.

Environment: ORACLE 9i and 8i, LINUX 2.x, SUN SOLARIS 5.8, Windows XP

We'd love your feedback!