An accomplished Database Administrator (DBA) with over 7+ years of experience working on 11g/12c/19c databases. I am vastly experienced in Oracle software installations, database normalization (design) and creation ( standalone and containers), database administration and maintenance, database tuning, RMAN backup and recovery, Automatic Storage Management (ASM), Real Application Cluster (RAC), Data Guard (Physical), Patching and Upgrade (OPatch/OPatchAuto), Security Management and Performance Tuning on UNIX/LINUX, and Windows operating systems. Seeking a position in dynamic and technologically diverse environment.
⦁ RDBMS: PostgreSQL 9.5.x to 11.x, Oracle 11g, 12c, 19c
⦁ Monitoring DB growth every month in DWH databases and planning to implement table partitioning for better performance.
⦁ Monitoring bloat reports on every table and performing maintenance with minimal downtime.
⦁ Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
⦁ Data migration while upgrading database versions.
⦁ Removing Index bloat Concurrently to improve performance.
⦁ Experienced in Oracle DB 3-Tier architecture and Oracle Database System Development Life Cycle (SDLC) planning.
⦁ Performed Installation, Configuration, Upgrade, Patching of Oracle RDBMS and applications work on different versions of databases with OEM Cloud Control to maintain database effectively.
⦁ Monitored production databases using Oracle Enterprise Manager (OEM) and provided maximum uptime.
⦁ Routinely did Performance Tuning of queries by maintaining aggregates, compressions, partitions, indexing, use of Hints, Stored outlines, and statistics gathering.
⦁ Proficient in PL/SQL, SQL and UNIX Shell Scripting. Implement UNIX Scripts using CRONJOB for daily activities and Windows Task Scheduler.
⦁ Executed PL/SQL and SQL tuning of Oracle contention and monitor production database using Automatic Workload Repository (AWR), Automatic Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM).
⦁ SQL tuning and Database Performance Tuning done based on reports generated by SQL Trace, TKPROF, Explain Plan, AWR, ADDM and monitored database performance on daily basis.
⦁ Extensively implemented Data Pump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backup of database.
⦁ Applied Patch set, Critical Patch Updates (CPU) and Patch Set Updates (PSU). One-off Patches using OPatchAuto and runInstaller.
⦁ Intermittently carried out RMAN Backups, Hot Backups and Logical Backups of the containerdB.
⦁ Ocassionally tested proof of concept to switchover to standby database and switchback to production database using DG Broker utility.
⦁ Developed project plans for implementing database environments. Provided input to technical projects and oversaw tactical aspects of all database related tasks.
⦁ Designed and implemented administration of PostgreSQL databases to ensure accurate, and effective use of data, including database definition, structure, capacity planing, and documentation.
⦁ Evaluated database design and integration of systems, and made recommendations regarding enhancements or improvements.
⦁ Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases.
⦁ Installed and monitored PostgreSQL databases using standard monitoring tools like Nagios and PgAdmin.
⦁ Installed and configured HA connection pooling tools like Pgbouncer and pgpool with HAProxy.
⦁ Installed, configured, tested, monitored, upgraded, and tuned new and existing PostgreSQL databases.
⦁ Automated Postgres deployments on AWS EC2 with Terraform and Ansible.
⦁ Supported daily administration, monitoring, tuning, and troubleshooting of clusters on Linux and AWS Console (Database sizes range from 100GB to 2TB).
⦁ Proactive in updating latest security patches to database, which are provided by PostgreSQL Global Development Group (PGDG).
⦁ Set up and maintained security and integrity controls through creation of roles and granting them privileges.
⦁ Executed quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
⦁ Provided appropriate interfacing, consulting, and standards associated to database management, and monitored transaction activity and utilization.
⦁ Diagnosed, resolved and implemented preventive measures to guarantee availability, performance and recovery of all supported database environments.
⦁ Configured log analysis tools like pghero and pgbadger.
⦁ Daily log analysis using pgbadger tool and query tuning.
⦁ Tuned auto-vacuum parameters to ensure current table stats and reclaim space consumed by dead tuples.
⦁ Maintained custom vacuum strategies at table and db level.
⦁ Scheduled maintenance activities to vacuum, analyze to improve query response time.
⦁ Ability to proactively identify, troubleshoot and resolve live database systems issues.
⦁ Experienced in code migration, database change management through various stages of development life cycle.
⦁ Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
⦁ Studied and stayed current on features and functionality of PostgreSQL.
⦁ Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
⦁ Hands-on experience on database administration, backup recovery and troubleshooting.
⦁ Responsible for all backups, recovery, and upgrading of all PostgreSQL databases.
⦁ Performed weekly Point-in-time recovery (PITR) of development environment for proper failure testing.
⦁ Implemented and monitored replication for high availability and disaster recovery scenarios.
⦁ Proactively managed standby replication procedures like Streaming replication and hot standby for disaster recovery.
⦁ Provided responses for all database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
⦁ Ability to thrive in fast-paced, deadline-sensitive environment.
⦁ Participated in daily stand ups to discuss about new database design, modeling and creation.
Experienced with MTK for migrating databases from Oracle to PostgreSQL.
Oracle 12C SQL Fundamentals
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Job Titles Held: