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