UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs. Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility. Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM). Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage Implemented Dataguard in the production environment. Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard. Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery sites using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database. Experience in PostgreSQL RDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, bouncer, and ora2pg Configuring PostgreSQL Streaming Replication and PgBadger for load balancing. Expertise in implementing partitioning methodologies Range partitioning, List partitioning, Hash partitioning, Composite partitioning on tables and indexes for high performance. Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control. PostgreSQL Security, roles, group roles, and row-level security and granting privileges. HA solution via Streaming Replication, Setting up logical Replication, configuration of Repmgr, PgBadger, PgBouncer, Pg_Basebackup, PgBackRest, PgAdmin 4, Profile Over 6+ years of in-depth experience as an Oracle and PostgreSQL Database Administrator with experience on 24x7 production and mission critical database support. Hands on experience in configuring, integrating, and maintaining Development, Staging, and production PostgreSQL databases. I possess strong analytical and problem-solving skills, self-motivated, results-driven, team player with excellent verbal and writing communication skills. I have worked on Oracle 11g, 12c and 19c versions as well as PostgreSQL 9.6, 10, 11 and, 12. Other areas of work include performance tuning, backup and recovery, database migration, upgrades, and patches, configuration of Goldengate and Dataguard for Replication, and High Availability, database security and capacity planning. Talented Database Administrator with [Number] years of success using [Type] and [Type] technologies to produce [Result]. Proficient in wide range of development languages, including [Type], [Type] and [Type]. Excellent presentation and communication skills.
Job Titles Held: