* I work closely with customers to design solutions to migrate their data from traditional DBMS to the Aurora PostgreSQL Limitless Database.* I work closely with our customers to understand their challenges, solve issues during critical escalations, and teach best practices.* I, acting as the “voice of the customer”, bring learnings to the engineering process to design new features and plan end-to-end test scenarios. By shaping the direction of the Aurora Database service, I make it easier to understand how our service is used by customers, including database developers and administrators.* I will actively drive feature enhancements, permanently resolve the root causes of issues, and improve the performance of our managed database service.* I will contribute to automation solutions to improve the operational efficiency of the entire database service.* I am viewed as the ultimate subject matter expertise for all things databases as my work will be highly sought by the development team, the support team, the field teams, and customers directly.* I will interact with the open-source community via forums, conferences and feature or bug-fix code submissions.

AWS Professional Services help customers in designing their environments to move to cloud using AWS services available to fit for the design. Worked on multiple heterogeneous database migrations and lift-and-shift migrations. Earned trust and saved a lot of dollars for multiple customers by migrating their databases to Cloud using tools like SCT, DMS.

This comprehensive book serves as a guide to understanding the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. It provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, arrays and JSON to achieve desired outcomes, and transaction management.The unique approach to handling Triggers in PostgreSQL ensures both functionality and performance are maintained without compromise. Additionally, the book offers valuable knowledge on managing exceptions while writing code blocks. Readers will gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. The book also delves into statistical analysis of PL/PGSQL code. Furthermore, readers will explore the installation and configuration of extensions that cater to developers to enhance the performance of stored procedures and functions.What You Will Learn:• Understand the PL/PGSQL concepts• Learn to debug, profile, and optimize PL/PGSQL code• Study linting PL/PGSQL code • Transaction Management within PL/PGSQL code• Developer friendly features like operators, casts, and aggregatorsWho Is This Book ForApp developers, database migration consultants, and database administrators

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in PostgreSQL. Every system containing valuable data needs to be backed-up regularly. PostgreSQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner. What You Will Learn Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL Who This Book Is ForReaders with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment.

It is very challenging for people to understand the limitations on cloud and also plan for specifications that suit their needs. One more challenging part is the number of cloud vendors such as : Amazon, Rackspace, Azure, and Google Cloud. People may find it very difficult to choose the best vendor that can suit their requirement. Every Vendor is equally aggressive in pricing. Within each vendor, there are several 10's of Instance types that may confuse everyone. Most of the deployments on Cloud fail as there as lack of resources that helps people understand the limitations and the best practices. This lets people migrate to different instance types or a different cloud vendor.Hence, we plan to put together a detail on how to plan PostgreSQL on Cloud and here is the outcome of the work: Beginning PostgreSQL on Cloud.

Working for GE Digital as a Database Consultant.- Working on Automation, Orchestration, and DevOps in Pridix cloud environment.- Maintenance of PostgreSQL service instances in Predix.- Creating and Managing instances using Cloud Foundry.- Building monitoring of cloud instances using Grafana, Sensu, and Vistara.- Working with NoSQL DBs like Graphite and InfluxDB.

Performing the standard duties that any DBA would need to fill to effectively accomplish their job. This includes things like ensure database is available to the application(s), monitor any changes in log volumes, monitor historical CPU & Disk I/O, validate backup jobs, perform schema updates, validate per-table stats, query SLA, verify jobs, reporting, availability, Disaster Recovery, respond to alerts.

If you run a database, you want it to perform well and you want to be able to secure it. As the world’s most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database’s performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance.This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you’ll get familiarized with essential developer/administrator concepts such as load balancing, connection pooling, and distributing connections to multiple nodes. Next, you will explore memory optimization techniques before exploring the security controls offered by PostgreSQL. Then, you will move on to the essential database/server monitoring and replication strategies with PostgreSQL. Finally, you will learn about query processing algorithms.If you run a database, you want it to perform well and you want to be able to secure it. As the world’s most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database’s performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you’ll get familiarized with essential developer/administrator concepts such as load balancing, connection pooling, and distributing connections to multiple nodes. Next, you will explore memory optimization techniques before exploring the security controls offered by PostgreSQL. Then, you will move on to the essential database/server monitoring and replication strategies with PostgreSQL. Finally, you will learn about query processing algorithms.

PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it’s difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQLYou will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database.The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts

Working at Wipro for Pivotal as a GreenPlum DBA. .) Good experience in Installing, configuring GreenPlum DB using software-only software and DCA(Data Computing Appliance) installer. .) Implementing GreenPlum high availability using master/segment mirroring. .) Recovering failed segments and preparing RCA for the same. .) Troubleshooting performance issues of GreenPlum DB..) Compiling contrib modules against GreenPlum. .) Resolving catalog inconsistencies detected by gpcheckcat tool. .) Checking performance of network bandwidth, disk speed and stream using gpcheck/gpcheckperf utility. .) Backup of DB's using pg_dump(single thread), gp_dump and gpcrondump(multithread) utilities.

Currently I’m working at EnterpriseDB as an Expert DBA and serve as a postgresSQL Database Administration. Here I am working with PostgresSQL since 2012 and have developed a wide range of technical skills as PostgreSQL DBA and Developer. I have hands-on experience with real-world Production environments and have risen in the ranks from a developer to a managing DBA. I’m PostgreSQL Certified and experiencing managing UNIX- based PostgreSQL Databases and have also work with Cloud technologies.. I have worked as a consultant in production and development environments both for multinational companies across the world. I have a strong background of installing, upgrading, managing, troubleshooting and tuning PostgreSQL databases . I hold following certification credentials: PostgreSQL Certified Professional. Oracle Certified Associate.

This book is your practical guide to understanding the advanced techniques used to handle complex data and methods to solve issues that you might face while working with PostgreSQL. We will start with discussing the issues that arise at the time of setting up PostgreSQL. The next step will be to decide which data types will be most suitable to the task at hand and optimize performance using the right ones.We will understand how to deal with transaction locks, fuzzy matches, cursors, joins, and so on. Know the warning signs to look for, and how to avoid the most common issues before they even happen. In addition to that, specific high-level topics such as replication and Point-In-Time-Recovery will be discussed. The entire book is based on PostgreSQL 9.4 and contains up-to-date information.

Sr. Operations ProfessionalMy journey began with my engineering in Telecommunication. Professionaly I attached for a bit time with developing with C# and Java as well. After that was employeed with the one of the largest organization across the the era named IBM in the year 2011 as an Oracle DBA. As a working IT professional, I have experience in a wide range of mission critical technologies, specializing in database administration best practices for backup and recovery and another conceptual technologies.