Recovery Manager Postgresql Dba

Location:

Celina, TX

Salary:

120000

Posted:

March 03, 2023

Contact this candidate

Resume:

MAHESH KUMAR KONDAPALLI 646-***-****

******.***@*****.***

PROFESSIONAL SUMMARY:

I am a highly motivated professional Oracle/SQL Server/PostgreSQL Database Administrator with 12+ years of extensive knowledge and proficiency. I have worked on On-prem and Cloud(AWS and Azure & OCI) platforms (LINUX, Solaris, UNIX, AIX and Windows) in production, development and testing environments. Proficient in database support, research, process automation, documentation, patching and upgrades, database performance tuning, High Availability, backup/recovery, data migration and database security. I am enthusiastic, go-getter and proactive team player who is fast at picking up new technology with great attention to detail.

#Technical Skills:

Operating Systems

AWS EC2,RDS,Azure VM,OCI, EXADATA,HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 3.x, 4.x,5.x Oracle Enterprise Linux OEL 5.x,6.x and 7.x and Windows 2003, XP,2007,2008,2012,2014

RDBMS

AWS RDS,Oracle 21c,19c/12c/11g/10g/9i, PostgreSQL 9,10 and 12 and 14,MSSQL 2012/2016/2017/2019

Languages

SQL, PL/SQL, UNIX Shell Scripting,

Tools

TDE,RMAN, OEM, SQL*Loader, Redgate, SQLsentry, EXP, IMP, expdp, impdp, TOAD, SQL Developer, DBArtisan, JIRA, Golden Gate, DBverify and Putty, Mirroring, Log shipping, Clustering, Replication, Always-On Availability Groups (AAG), Performance Tuning, Microsoft Visual Studio 2017/2008, SSMS,SSIS, SSRS, iReports, SSAS and T-SQL,Foglight,

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Tuning Advisor, SQL Profiler, Query Analyzer,

# Work Experience:

Client: Rijuven Corporation, Pittsburgh, PA

Employer: Infoyuga Technologies Dec 2022 to Till Date

Role: Sr. DBA Consultant with Oracle, PostgreSQL, and SQL Server

Responsibilities:

Oracle DBA Experience:

Installation, configuration, Maintenance and Support of Oracle 11g, 12c and 19c & 21c Databases as a part new Project implementation.

Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.

Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.

Implementing Oracle TDE Transparent Data Encryption in all our new/existing databases for Tablespace encryption.

Worked on online tablespace Encryption Rekey from AES 128 to 256 on existing databases.

Migrated all Non-Prod and PROD On-Prem environments to Microsoft Azure with Active standby and snap backup's.

Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.

Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and DataPump Export/Import and perform database Refresh and RMAN Cloning between 10g/11g and 12c environments.

Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.

Able to Be Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise-wide targets.

Migration of databases from non-ASM (filesystem also referred as Logical Volumes) to ASM i.e Automatic Storage Management.

Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Re-definition (with minimal impact to live system), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.

Pro-Active Monitoring of the Databases using 11g and 12c & 19c and 21c Enterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Capacity Planning and requesting the storage required by analyzing the database growth.

Customization and development of K- shell scripts required for monitoring space usage, backup jobs, stats gathering, Goldengate Process Monitoring etc.

Cloned and refreshed development and staging databases from production for development and testing.

Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation.

Providing the Go-live and Post –go live Support for the database performance related issues and ensure that all the work is documented for future reference.

Determine time estimates and schedule for own work and resolve issues in timely manner.

Providing assistance in activities such as knowledge sharing and knowledge transfer.

Migration of databases from non-ASM (filesystem also referred as Logical Volumes) to ASM i.e Automatic Storage Management.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements.

Database performance, availability, handle performance tuning, conducting backups and ensure integrity and security in the database.

Supporting databases for production, development, test, and staging purposes on, Linux/Unix, Windows, AIX environments.

Implemented table partitioning, Rebuilding Indexes, tuning SQL using SQL Trace, TKPROF, Explain Plan, ASM,AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader

Implemented Data guard, creating both logical and physical standby databases in 12c for production database, Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.

Diagnosis and repair of Physical and Logical Block Corruptions. Implemented Flashback technology of the Oracle 21c,19c,12c, 11g, 10g.

SQL Server DBA Experience:

Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005, 2008, 2008R2, 2012 and 2014 in development, production, testing, environments.

Create databases and schedule backups (Transaction log backup, Differential backup and Full back up) with Recovery sessions (Simple or Full).

Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard.

Created maintenance plan for regular scheduled Transaction log backup, Full backup (Separately in remote server), Check database, reorganize index, Rebuild Index, Update Statistics and Cleanup task.

Setup Alerts, Notifications, Jobs, Job steps with automated Response solution schedules.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Performed Migration of data from SQL Server 2005 to SQL Server 2008 Edition.

Periodically monitored performance using both System Monitor and SQL Profiler Trace.

Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables, SQL Profiler and Enterprise Manager/Management Studio, and Server monitoring and capacity planning to ensure adequate CPU, disk space, and memory on all SQL servers.

Provided 24 X 7 dedicated support to all Production Environments

Experienced in planning and implementing multiple database migrations (side by side, in place) from older Versions to Latest Version as part of Database Upgrade and Data center Migrations.

Experienced in configuring, troubleshooting, implementing efficient Disaster Recovery Strategies, High availability include Always On High Availability between the data centers with multiple replicas, Replication, Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring (Sync and Async).

PostgreSQL DBA Experience:

Installed and configured PostgreSQL 9.5, 9.6 and 10,12 and recently worked with PostgreSQL version 14

Supporting production, development, test and staging on linux/unix platforms and managing over 400+ PostgreSQL databases with sizes ranging from 400 MB to 1TB

Managed and Monitored PostgreSQL databases using PGAdmin, psql and sql developer.

Migrated databases from Oracle to PostgreSQL by using Ora2Pg and sitebuild tools.

SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY

Creating users and roles, granting privileges, creating tables, use of indexes, and primary & foreign key constraints as required.

Assisted in production support based on a ticketing system.

Implemented a maintenance plan for the database system.

Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.

Use PgBouncer for connection pooling, pgBadger for generating statistic reports.

Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cron jobs.

Hands on experience on restoration techniques on PostgreSQL like pg_restore and (PITR) Point in Time Recovery.

Performed backups (pg_base backup and pg_dump,) and restore, compressed (gzip) backups.

Upgrading database version (pg_dump/pg_restore and pg_upgrade).

Assisted in production support based on a ticketing system and, also teaming up to defining and implementing maintenance plan for the database system.

Environment: LINUX, IBM-AIX, Windows 64-Bit, Oracle 10G, 11G and 12c,19c,21c OEM 13c, UNIX, SQL, Oracle Auditing, Oracle Partitioning, GoldenGate versions 11g, 12c, 18c & 19c, DMS (Data Migration Service), Physical Standby (Active Dataguard, normal standby), LogMiner, Oracle 12c,11gR2 RAC and Standalone, Toad, Data-Pump, OEM, RMAN, Azure (AWS),, Explain Plan, Automatic SQL Tuning, Shell Scripting, MSSQL 2008R2,2012 and 2016, PostgreSQL 9.x,10.x and 12.x, Ora2Pg, Aurora, AWS, EC2 & RDS, Nagios, T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, Erwin, SQL Profiler, MS Excel 2003, Visual Studio 2008-2005

Client: Harvard Pilgrim Health Care, Boston MA

Employer: NTTDATA Mar-2021 to Dec 2022

Role: Oracle Database Advisor

Responsibilities:

24x7 Oracle Production Database Administration including Oracle 10g/11g/12c/19c RAC over 500+ databases.

Installation, Configuration, Designing and Maintaining of Oracle 11g (11.2.0.3, 11.2.0.4) and 12c,19c databases on AIX, RHEL 5 and 6,7 Versions.

Upgrade/Migration of Databases from Oracle 8i to 12c, 1.2.0.3 to 11.2.0.4 and 11.2.0.3 to 12c (12.1.0.1)

Responsible for setting up and maintaining the user accounts and providing required privileges for database access.

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.

Refresh the test and development databases from the source production databases on a regular basis using export/import utility

Successfully maintained multiple databases. Implemented Grid Control for managing databases.

Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.

Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch.

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.

Involved in capacity planning and resource planning.

Installed and configured OEM Grid Control, deployed agents registering and monitoring databases, configuring the alerts by installing the agents on clients.

Restore and recover successfully production databases in RAC and ASM environment using RMAN. Successfully convert oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.

Plan and perform recovery for Disaster Recovery Drill.

Managing health check and potential fix using orachk, Crsctl and Srvctl in clusters.

Implementation of High Availability solutions with Oracle 12cg RAC, Physical and Active Standby Databases (Data Guard)

Cloned/Duplicated databases using RMAN backups whenever required by business.

Manage Offshore and Onsite DBA Services including management of client work activities, understanding overall client and business deliverables.

Prepare and Review Process documents for process improvements including ensure compliance with all laid down processes and procedures by all team members.

Involved the database Capacity Planning for the future business growth requirement and suggest the input value to customer.

Configured Data Guard (Physical Standby database) for the production database and tested for Switchover, Failover, Activating the Standby to Primary Database.

Monitoring of cluster resources on RAC environment with cluster server manager.

Participation in Change review board meetings and coordinating with application support team and execution of change requests as per schedules.

Documentation and maintain database, Fix the issues and provide root cause analysis.

PostgreSQL DBA Experience

Installed and configured PostgreSQL 9.5, 9.6 and 10.

Installing and Configuring PostgreSQL from source or packages on Linux machines.

Managed and Monitored PostgreSQL databases using PGAdmin, psql and sql developer.

SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY

Creating users and roles, granting privileges.