Sphere collaborates with clients to transform their organizations by embedding technology and processes into every aspect of their operations, creating lasting competitive advantages. By combining global expertise with local insights, we help individuals and companies achieve their ambitious goals.

Our current client, a leading fintech organization, operates financial services trade associations across multiple regions and provides financing solutions in compliance with diverse lending regulations. We are seeking a skilled Database Engineer (Database Automation Engineer) to join the team and contribute to creating a cutting-edge automation framework for managing the client’s extensive database infrastructure.

Position Details:

• Type: Contract
• Location: Remote
• Start Date: Late February/Early March
• Term: 6-12 months with potential extension

---

The client is building a new automation framework to manage approximately 800 databases hosted both on-premises in their data centers and in AWS. The framework will initially focus on PostgreSQL, with additional components introduced iteratively. The framework should support the actions below for PostgreSQL.

• Design and implement database clusters to support critical applications.
• Create and manage new primary databases, including schema initialization, user roles, and permissions (e.g., DBA admin, app owner, app user).
• Configure and manage PostgreSQL replication setups (logical, binary, and event streaming with Debezium).
• Automate tasks such as binary and logical replica setup, database snapshots, and PII scrubbing for refreshed snapshots.
• Facilitate database relocation for primary, binary replica, or logical replica instances, both on-premises and in AWS.
• Manage SAN volume attachment and resizing for database instances.
• Customize and maintain PostgreSQL global configurations, including pg_hba.conf and postgresql.conf, with support for version-specific and database-specific overrides.
• Monitor and integrate database alerting via tools like DataDog, ensuring efficient notifications through PagerDuty and Slack.
• Oversee database backup processes using Commvault, including monitoring and alerting for backup status.
• Generate ServiceNow resource requests for new application database clusters or to decommission existing resources.

---

Requirements:

• Experience managing PostgreSQL databases in both on-premises and cloud environments (AWS preferred).
• Experience in Software development using Python/Go.
• Experience in database automation frameworks and tooling (proficient with Terraform and Ansible for infrastructure automation)
• Skilled in Python and Bash scripting to streamline database operations.
• Proficiency in configuring PostgreSQL replication (logical and binary) and event streaming technologies such as Debezium.
• Experience with SAN volume management and database configuration tuning.
• Experience with monitoring tools like DataDog and alerting platforms such as PagerDuty and Slack.
• Experience with backup systems (e.g., Commvault) and ensuring database integrity during backup and restoration processes.
• Knowledge of database infrastructure automation and DevOps practices.