We provide IT Staff Augmentation Services!

Oracle/postgresql Production Support Resume

Plano, TX

SUMMARY:

  • 7 years of experience in the field of Database Technology. I managed Oracle and Postgres databases supporting many different applications. Expert knowledge in performance tuning, Backup and Recovery, High Availability Solutions like Dataguard, RAC and Golden Gate, Database Migrations, Database and scheme refreshes, Installations, Patches and Upgrades. I have also strong knowledge in SQL Server Databases.
  • Administer over 600 databases across Development, QA, UAT and PROD environments via use of command line and Oracle tools - Oracle Enterprise Manager Cloud 12c and Postgres Tools - PEM, PgAdmin4, and pg dump.
  • Upgraded Oracle databases from 11g to 12c.
  • Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.
  • Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.
  • Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication.
  • Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 7 using Transportable Tablespaces.
  • Good knowledge in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication.
  • Installed and Administered Oracle 11g & 12c RAC software with ASM.
  • Using Datapump import/export to move data between 11g/12c environments.
  • Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.
  • Performance Tuning of Oracle database using OEM, SQL analyzer, AWR, ADDM, ASH, Explain plan, TKPROF, and SQL TRACE.
  • Data transferring using Export/Import utilities and SQL*Loader.
  • Installed Oracle 11g,12c RAC software with ASM & ACFS File systems complete, Hot, physical backups of multiple Postgres Plus Advanced Server and PostgreSQL database servers using Bart Tools.
  • High knowledge in High Availability, Load Balancing, and Streaming Replication in PostgreSQL

PROFESSIONAL EXPERIENCE:

Confidential - PLano, TX

Oracle/PostgreSQL Production Support

  • Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
  • Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled job (Cron Job).
  • Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
  • Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
  • Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
  • Designed GoldenGate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.
  • Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.
  • Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
  • Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 .
  • Initializing a PostgreSQL Cluster and Configuring postgresql.conf file
  • Moving Data with PostgreSQL using Tools suchas PgAdmin4, Pg Dump and PEM.
  • 24 X 7 Production & Development database support and administration in PostgreSQL Database.
  • Performing Performance tuning in PostgreSQL including idle-transaction, CPU utilization High, Wal Space issue and Long running queries.

Confidential - Atlanta, GA

Oracle Database Administrator

  • Supporting multiple databases for production, development, test and staging purposes on Lunix and Windows environments.
  • Implemented Dataguard, creating both logical and physical standby databases in 12g RAC environment for production database.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
  • Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.
  • Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.
  • Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication.
  • Designed GoldenGate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.
  • Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, and TKPROF for best performance.
  • Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.
  • Administer RAC Database servers using SRVCTL, OEM Grid control, V$/GV$ views and System wide tuning using UTLBSTAT and UTLESTAT.
  • Used Oracle Enterprise Manager (OEM) 12c Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Explain plan and SQL*Trace. Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 6.

Confidential - Toms Rivers, NJ

Oracle/PostgreSQL Database Administrator

  • Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.
  • Alert management Created and setup alerts to send notification to Users from application wherever necessary.
  • Carrying out Postgres upgrade including Minor and Major Version Upgrade using Pg Upgrade
  • Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 .
  • Implemented Dataguard, creating both logical and physical standby databases in 12g RAC environment for production database
  • Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 6 using Transportable Tablespaces.
  • Implemented fast start failover on databases and configuring disaster recovery site using dataguard. Also proficient with new 12c features such as Active Dataguard and Snapshot standby database.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 11g/12c environments.
  • Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 6.5. Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.
  • Upgraded databases from 11g to 12c.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Installing PostgreSQL on Linux / Unix and Windows OS platforms complete understanding on setup, maintenance of replication at PostgreSQL implementing the industry best practices to comply company security policy in line with the PostgreSQL environment. understanding on Backup and recovery process and also experience on Performing an SQL Dump and Restore.

TECHNICAL SKILLS:

Operating Systems: HP-UX 11.x. Sun Solaris 8, 9, 10. AIX 5.x, 6.x, Linux Enterprise Redhat, Centos and Ubuntu 6&7. Windows 2010, 2012

RDBMS: Oracle 12c, 11g, 10g, SQL Server, PostgreSQL 9.2, 9.3, 9.4, 9.5, 9.6 and 10

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM.: Toad, Putty, NX client, Winscp, pgAdmin4, Shell SQL, SQL Management Studio, Connection, VNC and Cisco VPN Client, PEM

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, Pg Dump, Pg DumpAll, BART

Hire Now