Senior Cloud Database Engineer (PostgreSQL)

Saransh Inc; Reading (Berks County); On-site; USD 120,000 - 150,000; Full time

Job summary

A data solutions company seeks a skilled data engineer to design and implement enterprise data platforms. The ideal candidate will have extensive experience with various database technologies and cloud databases, especially AWS and Azure. Responsibilities include supporting application modernization, collaborating with cross-functional teams, and driving architectural improvements. A Bachelor's degree in IT or a related field is required, along with strong skills in SQL and other database technologies.

Qualifications

• 10+ years of progressive experience in database technologies.
• 5+ years of extensive experience with various database technologies.
• Strong command of SQL, PowerShell, and Unix shell scripting.

Responsibilities

• Support application modernization and lead database migrations to cloud environments.
• Collaborate with product owners and enterprise architects.
• Design and implement automated infrastructure provisioning using IaC tools.

Skills

PostgreSQL

Redis/Memory DB

DynamoDB

Aurora/RDS

MySQL

Snowflake

MongoDB

SQL

PowerShell

Unix shell scripting

Python

JSON

TOAD

SQL Developer

PGADMIN

DPA

snowsql

MongoDB compass

Education

Bachelor’s degree in IT or a related field

Tools

Terraform

Ansible

CloudFormation

Prometheus

Grafana

CloudWatch

LogicMonitor

Job description

Overview

Job Description: The primary responsibility of this role is to design and engineer resilient enterprise data platforms, both on-premises and in a multi-cloud hybrid environment, guided by the principles of a well-architected framework.

This is an individual contributor role that requires collaboration with cross-functional teams across the company to ensure platforms are built for adoption with high standards of performance, scalability, and cost optimization, while leveraging emerging technologies in the data ecosystem.

The person in this role will support the Data Engineering and Services team's objective to architect and engineer highly resilient and available data platforms in a global multi-cloud hybrid environment.

Mandatory Skills

• Bachelor’s degree in IT or a related field.
• 10+ years of progressive experience in database technologies.
• 5+ years of extensive experience with database technologies such as PostgreSQL, Redis/Memory DB, DynamoDB, Aurora/RDS, MySQL, Snowflake, and MongoDB.
• 5+ years of experience with cloud databases and public cloud services (AWS, Azure, OCP, OIC, MongoDB Atlas, etc.).
• 3+ years of experience designing business solutions in a hybrid cloud environment.
• Strong command of SQL, PowerShell, and Unix shell scripting; knowledge of Python and JSON is a plus.
• Proficiency in SQL tools such as TOAD, SQL Developer, PGADMIN, DPA, snowsql, MongoDB compass, etc.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Solid understanding of relational and dimensional data modeling.
• Experience with database migrations and upgrades.
• Experience with both homogeneous and heterogeneous database migrations between cloud and on-premises environments.
• Expertise in modern approaches to designing, building, optimizing, and deploying database workloads in public cloud environments, preferably AWS.
• Skilled in schema design and data modeling.
• Proven ability to drive architectural and security improvements across systems, tools, and workflows.
• Passion for automation and optimization of database infrastructure, working effectively with international teams (onsite and offshore).
• Strong written and verbal communication skills, with the ability to present concepts and recommendations to management.
• AWS/Azure cloud certifications.

What You\'ll Be Doing

• Support application modernization and lead database migrations from on-premises to cloud environments.
• Stay current with industry trends and evaluate competitive advantages of emerging technologies, patterns, and methodologies.
• Drive the creation of technology roadmaps and maintain product portfolio components.
• Collaborate with product owners, enterprise architects, business SMEs, and various application teams.
• Act as a Level 3 support resource for high-priority database-related incidents.
• Provide mentorship to onsite and offshore resources regarding cloud database technologies.
• Support internal and external audit requests related to databases.
• Guide teams in upgrading databases to newer versions and applying security patches.
• Collaborate proactively to ensure database reliability, enforce robust security measures, and conduct strategic capacity planning to support scalable and resilient infrastructure.
• Communicate complex technical concepts effectively and align stakeholders on key decisions.
• Design and implement automated infrastructure provisioning using Infrastructure as Code (IaC) tools such as Terraform, Ansible, or CloudFormation, ensuring consistency, scalability, and repeatability across environments.
• Lead efforts to modernize legacy database systems and migrate workloads to cloud-native platforms, leveraging automated pipelines and IaC for deployment.
• Implement observability tools to monitor database performance and system health, including setting up alerts, dashboards, and logs using tools like Prometheus, Grafana, CloudWatch, and LogicMonitor.
• Support the Data Engineering team’s objective to architect and engineer resilient, cost-optimized data platforms in a multi-cloud hybrid environment.
• Develop, implement, and regularly test database backup, recovery, and disaster recovery plans to ensure business continuity.
• Create scripts and procedures to automate routine maintenance tasks such as backups, patching, and monitoring.