SUMMARY

• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures
• Experience with ORA2PG, a tool for migrating database from oracle to PostgreSQL
• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents
• In - depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.
• Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Experienced in Performance Monitoring tools like OEM, AWR report, DBMS PROFILER to troubleshoot some PL/SQL codes.
• Also responsible for well-functioning of the database by Checking and Applying Patch set and Interim patches and upgrades. Upgraded databases from 10g and 11g to 12c.
• 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)
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Install, configure, and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
• Performed database monitoring and tuning to ensure databases run at peak performance, troubleshooting production performance issues.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing and High-level Security using Transparent Data Encryption (TDE),
• Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.
• Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Performed RMAN backups (Full, Incremental and Cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading to Oracle 12c to the latest Oracle 12c and applied patches as required.
• Installed, Configured and Administered STREAMS and good knowledge on GOLDEN GATE.
• 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)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Designed, developed, and migrated existing SQL databases. Automated DBA activities and upgraded existing databases.
• Maintained and optimized database application performance through tuning.
• Generated database reports such as financial data statements and user data.
• Prepared automation scripts and developed PostgreSQL database architecture.

PROFESSIONAL EXPERIENCE

Confidential - Richmond, VA

Oracle & PostgreSQL Database Administrator

Responsibilities:

• Expertise in maintaining Database Security using auditing.
• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Experienced using GOLDEN GATE for UNIDIRECTIONAL AND BIDIRECTIONAL Replication
• Used GOLDEN GATE for Zero Downtown Upgrade and Migration.
• Monitored database and SQL performance using OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords, network, etc.)
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures
• Experience with ORA2PG, a tool for migrating database from oracle to PostgreSQL.
• Maintaining custom vacuum strategies for high volume databases.
• Database migration while upgrading databases versions.
• Extensive experienced with warm standby and hot standby.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Configured PostgreSQL databases to replicate across multiple sites using REPMgr and streaming replication.
• Hand on experience on performance tuning, index maintenance on PostgreSQL database on a regular daily basis.
• Linked database security controls to external authorization sources to provide row-level security.
• Responsible for regular maintenance on databases (reindexing, archiving, vacuum).
• Responsible for query tuning and preventative maintenance
• Responsible for regular backups and recovery of databases in PostgreSQL environment.
• Responsible for proactive remediation of database operational problems in PostgreSQL environment.
• Responsible for the monitoring and uptime of all production databases
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues
• Refresh/Cloning of Database from production environment to test environment and application of patches
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Applied bug patches according to the Oracle Critical Patch alerts
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers
• Provided 24X7 support for all the production and development databases
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF
• EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Worked on user management mainly on grants, privileges, roles, and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Involved in query optimization and using rule-based optimizers and cost based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Confidential - Milwaukee, WI

Oracle Database Administrator

Responsibilities:

• 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
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests. Involving in Installing/configuring PostgreSQL. Mainly TWO postgres VERSIONS 9.5 and 9.6. managing and monitoring databases using pgAdmin
• I Used pgHero for Performance TUNING mostly. SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY Performing BASIC TASKS such as Creating OBJECTS, 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. And Assisting in defining and implementing MAINTAINANCE PLAN for the database system.
• Performing maintenance activities like vacuum, vacuum full, analyze etc Configuring PgBouncer for connection pooling.
• Configuring pgBadger for generating statistic reports.
• Experience of tuning PostgreSQL server settings & Troubleshooting performance issues.
• Managing Users and Tablespace on PostgreSQL Servers.
• Working knowledge of pgAdmin tool.
• Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Using customized scripts to perform maintenance.
• Checking the AUTO VA
• CUUM jobs, Customized VACUUM on certain tables and columns
• Experience in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Perform BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database Or Schema REFRESHES
• 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.

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.