PostgreSQL Database Administrator
Core
Managing database management for Clearing applications using Postgres and/or MS-SQL, ensuring availability, performance, and disaster recovery.
Role type
Senior IC PostgreSQL Database Administrator
Builds
Clearing applications in development, test, and production environments
Domain
Financial services (Clearing) + Database Administration
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Postgres Enterprise/Community, streaming replication, SQL/PL/SQL, Linux administration, Bash/Python scripting, capacity management, automation, RAC, RMAN, ASM, DG broker, TDE configuration, migration from non-CDB to CDB
Preferred skills
Red Hat Cluster, OEM, Engineered systems (Exadata/ODA), PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit
Technologies
Postgres, MS-SQL, RHEL, Bash, Python, OEM, Exadata, ODA
Responsibilities
Ensure availability and performance of the Clearing database environment; Manage non-production, production, and disaster recovery environments; Monitor database environment for minimum downtime; Provide trend analysis for capacity planning; Implement enhancements, maintenance, and upgrades; Develop and maintain runbooks for High Availability and Disaster Recovery tests; Provide technical expertise to development teams on database deployment best practices
Seniority
Senior, hands-on IC
