Data Oracle

Phone: 443-***-**** Email: ***********@*****.***

Professional Summary

Over 8 years of extensive experience as an Oracle/PostgreSQL database administrator, I have knowledge and hands-on experience in database design, migration, upgrades, database security, backup and recovery, cloning, replication, monitoring and tuning. I am proficient in an assortment of technologies including Oracle 12c and PostgreSQL. A team player with excellent communication skills and problem solver who can successfully manage multiple priorities while performing well under pressure. I am a proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.

Handled Space Reclaim, Performance Improvement and De-fragmentation of Database Objects using VACUUM FULL, auto VACUUM and several other options.

Enabled Logging of Slow Queries and improved performance through several maintenance tasks on PostgreSQL and MySQL Database Tables u\ng OPTIMIZE and Table Rebuilds.

Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.

Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL and MySQL Databases

Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.

Deploy the Database Objects requested by the Application Team.

Collect the Dumps generated by several reports from PostgreSQL Databases and importing to Archival Databases for Archival and Purging.

Installed, Configured and Administered STREAMS and good knowledge on GOLDEN GATE.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Worked on large-scale databases with size around 10TB in large system environments.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of DR sites for all the Production and IST environments.

Performed Database Refresh from Production to IST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Cloned Database from Production to Test and Development.

Exporting and Importing of dumps using expdp and impdp.

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Professional Experience

M&T BANK - BUFFALO, NY

AUGUST 2017 – PRESENT

ORACLE/POSTGRES DATABASE ADMINISTRATOR

Involved in Installing/configuring PostgreSQL VERSIONS 9.6 to 11

Manage and monitor Postgres databases using pgAdmin and PEM.

pgHero for Performance Tuning as well as SQL Tuning using EXPLAIN ANAYZ Participated and assisted in data migration from Oracle databases to PostgreSQL databases on premises and in AWS Cloud.

E and PG_STAT_ACTIVITY .

Performing basic tasks such as objects creation; creating roles, granting privileges, creating tables.

Implementing the use of indexes, and primary & foreign key constraints as required

Providing production support based on a ticketing system.

Assisted in defining and implementing maintenance plan for the database systems.

Performing maintenance activities like vacuum, vacuum full, analyze etc.

Configured PgBouncer for connection pooling.

Configured pgBadger for generating statistic reports.

Experienced of tuning PostgreSQL server settings & Troubleshooting performance issues.

Managing Users and Tablespaces on PostgreSQL Servers.

Using Customized scripts, to monitor database growth, table growth, automated backups using cronjobs.

Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.

Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.

Used restoration techniques like pg_restore and (PITR) Point in Time Recovery.

Performing BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema refreshes.

VCU Health - Richmond, VA

Jun 2015 – August 2017

Oracle Database Administrator

Renaming and Resizing the databases and Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Performed Schema as well as Table level Replication using Oracle Streams.

Implemented downstream capture at the destination database using Oracle Streams.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Worked on Multitenant databases.

Performed Database Refresh from Production to QA, UAT and Development databases.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Extensive experience in RMAN recovery testing, RAC and stand alone database.

Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Installed and configured PostgreSQL versions like (9.5, 9.6 and version 10) on Linux OS.

Configured, managed and monitored replication between master and slave databases

Used pg_Bouncer for connection pooling, pg_Badger for generating statistic reports.

Create roles/tables and grant privileges to users

Implemented database security using pgcrypto.

Upgraded database versions using pg_dump/pg_restore and pg_upgrade tools and I make sure the latest security patches are updated, provided by PostgreSQL open source community.

Exposure to mongo DB environment

Performed Backups (pg_basebackup, PgBackRest, pg_dump) and restore operations, compressed backups and database/schema refreshes.

I created an RDS Postgres instance and connect with pgAdmin for easy access.

Experience on restore operations (pg_restore) and Point In Time Recovery.

Experience in using pg_hero for performance tuning and analysis, SQL Tuning using pg_stat_activity and EXPLAIN ANALYZE.

Tuned Auto vacuum parameters to reclaim space consumed by dead tuples and ensure the up to date statistics of tables.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Upgraded the databases to version 12c from 11g and 10g

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6

Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.

Applying upgrade patches, maintenance and interim patches on all the databases.

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Successfully implemented 10g RAC on nodes for high availability.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Involved in construction of DR sites for all the Production environments.

Installed 12c database

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.

Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Experience in writing UNIX/SHELL scripts for providing the reports.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Quintiles Transnational - Providence, RI July 2012 – May 2015

Oracle Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.

Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.

Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

Performed troubleshooting of database using AWR and ADDM reports.

Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.

Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually

Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.

Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Technical Summary

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS

Oracle 12c, 11g, 10g

Languages

SQL, PL/SQL

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, PGADMIN4, PGBOUNCER, PGBACKREST, Toad, Grid, RMAN, MTK, Orapg2, Exp, Log miner, DBCA, DBUA, ADDM, Oracle

Education

-Bachelor of Science in Computer Science

- Oracle Certified Associate (OCA), PL/SQL Certified

-AWS Certified Solutions Architect

SPOKEN LANGUAGES: ENGLISH & FRENCH

Contact this candidate