Venkat Magam

Senior Oracle, MS SQL, PostgreSQL DBA AWS DB Specialist

+1-732-***-**** LinkedIn adx9gu@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Overall 16+ years of IT experience as Oracle/SQL/Postgres DBA, providing 24/7 on call support at L4 level for both production and Non-prod databases on Various Platforms like Sun Solaris, Red hat Linux, HP-UX, AIX, and Windows.

•Experience in OLTP/DW database systems on oracle 11g,12c,18c,19c, managing large and highly available Oracle databases up to 10TB in size for various projects supporting Peoplesoft, CRM, SAP, and voice portal applications.

•Good working experience on improving query performance of PeopleSoft applications.

•Experienced in implementing row level security and TDE in oracle databases.

•Experienced in Database upgrades from 12c to 19c version with minimal down time and post upgrade support to improve performance on 19c version.

•Expert skill in implementing advanced features of oracle 19c and good knowledge on SAP Hana.

•Migration Expert in Database migrations for Oracle from physical machines to AWS cloud (RDS).

•Good working knowledge of managing snowflake databases.

•Golden Gate expert for replication implementations across oracle to oracle and oracle to other platforms like Postgres.

•Performed database, Schema Refresh and Table Refresh on PostgreSQL database.

•Implemented Goldengate unidirectional and bi-directional (ACTIVE-ACTIVE) replications for mission critical business applications.

•Good experience in resolving conflict in Golden Gate active-active setups.

•Experienced in managing Oracle Golden gate 19c, 21.3 and 21.6.

•Configured Uni-directional replications using Goldengate 21.3, 21.6 for Oracle 19 database schemas and tables.

•Identified and fixed out of sync issues between primary and standby databases that are setup with ACTIVE-DATAGARUD.

•Skilled in implementation of SQL Server 2012/2014/2016/2017/2019 new features.

•Experienced working with multiple versions of SQL Server, performance tuning, data mirroring, replication, back up, warehousing and all other related administrative and transactional issues.

•Good working knowledge of managing oracle DB’s on Exadata and PCA X9-2 machines.

•Good working experience with Ansible playbooks and automation.

•Expert level skill in identifying and resolving Golden Gate replication issues using LOGDUMP, GGSEVT utilities for both unidirectional and bidirectional replications.

•Expert level skills in identifying Goldengate performance related issues and fixes.

•Expert skills in migrating and managing Oracle Databases on AWS cloud infrastructure.

•Expert in Database upgrades from 11g and 12c to 19c and have performed upgrades for over 200 + instances in recent years.

•RMAN backup configuration expert and also experienced in recovering databases using RMAN whenever required.

•Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

•Experience in using 12c and 13c OEM, TOAD, and Data Migrations using Export/Import, RMAN.

•Excellent experience in identifying and resolving Node evictions on Oracle 11g,12c,18c RAC production systems on VBLOCK machines and Engineered systems.

•Excellent working knowledge of managing ORACLE RAC using CRSCTL, SRVCTL, ASMCMD.

•Strong working experience in applying patches to databases and storage layers on Exadata.

•Migrated several databases from Physical machines to Exadata X6, X7 machines using Data pump and Physical data guard methodologies.

•Performance Tuning expert for identifying and troubleshooting P1 issues on mission critical databases.

•Experienced in working and coordinating with internal and external auditors for SOX audits.

•Excellent working knowledge in handling SMART SCANS, Flash cache and Hybrid columnar compression in EXADATA machines.

•Excellent knowledge and experience in installing and configuring Oracle 12c and OEM 13c cloud control.

•Good working knowledge of PostgreSQL 9, 10,11 and 12 versions on Linux platforms.

•Experienced in configuring Monitoring templates, Metrics and policy setting using 12c OEM and Oracle Enterprise Manager Cloud Control 13c Release 2.

•Excellent experience in recovering databases and tablespaces using RMAN recovery strategies during storage corruptions and outages.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c /19c, EC2, RDS, RDBMS, SQL Server 2012 – 2019 and PostgreSQL 9.6,10,11,12

Programming Lang’s: SQL, PL/SQL

Scripting Tools: PowerShell, JavaScript, Shell Scripting

Operating Systems: Red Hat Linux, Unix, Solaris, and Windows 2003 -2022

Cloud Technologies: AWS, Snowflake

Software Methodologies: Agile Methodology, Waterfall Methodology

Tools: AWS - SCT, KMS, DMS, IAM, MMIS, RMAN, OEM, Oracle Management

Service (OMS), SQL*Loader, ASM, SRVCTL, CRSCTL, Export/Import,

TOAD, Patch Management, ODBC, DBUA, DBCA, putty, Golden32,

ImpExp32, Grid Control, Data pump, Data guard, VERITAS Net Backup.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, SQLT, SQL

TUNING ADVISOR

Office & Other Tools: MS Word, SharePoint, Excel, Golden gate, PowerPoint, Service-Now

CERTIFICATIONS:

•ORACLE CERTIFIED DBA PROFESSIONAL (ID - OC2485039)

•AWS Database Specialty Certificated (R8H8X9E14BR410SM, 04/2023 – 04/2026)

EDUCATION:

•Master of Computer Application (M.C.A.) from Periyar University in 2003, India.

•Bachelors in computer science (B. Sc.) from Nagarjuna University in 2000, India.

PROFESSIONAL EXPERIENCE:

Client: PEPTALK Health, NY Apr’2023 – Current

Role: Sr. Database Administrator

Project Title: PEPTALK Health

Description: The PEPTALK Health platform of services is customizable to meet the individual needs of providers and patients. Will work with you to identify the services that meet the unique needs of your patient population so you can provide cost effective care to optimize their sense of well-being. Continue reading for further information about our services. PEPTALK healthcare to providers patients. Our reliable, affordable, and efficient services help patients and health providers stay connected seamlessly through Remote Patient Monitoring, Telemedicine, Text Messaging, Educational videos, and Electronic form completion.

Responsibilities:

•Performed database, Schema Refresh and Table Refresh on PostgreSQL database.

•Designed, developed, and maintained PostgreSQL database architecture.

•Prepared and updated scripts for various administrative tasks.

•Performance tuning and recommendations for existing database deployments.

•Evaluated database performance and executed table maintenance processes.

•Developed scripts for database monitoring and tuning procedures.

•Maintained and optimized database application performance through tuning.

•Implement solutions for backup and restore.

•Implement management/monitoring and perform upgrades and patching.

•Managing Logins, users, Roles, and User permissions on PostgreSQL database.

•Implemented migration tasks from PostgreSQL databases to AWS Cloud (RDS).

•Implement replication, High Availability, and disaster recovery solutions with Postgres.

•Worked on Configuring and installation of Data Guard Broker on AWS Servers.

•Performed DR drill – Role transition from primary to standby and from standby to primary.

•Configured OEM and installed Oracle binaries/ created the new database for database monitoring and performance.

•Converted snapshot standby database to physical standby database for application testing.

•Schemas refresh using Traditional Export and Data pump utility.

•Skilled in implementation of SQL Server 2017-2019 new features.

•Performed Database refresh by using RMAN to check the validate for application testing on test and development server.

•Resolved many outages of oracle 12c and 19c RAC databases caused due to Node evictions resulting from voting disk and OCR file corruptions and ASM related issues.

•Configured and managed ASM instances on both 12c and 19c RAC clusters using ASMCA, ASMCMD and various sql commands.

•Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

•Experience in implementing SQL Server Databases in Azure Environment (SaaS, PaaS, IaaS).

•Ensured security logins and database access permissions.

Tools & Technologies: PostgreSQL 9.6,10,11,12, Linux, Windows, AWS-RDS, Oracle 12c and 19c - Oracle Enterprise Linux Servers, SQL Server 2012-2019, RAC, RMAN, Data pump, Data Guard, Grid Control, AWR, EXPLAIN PLAN.

Employer: HCL Technologies Ltd March’2019 – April’2023

Role: CONSULTANT Oracle DBA

Client: Sempra Energy, CA

Project Title: Sempra Energy

Description: Sempra is an energy infrastructure company focused on connecting millions through the power of people, ideas, and innovation. Our 20,000+ employees pride themselves on being part of a leader in the energy industry, serving nearly 40 million consumers worldwide. From our San Diego, CA headquarters to our operations in key markets in North America, we are making great strides in developing forward-thinking energy solutions and positively impacting the communities we serve by delivering energy with purpose. The Sempra companies are on a collective mission to build North America’s premier energy infrastructure company. Every day, our teams innovate, collaborate, and adapt in order to deliver energy with purpose to nearly 40 million consumers who rely on us for energy.

Responsibilities:

•Providing regular DBA support for the database servers of Oracle and SQL Server.

•Administration and monitoring of Real Application Cluster (RAC) 19c, 12cR2 and 11gR2 environment for cluster health check.

•Performed Database refresh by using RMAN to check the validate for application testing on test and development server.

•Hands on experience in AWS Database and migration from on premises to AWS cloud service platform.

•Refreshed schema and table by using Expdp/Impdp.

•Deployed the scripts on production database when request raised by Application team.

•Involved for snapshot refresh with storage team to make the data consistency.

•Built the data guard standby database configuration and make sure the standby database is sync for disaster recovery.

•Performed database, Schema Refresh and Table Refresh on PostgreSQL database.

•Killing blocking and long running queries as confirmed by apps team on PostgreSQL database.

•Managing Logins, users, Roles, and User permissions on PostgreSQL database.

•Appling patches on PostgreSQL database.

•Worked on AWS DMS for Migrating Oracle databases.

•Skilled in implementation of SQL Server 2012/2014/2016/2017/2019 new features.

•Worked on Configuring and installation of Data Guard Broker on AWS Servers.

•Performed DR drill – Role transition from primary to standby and from standby to primary.

•Converted snapshot standby database to physical standby database for application testing.

•Performed incremental SCN backup / Service method to bring sync with primary if gap there.

•Configured OEM and installed Oracle binaries/ created the new database for database monitoring and performance.

•Developing and testing stored procedures, SSIS packages, triggers, queries, and scripts.

•Analyzed and Tuning for performance tuning and given the solution or recommended to the application team if end user reporting the slowness issues.

•Compressed and decompressed the table/index/partition/sub-partition.

•Created Partition table if table having huge data load and maintain number of year data.

•Upgraded database from 11g to 12c /19c using manual/ DBUA method.

•Using Flashback database for rollback plan/blackout plan for testing and downgrade database.

•Restored and resolved the OCR corruption and Voting disk issue when cluster failed.

•Supporting scheduled patching activities with Unix team and relocated the services for database availabilities for application access.

•Resolved many outages of oracle 12c and 19c RAC databases caused due to Node evictions resulting from voting disk and OCR file corruptions and ASM related issues.

•Configured oracle wallets for SOX compliant databases to enhance security.

•Migrating oracle database from Linux server to VX block server and Transportable table space method.

Tools & Technologies: Oracle 11g/12c and 19c - Oracle Enterprise Linux Servers, SQL Server 2012-2019 and AWS, RAC, ASM, OEM, PostgreSQL, Oracle Management Service (OMS), RMAN, Data pump, Data Guard, Grid Control, AWR, EXPLAIN PLAN.

Employer: Wipro Technology Services Nov’2007 – March’2019

Role: Lead Database Administrator

Client: Citibank, USA

Client: DirecTV (LA, California)

Client: EA Sports (Electronic Arts), Redwood City, CA

Description: Electronic Arts, Inc. (EA), also known as EA Games, Electronic Arts Inc. (EA) is an American video game company headquartered in Redwood City, California. Currently, EA develops and publishes games under several labels including EA Sports titles FIFA, Madden NFL, NHL, NCAA Football, NBA Live, and SSX. Other EA labels produce established franchises such as Battlefield, Need for Speed, The Sims, Medal of Honor, Command & Conquer, as well as newer franchises such as Crysis, Dead Space, Mass Effect, Dragon Age, Army of Two, Titanfall and Star Wars: Knights of the Old Republic, produced in partnership with Lucas Arts. EA also owns and operates major gaming studios, EA Tiburon in Orlando, EA Canada in Burnaby, BioWare in Edmonton as well as Montreal, and DICE in Sweden.

Responsibilities:

•Configured 10G Physical Standby database for Disaster Recovery.

•Checking MRP process to apply the redo data into standby database.

•Analyzing the SQL Query using Explain plan and TKprof.

•Managed SQL Server databases of versions from 2012 – 2019.

•Experienced working with Database Creation, Upgradation, Migration, Replication and Recovery activities for day-to-day high volume of live transactional data from Platform Online users.

•Schemas refresh using Traditional Export and Data pump utility.

•Performing Backup and recovery, creating catalog mode and registering the database using RMAN

•Worked on User account issues like lock, Password expiration etc.

•Check Alert Log errors and take necessary actions to rectify them.

•Maintenance of production database which includes tablespace management, user creation.

•Maintaining archive data on appropriate storage devices.

•Space management: Creating tablespaces and resizing the data files.

•Releasing Locks and Killing blocking sessions.

•Goldengate expert for replication implementations across oracle to oracle and oracle to other platforms like Postgres.

•Implemented Goldengate unidirectional and bi-directional (ACTIVE-ACTIVE) replications for mission critical business applications.

•Good experience in resolving conflict in Golden Gate active-active setups.

•Experienced in managing Oracle Goldengate 19c, 21.3 and 21.6.

•Configured Uni-directional replications using Goldengate 21.3, 21.6 for Oracle 19 database schemas and tables.

•Good working knowledge of managing oracle DB’s on Exadata and PCA X9-2 machines.

•Excellent working knowledge in handling SMART SCANS, Flash cache and Hybrid columnar compression in Exadata machines.

•Migrated several databases from Physical machines to Exadata X6, X7 machines using Data pump and Physical data guard methodologies.

•Migrated standalone databases to Exadata machine using Data pump.

•Strong working experience in applying patches to databases and storage layers on Exadata machines.

•Expert level skill in identifying and resolving Goldengate replication issues using LOGDUMP, GGSEVT utilities for both unidirectional and bidirectional replications.

•Expert level skills in identifying Goldengate performance related issues and fixes.

•To manage control file multiplexing and to trace the control file.

•Creating and managing pfile & spfile.

Tools & Technologies: Oracle 9i/10g,11g and 12c,19c - Oracle Enterprise Linux Servers, Data pump, Snowflake, ASM, RMAN, OEM, Oracle Management Service (OMS), SQL Server 2005 – 2019, Goldengate and Windows.

Contact this candidate