Postgresql Dba Database

Konda Reddy PR

PostgreSQL DBA Email id: **********@*****.***

https://www.linkedin.com/in/konda-reddy-p-r-56a74738/ Dallas, TX, Mobile: +1-469-***-****

Summary of experience:

With around 14 years of DBA experience in PostgreSQL, MySQL, and Aurora across various operating systems, including Linux, Ubuntu, and Windows NT, I have extensive expertise in DBA activities such as installation, backup and recovery, high availability, performance tuning, and replication.

Additionally, I am having experience with Amazon cloud Services, including EC2, RDS, S3, IAM, Glacier, SNS, Security Groups, EBS, CloudWatch, and Cloud Formation. Also having good experience in timescale DB and Gen AI.

Key strengths:

10+ Yrs. Of experience in PostgreSQL Database Administration (Cloud, On-Prem), Database Developer and SDLC Cycle.

Extensive experience in heterogeneous (Oracle/SQL Server/Mysql.. to PostgreSQL) and homogeneous(PostgreSQL to PostgreSQL) database migrations.

Strong expertise in handling cloud database infrastructure (AWS, GCP & Azure).

Experienced in implementing best security standards across database infrastructure.

Hands-on experience with open-source databases and data warehouses (PostgreSQL, MySQL, Aurora, YugabyteDB, MongoDB, and Snowflake).

Worked on Row level security for implementing multitenant applications/users.

Designed and optimized database architectures for multiple applications, ensuring scalability, high availability, and performance across diverse use cases.

Implemented table inheritance and partitioning strategies in PostgreSQL to boost query performance, enhance data organization, and reduce maintenance overhead.

Configured Foreign Data Wrapper (FDW) and DB-LINK to seamlessly access and integrate cross-platform databases, facilitating efficient data exchange between different systems.

Developed custom automation scripts for user management controls in PostgreSQL, streamlining access control, permission management, and enforcing security policies.

Utilized OEM/PEM monitoring tools with Blue Medora plugin to monitor PostgreSQL database performance, providing deep visibility into key metrics and enabling proactive performance tuning.

Good exposure to the healthcare domain (Emergency Response System) and Banking & Financial domain.

Implemented build pipelines across AWS accounts to launch RDS instances based on customer requirements.

Analyzed authentication patterns for each RDS product (MySQL, PostgreSQL, Aurora) and implemented them in the infrastructure.

Responsible for installing, upgrading, and configuring PostgreSQL/MySQL Database clusters, including creating databases, storage structures, objects, and implementing backup and recovery strategies.

Extensive experience in query tuning and performance optimization for PostgreSQL/MySQL databases.

Experience in troubleshooting and enhancing existing stored procedures for efficiency and reliability.

Worked on high-profile projects with large databases and critical applications, including deployments for the Royal Government of Bhutan and the State of Maharashtra.

Customized PostgreSQL source code for password complexity.

Managed PostgreSQL databases in a containerized environment using Docker, enabling efficient deployment and scalability.

Knowledge & experience in AWS services - EC2, S3, IAM, Glacier, SNS, Security Groups, EBS, Cloud watch, RDS, Cloud Formation.

Implementing HA / DR strategies based on application requirements.

Designed and maintained AWS infrastructure highly available, scalable, secured, monitored and alerting network infrastructure

Proven experience assessing clients’ workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmap.

Having experience in handling huge volume MySQL servers with multiple instances.

Experience in different and day-to-day MYSQL DBA activities from MySQL 5.5 till the current version.

Having experience on multiple backup technologies using traditional mysqldump and other external tools like Percona xtrabackup.

Good at basic Linux administration like handling high Swap usage, High CPU utilization, disk space issues, DB directory file permissions issue etc.

Implemented rigorous security measures across all Operating Systems to protect valuable company data.

Applied exceptional problem-solving capabilities to design, implement, and manage secure database systems

Applied expert knowledge in database design to streamline database management processes, reducing data redundancy.

Managed and delivered weekly status reports to stakeholders to ensure efficient operation of the database systems

Leveraged Agile principles in managing complex database systems, ensuring timely updates and upgrades.

Expertise in developing applications using PHP.

Experience in developing with Google Maps and Map My India.

Technical Skills:

Operating Systems:

Linux, CentOS, Ubuntu, Amazon Linux and Windows

Programming Languages:

SQL, PL/pgSQL, PL/SQL, PL/JAVA, Shell, PHP, Ajax, JavaScript

Databases:

PostgreSQL, MySQL, AWS Aurora, Timescale DB and Gen AI

Cloud

Amazon, Azure

Tools:

Winscp, SVN Tortoise, GIT, Putty and Dockers

Utilities:

MySQL workbench, Pgadmin, DBeaver, Enterprise Monitor

Professional Experience:

1. Franklin Templeton (FT) - San Mateo, California. Duration: August 2022 to June 2024.

Role: Senior Database Administrator.

Oversaw daily operations of PostgreSQL, MySQL, and Aurora databases, managing installations, upgrades, and configurations, while implementing robust backup and recovery processes in both cloud and on-premises setups.

Responsible for doing POC for a newly introduced features, client requirements.

Developed and maintained high availability (HA) and disaster recovery (DR) strategies for database systems, ensuring resilience and uninterrupted operations.

Managed and resolved design issues during development stage. Interacting with developers closely.

Worked on Row level security for implementing multitenant applications/users.

Handling huge volume of data with different layers of DB as a Lead DBA.

Regularly optimized PostgreSQL, MySQL, and Aurora database performance, enhancing system efficiency and responsiveness.

Environment: Amazon/Azure Cloud, MySQL, PostgreSQL, Aurora, TimescaleDB, Gen AI, Linux, Windows, Jenkins, Shell.

2. GE Healthcare/Power/Renewables/Corporate - United States Duration: Mar 2016 – July 2022.

Role: Lead Consultant.

Managed the setup, upgrades, and performance tuning for PostgreSQL, MySQL, and Aurora databases, ensuring high efficiency and optimal data handling.

Implemented and managed robust backup and recovery protocols for critical PostgreSQL, MySQL, and Aurora systems.

Regularly optimized PostgreSQL, MySQL, and Aurora database performance, enhancing system efficiency and responsiveness.

Developed and maintained advanced reporting tools using PL/pgSQL and SQL for PostgreSQL, MySQL, and Aurora, facilitating strategic decision-making.

Collaborated with development teams to swiftly resolve design issues, improving application performance and functionality across all database platforms.

Designed effective database schemas for PostgreSQL, MySQL, and Aurora to streamline data storage and retrieval.

Ensured stringent security and user access controls within PostgreSQL, MySQL, and Aurora databases to maintain compliance and data integrity.

Established high availability and disaster recovery strategies for PostgreSQL, MySQL, and Aurora, ensuring continuous system operation.

Environment: Amazon/Azure Cloud, MySQL, PostgreSQL, Aurora, Time Scale DB, Gen AI, Linux, Windows, Jenkins, Shell.

3. Master card, USA/Vadodara. Duration: Aug 2015 – March 2016

Role: Database Administrator & Developer.

Led the installation, configuration, and upgrading of PostgreSQL/MySQL database environments, including database creation, object management, and performance tuning.

Implemented robust backup and recovery strategies for PostgreSQL and MySQL databases, ensuring data integrity and availability.

Conducted regular performance optimization and query tuning for PostgreSQL and MySQL databases to enhance system efficiency and response times.

Developed and maintained custom reports using PL/pgSQL and SQL to support data-driven decision-making processes.

Collaborated closely with development teams to resolve design issues during the development stage, enhancing application functionality and performance.

Managed database cloning using scripts to facilitate efficient environment replication and testing.

Designed and implemented database schemas, including tables, indexes, and views, to optimize data storage and retrieval in PostgreSQL and MySQL environments.

Managed user access and security for PostgreSQL and MySQL databases, ensuring compliance with best security practices.

Supported critical operations beyond regular business hours, providing 24x7 on-call production support to address urgent system needs.

Handled extensive database migrations, both heterogeneous and homogeneous, to ensure seamless data transfer and system integration.

Environment: PostgreSQL, MySQL, Android, IOS, Java Script, Mobile Technologies, SQL, PL/pgSQL, PL/JAVA, Shell, RHEL, Windows.

4. BVG-Pune/Falck India-New Delhi/DMC-Srilanka/HHC-Ministry of Health-Bhutan. Duration: Sep 2009 – July 2015

Role: Database Developer & PHP, GIS Developer

Designed and executed complex SQL queries to serve as a search engine, delivering tailored outputs based on user inputs.

Played a pivotal role in the Software Development Life Cycle (SDLC), with a focus on database-driven application development.

Managed and resolved design and development issues, collaborating closely with application developers to enhance system functionality.

Developed and generated custom reports using PL/pgSQL and SQL to meet specific business requirements.

Enhanced existing analytical software tools by introducing innovative features and capabilities.

Provided critical support outside of standard business hours, including 24x7 on-call production support, to meet business demands and ensure system reliability.

Designed and implemented database schema elements, including tables, indexes, and views to optimize data retrieval.

Maintained and upgraded corporate websites, focusing on form submission workflows and data validation processes.

Optimized server-side code and expanded the MVC model using PHP, improving system performance and scalability.

Developed and maintained a network traffic monitoring system to aid network administrators in traffic management and problem resolution.

Automated database cloning processes using scripting to enhance data redundancy and recovery strategies.

Managed database users and security objects, ensuring compliance with security policies and data integrity.

Innovated and added new functionalities to existing analytical tools, enhancing data analysis capabilities.

Environment: Swings, Spring-Core, ORM, Hibernate, JSF, Rihfaces, Struts, JMS, Java Script, WebServices (JAX-WS, RPC), Jasper Reports, PostgreSQL, Jboss.

Educational Qualification:

MCA from Sri Venkateswara University-2008, India.

Contact this candidate