We provide IT Staff Augmentation Services!

Sr.oracle Dba Resume

Fairfax, VA

SUMMARY:

  • AboutSevenyears of experience as anORACLE 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 balancingRAC (Real Application Clusters)databases on HP UNIX and Linuxwith ASM (Automatic Storage Management) and Data Guard.
  • Experience inUpgradefrom oracle 8i, 9i to oracle 10g, 11g andMigrationof oracle database from red hat Linux, Window platform to Linux on development, integration and production environment usingOracle Data Migration Assistant.
  • Experience infull life cycleof database administration. Worked both as aDevelopment and Production Support DBAon a24x7Basis. Willing to work beyond regular hours.
  • Successfully implementedphysical standbydatabase usingOracle Data Guardfeaturefor High availability configuration.
  • Experience inInstallation, upgrades, patches, TAR support.Duties included database creation,backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
  • Designed and implementedbackup and recoverystrategies. Extensively used conventional andRMANfor backup and recovery. Logical backup usingand full/ partialexport/importandData Pump.
  • Experience inPerformance Tuningof database, instances,SGA, I/O, and Rollback segmentusing different methods and detecting locks.
  • Efficient in SQL query optimization and instance tuning usingSTATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDMreports, 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 ByOracle Enterprise Manager (OEM).
  • Design and ImplementDatabase security, schema management,Back-up, Restore, Scheduling and Maintenance taskin SQL SERVER.
  • Experience onParallel Execution, Advanced Compression.
  • Knowledge ofOracle Application Server (OAS).
  • Knowledge ofNetApp experience.
  • Experience withFTP,SFTP,PSFTP,SCPfiles on cross platform
  • Experience withOEM agent and GRID controlInstallation and configuration.
  • Working knowledge ofDATAWAREHOUSINGtools likeETL(Extraction, Transformation and Loading).
  • Experience in VM Ware Oracle Server administration, installation.
  • Expertise in loading data from flat files usingexternal tables,SQL*LOADER.
  • Designed logical and physicalData ModelsusingERWINinto 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 Database11gAdministrator Certified Associate(OCA)
Oracle Database11gAdministrator 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 oforacle 10g,11gdatabase onLinux, AIX and Sun.
  • Creation and configuration of Oracle database of various sizes 200GB to 500 GB, and 2TB in Dev, ITG, Model andProductionenvironments.
  • Cloneddatabases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
  • Support database platform areAIX, Hp-Unix, Solaris, REHLandWindow.
  • CreateUNIX shell scriptsthat automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
  • Create table withDaily Range partitionas per the requirement.
  • CreateClonedatabases usinguser-managedas well asRMAN.
  • Support the development staff for implementation ofdatabase objects.
  • Schedule jobs incrontabincludingRMAN backupand other memory maintenance, security jobs.
  • TuneandoptimizeSQL Query, SGA, and Disk I/O usingOracle Enterprise Managerand by monitoring theAWRandADDRreport 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 usingOracle SQL, PL/SQL, SQLperformance tuning and korn shells, Unix shell Scripting.
  • ManagingInstances redo log files, Tablespaces, Data files, Indexes, Undo Segments,andTemporary segments.
  • Extracted data from Oracle database into XML format for EDI requirement.
  • Worked on logical backup using and full/ partialexport/importand Data Pump.
  • Involved indisaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies usingRMAN.

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 ofOracle 10g, 11gdatabases on Linux 5.4.
  • Implement Oracle 10g Release 1RACon Enterprise Linux 5.4 in a Test environment.
  • Migrateddatabases 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 andProductionenvironments.
  • Cloneddatabases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
  • Support database platform areAIX, Hp-Unix, Solaris, REHLandWindow.
  • CreateUNIX shell scriptsthat automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
  • Create table withDaily Range partitionas per the requirement.
  • Createstandbydatabase and worked withdata guardto provide high availability.
  • Create and Manageuser, table spaces, datafiles and archive log.
  • Monitor, tuneandmaintainoverall database.
  • CreateFunctions, Procedure, triggers, synonyms and profiles.
  • Work withFlash Recovery Area.
  • Create and implement backup and recovery strategies usingRMANconfiguration.
  • Providetroubleshootingandproblemsolving supportto application developers.
  • CreateClonedatabases usinguser-managedas well asRMAN.
  • Support the development staff for implementation ofdatabase objects.
  • Schedule jobs incrontabincludingRMAN backupand other memory maintenance, security jobs.
  • TuneandoptimizeSQL Query, SGA, and Disk I/O usingOracle Enterprise Managerand by monitoring theAWRandADDRreport generated from snapshots taken at the peak business hours.
  • Transported tablespaces and data exports from production and staging databases.
  • Appliedclient patchesand other patches as required.
  • Support production databases on24x7 on callbasis.

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:Confidentialis an established software development company specializing in high end database applications targeted to the financial and foreign exchange markets.

Responsibilities:

  • Installation and configuration ofOracleDatabase Software 10g.
  • Creation and configuration of Oracle database.
  • Migration of database (from 9.2.0.5 to 10.2.0.1)onSUN Solaris 2.7.
  • Installed and ConfiguredRAConRed Hat Linux Advanced Serverwith 4 nodes server side load balancing usingAutomatic Storage Management.
  • WrittenStored Procedures and Triggersfor database maintenance and management usingPL/SQL.
  • Production support of Databases onHP-UNIX.
  • Worked onFTP, ZIPfiles on cross platform.
  • Involved indisaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implementeddatabase backupsand disaster recovery strategies usingRMAN.
  • Performance tuningofSQL queriesand advising the application programmer of the opportunities in tuning the application.
  • Involved inperformance monitoring and tuning of the databaseby fine tuning the database implementation.
  • Successfully implemented physical standby database usingOracle Data Guardfeaturefor High availability configuration
  • Designed and Implemented database security using Oracle roles and privileges.
  • Troubleshoot Database performance issues usingAutomated Workload Repository(AWR)andAutomatic Database Diagnostics Monitor(ADDM). Tuned database for optimum performance.
  • Communicate and coordinate with Oracle usingTAR systemfor major database issues/ problems; apply the requiredpatches, test (unit test/ system test) and roll out and implement the patches into production.
  • ConfiguredOracle Streams(Advanced Replications) and exchanged data between two databases in remote locations.
  • Schedule jobs incrontabincludingRMAN backupand other memory maintenance, security jobs.
  • UNIX Shell scriptingforbackupand 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:Confidentialis a vertically integrated insurance holding company, which covers all aspects of insurance underwriting, distribution, claims processing and exposure management.
Responsibilities:

  • Installation and configuration ofOracleDatabase Software 9i.
  • Creationandconfigurationof database.
  • Performance tuningof application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
  • Upgrading databasefromOracle version 8i to 9iandmigrationof data.
  • Integrated theBackup Status Reportingfor all the databases in the enterprise to enable the web reporting usingOracle SQLandPL/SQL.
  • Worked withUNIXscriptsformonitoring and backupof the database.
  • Communicating with Oracle to get the necessary patches required to fix up the database changes needed usingTAR supportand coordinating the patches and implementing the necessary changes.
  • Schedule jobs incrontabincludingRMAN backupand other memory maintenance, security jobs. Worked onDBMS SCEDULER.
  • Identifying issues/ bottlenecksthat 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 extensivelyUNIX Shell Scripts &PL/SQL Stored Procedures and Triggers.
  • Performance tuningforOracleDay-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 ofOracle 9ionAIX 5.2.
  • Creationandconfigurationof database.
  • Participation in designingdata modelfor administration system.
  • Upgradingdatabase from Oracle version 8i to 9i andmigratedata on diverse platform.
  • Troubleshoot Database performance issues usingTKPROF, STATPACK, EXPLAIN PLAN. Tuned database for optimum performance.
  • Develop difficultPL/SQL scriptto perform error managing and reporting.
  • Change databases designs for many purposes such asdata migration, data warehouse,andonline transactions.
  • Installation of software on a wide range of platforms, for large number of clients.
  • Schedule jobs inCrontabincluding RMAN backup and other memory maintenance, security jobs.
  • Maintain and monitor multiple databases usingOracle Enterprise Manager.
  • Provides services in theidentificationandresolutionof database issues.
  • Setting up ofRMAN configurationon the database to perform necessary back-up.
  • Proactivelymonitoringproduction environmentfor any exceptions/ issues.
  • Written extensivelyUNIX Shell Scripts, PL/SQL, Stored ProceduresandTriggers.

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:Confidentialprovides 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 andRAC setupwithASM.
  • Upgradingdatabasefrom Oracle version 9i to 10g andmigrationof data.
  • Worked onbackup, recoveryand disaster recovery strategy using RMAN.
  • WrittenStored Procedures and Triggersfor database maintenance and management usingPL/SQL.
  • Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting usingOracle SQL, PL/SQL, SQLperformance tuning and korn shells, Unix shell Scripting.
  • ManagingInstances redo log files, Tablespaces, Data files, Indexes, Undo Segments,andTemporary segments.
  • Extracted data from Oracle database into XML format for EDI requirement.
  • Worked on logical backup using and full/ partialexport/importand Data Pump.
  • Involved indisaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies usingRMAN.
  • Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.
  • Performance tuningof 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 inSQL tuningthat improved application response and supported the Production DBA Team and analyzed each project in the production environment.
  • Involved in the project of implementing and configuringReal Application Clusters (RAC)on Oracle10g.
  • 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 fromOracle 8i to Oracle 9i.
  • Performedcloningto create test and development databases.
  • Developed scripts for database backup and recovery includingHOTandCOLDbackup with and withoutRMAN.
  • Set upRMAN catalogfor all the databases.
  • Involved in the process of tuning and refining SQL queries and analyzedTKPROF, Explain Planoutputs for improving the performance.
  • Achieved replication by creating and refreshingSNAPSHOT/MaterializedViews.
  • Configured listeners with Net Manager and createdSQL*NETserver configuration files such as tnsnames.ora and listener.ora and started the listener for making database available to users.
  • Created databases usingDBCA, OMFand manually.
  • Provided security and implemented various auditing techniques.
  • Created table spaces, tables, indexes, triggers for custom applications.
  • Database export/import usingexportandimportutilities.
  • Performed data loads from flat files usingSQL loaderutilities.
  • Performed database administration tasks like space management, users, roles, profiles, schema management.
  • Wrote scripts to monitor thealert logandlistener.logfiles for ORA errors.
  • Compiling invalid objects usingutlrp.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