Job Description:

Looking for pure Cloud RDS, PostgreSQL DBAs, who are deeply hands-on with AWS RDS and PostgreSQL with in-depth knowledge of Clustering, High Availability, Load Balancing, and Replication, Performance Tuning and Database

Representative Job Duties:

Performing all the activities for AWS Cloud Databases RDS & EC2 HostedDatabase maintenance activities on both Prod and Non-Prod Environment.Create SOP documents and building Knowledge management (KEDB) and other GXP related artifacts.Training and following for GXP Standards.Participate in Project related activities of coordination, joining calls etc.Build and manage HA/DR solutions as per Standards.Setting up Backup and recovery policies as per Standards.Core Database administration task.Setup and Management Cloud Database like PostgreSQL , Aurora, RDS/Database solutioning (Defining physical architecture / building DR / HA / OR solutions)Building Active/ Active or Active/ Passive database solutionWorking on key database features Clustering, High Availability SolutionsBuild, Install, Upgrades, Migrations and Patching activities.Managing database on Windows OSAutomation scripting skills (Linux, PowerShell, Python, Perl etc.)Responsible to independently setup RDS environmentResponsible to independently do infra. migration (Cloud to Cloud, In-Premise to Cloud)Responsible for independently provisioning cloud infra. using CLI and Cloud-formationResponsible to implement the solution in a framework that is more readily available and demonstrate ease of use.

Core / Must have Skills & Qualification:

AWS RDS Deep hands-on experience is a must.PostgreSQL database Administration, in-depth hands-on experience is a must.PostgreSQL running on AWS EC2 - database Administration in-depth hands-on experience is a must.Knowledge of Best practices when dealing with relational databases (PostgreSQL )Must be able to write SQL scripts and power shell scripts.Hands on experience with large size Databases running at Enterprise scale around troubleshooting, performance Tuning.Skilled at optimizing large, complicated SQL statements and stored procedures, functions, packages.Assist with common database procedures such as upgrade, patch, backup, recovery, migration, High Availability etc.Ensure performance, security, wallet, and availability of databases.Need to have strong experience in PostgreSQL HIGH Availability Solutions.Capable of configuring popular database engines and orchestrating clusters as necessaryDesign and develop PostgreSQL, Snowflake database systems including statements, data modelling, procedures

State Street's Speak Up Line