Database Engineer

GeorgiaTEK Systems Inc.; São Paulo; Presencial; BRL 180 000 - 260 000; Tempo integral

Resumo da oferta

GeorgiaTEK Systems Inc. seeks an experienced PostgreSQL/MongoDB Database Engineer to manage and optimize databases across on‑prem, AWS, and hybrid environments. You will lead migrations to AWS, build Terraform modules, and automate provisioning and upgrades.

Strong scripting and ITSM alignment are required for secure, reliable operations. The ideal candidate has hands‑on experience with database security, high availability, and performance tuning, delivering scalable database solutions for

Qualificações

• Strong experience administering PostgreSQL and/or MongoDB databases.
• High availability clustering, replication, backup and disaster recovery.
• Experience migrating databases from on‑premises to AWS.
• Familiar with AWS services and RDS for PostgreSQL.

Responsabilidades

• Administer PostgreSQL and/or MongoDB across on‑premises, AWS and hybrid environments.
• Design and maintain highly available database architectures.
• Lead migration initiatives to AWS and Amazon RDS for PostgreSQL.
• Develop Terraform modules for automated provisioning and deployment.
• Create automation scripts for provisioning, patching, upgrades, and monitoring.

Conhecimentos

PostgreSQL

MongoDB

AWS

Python

Terraform

ITSM

Security

Ferramentas

Terraform

pg_dump/pg_restore

mongodump/mongorestore

ServiceNow

Descrição da oferta de emprego

Job Overview

We are seeking an experienced PostgreSQL / MongoDB Database Engineer to manage, administer, automate, and optimize database environments across on-premises data centers, AWS cloud, and hybrid infrastructure. The ideal candidate will have strong expertise in PostgreSQL and\/or MongoDB administration, high availability, database migrations, AWS, Terraform, automation, security, and ITSM processes.

Key Responsibilities

• Administer and support PostgreSQL and\/or MongoDB databases across on-premises, AWS, and hybrid cloud environments.


• Design, deploy, and maintain highly available database architectures, including PostgreSQL clusters and MongoDB Replica Sets.


• Lead database migration initiatives from on-premises environments to AWS and Amazon RDS for PostgreSQL.


• Develop, maintain, and enhance Terraform modules for automated database provisioning and infrastructure deployment.


• Develop automation scripts and playbooks using Python and other scripting technologies to support database provisioning, migration, patching, upgrades, monitoring, and operational activities.


• Perform database security patching, vulnerability remediation, hardening, and compliance activities.


• Plan and execute database version upgrades, patch upgrades, and client software upgrades with minimal operational impact.


• Manage and support backup, restore, replication, disaster recovery, and high-availability solutions.


• Monitor database health and performance, troubleshoot issues, and implement performance tuning and optimization strategies.


• Perform PostgreSQL backup and recovery using pg_dump / pg_restore and MongoDB backup and recovery using mongodump / mongorestore.


• Integrate database operational processes with ServiceNow workflows and ITSM practices, including incident, change, problem, and request management.


• Develop and maintain infrastructure automation and orchestration processes to improve operational efficiency and consistency.


• Collaborate with cloud, infrastructure, application, DevOps, security, and architecture teams to deliver reliable and scalable database solutions.


• Participate in database capacity planning, availability improvements, operational documentation, and continuous improvement initiatives.

Required Skills & Experience

Database Technologies

• Strong experience administering PostgreSQL and\/or MongoDB


• PostgreSQL clustering and high-availability architectures


• Database replication, backup, recovery, and disaster recovery


• MongoDB mongodump / mongorestore


• Database performance monitoring and tuning


• Database version upgrades and client maintenance


• Hands-on experience with AWS cloud services


• Experience with Amazon RDS for PostgreSQL


• Proven experience migrating databases from on‑premises to AWS


• High availability and disaster recovery architecture


• Infrastructure provisioning and automation

Infrastructure as Code & Automation

• Strong Terraform experience


• Terraform module development and maintenance


• Python scripting for database and infrastructure automation


• Automation of database provisioning, migration, patching, upgrades, and operational tasks

Security & ITSM

• Database security patching and hardening


• Vulnerability identification and remediation


• Database compliance activities


• ServiceNow and ITSM processes


• Change, incident, problem, and request management

Preferred Qualifications

• Experience with automated database deployment and operational tooling


• Strong troubleshooting and performance optimization skills


• Experience working in DevOps / CloudOps / Infrastructure Engineering environments


• Strong communication and collaboration skills with cross-functional technical teams