Database Administrator Oracle
Resume:
Tarun Kumar Vemuri – Database Administrator.
phone: 270-***-**** Mail: ********@*****.***
https://www.linkedin.com/in/tarun-vemuri-605396120/
Domain: Banking, Health Care and Private Sector.
9+ years of experience as an Oracle DBA (19c,18c,12c, and 11g), and PostgreSQL (9.6, 10.11, 12.1) in Production, Development and Test environments.
Expertise in Database replication techniques like Dataguard, Goldengate in oracle and Replication techniques in Postgres using streaming replication.
Deep knowledge of solving performance issues in Oracle hosted on Exadata, Linux machines and tuning Postgres databases.
Expertise in oracle database migration from 10g to 11g & 11g to 19c using RMAN full backup, Restore from Linux servers to X5 and X6.
Good Knowledge on Exadata specified features such as Smart Scan, Exadata Hybrid Columnar compression and Flash Cache.
Expertise in database upgrades from 11g to 19c, 12c to 19c for small to 500TB databases and also converting non-cdb to CDBs.
Expertise in Database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), SQL Tuning Advisor and manual SQL tuning.
Expertise in Installation of Oracle golden gate 12.2 with high availability using Oracle clusterware and ACFS file system in a four-node cluster.
Expertise in creating, configuring, administering, upgrading, and troubleshooting PostgreSQL clusters and implementing high availability solutions using PGPOOL and REPMGR; performing load balancing using PGBOUNCER; and optimizing PostgreSQL clusters using configuration parameters and SQL tuning.
Knowledge on Patching the Oracle databases to the latest Quarterly PSU’s and one-ff patches to adhere to the bank security standards by patching RDBMS as well as GRID on RAC, Non-RAC and Data Guard Environments.
Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
Experience in upgrading various versions of PostgreSQL database and migration of oracle database to postgres on-perm and Azure Flex postgres.
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Expertise in implementing Oracle Database Security utilities like Transparent Database Encryption using OKV and Data Masking Technologies.
Expertise in Database refresh using active Duplication, Restore, recovery through RMAN and Refreshing database to point in time by using Flashback parameter in Datapump.
Expertise in Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
Good Knowledge of enterprise manager by configuring alerts, monitoring Database health, Performance, Scheduled Jobs, Creating blackouts and Monitoring Disk i/o.
Expertise in using OEM for standalone and RAC database, configuring alerts through OEM, creating blackouts for bulk targets and monitoring performance using SQL monitor via OEM.
Experience with troubleshooting oracle goldengate error by looking at OGG errorlog file, report file and discard file.
Knowledge on Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE, Indexing, partitioning, and using SQL Profile and Baselines.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
Good Knowledge on building physical standby for production environment and maintaining without lag by performing incremental recovery.
Upgradation/Migration of databases from Oracle 9i/10g to Oracle 11g using RMAN backup, Datapump, transportable tablespace and migration of database from Solaris to Linux server by using Transportable database techniques.
Knowledge on object level tuning on databases hosted in Exadata machine and involved in patching Exadata machines, upgrading oracle database, Data center migration activities.
Good Knowledge of automating RMAN, Datapump, housekeeping jobs, configuring alerts using crontab and shell scripts.
Worked with Application DBAs for large number of tuning projects. Working with third party developers on SQL code review and quality control.
Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, and OEM Performance Manager.
Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
Expertise in installation, maintenance and configuring alerts for oracle and postgres database using Nagios and Grafana.
Expertise in implementing Database Wallets for Oracle TDE on software based and Oracle Key Vault for Exadata and Linux Systems.
Database replication using snapshots, materialized views and advanced replication methods and Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
Education Murray state University – Murray, KY. - 2013
MS in engineering and Technology Management
B. Tech in JNTU Kakinada - 2011
Technology Expertise
Database Technologies: Oracle Database 11g,12g,18c, 19c. Postgres 9.6, 10.x, 11.x, OEM, Golden Gate.
Physical Server Technologies: Exadata, Oracle Database Appliance, Linux servers 5-7
Virtualization Technologies: Oracle VM Server, VMware, Enterprise Manager.
Cloud Technologies: Microsoft Azure.
Security Technologies: Oracle Key Vault. TDE, Redaction, Masking.
Monitoring Tools: Oracle OEM, Pgadmin3/4.
Ticketing Tools: Service Now, JIRA.
CI/CD Tools: Atlassian bamboo.
Professional Experience:
UBS LLC. Apr 2020 – Till date.
Role: Database Consultant
Responsibilities:
Patch the Oracle databases to the latest Quarterly PSU’s to adhere to the bank security standards.
Patch the RDBMS as well as GRID on RAC, Non-RAC and DB standard environments.
Worked on migration of Oracle databases from Exadata to oracle standard stack. Helped in solving performance issues facing during and after migration of database.
Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.2, ASM and Oracle Cluster ware and Managed Exadata X-5 and X-6 servers.
Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, Golden Gate replication checks, OS checks.
Creating/Managing CDB / PDB and have done migrations from 11g to 12c.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
Setting up production databases, Testing with Switch-Over/Switch-Back before go-live and Participated in many DR activities.
Automated many common tasks using crontab including Backups, exports and imports, housekeeping old records.
Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
Worked on parallelizing oracle RMAN backup across all nodes in a cluster for making backup and restore process faster.
Worked on Defragmentation of tables and indexes for improved performance and efficiency and Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
State of Rhode California. (CALHEERS) Jan 2020 – Mar 2020.
Role: Database Consultant
Responsibilities:
Provided secure authentication to for app users to postgres cluster.
Worked on configuring backups for postgres database using pg_dump and pg_dumpall and configured replication using hot and cold standby.
Extensively worked on configuring backups on AWS S3 and pushing according to its retention policy.
Worked on AWS IAM for onboarding new users on oracle database hosted on EC2 instance and monitoring the metrics and alerts of database using amazon Cloud Watch
Participated in migration of oracle database to AWS using AWS migration service.
Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
Patch the Oracle databases to the latest Quarterly PSU’s to adhere to the Deutsche bank security standards.
Patch the RDBMS as well as GRID on RAC, Non-RAC and DB standard environments.
Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.2, ASM and Oracle Cluster ware and Managed Exadata X-5 and X-6 servers.
Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, GoldenGate replication checks, OS checks.
Creating/Managing CDB / PDB and have done migrations from 11g to 12c.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
Setting up production databases, Testing with Switch-Over/Switch-Back before go-live and Participated in many DR activities.
State of Rhode Island. (UHIPRI) Mar 2019 – Dec 2020
Role: Database Consultant
Responsibilities:
Performed POC testing’s on Upgraded Standalone/Clustered databases from 11g – 19c using DBCA, upgrading OEM 12.1.0.5 to 13.3.2.0
Worked on patching and in place upgrade of the oracle database 12c, 18c and 19c database using zero downtime patching.
Refreshing NON-PROD environments using RMAN, DATAPUMP backup tools Monitoring SQL Plan changes, Analyzing SQLHC and SQLT reports and implementing the best practices for plan stability using SQL Profiles and SQL plan baselines.
Diagnosis of AWR/ASH/ADDM reports and checking Instance activity, wait events and taking necessary actions to improve database performance.
Extensively used OS tools for Server performance stats like top, vmstat, iostat and sar commands for tuning the high resource consuming process.
Worked on performance related problems that usually occur after database upgrade and storage migration by comparing the plans using v$ views.
Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, storage replication checks, OS checks.
Worked on oracle TDE wallet setup, related issues that occur due to loss of wallet files, troubleshooting the encryption issues and making data available.
Performed Maintenance of Quarterly/Annual audit remediation activities for both Database & Application service accounts.
Managing, troubleshooting and resolving oracle database and application issues and Monitoring alert log/system log and managing Database Locks and blocking sessions.
Worked on parallelizing oracle RMAN backup across all nodes in a cluster for making backup and restore process faster.
Worked on Defragmentation of tables and indexes for improved performance and efficiency and Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
Worked on Scrambling the sensitive data using Data remap definition through datapump and worked on tuning datapump jobs.
Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
Schema / Table level and query based normal Export & Import and Data Pump Export & Import utility.
Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.
Worked on planning exadata activites and performing exadata patch on X5 and X3 environment.
Deutsche Bank AG, Jersey City, NJ Jun 2016 – Mar 2019
Role: Database Security consultant.
Responsibilities
Implemented Oracle security products on database using Transparent Database Encryption both table and tablespace level.
Worked on 11g, 12c and 18c database online encryption on standby and golden gate environments.
Installed, configured, and supporting Oracle GoldenGate 12 for Oracle to Oracle Data replication to AWS Cloud
Implemented Oracle Golden Gate 12x Bi-Directional (active-active) and configures DDL replication for Oracle databases.
Worked with third party Products like Vormetric for implementing TDE Wallets on Solaris Database.
Responsible for administrating and supporting Oracle databases running on all the Linux, Real application clusters (RAC), ASM platforms, DataGuards.
Worked on installing postgres database for small size applications and configured pg_pool, pg_admin III for all the databases in cluster. Provided secure authentication to for app users to postgres cluster.
Worked on configuring backups for postgres database using pg_dump and pg_dumpall and configured replication using hot and cold standby.
Extensively worked on configuring backups on AWS S3 and pushing according to its retention policy.
Worked on AWS IAM for onboarding new users on oracle database hosted on EC2 instance and Monitoring the metrics and alerts of database using amazon Cloud Watch
Participated in migration of oracle database to AWS using AWS migration service.
Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
Patch the Oracle databases to the latest Quarterly PSU’s to adhere to the Deutsche bank security standards.
Patch the RDBMS as well as GRID on RAC,Non-RAC and DB standard envirnonments.
Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.2, ASM and Oracle Cluster ware and Managed Exadata X-5 and X-6 servers.
Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, GoldenGate replication checks, OS checks.
Creating/Managing CDB / PDB and have done migrations from 11g to 12c.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
Setting up production databases, Testing with Switch-Over/Switch-Back before go-live and Participated in many DR activities.
Automated many common tasks using crontab including Backups, exports and imports, housekeeping old records.
Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and
Extensive experience on RMAN Active duplication, Datapump Scheme refresh and database refresh.
Export and Import of database objects to copy from one database to another database between different environments.
Troubleshooting errors and using the expdp/impdp utility on a very regular basis for copying data across schemas.
CITI GROUP – Tampa, FL Jan 2016 – Jun 2016
Role: Database Administrator.
Responsibilities:
Managed multiple production databases (8 TB to 17 TB) as well as development and QA databases 24x7
Performed performance tuning at database and statement level and finding bottleneck SQL statements to enhance speed and performance by using AWR, ADDM, SQL tuning advisor TKPROF, EXPLAIN PLAN and TOAD
Performed user and security administration of profiles, roles, users and their privileges
Supported all users on database, application issues and access control
Installed, configured and maintained Oracle 10g on Linux Red Hat 5
Cloned database from Production to Development, QA testing environments
Created materialized view (snapshot)
Installed, Upgraded, patched, and configured Oracle 10g,11g Oracle databases.
Implemented Rolling install oracle patch in Oracle RAC 11g to 12c & Upgrade database from 10g to 11g
Monitored database in GRID CONTROL, OEM and OS level
Implemented Unix shell scripting for monitoring database backups
Setup email to automatically send daily database monitoring information or alert.
Reviewed and approved project DDLs and deploy all DDLs on QA environment and production environment.
Reviewed and approved SQL for production database and directed utilization of RMAN for backup and recovery
Completed export and import of different databases using Oracle Export / Import utilities, data pump
Provided DBA support to development teams as well as production support to various applications
Collected table, schema, and database system statistics periodically and scheduling of collection jobs in OLTP database during off peak hours to limit system resources
Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement
Net Smart Technologies, INDIA May 2014 – Dec 2014
Role: System Administrator.
Responsibilities:
Installed, configured and maintained Oracle Databases 11g/10g/9i.
Provide support on DB service outage calls due to Infrastructure slowness or failures, which includes and not limited to IO slowness, Network slowness, Server resource bottleneck and perform end to end diagnostics and provide immediate fix following by RCA.
Monitoring SQL Plan changes, Analyzing SQLHC and SQLT reports and implementing the best practices for plan stability using SQL Profiles and SQL plan baselines.
Backup and recovery using RMAN, Datapump and Export/Import also Created and managing the database objects such as tables, indexes and views.
Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding of Indexes and running scripts given by the clients.
Granting roles and privileges to end users.
Managing, troubleshooting and resolving oracle database and application issues Monitoring alert log/system log and managing Database Locks and blocking sessions.
Automated many common tasks using crontab including Backups, exports and imports, housekeeping old records.
Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and
standalone instances.
Contact this candidate