We provide IT Staff Augmentation Services!

Oracle Resume

Fairfax, VA

ORACLE DBA

SUMMARY:

  • About Seven years of experience as an ORACLE DBA(8i/9i/10g/11g) on different Unix and Windows environments like - Linux,AIX, HP-UX , Sun Solaris, Windows NT/2000/2003.
  • Installed and configured 2, 4, 6 node server side load balancing RAC (Real Application Clusters) databases on HP UNIX and Linux with ASM (Automatic Storage Management) and Data Guard.
  • Experience in Upgrade from oracle 8i, 9i to oracle 10g, 11g and Migration of oracle database from red hat Linux, Window platform to Linux on development, integration and production environment using Oracle Data Migration Assistant.
  • Experience in full life cycle of database administration. Worked both as a Development and Production Support DBA on a 24x7 Basis. Willing to work beyond regular hours.
  • Successfully implemented physical standby database using Oracle Data Guard featurefor High availability configuration.
  • Experience in Installation, upgrades, patches, TAR support. Duties included database creation, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
  • Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup usingand full/ partial export/import and Data Pump.
  • Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
  • Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
  • Experience inmaintaining and monitoring databases By Oracle Enterprise Manager (OEM).
  • Design and Implement Database security, schema management, Back-up, Restore, Scheduling and Maintenance task in SQL SERVER.
  • Experience on Parallel Execution, Advanced Compression.
  • Knowledge of Oracle Application Server (OAS).
  • Knowledge of NetApp experience.
  • Experience with FTP,SFTP,PSFTP,SCP files on cross platform
  • Experience with OEM agent and GRID control Installation and configuration.
  • Working knowledge of DATAWAREHOUSING tools like ETL (Extraction, Transformation and Loading).
  • Experience in VM Ware Oracle Server administration, installation.
  • Expertise in loading data from flat files using external tables, SQL*LOADER.
  • Designed logical and physical Data Models using ERWIN into DDL and executed on large scale to create database.
  • Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
  • Result oriented, self-motivated, Team player, ability to work independently and within a team.
TECHNICAL SKILLS
  • OPERATING SYSTEM:HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows NT/2000/2003.
  • DBMS: ORACLE 8i/9i/10g/11g, SQL SERVER, MS ACCESS
  • TOOLS: Oracle Migration Workbench, SQL-Navigator, OEM , Power Designer, ERWin, TOAD, SQL* Loader, Crystal Reports, RMAN
  • LANGUAGES: SQL, PL/SQL, UNIX Shell scripting, Perl scripting
  • ETL: SQL Server Integration Services(SSIS)
Certifications

Oracle Database 11g Administrator Certified Associate (OCA)
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Application Database Administrator Professional (E-Business Suit R12)

Professional Experience

Confidential, Fairfax,VA
POSITION: Sr.ORACLE DBA
DEC 2011 - present

Description: Confidential is a global information services company has multiple project Commonwealth of Virginia agencies (COVA), institutions and public bodies conduct procurement business through a web portal, thus capturing the efficiency and effectiveness of a virtual centralized organization. This procurement solution enables the Commonwealth of Virginia to obtain goods and services easier, faster, and at the best value.

Responsibilities:

  • Installation and configuration of oracle 10g,11g database on Linux, AIX and Sun.
  • Creation and configuration of Oracle database of various sizes 200GB to 500 GB, and 2TB in Dev, ITG, Model and Production environments.
  • Cloned databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
  • Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
  • Create UNIX shell scripts that automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
  • Create table with Daily Range partition as per the requirement.
  • Create Clone databases using user-managed as well as RMAN.
  • Support the development staff for implementation of database objects.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
  • Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
  • Integrated the Backup status reporting for the entire database in the enterprise to enable the 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 the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.

Confidential, Stamford, CT
POSITION: ORACLE DBA
March 2011 - NOV2011

Description: Confidential is a premier global financial services firm offering wealth management, investment banking, asset management and business banking services to clients. The project was to provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases.

Responsibilities:

  • Installation and configuration of Oracle 10g, 11g databases on Linux 5.4.
  • Implement Oracle 10g Release 1 RAC on Enterprise Linux 5.4 in a Test environment.
  • Migrated databases from 9i to 10g, 11g and 10g to 10g on different platform.
  • Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
  • Cloned databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
  • Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
  • Create UNIX shell scripts that automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
  • Create table with Daily Range partition as per the requirement.
  • Create standby database and worked with data guard to provide high availability.
  • Create and Manage user, table spaces, datafiles and archive log.
  • Monitor, tune and maintain overall database.
  • Create Functions, Procedure, triggers, synonyms and profiles.
  • Work with Flash Recovery Area.
  • Create and implement backup and recovery strategies using RMAN configuration.
  • Provide troubleshooting and problemsolving support to application developers.
  • Create Clone databases using user-managed as well as RMAN.
  • Support the development staff for implementation of database objects.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
  • Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
  • Transported tablespaces and data exports from production and staging databases.
  • Applied client patches and other patches as required.
  • Support production databases on 24x7 on call basis.

Environment: Oracle 9i/10g/11g, RAC, TOAD, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN, Solaris 10, UNIX and Linux.

Confidential, Chatsworth, CA Sep 2010 - March 2011
ORACLE DBA

Description: Confidential is an established software development company specializing in high end database applications targeted to the financial and foreign exchange markets.

Responsibilities:

  • Installation and configuration of Oracle Database Software 10g.
  • Creation and configuration of Oracle database.
  • Migration of database (from 9.2.0.5 to 10.2.0.1) on SUN Solaris 2.7.
  • Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
  • Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
  • Production support of Databases on HP-UNIX.
  • Worked on FTP, ZIP files on cross platform.
  • Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
  • Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
  • Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
  • Successfully implemented physical standby database using Oracle Data Guard featurefor High availability configuration
  • Designed and Implemented database security using Oracle roles and privileges.
  • Troubleshoot Database performance issues using Automated Workload Repository(AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
  • Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
  • Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
  • UNIX Shell scripting for backup and monitoring of databases.

Environment:Oracle 10g/9i, SUN Solaris 2.7,Red Hat Linux, Hp-Unix, Windows 2000/2003, TOAD, OLTP, RMAN.

Confidential, FORT LAUDERDALE, FL
POSITION: ORACLE DBA
JAN 2010 - AUG 2010

Description: Confidential is a vertically integrated insurance holding company, which covers all aspects of insurance underwriting, distribution, claims processing and exposure management.

Responsibilities:

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

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

Confidential, Clinton, MA
POSOTION: ORACLE DBA
Aug 2008 - Nov 2009

Description: Confidential is the leading global solutions provider in the field of manufactured precision plastic products. The project was to migrate and upgrade the database and to perform day to day DBA activities.

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 the identification and resolution of database issues.
  • Setting up of RMAN configuration on the database to perform necessary back-up.
  • Proactively monitoringproduction 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, West Palm Beach,FL Jul ‘06 - Aug‘08
POSITION: Oracle DBA

Description: Confidential provides a wide array of banking solutions and services to help individuals and businesses meet their financial goals, delivered with the personal attention.

Responsibilities:

  • Installation, configuration and troubleshootingof 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.
  • WrittenStored Procedures and Triggers for database maintenance and management using PL/SQL.
  • Integrated the Backup status reporting for the entire database in the enterprise to enable the 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 the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
  • Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.
  • Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
  • Tuned Production database performances and instrumental in SQL tuning that improved application response and supported the Production DBA Team and analyzed each project in the production environment.
  • Involved in the 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 Dec‘04 - Jul ‘06
OracleDBA

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 the databases.
  • Involved in the process of tuning and refining SQL queries and analyzed TKPROF, Explain Plan outputs for improving the 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 the 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 the 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

Hire Now