PostgreSQL Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Galactic Minds INC · 18 hours ago

PostgreSQL Architect

positionUnited States
timeContract
remoteRemote
senioritySenior Level, Lead/Staff
date13+ years exp

Galactic Minds INC is seeking a PostgreSQL Architect with extensive experience in managing PostgreSQL databases and migrating them to Azure Database for PostgreSQL. The role involves planning, installation, administration, and performance tuning of PostgreSQL databases while providing 24x7 support.

Business IntelligenceConsultingInformation TechnologyRecruitingStaffing Agency
Hiring Manager
Shruti Yadav
linkedin

Responsibilities

Planning for Production Storage and Capacity Management
Create logical models and build physical models
Installing and Managing PostgreSQL Clusters on Azure VMs , provisioning Azure Database for PostgreSQL (Flexible Server)
Migrating PostgreSQL instances to Azure Database for PostgreSQL
Migrating PostgreSQL from on-premises, Azure VMs, and other cloud platforms to Azure-managed services
Administer production and development PostgreSQL databases, ensuring maximum availability
Installation and configuration of PostgreSQL on UNIX/Linux platforms
Performing PostgreSQL version upgrades (major and minor)
Applying security patches and updates for PostgreSQL
Extensive working knowledge of PostgreSQL utilities
Demonstrable experience working effectively with clients and internal teams to resolve issues
Good knowledge in UNIX and shell scripting
Handle all PostgreSQL DBA-related daily maintenance tasks
Experience in Database/SQL Performance Tuning
Migrating on-premise PostgreSQL workloads to Azure Database for PostgreSQL (Flexible Server)
Security setup: Enabling & Configuring SSL/TLS authentication to encrypt data transfer
Configuration of High Availability (HA) and Disaster Recovery (DR)
Day-to-day PostgreSQL administration activities
Monitoring and troubleshooting PostgreSQL performance issues

Qualification

PostgreSQL managementAzure Database for PostgreSQLDatabase/SQL Performance TuningUNIX/Linux administrationHigh Availability (HA)Disaster Recovery (DR)SSL/TLS authenticationPowerShell scriptingBackupRestore strategiesClient compliancePostgreSQL certificationsCloud PostgreSQL certifications

Required

13+ years of IT experience
Minimum of 5+ years of experience on managing PostgreSQL databases
Migrating PostgreSQL servers to Azure Database for PostgreSQL using various tools
Willing to provide 24x7 support
Flexible to work in shifts
Planning for Production Storage and Capacity Management
Create logical models and build physical models
Installing and Managing PostgreSQL Clusters on Azure VMs
Provisioning Azure Database for PostgreSQL (Flexible Server)
Migrating PostgreSQL instances to Azure Database for PostgreSQL
Migrating PostgreSQL from on-premises, Azure VMs, and other cloud platforms to Azure-managed services
Administer production and development PostgreSQL databases, ensuring maximum availability
Installation and configuration of PostgreSQL on UNIX/Linux platforms
Performing PostgreSQL version upgrades (major and minor)
Applying security patches and updates for PostgreSQL
Extensive working knowledge of PostgreSQL utilities
Demonstrable experience working effectively with clients and internal teams to resolve issues
Good knowledge in UNIX and shell scripting
Handle all PostgreSQL DBA-related daily maintenance tasks
Experience in Database/SQL Performance Tuning
Migrating on-premise PostgreSQL workloads to Azure Database for PostgreSQL (Flexible Server)
Security setup: Enabling & Configuring SSL/TLS authentication to encrypt data transfer
Configuration of High Availability (HA) and Disaster Recovery (DR)
Day-to-day PostgreSQL administration activities
Monitoring and troubleshooting PostgreSQL performance issues

Preferred

Azure Database PaaS services (Azure SQL DB, MySQL, PostgreSQL)
Good knowledge of tools, scripting, and PowerShell
Experience in backup, restore, PITR, replication, and failover strategies
Conforming to client compliances and expectations
Microsoft Certified: Azure Solutions Architect Associate
PostgreSQL-related certifications such as: PostgreSQL Associate / Professional
Cloud PostgreSQL certifications

Company

Galactic Minds INC

twittertwitter
company-logo
Galactic Minds INC is a leading IT consulting company specialized in staffing and workforce solutions with a strong presence across USA, Canada, and Mexico.
location
Hampton, New Jersey, USA
people-size11-50 employees
web-link
https://www.galacticmind.com

Funding

Current Stage
Early Stage

Leadership Team

leader-logo
Akash Pattnaik
Founder and M.D.
linkedin
Company data provided by crunchbase