I am a proactive Oracle/PostgreSQL database administrator, detailed oriented, team player with Five (5) years of experience working on different oracle/PostgreSQL versions oracle (10g,11g,12c, 18c and 19c) PostgreSQL (9 and 10). existing on different platforms such as Linux. Unix and Windows. I have good experience in backup and recovery, performance tuning, security, migration and refreshes. I have participated in projects like. Data guard, Golden Gate, RAC, patches, upgrades Migration from Oracle to PostgreSQL. I have done installation and configuration of oracle and PostgreSQL and aws software’s.
SKILLS SET
- Oracle Database Administrator having hands and experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
- Over 5 years of PostgreSQL installation, configuration, performance monitoring, database design, migration form Oracle to PostgreSQL, security, troubleshooting, as well as backup and data recovery.
- Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 12c Grid and 11g on ASM and OCSF2 file systems.
- Highly experienced in Oracle 11g, 12c Automatic Storage Management (ASM) required to fulfill the storage needs.
- Installation and configuration of oracle Golden Gate.
- Experience in using Golden Gate to support data replication in the Oracle database environment.
- Experience in Golden Gate upgrade from 11g to 12c.
- Experience in applying PSU patch on standalone as well as RAC databases.
- Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 12c, 18c RAC servers for the purpose of disaster recovery procedures.
- Setup and maintenance of Postgres master-slave clusters utilizing streaming replication. Cross-datacenter disaster recovery and backup architecture
- Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions ranging from 8.2 to 9.6.
- Experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
- Migration to aws setup database in aws.
- Create aws instances and managed them for performance.
- Manage EC2 instances.
- Installing pivotal-support packages to monitor performance like (gpsupport and mem_watcher.. etc)
- Fixing the memory issues and suggesting the best practices.
- Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
- Created SQL reports per requirement.
- Troubleshoot and resolve database problems.
- Configured Manager, Replicate and Extract processes and implemented unidirectional replication using Oracle 11g/12c Golden Gate on RHEL 5.
- UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
- Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
- Installed Oracle 11g with ASM and OCFS2 File systems.
- Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
- Configuring backup strategies with image copy, level 0 and level 1 RMAN backup
- Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
- Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
- Highly experienced in implementing Oracle's Transportable Tablespaces (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
- Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 10g, 11g, 12c and 18c.
- Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
- Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
- Expertise in maintaining Database Security using auditing.
- Experience in doing upgrades including maintenance & monitoring implementation.
- Extensive knowledge in UNIX platforms includes SOLARIS, AIX, and LINUX.
- Knowledge in configuring ASM (Automatic Storage Management)
- UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
- Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
- Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
- Experience in Upgrading databases, applying patches.
- Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
