Azure and PostgreSQL Database Engineer

Skysoft Inc

Louisville, KY, United States

29 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Automation of Tests Microsoft Azure Databases Data Validation Database Queries Database Security Linux Disaster Recovery Monitoring of Systems Identity and Access Management Python (Programming Language) PostgreSQL

+17 more

SQL Azure Windows Servers Performance Tuning Windows PowerShell Query Optimization Release Management Shell Script Software Deployment Virtual Machines Software Vulnerability Management System Availability Database Optimization Azure Powershell Database Performance Indexer Database Migration Cloud Optimization

Job description

Administer, monitor, and maintain PostgreSQL databases hosted on Azure to ensure high availability, reliability, performance, and security.
Install, configure, upgrade, patch, and support PostgreSQL database environments across development, test, staging, and production platforms.
Design and implement database backup, restore, replication, disaster recovery, and high availability strategies.
Perform database performance tuning, query optimization, indexing, capacity planning, and proactive health checks.
Support Azure database services, virtual machines, storage, networking, security, monitoring, and automation related to database platforms.
Collaborate with application, infrastructure, cloud, and security teams to troubleshoot complex database and platform issues.
Implement database security controls including access management, encryption, auditing, compliance, and vulnerability remediation.
Develop automation scripts using PowerShell, Azure CLI, Python, shell scripting, or similar tools to streamline database operations.
Participate in incident, problem, change, and release management processes, including CAB approvals and production deployment support.
Prepare technical documentation, SOPs, runbooks, architecture notes, migration plans, and operational reports.
Work with business stakeholders to understand requirements, provide consulting-style advisory inputs, and deliver solutions aligned to project objectives and SOW commitments.
Provide on-call or after-hours support as required for critical production systems.

Requirements

Strong hands-on experience in PostgreSQL Database Administration, including installation, configuration, patching, upgrades, backup, recovery, replication, and performance tuning.
Experience supporting PostgreSQL databases on Microsoft Azure, including Azure VMs, Azure Database for PostgreSQL, storage, networking, monitoring, and security services.
Good understanding of Azure cloud architecture, availability zones, disaster recovery, scalability, cost optimization, and cloud best practices.
Experience with database migration, upgrade planning, data validation, rollback planning, and production cutover support.
Strong SQL skills with the ability to troubleshoot slow queries, locking, indexing, resource contention, and database performance issues.
Working knowledge of Linux and Windows server environments used for database hosting and administration.
Experience with monitoring and observability tools for database performance, availability, logs, alerts, and capacity trends.
Knowledge of ITIL processes including incident management, problem management, change management, and capacity management.
Ability to work independently, manage multiple priorities, and collaborate with cross-functional teams in an enterprise environment.
Strong communication, documentation, stakeholder management, and problem-solving skills.