We provide IT Staff Augmentation Services!

Oracledatabase Resume

Boston, MA

SUMMARY:
Over8 yearsof experience as anOracleDatabase Administratorhaving hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.

  • Involved in different scenarios ofOLTPas well asDSS(Data warehouse) databases.
  • Worked with a team to provide24x7on-callproduction database support.
  • Experience inHP-UX,AIX,SUN SOLARIS,Linuxand Windows environments.
  • Excellent experience in Installation and configuration of Oracle8i, 9i, 10g and 11g inUNIX/LINUXandWindowsenvironment.
  • Experience in installation and maintenance of Oracle 10g RAC using both ASM and OCFS2 File System
  • Installation, maintenance and tuning ofRACApplications. Used rapid install and other Oracle Application maintenance utilities likeOEM.
  • Createddevelopment, testing, staging, production, RACandstandby databasesfor OLTP, DSS and Data Warehousing using customizedshell scriptsand stepwise.
  • Management of schemas, objects & Partitioning thetables&indexes.
  • Development experience in creatingProcedures,Pro*C, Packages,Functions, Triggers and other database objects using SQL,PL/SQL.
  • Involved in the data migration from sql-server/DB2 to Oracle.
  • Proactive Monitoring, identifying areas that need to be improved in the application and database usingStatspack, AWR, ADDMand 10g OEMGridMonitoring.
  • Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM,GridMonitoring, Recycle Bin.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases usingRMAN with VERITASNet Backup.
  • Extensive performance tuning experience, specializing in Operating System Tuning,SQL Tuning,Database/Instance Tuning.
  • Planned and implemented Disaster Recovery &high availabilitysolutions using Oracle 10g Standby DatabaseusingOracleData Guard, 9i and 10g.
  • DeliveringOracleDatabase performance-tuning services for customers withExplain Plan,Tkprof,Statspack,SQL Trace,AWR, ADDM,10g OEM Grid Monitoringcustom scripts troubleshootingOracledatabases using SQL trace utilities.
  • PerformanceTuningi.e. tuning applications, shared pool, I/O distribution,rollback segments, buffer cache, redo mechanisms.
  • Experienced inOracleSupport processes for technical requests throughMetalinkand other Support Procedures
  • Good experiencein SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • Experience in basic and advanced replication usingOracleStreamsand experience in usingOEM,TOAD,SQLDeveloper ,DataMigrationsusingexport/import, benchmarking using load testing tools
  • Expertise in maintaining Database Security using security complianceauditing,expertise in loading data from flat files usingexternal tables, SQL*LOADER.
  • Worked on different types ofstorage structures (SAN/NAS).
  • Good written and verbal communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Operating Systems

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 95/98/ME/NT/2000/XP.

RDBMS

Oracle 11g/10g/9i/8i, SQL Server 2000.

Languages

SQL, PL/SQL, C, C++,UNIX Shell Scripting

Tools

TOAD9.5, SQL Plus, SQL Developer RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp , impdp , ERWIN, DTS ,Informatica.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK

Other

VERITAS, NetBackup, EMC

Web Tools

HTML, XML


CERTIFICATION:

  • Oracle 10g Certified Associate

PROFESSIONAL EXPERIENCE:

Confidential,Boston ,MA. Jan2008 – Till Date
Role: Oracle Database Administrator

Responsibilities:

  • Installation and Configurations ofOracle 11g ,10g and 9ionLinux.
  • InstalledRACon Oracle 10g and worked onASMfeature of Oracle
  • Involved in performing migration from Oracle 10g to Oracle 10g RAC database
  • Installation and configuration of 32 bit and 64 bit 9i/10g RAC on UNIX and Windows environment
  • Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools likeErwin
  • Created and manageddatabase objects such astables, indexes, partition tablesandviews.
  • Created and managed users, roles, privileges, profiles, schemas using OEM.
  • Handling large database environments (Datawarehouse) usingETLtoolInformaticaand Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database
  • 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.
  • Worked on Automatic Storage Management(ASM)for managing data inSAN.
  • Upgradation and migrationfrom Oracle 9.2.0.8 databases to Oracle10.2.0.3.
  • Manage data architects, data administrators and client enhancement requests.
  • Have setup snapshotreplicationdatabase for reporting purpose.
  • Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did thepatch managementfor oracle upgrade.
  • Expertise in Client server GUI software and different Operating systems.
  • Migrated from SQL server to oracle .
  • Worked onimport/export, export datapump/import datapumpandSQL- loader.
  • Cloning databases using scripts as well asRMAN. Installation, setup and configuration ofOracle Streams.
  • Creating and rebuilding indexes and optimizing the code to improve the performance.
  • Have done database backup and recovery usingCold backup/ Hot backup/ Logical.
  • Setup backup and recovery procedure using Netbackup ,Rman.
  • SQL tuningand Database tuninghas been done based on reports generated bySQL Trace,TKPROF Reports, Statspack, Explain Plansand monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
  • Worked on SQL Navigator for tuning database, developing and testing stored procedures, schemas, and SQL scripts.
  • Wrote UNIXshell scriptingto automate tasks and crontab and dbms_schedulerfor scheduling jobs

Environment:Oracle 9i/10g, RAC, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, Rman, ASM, Tkprof, Statspack, SQL Loader ,AIX ,Linux, HP-UX, Windows NT/2000.

Confidential, NY.March2007 – Dec2007
Role: Oracle DBA
Responsibilities:

  • Have worked on different environments like test, development and production databases.
  • Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
  • Analysis of the existing Data Warehouse system to understand existing functionality
  • Have worked on backup/recovery, performance tuning.
  • Worked onOLTPandOLAPdatabase systems.
  • Installation and creation of Oracle 9i, 10g databases on Production and Test Solaris servers.
  • Installed and configured Oracle 10g Real Application Clusters (RAC) on linux.
  • UtilizedOracle Enterprise Manager (OEM), Grid controlto manage users, privileges, profiles, and schemas.
  • Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
  • Responsible forupgrade & migrating databases from 9i to 10g, applying patches.
  • Database Restore usingRMAN,Cold BackupandExport.
  • Worked on VERITAS volume manager and VERITAS Cluster Service.
  • Involved in Design and implementation oforacle 10g Dataguardboth physical/logical standby databases.
  • Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
  • Usedimportdp/exportdpandSQL- loaderto load data into tables.
  • Identified, designed and developed allOracle PL/SQLPackages,Procedures,Functions,Triggersand arrays.
  • Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and writeUNIX shellsscripts for job automation.
  • Performed database and memory tuning using tools likeSTATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
  • Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment:AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0.

Confidential , Columbus ,OH.June2006 – Feb2007
Role: Oracle Database Administrator

Responsibilities:

  • Review of Database logical and Physical design.
  • Install, upgrade and maintain Oracle 9i on, Linux and Windows 2003
  • Database monitoring and performance tuning usingOEM(Oracle Enterprise Manager) andSTATSPACK.
  • Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
  • Implementing Database Security, Management of role-based security
  • Database Restoreusing RMAN, Cold Backup and Export.
  • Applying Patches 9.2.0.6and applying Oracle DST Patches on Oracle database.
  • 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.
  • Corporation and installation of patches.
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Problem analysis involving interactions/dependencies between UNIX and Oracle.
  • OLAP on Oracle platform using Oracle Express (OLAP server), Data Migration as part of enterprise data warehouse project.
  • Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
  • UsedPL/SQL, SQL Loaderas part of ETL process to populate the operational data store.
  • Performed scheduling Control-m for scheduling jobs.
  • Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
  • Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Environment: Oracle 8i/ 9i, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, RHEL

Client : CONFIDENTIAL, Reston , VA Dec 2005– May 2006
Role: Oracle Database Administrator

Responsibilities:

  • The work involved overallMaintenance of Oracle Database, PerformanceTuning, Backup, Recoveryand other database related activities.
  • Taking Backups on scheduled time andMonitoring Scheduled Backups.
  • Creating and dropping of users, granting and revoking rights as and when required.
  • Checking ofOraclefiles for abnormal behaviors.
  • Day to dayPerformance Monitoringand tuning of database.
  • Diagnose andTroubleshoot Database Problemsand failures
  • Involved in the Design (Logical & Physical) of Databases
  • PreparingBackup and Recovery Plan.
  • Involved in the installation ofOracle9i on Solaris and UNIXplatform.
  • Creation and maintenance of database. Handling day-to-day activities.
  • Monitoring of database for growth and performance
  • Defined backup procedures using daily hot backups and weekly cold backup.
  • Storage and space management including table spaces and data files.
  • Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
  • Management of table space growth, monitoring data files additions, extent growth
  • Constantly monitor the performance of the Databases and viewingAlert log files&Trace files.
  • UsingTKPROF, EXPLAIN PLANfor the Better performance.
  • Monitoring of database for growth and performance
  • Monitoring Database for fragmentation and correcting them
  • Creating and implementing backup and recovery strategies
  • Setting up and maintaining user accounts and profiles, Space management
  • Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment:Oracle 9i, SQL, PL/SQL, TOAD, Sun Solaris 2.5, 2.6, UNIX Shell scripting.

Confidential, Philadelphia ,PA May 2004 – Nov 2005
Role: Oracle Database Administrator

Responsibilities:

  • Support & Maintenance of Production/Development Databases on various servers.
  • Install and create database, managing servers of other groups on call duty.
  • Logical and Physical Modeling.
  • Coordinate with Unix Administrators for space management on various servers and help in Oracle Installation,Upgrading from 8i to 9i.
  • Capacity Planning, Storage Allocation and Space Management.
  • Creating users, tables,database links, Performing Exports/Imports.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups
  • Database Tuning – Tuning Applications, Tuning Memory and Tuning Disk Usage.
  • Created PL/SQL Packages, Procedures and Functions for maximumperformance
  • TuningRollback segments, Sizing the database for future growth.
  • Performing Database monitoring for deadlocked process and maintaining logs/Backups usingImp/ExpUtilities & VERITAS Backup system.
  • Automating the process/Scheduling Jobs usingDBMS_JOB.
  • Writing scripts for monitoring the database, Configuring SQL* Net. Integrating multiple application databases with multiple corporate entities, receiving business data feeds.
  • Fine Performance Tuning the Databases for optimization, Tuning Application, Estimating Table & Index Size in TOAD7.5.5/7.6, Diagnosing the contentions, troubles using v$views.
  • Storedprocedures, packages&triggersto support the Front end/e-commerce.
  • Supporting the Development team, supporting production Environment, Setting up passwords for SVRMGR and Listener, Sending out e-mails/alerts from the Database using UTL_SMTP.

Environment:Oracle 8i/9i, OEM, DBCA, TOAD, Data Guard, XML, Sun Solaris, Test Director, CVS, Erwin, FTP, UNIX, Windows XP.

Confidential Sept 2001 – March 2004

Role: Jr. Oracle DBA/ Developer

Description:
Siemens is often at the forefront in responding to new trends in the healthcare industry and has built its operations through internal growth, strategic alliances and mergers and acquisitions. I worked with SEDA - Sorian Enterprise Data architecture – Clinical and Financials.

Responsibilities:

  • Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
  • Analyzed the structures using Analyze command. Involvement in all phases of the project life cycle
  • Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
  • DevelopedPL/SQLfunctions and procedures to provide APIs for the front-end developers to manipulate the database efficiently.
  • Involved in application Testing, Deployment, Production Support.
  • Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
  • Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
  • Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
  • Implemented automated backup strategy using the UNIX shell script Cron Utility.

Environment:Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities.

EDUCATION:

  • Bachelor of Technology in Electronics and communication

Hire Now