12+ 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.
Mandatory Technical skills required:
- Migrating on-premises PostgreSQL to Azure Cloud
- Migrating Azure database for PostgreSQL (Single server) to Migrating Azure database for PostgreSQL (Flexible server)
- Security setup: Enabling & Configuring SSL Certificate Authentication to encrypt data transfer.
- Day –to-day PostgreSQL
Key Responsibilities:
PostgreSQL:
- 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.
- Analyze, recommend, and implement configuration for Optimized Performance.
- Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.
- Ability to configure and troubleshoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
- Understanding of UNIX environment with shell scripting.
- Trouble shooting and resolving database issues.
- This role may entail shift & after-hours support on an on-call basis.
- HA/DR Setup including logical, physical standby.
- Conforming to client compliances and expectations
- This role may entail shift & after-hours support on an on-call basis.
- Good working experiences all HA and DR solutions.
Good to have: Any of the following PostgreSQL certificate:
- PostgreSQL Associate
- PostgreSQL Professional