Cloud Architect - PostgreSQL

    • ComResource
  • Toledo, OH
  • Posted 3 days ago | Updated 10 hours ago

Overview

On Site
Full Time

Skills

Python
SQL
Remote Desktop Services
Amazon RDS
Terraform
Backup
Cloud computing
Database
Business intelligence
Replication
PostgreSQL
Provisioning
ServiceNow
Forms
Jenkins
DevOps
Artificial intelligence
Amazon Web Services
Ansible
Reporting
Splunk
Dynatrace
Benchmarking

Job Details

Job Description

Job Description
Here is what we are looking for:
Create/modify cloud formation code for RDS PostgreSQL (non-Aurora) that can be vended through Service catalog
-Create/deploy/modify cross account Lambda functions and/or Python code that can be used for
Monitoring Drift detection, Monitoring SQL and instance level performance
-Create/modify pipelines and/or self service tooling for backup and recoveries at the instance and table level (RDS PostgreSQL/Aurora)
-Modify and maintain/enhance existing Terraform code
-Create/modify pipelines and/or self-service tooling for backup and recoveries at the instance and table level (for on-prem PostgreSQL). On-prem automation is currently done through Ansible tower)
--Create/modify cloud formation code for Dynamo DB that can be vended through Service catalog
-Deploy pgadmin in a hybrid eco-system
-Develop proof of concept for replication from AWS to on-prem, and on-prem to AWS
-Partner with app team and DevOps team to create Jenkins pipelines, that can incorporate/enforce DB Engg standards
-Perform proof of concept for Bi-directional replication in on-prem PostgreSQL
-Partner with Service Now team to incorporate straight through provisioning. Candidate is not expected to know how to modify service now forms; but should be able to partner with the SNOW team to stitch together Ansible playbooks and/or Jenkins.
-Partner with DevOps team to start working on proof of concept for AI Ops in AWS as well on-prem. This would be using Ansible playbooks to perform reporting/corrective action based on triggers from Splunk/Dynatrace.
-Develop self-service tooling for minor version upgrades
-Use HammerDB etc to perform benchmarking for measuring performance across versions
-Develop and automate post version upgrade validation
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.