We provide IT Staff Augmentation Services!

Oracle Database Administrator / Postgres Database Administrator Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • Experienced Oracle Database Administrator with over 7 years of Oracle experience in configuring, integrating, upgrading, migrating, and setting up databases in various environments.
  • Highly skilled in database cloning and refreshing and tuning and assigning indexes.
  • Excels as an IT professional and a database analyst, easily able to work in teams to achieve common goals.
  • Skilled in installing, configuring, upgrading, and migrating databases as needed.
  • Maintains strict database security and integrity standards for databases.
  • I have good knowledge of AWS, 3years experience with POSTGRESQL databases.

AREAS OF EXPERTISE

  • Oracle 10g, 11g, 12c
  • Solaris
  • UNIX
  • AIX
  • Linux
  • Windows
  • TOAD
  • SQL DEVELOPER
  • Performance tuning
  • RMAN
  • RAC
  • Data guard
  • Goldengate
  • Upgrades and patches
  • Oracle Enterprise Manager (OEM)
  • Real Application Cluster (RAC)
  • ASM
  • Data pump
  • UNIX scripting
  • Database security
  • AWS
  • Data migration
  • EXADATA
  • PL/SQL
  • SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator / Postgres Database Administrator

Responsibilities:

  • Participate in a 24/7 on - call rotation position for all prod, QA, and dev environments
  • Expert in initializing clusters and creation of PostgreSQL Databases
  • Responsible for configuring, integrating maintaining development and production PostgreSQL databases
  • Administering large PostgreSQL Databases
  • Experience in master and slave replication of PostgreSQL
  • Experience in tuning PostgreSQL Databases using vacuum and analyze
  • Experience with pg bouncer for connection pooling
  • Experience taking PostgreSQL backups using pg basebackup and pg backrest
  • Experience using pg dump and pg upgrade for database upgrade
  • Hands on experience migrating from oracle to PostgreSQL
  • Installed and created 11g,12c databases
  • Experience working with AWS
  • Experience with EC2 and RDS instance
  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Experience with RMAN for backup and recovery
  • Experience using RMAN for refresh
  • Experience using RMAN for cloning
  • Experience with RMAN migration
  • Experience using data pump for import and export of data
  • Used data pump for upgrade
  • Used implemented range, list, hash, and sub partitions to develop partitioning strategies for large tables and create and schedule refreshes for materialized views
  • Provided high speed parallel bulk and meta data movement of database contents through skillful use of Data pump
  • Reorganized databases, tables, and schemas to improve performance and aid in capacity planning
  • Administered and troubleshot 3 node clusters on 10g/11gR2 and configured Grid Infrastructure SCAN listeners
  • Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
  • Performed task like administering the RAC using SRVCTL adding nodes, administering storage components
  • Performed cluster-wide resource management, creating resource plans, service configuration, parallel instance groups, and application isolation
  • Managed all ASM functions including storage, cloning, preparing/adding/and removing disks, tuning I/O, and troubleshooting crashes and memory problems
  • Expert in logical and physical data modeling and designed logical and physical database structure
  • Created user accounts, roles, privileges, administrative tasks and schema deployments
  • Ensured high availability, data protection, and disaster recovery through extensive use of Data guard and physical and logical standby databases
  • Utilized ADDM and SQL Tuning Advisor in 10g, 11g, and 12c to improve database performance by tuning SQL and instance parameters
  • Expert on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
  • Quickly resolved client connectivity issues by using TCP/IP protocol configured SQL*Net files on server and client machines
  • Expert with setting up physical standby Data guard environment for prod and non-prod databases
  • Expert in using the data guard broker to manage the data guard environment
  • Efficiently monitored application and database security along with user accounts and passwords
  • Extensively used Hints, Indexes, and partitioning to improve performance
  • Recovered data files from logical and physical block corruptions
  • Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches
  • Configured Golden Gate for continuous, real-time capture, routing, transformation and delivery of transactional data across heterogenous platforms.
  • Hands on experience in collision handling during initial load golden gate
  • Experience in resolving oracle golden gate errors
  • Experience in trouble shooting golden gate abending processes

Confidential

Oracle Database Administrator

Responsibilities:

  • Provided prompt 24/7 support for all production and development databases
  • Utilized RMAN and traditional Data pump export/import to clone and migrate databases
  • Used RMAN to successfully recover database data during database crashes and media and disk failures as well as create and implement recovery strategies
  • Extensively used Crontab to schedule and monitor hot and cold physical backups
  • Created all users, groups, roles, profiles, and privileges for relevant groups
  • Optimized and tuned SQL queries using AWR, ASH, ADDM, Explain Plan, SQL TUNING ADVISOR.
  • Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches
  • Skillfully used RMAN and Data pump conventional import/export to implement database, schema, and table level data refreshes
  • Installed and configured 10.2.0.1 database and upgraded from 11g to non-CDB 12c
  • Successfully migrated from 11g to 11gR2 and from 12c non-CDB to pluggable databases
  • Implemented tablespace level TDE security successfully and created Oracle Wallets
  • Reviewed alert log and trace files to constantly monitor database performance (V$ dynamic performance views at peak load)
  • Checked database health status including table size growth, extent allocation, free and used space, and fragmentation by creating and running scripts
  • Managed space maintenance, capacity planning, disaster recovery, and database overall maintenance Data guard
  • Ensured zero downtime during physical standby database creation by using RMAN Data guard performing failover and switchover manually and Data guard Broker
  • Knowledge in resolving gaps in the data guard environment
  • Resolved SRS efficiently through use of Oracle Support
  • Configured Golden Gate for real time replication of data
  • Knowledge in monitoring golden gate errors using ggserr.log file and the discard file
  • Experience in troubleshooting golden gate processes like abending replicate and extract
  • Created standard process documentation for peers to follow and utilize

We'd love your feedback!