We provide IT Staff Augmentation Services!

Lead Oracle Dba Resume

Edison New, JerseY

SUMMARY:

  • Over 10+ years of IT industry experience in administrating Oracle Database, Oracle Certified Professional (OCP) and AWS Solution Architect and willingness to learn new technologies.
  • Experience in various Oracle consulting practices and procedures in database administration which includes Installation, Configuration, Upgradation, Cloning, and Backup/Recovery on different Operating systems in various cycles of Development, Testing and Production.
  • Configured Oracle ASM Disks, ASM Disk groups & ASM Instances.
  • Configure physical& logical standby databases using Oracle Data guard.
  • Involved in User Management, creating Roles and assigning privileges and roles to database users.
  • Exporting and Importing database backups using Export & Import and Data pump utilities. Experience in Cloning production databases using RMAN.
  • Involved in SQL tuning by generating explain plan, ADDM, AWR. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files.
  • Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
  • Help establish standards and best practices for database design; consult with development and quality assurance on compliance for database design best practices.
  • Experience with handling of medium to large Oracle OLTP (Online transaction processing).
  • Administered databases on Linux (RHEL), Cent OS, AIX and Solaris.
  • Experience in upgrading database using DBUA and manual methods.
  • Experience in upgrading the databases from Oracle 9i to 10g, Oracle 10g to 11g and 11g to 12c using DBUA and Manual Upgrade methods. Handover of fully tested and operational DB to users.
  • Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
  • Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
  • Strong experience required in creating, configuring, and managing AWS databases RDS on EC2 instances for Oracle.
  • Well experienced in AWS infrastructure details.
  • Good experience of AWS Elastic Block Storage (EBS), different volume types and use of various types of EBS volumes based on requirement.
  • Experience in Oracle Golden Gate with very large Data bases.
  • Experience in data filtering using Oracle Golden Gate.
  • Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
  • Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non-ASM.
  • Regular checking of Alert log and Trace files.
  • Good experience in solving performance related issues on production databases.
  • Experience in managing the team, mentoring and resource allocation.
  • Involved in applying the CPU and PSU patches in non-prod and prod environments.
  • Liaison with Oracle Support to resolve various application and database issues.
  • Supported and worked on Priority 1 SR’s with Oracle Support during Go-Live period. Provide off hours support, as needed, to support product enhancements, data uploads and technical issues.
  • Excellent analytical and communication skills combined with interpersonal skills and ability to work cohesively in a team. At ease in interacting with people at all levels, able to work under pressure.

TECHNICAL SKILLS:

Oracle Databases: Oracle 9i, 10g, 11g, 12c,13c, MS SQL Server 2008,2012, 2014

Operating Systems: HP-UX, Red Hat Enterprise Linux, Solaris, AIX, Oracle Enterprise Linux and Microsoft Windows Server 2008R2, 2012, 2012R2.

Database Utilities: Export/Import, Data Pump, DBCA. DBUA, OUI, RMAN, SQL*Plus, SQL Loader, OEM 12c GRID Control, Data Guard, Data Migration, Real

Application: Clustering, ASM, Golden Gate, SSMS, SSCM

Tools: Putty, Toad, SQL Developer, cronjob (UNIX), PL/SQL, Amazon Web Services, WinSCP and FileZilla

Domains: Banking, ecommerce and Manufacturing

PROFESSIONAL SUMMARY:

Confidential

Lead Oracle DBA, Edison, New Jersey

Responsibilities:

  • Enforce best practices in all areas of database administration and architecture.
  • Creation and Maintenance of database storage structures such as Tablespace, Data files etc.
  • Monitoring the usage and growth of Tablespace, Data files and whole database using automated monitoring alerts.
  • Review and implement database changes.
  • Performing regular Oracle database maintenance like clearing Flashback, archive logs on various instances.
  • Installing and Configuring ASM with various Disk Groups to create Oracle Database Instances.
  • Worked in Planning and implementing the Backup strategy using RMAN, Hot backup, Cold Backup, Logical backup.
  • Regular RMAN backup and recovery activities based on requests.
  • Proficient in use of tools like SQL Developer, Toad.
  • Upgraded the Oracle Databases from 11.2.0.1 to 11.2.0.3 and 10.2.0.5 to 12.1.0.2 (12c).
  • Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
  • Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
  • Configured Unidirectional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
  • Experience in Oracle Golden Gate with very large Data bases.
  • Experience in data filtering using Oracle Golden Gate.
  • Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
  • OLTP, OLAP and Data warehouse configurations.
  • Experience in handling out of sync data issues with Oracle Golden Gate.
  • Experience in performance tuning for Oracle Golden Gate Extract and Replicates
  • Involved in SQL tuning by generating explain plan, ADDM, AWR. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files.
  • Monitored and tuned long running jobs by working with the application and development team and analysing objects, create or rebuild indexes. Using SQL TRACE, Explain plan.
  • Generated AWR reports on Oracle 11g database and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth.
  • Strong experience required in creating, configuring, and managing AWS databases RDS on EC2 instances for Oracle.
  • Well experienced in AWS infrastructure details.
  • Good experience of AWS Elastic Block Storage (EBS), different volume types and use of various types of EBS volumes based on requirement.
  • Involved in applying the CPU and PSU patches in non-prod and prod environments.
  • Regular checking of Alert log and Trace files.
  • Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects.
  • Experience in upgrading database using DBUA and manual methods, creating documents for the same.
  • Assist OS Administrators whenever there are configuration changes that are applied to Oracle Software.
  • Good experience in solving performance related issues on production databases and ability to contact Oracle Support using Metalink.
  • Documenting Oracle Database design, creation and other database features for reference purposes.

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), Amazon Web Services (AWS), Data Guard, Oracle Universal Installer (OUI), WinSCP, Putty, SSMS, SSCM, RAC, Golden Gate, RMAN, Data Pump, Export/Import.

Confidential

Oracle DBA, Tampa, FL

Responsibilities:

  • Providing 24*7 Oracle Database Production Support.
  • Planning and creating databases manually as well as with DBCA on Test and Production boxes.
  • Creation and Maintenance of database storage structures such as Tablespace, Data files etc
  • Database cloning from Production to Test and Development environments
  • Space management- free space check on the server, monitoring data growth and add free space in required tablespaces.
  • Configured Oracle Automatic Storage Management (ASM) and Oracle Automatic Storage Management Cluster File System (ACFS).
  • Daily and weekly database backup (Cold backup / Export).
  • Experience in upgrading database using DBUA and manual methods. Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.3. Handover of fully tested and operational DB to users.
  • Configure physical& logical standby databases using Oracle Data guard.
  • Installation and administration of replicating Golden Gate.
  • Checking the process Extract jobs as the part of Golden Gate.
  • Maintain the manager at both sides physical replicated Golden Gate.
  • Help developers to install Oracle Client, troubleshoot and inform about any database performance issue of their application.
  • Experienced in Oracle Database Partitioning.
  • Experience with 11g, 12c Oracle databases and Golden Gate 12.x.
  • Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non-ASM.
  • Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
  • Experience in using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, AWR and ADDM reports for performance tuning.
  • OLTP, OLAP and Data warehouse configurations.
  • Involved in applying the CPU and PSU patches in non-prod and prod environments.
  • Send weekly database health check-up report to the client.
  • Regular checking of Alert log and Trace files.
  • Assist OS Administrators whenever there are configuration changes that are applied to Oracle Software.
  • Proactively work with client and other technical support staff to resolve production issues.
  • Documenting Oracle Database design, creation and other database features for reference purposes.
  • Analysed & solved performance issues on production data within stipulated time span for which received appreciation from client.

Environment: Oracle Database 10g and 11g, Oracle Enterprise Linux, Windows 2003, HP-UX, Oracle Enterprise Manager (OEM), WinScp, Putty, RAC, RMAN, Golden Gate, Data Pump.

Confidential

Jr. Oracle DBA

Responsibilities:

  • Installed various versions of databases as per requirement and worked on the same.
  • Experience in performing regular database activities, backups monitoring and issues resolving.
  • Performed cold and hot backup and used them for cloning of databases.
  • Successfully apply new patches/version upgrades.
  • Management of User schema and database objects. Creation of user accounts and granting privileges to users.
  • Regular checking of Alert log and Trace files.
  • Tuning of databases using AWR and ADDM. Maintained Security of Database and applications through roles, profiles and responsibilities.
  • Managing internal databases, from planning and testing stages through implementation and support.
  • Experience in Deployment process in all phases from Development to production.
  • Modified various shell scripts for monitoring of databases. Good Understanding of SHELL scripts.

Environment: Oracle Database 9i, 10g, SQL Loader, TOAD, Putty, Oracle Enterprise Linux, Windows 2003.

Confidential

Jr Oracle DBA

Responsibilities:

  • Involved in supporting Dev and Test environment in UNIX and Windows platforms
  • Performed Database Cloning from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
  • Applying database patches using Opatch Utility.
  • An active member in the team of upgradation.
  • Managing Oracle user management, like creating/dropping assigning roles and privileges.
  • Creating Logical and Physical database structure, Creating and altering Table spaces, Managing Users and Resources, Granting and Revoking privileges through Roles.
  • Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 10g and Oracle 9i on operating system RHEL.
  • Maintaining Archive logs and their spaces for routine administration, alert and trace monitoring.

Environment: Oracle 9i, 10g, RMAN, Oracle Enterprise Linux, Windows 2000.

Hire Now