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

advost@r.postjobfree.com

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.

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

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

Environment: ORACLE 19c,12c, 11g, Oracle 11g/12c RAC, ORACLE 10g, ASM, Oracle Solaris 10, AIX 5.x,6.x, Windows, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Shell Scripting, PostgreSQL 9.x,10.x and 12.x, Ora2Pg, Aurora, AWS, EC2 & RDS, Nagios, MSSQL 2005, 2008,2008R2,2012 and 2014, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), T-SQL, SQL Profiler.

Client: Harvard Pilgrim Health Care, Boston MA

Employer: NTTDATA / Inventech InfoSolutions Jun-2018 to Mar-2021

Title: Technical Lead

Responsibilities:

Manage and support 500+ Oracle/My Sql Server databases.

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

Installation of Oracle binaries and Upgradation of Oracle databases from 11gR1 to 11gR2.

Troubleshooting RAC startups, crashes, node evictions, reboots, corruptions, failover & failback of VIP.

Synchronizing Standby databases with Production databases.

Monitor, analyze, tune and otherwise maintain Peoplesoft system performance.

Worked on Data Mover tool to export/import data between Peoplesoft environments.

Established client workstations for the developers to connect with new Peoplesoft Instance.

Scripted and implemented new PeopleSoft database cloning procedures for Test and Development environments.

Implemented DR TESTING exercises/snapshot standby feature for client requirement to maintain high availability for 10g/11g using restore points.

Golden Gate setup to achieve Unidirectional replication.

Setup Golden Gate Database User with necessary privileges

Planning and implementing Backup strategy for the databases using RMAN, Scripting backup.

Database clone from PROD/DR to DEV/QA/TEST servers using RMAN (backup/restore and Duplicate/Active Duplicate).

Extensive experience in Data Center Configuration and Migration from Linux to AIX.

Migrating single instance database to RAC environment using reconfig utility.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Applied CPU, PSU (+OJVM) patches and regular bug patches with Opatch utility as per the business requirement.

Identifying fragmented tables and re-organizing tables and rebuilding indexes.

Performed Data Centre Migrations from Linux to AIX.

Performance tuning Using TKPROF, EXPLAIN PLAN, Automatic SQL Tuning, AWR and ADDM reports for the better performance.

Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose.

Provide support to Development Team with their SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.

Environment: ORACLE 10g/11g,12c,19c Oracle 11g RAC, ASM, Oracle Solaris 10,11 Linux 5.x,6.x,7 Windows, Golden Gate, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, People Tools 8.51 / 8.53, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Shell Scripting, MSSQL 2000, 2005, 2008 and 2008R2

Client: Client: Harvard Pilgrim Health Care, Boston MA

Employer: NTTDATA / Antel Infotech Jun-2018 to Jun-2019

Role: Technical Lead

Responsibilities:

Working 24*7 along with DBA team to maintain & support more than 3000 Oracle Database in Production (RAC & NON RAAC), Test and Development Environment.

Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 9i, 10g, 11g.

Generating Reports, Monitor Disk Usage and up-keep of the systems for the continuous production environment.

Created several databases manually and by using DBCA tool for supporting Production/QA/Test and Development environments.

Tuning of the SQL Queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.

Maintenance of the DR sites, monitoring for archive log gap. Recreate the standby database if needed.

Monitoring and checking the RMAN hot backup and Logical backup (Datapump, Export /Import), both scheduled in cron job.

Installation & configuration of ORACLE Database Vault.

Creating the partitioned table using Range, hash, list partitioning.

Installation of RAC and Managing RAC Environment efficiently.

Working on database application and performance tuning.

Monitor, analyze, tune and otherwise maintain Peoplesoft system performance.

Worked on Data Mover tool to export/import data between Peoplesoft environments.

Established client workstations for the developers to connect with new Peoplesoft Instance.

Scripted and implemented new PeopleSoft database cloning procedures for Test and Development environments.

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Scheduling database backup jobs from OEM, monitoring and troubleshooting the failed backup jobs and cronjobs.

Implementing and maintaining database security (create and maintain users, roles and assign privileges), Oracle Configuration Management Pack.

Troubleshooting database problems faced by the application developers/users.

Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Perform day-to-day operations like troubleshooting client connectivity, user/application errors, monitoring database growth, review of alert, listener, alert log on time base for ORA errors and other logs, monitoring scheduled jobs that include statistics gathering, backups, snapshot refreshes etc.

Creating technical documentation and imparting knowledge sharing within the team.

Environment: Oracle 12c/11g/10g/9i Oracle 10g RAC on LINUX Platforms RHEL 7,6, 5.x, Sun Solaris, Oracle Partitioning, RMAN, Data-Pump, RMAN, Golden Gate, OEM, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning.

Client: Dupont, Wilmington DE

Employer: IBM Jan-2013 to Apr-2018

Title: SME (Oracle DBA)

Responsibilities:

Supported over 200 databases and over 75 Production databases which includes RAC databases.

Supported various Oracle Database for various applications viz., SAP, PeopleSoft, JD Edwards, and other in-house application and various other Data Warehouse Applications at NBC Universal.

Applied Security Patches for DEV, QA, TEST and PROD.

Performed Cloning and database refreshes as and when requested by users.

Having good knowledge in UNIX shell scripting to prepare Database monitoring scripts and scheduling backups at scheduled intervals and various other jobs.

Back-up of database using Logical (Export and Import), Physical (Hot and cold) Backups and RMAN.

Performed performance tuning from time to time.

Creating the partitioned table using Range, hash, list partitioning.

Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose

Monitored the production Oracle alert logs for database errors.

Implemented and maintained database securities (create and maintain users, roles and assign privileges).

Performed “trouble shooting” of the problems faced by Application Developers and End Users.

Coordinate and Monitored Application Outage Activities.

Created technical documentation and KT with the team.

Raised Service Requests through TAR and coordinated with Oracle Corporation as and when required.

Environment: Oracle 9i, 10g/11g with RAC, Oracle Data Guard, HP-UX 11i v3, Sun Solaris, RHEL 6.x, TOAD, RMAN, Control-M, Autosys, DBArtisan, Aqua studio, DBA Pool-Analyzer, TKProf, Explain Plan.

Client: Citi Bank, Kulalumpur Malaysia

Employer: Optimum Info Solutions Jun-2011 to Dec-2012

Role: Senior Oracle Database Administrator

Responsibilities:

Managed and executed database change requests.

Handled database Refresh from production to development and support databases.

Performed Data transfer using Oracle transportable table space feature.

Involved in DBCC requests handling, batch job monitoring, database health checking, ensuring the database availability and monitoring the database.

Created the users with necessary privileges, roles, profiles and space quota.

Worked on Table space creation and maintenance support such as adding data files to the production, development and support and test databases.

Maintained redo log and archived log files.

Involved in index creation and rebuilding to improve the query performance.

Resolved row chaining and migration.

Handled Application-level tuning (TKPROF/Explain Plan/SQL Trace).

Monitored the CPU usage and IO statistics to identify any OS level Performance killers.

Involved in Space management on temp, data and index table spaces in all the production, support, development and test instances.

Handled Database change request from the application developers as when required.

Monitored and scheduled jobs.

Performed Troubleshooting of database problems faced by the application developers/users.

Environment: Linux and Oracle 11g/10g/ 9i/8.x/7.x

Client: Navistar, Lisle, IL

Employer: IBM / Magna Infotech Apr-2010 to May2011

Role: Oracle DBA

Responsibilities:

Created users and gave specific roles and privileges.

Monitored the database performance.

Designed Table spaces/Tables/Indexes.

Monitored the database growth and increased the table space size.

Performed logical backup (exports and imports).

Collected statistics and analyzed the trend of database.

Checking alert logs and user logs.

Installing Oracle clients on user machines.

Created and maintained database objects.

Environment: Linux, Oracle 11g/10g/ 9i/8.x/7.x

#Certifications:

Microsoft Certified: Azure Fundamentals

Oracle Cloud Infrastructure Foundations 2020 Associate

Oracle 12c Certified Professional

Oracle 10g Certified Professional

#Educational Background

Bachelor of Commerce in Computer, Kakatiya University, Telangana, INDIA

Contact this candidate