We provide IT Staff Augmentation Services!

Technology Lead Resume

SUMMARY

  • Oracle certified associate with over 9 years of experience in Database Administration tasks like installation, configuration, monitoring, performance tuning and maintaining Oracle 9i/10g/11gR1/11gR2/12cR1/12cR2 databases on different platforms Sun Solaris, RHEL and Windows
  • Over 5 years of experience in administering Oracle E - business Suite R12.1.3 which includes installation, cloning, patching and performance tuning.
  • Expertise in supporting Production (24X7), Staging, testing and Development environment databases
  • Expertise in designing and implementing backup and recovery strategies using archived logs, RMAN with VERITAS Netbackup.
  • Proficient in cloning databases and lower environments through rman duplicate, SAN disk snapshots, Original rman restore or datapump
  • Hands on Experience in restoring 30TB databases directly from tapes.
  • Proficient in troubleshooting performance issues and performance tuning databases using tools like OEM, ADDM, Explain Plan and TKPROF
  • Experience in Migration from 9i to 10g, from 10g to 11g, 11gR1 to 11gR2, 11g to 12c in VCS and RAC environments through Datapump and RMAN transportable tablespaces.
  • Experience in installing, configuring, managing Oracle 10g and 11gR1,R2 RAC with ASM and SAN storage systems
  • Experience in Logical backup using full/partial export/import and Data Pump and worked with sqldeveloper in migrating from sql-oracle
  • Experience in Transportable Tablespace, Data Guard, and Oracle Streams Replication
  • Successfully Installed and actively setup goldengate 12.2 replication to Apache Kafka
  • Expertise in routine DBA functions like space management, Rollback segments, Undo segments and Invalid objects.
  • Proficient in creation and maintaining of schema objects like tables and indexes, triggers, procedure, function, synonyms and sequence.
  • Experience in disaster recovery planning and implementation procedures. Detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
  • Strong knowledge of Oracle Internals and Optimizer.
  • Experience with SQL, PL/SQL and UNIX Shell scripting.
  • Good knowledge on Unix shell scripting and involved in debugging existing scripts
  • Proficient with Sqldeveloper, OEM 10/11/12c Grid control.
  • Experience in interacting with Oracle support to resolve issues
  • Supported various production deployments and provided 24/7 support for the various databases
  • Excellent communication skills in explaining technical issues to management and self-motivated team player.

TECHNICAL SKILLS

Database: ORACLE 12.1/12.2/11 g(R1 and R2) 10g, 9i, 8i and Oracle E-buisness suite R12.1.3

Oracle Technologies: RMAN, Export/Import, OEM, Data Guard, Oracle Clusterware, Data Pump, SQL*Loader, Statspack, Opatch, RAC, VMWare, Replication, Streams, Grid control

Tools: & Utilities: SQL *Plus, TOAD, Putty, MS Visio, Rational Rose98, VERITAS Net Backup, SAN, Winscp, Humming Bird (Exceed), VNC, ERWIN, XMing,CYGWIN,Qualyss,Perforce

Operating System: Red Hat Enterprise Linux, Sun Solaris, Microsoft Windows

Programming Languages: C, Java, SQL, PL/SQL, Unix Shell Scripts, HTML

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Responsibilities:

  • Working as an Techonology lead for database management team across Raleigh and Offshore.
  • A subject Matter Expert in all oracle 9i/10g/11gR1/11gR2/12.1/12.2 databases on RHEL 7 and AIX platforms
  • Active Key member in all the application-cloud-Database workshops determining the Oracle support pricing, ULA and other aspects in terms of oracle supporting the migration to cloud
  • Key member involved in determining the strategic decisions of databases
  • Implemented intensive Oracle clusterware upgrade and database upgrade from 11g to 12c, 10g to 12c and 12.1 to 12.2
  • Actively installed golden gate replication from oracle database to Apache Kafka
  • Migrated the 2 TB database across servers using rman duplicate from TSM
  • Migrated OEM 12c to OEM 13c and completely setup OEM 13c metrics, templates and metric extensions
  • Extensively worked on re-active and pro-active performance troubleshooting and enhancements
  • Did Setup Proactive monitoring of the database and OS (CPU and other OS metrics) through unix shell scripts for huge database servers
  • Expert in installing/upgrading and patching Oracle Clusterware 11g/12c for High availability
  • Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
  • Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
  • Active member in updating Knowledge base documents for the team.

Softwares: ORACLE 12.2/12.1/11 gR1/R2/10g/9i, RHEL5/6/7,AIX, OEM 13c/12c, ASM,Disk Snapshot, TSM,Goldengate

Lead Oracle Database administrator

Confidential

Responsibilities:

  • Working as an Oracle Lead DBA for 9i/10g/11gR1/11gR2/12c databases on RHEL5.6 and Solaris and Supporting Oracle E-Business Suite applications R12.1.3
  • Implemented intensive Oracle clusterware upgrade and database upgrade from 11g to 12c
  • Performed a cross-platform migration of the databases from 11g to 12c through RMAN in both EBS and non-EBS environments
  • Performed infrastructure upgrades as like PSUs, one-patches and CPU’s for both oracle E-business applications and oracle databases every quarter
  • Scheduled EBS and Non-EBS Database refreshes of lower environments daily through datapump and RMAN
  • Expert in implementing various database cloning techniques using RMAN duplicate
  • Did Setup Proactive monitoring of the database and OS (CPU and other OS metrics) through unix shell scripts for huge database servers
  • Efficient in using Oracle Enterprise manager 12c and 11g both for administration and performance monitoring
  • Maintained and expanded ACFS filesystem whenever needed
  • Responsible for Oracle Grid Control setup, upgrades, troubleshooting and administration.
  • Upgraded Oracle enterpriser manager from 12c to 13c and redeployed all the agents
  • Expert in installing/upgrading and patching Oracle Clusterware 11g/12c for High availability
  • Worked on setting up and maintaining Oracle dataguard in maximum performance mode and implemented DR drill twice a year.
  • Worked with client, application team and team members to understand the requirements in designing a new application
  • Participated in project gatherings, review meetings for new & enhancement projects
  • Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
  • Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
  • Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
  • Made recommendations and enforced standards during project review meetings.

Softwares: ORACLE 12c/11gR1/R2/10g/9i, RHEL4/5, OEM 12c, ASM,ACFS, Oracle r12 EBS

Lead Oracle Database Administrator

Confidential

Responsibilities:

  • Worked as an Oracle L3 DBA for 10g/11gR1/11gR2 RAC and NON RAC on RHEL5.6 and Solaris in financials and fast based environment
  • Lead on supporting 24 *7 36TB of RAC data warehouse applications
  • Worked with Off-shore team at various shifts to manage mission critical databases and lead the production support team of 8 members.
  • Expert in dealing and fixing performance issues by reviewing with stats, indexing, bad plans and many more
  • Prioritized and Automated daily datapump refreshes with Unix shell scripts
  • Designed and implemented the restore of 26TB of RAC database from tape as per company’s regulatory requirement
  • Hands on experience in implementing BCV for Database backups
  • Expert in implementing various database cloning techniques using RMAN duplicate, storage based replication and many more
  • Setup Proactive monitoring for CPU and other OS metrics by writing unix shell scripts for huge database servers
  • Efficient in setting up and monitoring Oracle streams and dataguard for replication
  • Efficient in using Oracle Enterprise manager both for administration and performance monitoring
  • Worked in upgrading the databases from 10g - 11g using RMAN transportable tablespace
  • Performed infrastructure upgrades as like PSUs, one-patches and CPU’s.
  • Participated in project gatherings, review meetings for new & enhancement projects
  • Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
  • Worked with environments using VERITAS Cluster Server (VCS) high availability.
  • Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
  • Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
  • Active member in updating I2ms and edom (Database inventory)
  • Provided Oracle database knowledge transfer to the Manager of Application Development and the team continually.

Softwares: ORACLE 11gR1/R2/10g/9i, RHEL4/5, RAC, SAN, VERITAS Cluster Server, OEM, ASM,BCV

Senior Oracle Database Administrator

Confidential

Responsibilities:

  • Working as an Oracle DBA for 9i/10g/11gR1/11gR2 on RHEL5.6 and solaris
  • Worked in upgrading the databases from 11gR1 to 11g R2 in VCS clusters
  • Worked in upgrading the databases from 10g-11g R1 and R2 on RAC
  • Participated in project gatherings, review meetings for new & enhancement projects
  • Worked in setting up HugePages on the servers
  • Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
  • Performed various database migrations from solaris to linux in RAC and non-RAC environments and also involved in SQL - oracle migrations
  • Worked with the Recovery Manager RMAN and Used Oracle Enterprise Manager OEM for continuously monitoring the database.
  • Worked on 11.1 and 11.2 ASM and clusterware installations on brand new servers
  • Built Dataguard for RAC and non-RAC databases through DataGuard Broker and performed Switchovers frequently
  • Been an Active member in troubleshooting RAC Node Evictions
  • Built various databases on oracle 11gR2,11gR1,10g version in VCS and RAC environments
  • Worked with environments using VERITAS Cluster Server (VCS) high availability.
  • Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
  • Refreshing of database from Production to Testing and Development environments.
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN and monitored the databases through IGNITE tool.
  • Active member in updating SITS(Database inventory) and updating the documents for the team

Softwares: ORACLE 11gR1/R2/10g/9i, RHEL4/5, RAC, SAN, VERITAS Cluster Server, OEM, ASM,IGNITEDatabase Administrator

Hire Now