We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Lancaster, PA

SUMMARY

  • About 14+ Years of experience in IT industry, 12+ years’ experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security. Oracle DBA 12c Certified (OCP) & SQL server DBA.
  • Extensive knowledge on database administration of Oracle 8i, 9i, 10g, 11g & 12C with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g 11g & 12C on Windows, Solaris 10,Linux,HP Unix & RHEL platforms.
  • Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 & 12c ( 12.1.0.2)
  • Install configure and troubleshoot 12c OEM.
  • Monitor database performance, diagnose performance problems, and tune the database as necessary. Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors.
  • Hands - on experience with of Oracle Data Guard setup, maintenance and troubleshooting for high Availability.
  • Experience in Disaster Recovery activities RAC & non RAC environments.
  • Coordinate the implementation of technical controls to support and enforce defined security policies.
  • Experience with IBM AIX, Linux, SUN Solaris & UNIX operating systems.
  • Experience in applying APR 2017 PSU patches to the databases across all environments.
  • Requirements gathering with the application team and building new environments, Prod,Test,UAT,stage and Dev.
  • Creating TAR/SR with Oracle and follow up.
  • Building up new environments, setup, configure backup scripts and OEM metrics configurations.
  • Managing the databases on Automatic Storage Management (ASM).
  • Performing database cloning and restoration of very large sized databases using RMAN.
  • Perform Object and schema refreshes using data pump.
  • Coordination with UNIX team for platform migrations.
  • Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
  • Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, and VMSTAT.
  • Effective troubleshooting of database and Performance problems.
  • Good experience in Data Migration using Golden gate 12c, RMAN, and export/import across plat forms.
  • Installation and configuring of Golden gate replications
  • Oracle Goldengate replication expert DML, DDL unidirectional and Bi directional.
  • Experience in EMDiag,OEM Fixes.
  • Ticket resolutions and meeting SLA’s for MS-SQL and Oracle environments.
  • Installation of SQL Server 2008 R2/ configurations/ Administrations
  • Installation/configuration/Administering of SQL Server 2008/2008 R2/
  • Version upgrade of SQL Server 2005 to 2008 R2
  • User access management- MS-SQL /Oracle
  • Service packs installation and upgrades
  • Good Interpersonal communication skills and Documentation Skills.
  • Experienced in fulfilling regulatory compliance (SOX compliance database standards)
  • Worked on data center migration projects & Company separation works.
  • Knowledge on Exadata, Cellcli commands.
  • Trained on Mongo DB.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x and Windows 98/NT/2000/2003.

RDBMS: SQL SERVER 2008/2008 R2/ 2012 & Oracle 12C/11g/10g/9i/8,Teradata

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, XML,JAVA

DB Management: TOAD, OEM 12C

Tools: /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, Oracle Streams,Goldengate10g/11g&12C Data pump, Data Guard, VMware MS Office & Putty.

Tuning Tools: TOAD, DBaritician,OEM 12C, Oracle Developer

Backup Tools: BMC control M,SQL backtrack, veritas NetBackup,Data Domain & Commvault simpana

PROFESSIONAL EXPERIENCE

Confidential, Lancaster, PA

Sr. Oracle Database Administrator

Responsibilities:

  • Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 & 12c (12.1.0.2)
  • Day to Day database activities like space management, security and user
  • Management.
  • DR exercise on every quarter
  • Creating TAR/SR with Oracle and follow up.
  • Applying patches CPU/PSU on priority basis .
  • Building up new environments, setup, configure backup scripts and OEM metrics configurations.
  • Company Separation Data migration and new environment building.
  • Managing the databases on Automatic Storage Management (ASM).
  • Performing database cloning and restoration of very large sized databases using RMAN.
  • Perform Object and schema refreshes using data pump.
  • Coordination with UNIX team for platform migrations.
  • Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
  • Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, and VMSTAT.
  • SQL and PL/SQL or T-SQL programming.
  • Prod, Test, Stage and Dev.
  • Unix shell, Perl or OS scripting language.
  • Installation of SQL Server 2008 R2/ configurations/ Administrations
  • Provided L3 support
  • Glodengate 12c installation and configuration at source and target.
  • DML, DDL replication using Oracle unidirectional and bi-directional.
  • Windows to Oracle replication Glodengate.
  • Replication setup using materialized views.
  • Installation/configuration/Administering of SQL Server 2008/2008 R2/
  • Version upgrade of SQL Server 2005 to 2008 R2
  • User access management- MS-SQL /Oracle

Environment: Oracle 10g/11g & 12C RAC, RDBMS, RMAN, Data Guard,Glodengate 12c, Erwin Data Modeler, RHEL 5.x, 6.x, SQL Server /2008/ 2008 R2/ SQL Server 2012 shell scripting, OS, windows servers, Linux,HP Unix & Solaris servers. 12C OEM Grid control, CommVault,Simpana, & VERITAS NetBackup.

Confidential, Bloomington

Sr. Oracle Database Administrator

Responsibilities:

  • Real Application Clusters (RAC), Oracle 10g and 11gR2.
  • Upgraded the test, development & prod databases from 10g to 11g R2.
  • Performed performance monitoring through Oracle Enterprise Manager and SQL Scripts.
  • Day to Day database activities
  • Applying patches CPU/PSU on priority basis.
  • Building up new environments, setup backup scripts and OEM metrics configurations.
  • Monitoring of resources consuming high CPU and memory utilizations.
  • Glodengate 11g installation and configuration.
  • DML, DDL replication using Oracle 11g unidirectional and bi-directional.
  • Windows to Oracle replication Glodengate 11g.
  • Application database changes implementation on all environments.
  • Oracle 11g active data guard building.
  • Experience in creating TAR/SR with Oracle and follow up when required.
  • Patch applying, upgrading, cloning step by step document creation according to the requirements & mentoring team.
  • DR exercise on every quarter.
  • Requirements gathering with the application team and building new environments,
  • Prod, Test, Stage and Dev.
  • Ticket resolutions and meeting SLA’s for MS-SQL and Oracle environments.
  • Installation of SQL Server 2008 R2/ configurations/ Administrations
  • Provided L3 support
  • Installation/configuration/Administering of SQL Server 2008/2008 R2/
  • Version upgrade of SQL Server 2005 to 2008 R2
  • User access management- MS-SQL /Oracle

Environment: Oracle 10g/11g & 12C RAC, RDBMS, RMAN, Data Guard,Goldengate 11g Erwin Data Modeler, RHEL 5.x, 6.x, SQL Server /2008/ 2008 R2/ SQL Server 2012 shell scripting, OS, windows servers, Linux,HP Unix & Solaris servers. 12C OEM Grid control, Data Domain & Toad.

Confidential

Senior Oracle DBA

Responsibilities:

  • Sql back track backup tool
  • OEM monitoring tool
  • Upgraded the test, development & prod databases from 10g to 11g R2.
  • Performance Tuning.
  • Applying patches CPU/PSU on priority basis.
  • Data guard 11g setup and monitoring.
  • Oracle 10g and 11g database basic administration on Linux platform
  • Database design, Created physical database model
  • Multiple schema design for Data planning and Security
  • Optimized database performance by analyzing database objects, gathered statistics, created indexes
  • Improved performance of batch jobs, many reports. Performance fixes typically reduced batch runtime by hours. Recommended and implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as improved SQL techniques. Coordinate developers on more efficient ways to write database queries. Tracked down the source of troublesome locking problems
  • Identified and tuned SQLs in production databases

Environment: Oracle 10g/11g RAC, RDBMS, RMAN,SQL backtrack, Data Guard, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 11G OEM Grid control.

Hire Now