SUMMARY:

• Database Administrator with strong experience in Oracle (5yrs +) and PostgreSQL (2 years) in heterogeneous system environment including LINUX, UNIX, AIX, Solaris and Windows, supporting a variety of applications both in TEST and PRODUCTION environment with Oracle 10g, 11g and 12c.
• During this period, I have supported PostgreSQL databases where I migrated from Oracle to PostgreSQL.
• I have had the opportunity to support MS SQL server databases (2008,2012,2014) running on windows and Linux.
• Excellent in security management, database maintenance and establishing backup and recovery processes to safeguard data, paying attention to High availability configurations of the database as well as some PostgreSQL database activities like Replication.
• I am a fast learner and willing to learn more new things and make good use of them especially with the open source.
• I have the capability to start contributing to the growth of the company from day 1 and I bring to the company set of skills and experience.
• I look forward to a new role where I can learn new things and grow in my career alongside the company.

SKILL:

• Golden gate for replication
• Dataguard for disaster recovery
• RAC for availability
• Performance Tuning/Analysis
• Testing
• ASM
• Production Support
• OEM Grid control
• Shell Scripting
• Exadata
• Multitenant Architecture
• Installations and Configurations
• Upgrade and Patches
• ETL (extraction Transformation & loading)
• Database administration
• RMAN (Recovery Manager)
• Dataguard Broker
• Datapump and export/import
• Transportable Tablespace
• Sql loader
• AWR,ADDM,ASH,Explain plan
• SQL TRACE, TK PROF
• SQL Tuning & Access Advisor
• SQL DEVELOPER
• NAS
• Pg Admin
• Pg Bouncer
• Psql
• Ora2pg
• Pg Badge
• Pg basebackup
• Pg backrest
• Pg dump
• Pg restore
• Pg upgrade
• Pg Hero
• Explain Analyze
• Vacuum, etc.
• DATABASE $ SOFTWARE SUPPORTED
• Oracle - 10g,11g,12c
• PostgreSQL- 9.5,9.6 and 10
• MS SQL server- 2008,2012,2014,2016
• Linux (Red-Hat), Unix, Solaris, Window, Aix

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Oracle Database Administrator

Responsibilities:

• Skillfully implemented all new 12c features including redaction policy, optimization of adaptive queries, multi-index single columns, and RMAN table restoration
• Successfully cloned non-multitenant container database to pluggable database in 12c
• Efficiently installed high availability Goldengate systems on 11g and 12c environments
• Expertly configured Dataguard and logical and physical standby database in 11gR2 2-node RAC
• Applying Rolling Upgrade in the RAC environment to enhance availability.
• Experience in setting up Oracle ASM storage for Oracle RAC databases.
• Performed database replication through Golden Gate.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• RMAN point in time recovery and Instance recovery done on 11g.
• Utilized RMAN to perform hot/cold backups, recovery and cloning of databases
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Managed 100GB to 5TB databases using TOAD, OEM, and SQL Developer
• Extensively used TTS, Datapump, and SQL Loader to migrate tablespaces and databases across platforms
• Collaborated regularly with development, application, system administration, and release teams to ensure optimized functionality
• Primarily used diagnostic tools such as TKPROF, SQL*Trace, SQL*Analyzer, EXPLAIN PLAN, and ASH and AWR reports to monitor and tune database performance at the operating system and database level
• Optimized efficient database simultaneous auditing through installation, configuration, and maintenance of Oracle Audit Vault
• Provided 24/7 technical support for production and development databases
• Implemented and deployed high availability systems on 11g database using RAC, Dataguard, Streams, ASM, and RMAN to implement and administer effective disaster recovery strategies to mitigate data loss in the event of crashes
• Used SQL*Loader and external tables to load flat file data to databases
• Experience in installing, configuring, designing and building PostgreSQL databases in Linux and Windows and providing 24/7 on-call rotation.
• Good experience in performance tuning, query optimization, and overall security of the database.
• Installed and configured PostgreSQL (9.5, 9.6 and worked recently with PostgreSQL version 10 and 11.2).
• Highly experienced in Linux Operating system
• Proactively managed standby replication and hot standby for disaster recovery.
• Experience in creating database objects to enhance performance like index, partitioning etc
• Exposure to cross platform migration from oracle to PostgreSQL.
• Used pg Bouncer for connection pooling, pg Badge for generating statistic reports.
• Administered PostgreSQL databases using pg Admin and Psql.
• Configured replication between master and slave and monitored the on-going process.
• Upgraded database versions using pg dump/pg restore and pg upgrade tools and I make sure the latest security patches to the database are updated, this is provided by PostgreSQL open source community.
• Performed Backups (pg basebackup, pg backrest, pg dump) and restore operations, compressed backups and database/schema refreshes
• Experienced on restore operations (pg restore) and Point In Time Recovery SQL Tuning using the EXPLAIN ANALYZE and pg stat activity
• Tuned Auto vacuum parameters to reclaim space consumed by dead tuples and ensure the up to date statistics of tables.
• Extensively used customized scripts to monitor the growth of database, table growth and automated backups using cron jobs.
• Performance tuning of the database at all levels.
• Excellent in Capacity planning.
• Create roles, grant privileges, create tables, use indexes and foreign/primary key constraint as needed and required.
• Implemented security as required at all levels in the database.
• Experience in PostgreSQL clustering
• Implemented security measures ranging from Auditing to Encryption to protect Sensitive Data.

Confidential, Minneapolis, MN

Oracle Database Administrator

Responsibilities:

• Extensively utilized OEM 12c Cloud Control to monitor various database and application servers
• Analyzed user activity to determine appropriate roles and privileges to create and assign for individuals
• Cloned and migrated small databases via traditional import/export and moved data with Datapump expdp/impdp
• Periodically performance tuned database using AWR, ADDM, and EXPLAIN PLAN to optimize performance
• Extensively implemented enterprise databases on Enterprise Storage Solutions using SAN and NAS
• Applied all needed upgrade, security, and interim patches as needed, using Opatch utility
• Implemented effective recovery strategies and utilized RMAN to perform full and incremental backups both cumulative and differential
• Utilized RMAN utility efficiently to refresh and clone databases to maintain data integrity
• Successfully upgraded databases from10g (10.2.0.5) to 11g (11.1.0.7) RAC databases
• Rebuilt indexes on database tables and indexes to optimize database performance
• Developed well-constructed Unix scripts to automate database processes including file movement, alert log management, and efficient backup strategies
• Skillfully configured 2-node RAC with ASM file system on Linux and converted single instance database to 11g RAC
• Maintained currently knowledge of new technologies and applications to apply to database quality, productivity, and efficiency
• Managed large database from 50GB to 3TB utilizing TOAD, OEM, and SQL Developer
• Created detailed documents in SharePoint for future database administrators to while troubleshooting