We have an exclusive job opening for PostgreSQL Architect :: Bellevue, WA (Remote)
PostgreSQL Architect
Location: Bellevue, WA | Remote
Job Description:
13+ years of IT experience and minimum of 5+ years of experience on PostgreSQL database administration. Should have worked with the team size of above 10 members & technically guided the team. Willing to provide 24x7 support, flexible to work in the shifts.
Key Responsibilities:
- Planning for Production Storage and Capacity Management.
- Create logical models and build physical models
- Planning for Production Storage and Capacity Management.
- Creation, managing & migrating PostgreSQL schema, tables, tablespaces and users, roles & group in 10.x, 11.x,12.x,13.x, 14.x, 15.x to Azure Cloud including PaaS (Azure database for PostgreSQL single & flexible servers)
- Performance tuning, Query tuning by generating and explaining plan for SQL queries.
- Expert in DBA functions like managing databases, backup & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.
- Expert in Backup & Recovery including Pg_dump, pg_dumpall, setting up WAL archiving, Point in time recovery.
Mandatory Technical skills required :
- Migrating on-premise PostgreSQL to Azure Cloud
- Migrating Azure database for PostgreSQL (Single server) to Migrating Azure database for PostgreSQL (Flexible server)