SUMMARY

• 7+ years Experience in Oracle/PostgreSQL Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams Enterprise Manager and Golden Gate on Sun Solaris, Exadata, Red Hat Linux, ETL tools, HP - UX, AIX, and Windows Platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience wif Oracle Real Application Clusters (RAC) and Data Guard.
• Ability to work both as an individual contributor and as a member of a team.
• Experience in Performance tuning of Oracle Golden Gate Processes to achieve zero lag times.
• Experience in PostgreSQL RDBMS wif noledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, pgbouncer, Stado and ora2pg.
• Lead teh design, testing, implementation, maintenance, and control of teh organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
• Good Experience in migrating Databases from Solaris, AIX Oracle 10g/11g to Linux Oracle 12c
• Implementation of high availability solutions wif Oracle 11g RAC and 12c RAC, Physical and Logical Standby database (Data Guard) and golden gate
• Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.
• Configuring and fixing teh Issues wif Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
• Installing and configuring new servers as per customer's request. Cloning teh Development, test and UAT environments wif production data as per customer's request.
• Design and implement disaster recovery for teh PostgreSQL Database. Configuring third client software pgadmin-III, phppgadmin to access teh database server. Configuring teh backup jobs on customer system. Experienced in performing PITR.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and data Ware-housing.
• Good Experience in implementing Exadata Smart Scan for query processing and data mining scoring to scalable intelligent storage servers.
• Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
• Experience wif Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
• TEMPEffective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
• Experience in Database capacity planning, monitoring object growth and Storage Management.
• Performed data migration from flat files into an Oracle database using SQL*Loader.
• Experience in performing Cloning and Refresh using RMAN and Datapump.
• Experience in Oracle Advanced Compression techniques.
• Experience in Online/Offline Re-Organization of database objects.
• Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
• Experience working wif database security tools TDE, DB Vault / VPD.
• Experience in applying CPU/PSU patches to various versions of databases wif minimum downtime.
• Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.
• Experience in handling very large databases (VLDB) ranging up to 100TB.
• Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.
• Experience in Shell Scripting for configuring monitoring alerts and automation.
• Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
• Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
• Experience in Upgrading databases, applying patches.
• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
• Proficient wif Database Cloning, Migration, and Patching of Oracle Databases.
• Installed Oracle 11g wif ASM and OCFS2 File systems.
• Extensive Experience wif RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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.

TECHNICAL SKILLS

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 2012:

RDBMS: Oracle 10g, 11g, 12c, PostgreSql 9.x - 10.x, microsoft sql server, 2012,2016 version:

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM:

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import:

PROFESSIONAL EXPERIENCE

Confidential - Cincinnati, OH

Oracle Database Administrator

Responsibilities:

• me has migrated from oracle to postgres using EDB Migration toolkit (MTK), AWS Data Migration service (DMS) and schema convention tools (SCT).
• Assist wif developer in designing teh Logical database structure through index creation and other relational database object.
• me Utilized pg dump, pg dumpall, pg basebackup and pgbackrest in performing logical and physical backups.
• Used postgres Vacuum and Vacuum full for maintenance activity.
• Used pg stat activity, pg top, and pg stat statement in performance monitoring.
• Configured postgresql streaming replication for load balancing and high availability.
• Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload
• Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Able to resolve teh performance issue in database 12c using full database caching and In-Memory Aggregation features
• Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Migration of data from SQL server to Oracle12C.
• Migration of data from Oracle 11g & 12c and to 18c for testing
• Installed, patched, and managed Oracle Database versions 12c on Oracle Enterprise Linux (OEL)
• Hand on experience in cloning teh non-multitenant container database to pluggable database in 12c using teh PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Supports Dataguard databases running on Physical standbys.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication .
• Experience wif RAC /EXADATA
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Efficiently performed installation, setup and creation of four node cluster RAC wif Oracle 11.2.0.3 database using GRID infrastructure wif ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining teh best Cluster architecture, choosing teh best hardware configuration for Oracle RAC.
• Setup/ Configuration/ Monitor / Support of PostgreSQL Powa and pact tools. PostgreSQL database (version 9.2.18 till 12.0) creation/configuration/ maintenance into local and AWS cloud storage following agency level policies, rules and security.
• Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud and GCP VM.
• Database migration from Oracle to PostgreSQL into AWS EC2 and GCP VM using AWS SCT, AWS DMS, Ora2Pg, orafce, ora migrator, oracle fdw, bash shell, Python scripts and Coding/ Converting Oracle shared procedures in PL/SQL to PostgreSQL PL/PgSQL
• Upgrading to PostgreSQL Version 10.2, setting related configuration parameters, migrating existing partitions wif Inheritance to Native Range/List partition tables and changing automation scripts as per new / changed features / Syntax of PostgreSQL version 10.2
• Created Table Level Logical replication in PostgreSQL version 10.2 using Publication and subscription at Primary/Secondary PG databases.
• Physical replication, WAL archive setup/monitoring of multiple PostgreSQL databases.
• Worked on Automatic Storage Management (ASM) wif EMC Storage for managing data in SAN.
• Installation, maintenance and tuning of 11g RAC databases including ASM and CRS.
• Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve teh performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Upgraded Oracle 11g database version to 12c version
• Provided database related services to their development & QA environments.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes wif ASM (automatic storage management).
• Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
• Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC
• Configured Offline and Online Disaster recovery sites to maximize teh database availability
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups wif ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Thorough noledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving teh security and functionality of teh databases.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential - New York, NY

Oracle / Postgresql Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 12.1.0.2, Oracle 11.2.0.5 databases on Windows and AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12g Grid Control
• me has migrated from oracle to postgres using EDB Migration toolkit (MTK), AWS Data Migration service (DMS) and schema convention tools (SCT). me create user and manage them using authentication, Authentication and audit wif postgresql.conf, pgpass and pg hba.conf files
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated teh processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2
• Managed and monitored database using command line as well as 11g, 12c and 13c OEM
• Applied CPU and PSU Patching
• Performed Database Tuning & Performance, Storage Management
• Installed and configured Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point
• Implemented Golden Gate 10g/11g replication. Monitored Golden Gate lag and extract
• Performed schema migration
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkpof, Explain plan.
• Involved in teh installation, configuration and extended support to Oracle 11g, 12ctwo Node RAC (Real Application Cluster) wif ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 12c RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely wif teh Oracle developers for teh better performance in Applications in writing teh Packages, Triggers and Indexes on teh tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning teh databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate teh data from 11.1.0.7 to 12c.
• Made optimal use of Oracle Support in resolving teh SRs.
• Use of Datapump, conventional export/import utility of Oracle 12c, 11g for re-organizing Databases/Schemas/Tables to improve teh performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 11g/12c environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented teh Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Install and Managed Physical Standby databases Data Guard for disaster recovery.
• Experience in Backup and Recovery techniques using RMAN.
• Integrated teh Backup Status Reporting for all teh databases in teh enterprise to enable teh web reporting using Oracle SQL, PLSQL
• Wif help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation