We provide IT Staff Augmentation Services!

Sr. Oracle Database Resume

Carrollton, TX

SUMMARY:

  • Over7 yearsof technical/consulting experience as Oracle Database Administrator, Data Analyst, Data Modeling and Data Migration inOracle 9i/10g/11gonLinux, UNIX,&Windows.
  • Provided24/7 on call supportfor very large databases (VLDB) and Data Warehouse environments.
  • Excellent experience in OLTP/DSS database administration, implementing and managing Very Large Oracle Databases (VLDB).
  • ImplementedHigh Availability/Disaster recoveryusingRAC, Physical & Logical standbydatabases(OracleData Guard).
  • Experience withReal Application Testing (RAT).
  • ImplementedData guard(Physical Standby) for RACdatabases.
  • Upgraded 10g databases to 11g
  • Installation, Configuration and administrationOracle Golden Gate.
  • Performingcapacity Planning,Backup/Recoverystrategies usingRMANand conventional Oracle Hot and Cold backup and Export/Import.
  • Experience with High Availability features(RAC/ DG/ ASM / Flashback / RMAN).
  • Oracle 10g RCA, Oracle 11g RACimplementation & administrationusing Oracle Clusterware (Oracle Cluster waresetupandconfiguration,RAC installationusingASM,Configuration and Patching, RAC BackupandRecovery).
  • Experience in Data modeling usingReverse and Forward engineeringfor creatingLogical and Physical Databasemodels usingErwin.
  • Experienced in usingOracle Enterprise Manager(OEM) &Grid Controlfordatabase monitoring.
  • Good knowledge ofFlashback Technology, Flash recovery Area, Automatic Storage management (ASM) and RAC.
  • Performance tuning ofOracle 10g/11gdatabases, reviewingStatspack/AWRreport for resolving performance bottlenecks and involved inSQL tuning.
  • StrongRDBMS,SQL&PL/SQLexperience. Written Packages, Procedures, Functions, Triggers to incorporate complex business logic and writing shell scripts to automate day to day tasks.
  • Refresh and Cloning usingDatapumpandRMANwithCommvault,VERITAS Net Backup & TSM.
  • Applied patches, performed database upgrades, migrations.
  • Strong experience in using tools such asSQL*Plus, TOAD,TKPROF, RMANandExport/Import.
  • Performance tuning using, SQL Trace, Explain Plan, STATS PACK, AWR, ADDM
  • ProficientinCapacity planning and bench marking.
  • Experience in performingcrash recoverieswithout data loss.
  • Experience inDatabaseup-gradationand conversion from Oracle 9i/10g to Oracle 11g.
  • Replication using materialized views, streams, Golden Gate.
  • Knowledge on Exadata.
  • Experience in different phases ofSoftware Development Life Cyclewhich includeAnalysis, Design, DevelopmentandTestingand working closely in implementing DBAuditingand Compliance as well as Oracle and systemSecurityenhancement.
  • Strong Analytical, Communication, organizational, Troubleshooting & interpersonal skills.
  • Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
  • Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.

TECHNICAL SKILLS:
Languages :PL/SQL,SQL,SQL*PLUS,C,Java,Shell Scripting, Perl Scripting.
Databas : Oracle 11g RAC/10g RAC/9i/8.x, MS Access, DB2 UDB
Operating System : UNIX, Solaris,AIX,HP-Unix,Linux,Windows 2005/2003/XP/2000
Tools :SQL*PLUS,SQL Developer,TOAD, SQL Navigator,OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump,
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM
Tools/Utilities :RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp, Maximo
Others: :EMC, NetApp, Veritas, TSM, HP OmniBak

Education: Bachelor of Technology

PROFESSIONAL EXPERIENCE

Confidential, Carrollton, TX July 2011 – Till Date
Sr. Oracle Database Administrator

Responsibilities:

  • 24x7 on-call production database support.
  • Primarily responsible forproduction support. To keep alldatabases up and runningin production.
  • Responsible forOracle 9i/10g/11g logical and physical databases design, implementation and maintenance.
  • Installation, Configuration and administration of10g RAC/11gRAC environment.
  • Upgraded Oracle 9i, 10g databases to 11g.
  • Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
  • Applied patches.
  • Migrated NON ASMdatabases toASM databases.
  • Developed strategies for optimal backup and restores procedures.
  • Managed and resolved design issues.
  • ImplementedRACandPhysical Standbydatabases forHigh availabilityanddisaster recovery.
  • Implemented and monitoredRMANbackup scripts on regular basis for successful backup.
  • Involved inDatabasePerformancetuning and analyzingStatspack/AWRreports on regular basis to resolve performance bottlenecks.
  • Partitioned large tables, created global portioned indexes for manageability and performance improvement.
  • Createdprimary database storage structures(tablespaces),altering, and modifyingthedatabase structureaccording to the business requirement as necessary.
  • Developing SQL, PL/SQL stored procedures, packages, functions,triggers and views.
  • Created and managedusers, roles and profiles, implementing security, granting roles and privilegesetc.
  • Planning and implementingBackup and Recovery procedures(Conventional Cold &Hot Backups, and RMAN Backups),scheduling daily backups and performed periodic recovery tests.
  • Installation and configuration of Golden Gate.
  • Replication using Streams and Golden Gate.
  • Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
  • Performance monitoring and tuning usingExplainPlan, STATS PACK, AWR, ADDM,andOracle Enterprise Manager.
  • Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment:Oracle 9i/10g/11g, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN, RedHat Linux, HP-UX, Sun Solaris
Confidential, Bellevue, WA April 2010- Mar 2011

Sr. Oracle Database Administrator

Responsibilities:

  • 24x7 on-call production database support.
  • Provided primary administrative support forOracle9i/10g/11gdatabases in LINUX/UNIX and NT environments.
  • Installation, Configuration and administration of 10g/11gRAC environment.
  • Created, upgraded, and cloned Oracle databases for Development and testing databases.
  • Worked on Tuning OS,Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Performed backups and recoveries usingRMANconventional hot backups.
  • Created and Maintained database storedprocedures, databasetriggers, and user-defined functions.
  • Performance monitoring and tuning using OEM Grid Control, SQL Trace, Explain Plan, STATS PACK,Automatic Workload Repository(AWR) &Automatic Database Diagnostic Monitoring(ADDM).
  • Performed export imports using exp/imp, Data Pump.
  • Performed Data loads usingSQL Loader.
  • Tuning Queryperformance by creatingindexes.
  • Monitoring, sizingandtuning undo segmentsby creating multipleundo tablespaces.
  • Database Maintenance andclearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
  • Optimization of variousinitialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
  • Analyzing tablespaces and removing row-chaining and row migration in tablespaces.
  • Designing and developing packages in thedatabase layer, stored procedures, functions and triggers.
  • Installation and configuration ofGolden Gate
  • Applied latest patches as per evaluation requirement.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
  • Estimating thespace requirementsfor database growth for future making availability ofhardwareto support theprocesses.
  • Developing, Implementing and administeringdatabasepoliciesandprocedures.
  • Created users, roles and granted privileges according to the business requirements.
  • Proactive monitoringof Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
  • Assisted application development team with database design and support.

Environment:Oracle 9i/10g/11g, Red Hat Linux, IBM AIX, HP-UX, Sun Solaris, Windows 2000, OEM, SQL* Plus, TOAD, RMAN, ASM.
Confidential, Herndon, VA July 2009 – February 2010
Oracle Database Administrator

Responsibilities:

  • Provided 24x7 production database administration supports.
  • Administered several databases including single instance and multi-node RAC instances.
  • Upgraded databases from 9i to 10g.
  • Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
  • Wrote scripts to automate data loads, performance monitoring and backup.
  • Database physical/logical layout design and procedures for production, development, test servers.
  • Guided the Operations team in Creating,Cloning, and trouble shooting Oracle Databases, Database Objects Designs, and Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
  • Helped the Production teams in Applications Performance Tuning and providing 24X7 Production Support.
  • Performedcapacity planningrequired creating and maintaining the database environments.
  • Provided tuning support forSGA(shared pool, buffer pool and log buffer pool etc).
  • Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
  • Replication of materialized views (snapshots) with fast refreshes for transfers of information.
  • Set upCron jobsto monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and alsoRMANHot Backup Scripts.
  • SQL and PL/SQL PerformanceTuning and Identifying SQL and PL/SQL bottlenecksusing PL/SQL Profiler,Explain Plan,and Auto trace,TKPROFand tuned them to suitSLA.
  • Gathered Database Instance Statistics & generated reports usingSTATSPACK.
  • Implemented Oracle New features likeSPfile, Shared Severs, Locally managed Temporary Tablespace,UNDO TablespaceandRMAN.
  • Created Partitions at O/S level, according to DB requirements.
  • User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.

Environment: Oracle Server 9i/10g RAC, SQL, RHEL, AIX 5.2, Shell scripting, PL/SQL, MS SQL Server.

Confidential April 2008 to July 2009

Oracle Database Administrator

Responsibilities:

  • 24x7 Production Database Support
  • Installation, Configuration and Administration of Oracle 8i/9i databases.
  • Upgraded databases from 8i to 9i
  • Created roles, profiles, users and assigned privileges to them.
  • AnalyzedSTATSPACKreports for optimization of DB performance periodically.
  • Created different types of Indexes (B tree, reverse key, IOT and function based etc).
  • Involved in backup/recover strategy designing and implementation usingcold backup,hot backupandRMANmethodologies.
  • Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
  • Provided partitioning of the large tables to reduce the access time.
  • Applied patches.
  • Detectinganddiagnosingproduction system performance byanalyzing oracle trace, log files, analyzing SQL statement, measuring system and database activity.

Environment:Oracle 8i/9i, HP-UX, IBM AIX

Confidential January 2005 to March 2008
Oracle DBA/Developer

Responsibilities:

  • Worked on database backup strategy designing and implementation using cold/hot backup techniques.
  • Written SQL, PL/SQL functions, procedures, packages and triggers.
  • Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
  • Configured Statspack for Tuning databases.
  • Database Memory management (shared pool, db buffer cache and log buffer).
  • Upgrading, analysis and testing of the test and production database.
  • Monitored alert logs, trace files,partition tables and indexesfor better performance of the database.
  • Database physical/logical layout design and procedures for production, development, test servers.
  • Perform capacity planning required to create and maintain the database environments.
  • Optimization and performance tuning of database, SGA and SQL*Net/Net8 related problems.
  • Installing Oracle 8i on Win’NT Server and Setting up Oracle Clients.
  • User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.

Environment:Oracle 8i/9i, Sun Solaris, RHEL, Windows, SQL*Loader, SQL, PL/SQL

Hire Now