SUMMARY

• Five (5) years Superb Knowledge in Oracle Databases 10g, 11g and 12c, Experience in database. MIGRATION - 10g to 11g, 11g to 12c databases, cross-platform using Data guard, Golden Gate, Transportable tablespaces. Non-ASM to ASM. Maintain performance across all phase. Worked on oracle migration workbench. Responsible for Datacenter Migration from old Datacenter to new datacenter.
• Experience with performance tuning and troubleshooting Completed Oracle University performance tuning course. Using Explain plan, ASH, ADDM, AWR, v$, dba views, HIST tables &TKPROF, SQL Profile. Instance, database & SQL performance optimization. Forcing index, hints. I/O & CPU utilization trend analysis. Top SQL/session, bottleneck issues, locks, identifying oracle wait events. Create performance baseline, comparing performance and Investigate top activities; generate trend report of tablespace usage & estimate future growth. Extensive use of OEM grid control for tuning. Worked on ADRCI command-line 11
• UPGRADE&PATCHES - Apply security/PSU patches. Validate database structure. Troubleshoot failed component in upgrade process. Upgrade ASM and RAC from 10g to 11g. Perform backups, restores and recovery processes.
• DATA GUARD - Set up physical standby for DR. Configure data guard broker, open standby in read-only, manage archive gap, testing fail-over/switch-over scenarios, changing protection modes. Configured Active, Logical, and Snapshot Data Guard.
• RAC - Implementation & administration of 10g/11g RAC on Linux. Oracle ASM, OCFS, RAW devices. FAN, TAF, load balancing, inter instance parallelism, add/remove node. Troubleshooting & Admin ASM. Apply patches. Setup SCAN Listeners on 11gR2. experience with Data Security, Transparent Data Encryption (TDE) and data protection best practices.
• GOLDENGATE: Setup, data mapping, filter, troubleshoot, developing parameter file. Live reporting, CDC, Active-Active standby configuration. STREAMS replication at table, schema and database levels. Down steams, advance queuing, change data capture.
• (2) years POSTGRESQL: Software Installation, user and tablespace creation. Responsible for all backup, recovery, and upgrading the Postgresql
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production Postgresql databases within the organization.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.
• Migration of Data from Reports generated by various vendors into Postgresql Databases using Postgresql Export/Import Procedures.
• Maintaining custom vacuum strategies for high volume databases.
• Experience with ORA2PG, a tool for migrating database from oracle to PostgreSQL.
• Database migration while upgrading databases versions

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c, and Postgresql

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, Oracle Enterprise Manager 13C, RMAN, SQL*Loader, Exp/Imp/Data Pump, AWR, DBCA, DBUA, ADDM, Toad, Putty, WinSCP, SQL Developer, OEM 12c,, PEM, PG BOUNCER, ORA2PG, PG PARTMAN, BDR, PGBACKREST, PGLOGICAL, REPMGR, PGAdmin.

Operating Systems: LINUX, UNIX (Solaris 8/9/10, AIX, HP-UX), MS WINDOWS

Other Skills: Oracle, DATA GUARD, GOLDEN GATE, RAC

PROFESSIONAL EXPERIENCE

Confidential, Burlington, MA

Oracle Database Administrator

Responsibilities:

• Responsible for regular backups and recovery of databases in postgresql environment responsible for regular maintenance on databases (e.g, vacuum, reindexing, archiving) . responsible for query tuning and preventative maintenance performing other duties as assigned participate in a 24 * support rotation
• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views. responsible for pro active remediation of database operational problems in postgresql environment Maintaining custom vacuum strategies for high volume databases.
• Experience with ORA2PG, a tool for migrating database from oracle to PostgreSQL.
• 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 dabase on a regular daily basis.
• Programing various scripts to load data into a database and process it from various sources, (XML, CSV,JSON, API data feeds, Database dumps).
• Experienced writing Perl to run on both Linux and Windows environments.
• Knowledge of fault detection and resolution processes.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Linked database security controls to external authorization sources to provide row-level security.
• Experience in editing and writing UNIX/shell scripts for providing the reports.
• Created a clone database using rman on remote server and used srvctl commands for real application cluster (RAC) databases.
• Successfully implemented backup & recovery using rman which includes hot backups and cold backups.
• 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.
• Knowledge in oracle data warehouse dba skills relating to administration and management of VLDB environments, oracle OLTP.
• Performing monthly and annual performance reports for trend analysis and capacity planning
• Successfully implemented backup & recovery using rman which includes hot backups and cold backups.
• 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.
• Knowledge in oracle data warehouse dba skills relating to administration and management of VLDB environments, oracle OLTP.
• Performing monthly and annual performance reports for trend analysis and capacity planning
• Administration and management of the entire development, QA and production environment.

Confidential, Monroe, MI

Database Administrator

Responsibilities:

• Participated in 24 x 7 production & development database support and administration.
• Worked with data pump to take the logical backups of databases and experienced in performing point in time recovery using rman. used oracle configuration assistants like: dbca (database configuration assistant) for creating databases, dbua (database upgrade assistant) for upgrading databases, and netca (network configuration assistant) for creating client-server environment using listener, tnsnames etc.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing datapump, conventional export/import utility
• Implemented proactive monitoring using tuning pack, diagnostics pack, and statspack, SQL Trace & TKPROF. implemented oracle database 11g two node real application cluster (RAC) using oracle cluster-ware, and responsible for high availability and load balancing. * configured oracle data guard for oracle disaster recovery. applying upgrade patch, maintenance and interim (Opatch) patches on all the databases. implemented flashback technology of the oracle 12c, 11g, 10g along with recycle bin for a faster recovery of the databases and database objects. performed full & incremental backup (cumulative and differential) using rman and implemented recovery strategies. refreshed/cloned databases using rman utility.