We provide IT Staff Augmentation Services!

Sr. Oracle /postgresql Dba Resume

SUMMARY

  • 8 years of experience in Database Administration using Oracle & PostgreSQL Databases.
  • Expertise on Deploying Real Application Clusters technology for high availability configurations.
  • Excellent experience in Installation, configuration and administration of Oracle 19c,12c,11g.
  • Performed Database migrations/upgrades from 11g to 12g, 12g to 19c
  • Experience in Setup configure & manage standby databases using Active Data Guard in Oracle 11g/12c.
  • Managing Oracle Databases on AWS on EC2 and RDS services
  • Hands on experience in all backups & recoveries like export/import, manual and RMAN backup.
  • Configuration & maintenance of Oracle Recovery Manager - RMAN
  • Configuration of Oracle Management Servers for Database monitoring.
  • Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
  • Performing Oracle database administration tasks like software installation, database setup, database upgrade, database patching, database cloning, performance tuning, SQL tuning, backup & recovery.
  • Experience in Oracle Database performance-tuning using EXPLAIN PLAN, TKPROF, Sqltrace utilities.
  • Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
  • Strong ability with UNIX shell scripting to automate tasks and in Cron jobs and dbms scheduler for scheduling jobs.
  • Proficient in using AWR and ADDM for performance tuning like SQL tuning, Memory tuning, I/O tuning.
  • Supporting 24x7 operational database in critical production environment
  • Excellent communication, presentation and interpersonal, team building skills, versatile team player, highly motivated and will be able to achieve results in a fast paced team environment.

TECHNICAL SKILLS

RDBMS: Oracle 19c/12c/11g, PostgreSQL

Tools: & Utilities: SQL Loader, Export/Import, TOAD, Data pump & Oracle EM, Real Application Clusters.

Languages: SQL, PL/SQL and Shell scripts

Operating System: HP-UX, Linux and Windows

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle /PostgreSQL DBA

Responsibilities:

  • Install configure Oracle RAC 19c/12c/11g on Linux with ASM storage.
  • Providing support to Oracle 11g, 12c, 19c RAC databases.
  • Monitor troubleshoots databases using Oracle 11g Grid control.
  • Setup Backup/Recovery strategy thru RMAN.
  • Install and configure of new PostgreSQL databases in on EC2 instances.
  • Install, configure, test, monitor, upgrade, and tune PostgreSQL databases.
  • Configure and setup PostgreSQL replication for Hot Standby and Streaming Replication
  • Perform backups and restore using PgDump, hot backups.
  • Troubleshoot performance issues in Production and development database.
  • Setup Oracle physical Data Guard solutions for DR solution.
  • Monitoring and Sync up of Oracle Standby databases.
  • Upgrading the databases from lower version to higher versions.
  • Creating health monitoring Unix shell scripts and scheduling the health scripts using crontab, mailx.
  • Performing cloning databases regularly for the reporting databases and stage environments.
  • Performed SQL tuning on various reports/SQLs and implemented SQL profiles or hints to get better execution plans.
  • Taking AWR reports and analyzing them periodically for better performance.
  • Monitor and manage database indexes for optimal performance.
  • Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle.
  • Creating DB links to heterogeneous environments for the data warehouse
  • Periodic index management, index rebuilding.

Confidential

Oracle DBA

Responsibilities:

  • Supported and maintained Oracle 10g/11g databases.
  • Installed and created databases for Prod, Dev and ITG environments.
  • Installed OEM agents on several databases
  • Configured databases and monitored of all the databases using
  • Oracle Enterprise Manager (OEM) 11g grid control.
  • Production support for Oracle databases 10g/11g
  • Created scripts for the daily regular monitoring of the databases
  • Created shell scripts to automate different database jobs
  • Performed logical backup using export/import and data pump utilities Configured the RMAN backup
  • Carried out hot backup, cold backup and RMAN backup
  • Creation and configuration of Standby Database (Data Guard)
  • Loaded the different formats of data into Oracle using SQL Loader.
  • Performance Turing via OEM, AWR for 10g/11g
  • SQL Tuning using Explain Plan, TKProf with SQL trace, SQL Tuning Advisor I/O tuning Via OEM,

Confidential

Oracle DBA

Responsibilities:

  • Installing, Creating and Migrating the Oracle database on 10g R2 in Oracle Grid environment.
  • Created databases on RAC for Production, Development and ITG environments.
  • Performed migration from Oracle 8i, 9i, 10g to Oracle 10g Release2 RAC database.
  • Migrated 30+ databases (10gR2, R1, 9i, 8i) from Legacy environment to Oracle 10g R2 on RAC DCC environment using Export/Import, Loader, Database links, Data pump.
  • Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER (O.E.M.) 10g grid control.
  • Production support for Oracle database 8i/9i/10g/10g RAC
  • Troubleshooting on the Tickets for Oracle database related issues.
  • Upgrading and Patching the 9i/10g/10g RAC
  • Performed logical backup using export/import and data pump (remote export) utilities
  • Configured the RMAN backup, carried out hot backup, cold backup and RMAN backup
  • Creation and configuration of Standby Database (Data Guard)
  • Carried out the Binary Installs in the Oracle 10g RAC environment
  • Done the Migration Review required before the database migration and QA after the database is migrated.
  • Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
  • Provided full technical support to various application teams before the databases go to production
  • Experience in interaction with the top management and escalations of the complex issues
  • Performed entries capacity planning (CAPMAN) required creating and maintaining the Databases.
  • Perform Backups and Recovery, maintain 24 hours uptime for the database
  • Managed the databases of various sizes ranging from 50GB to 2 TB.

Hire Now