Position: Middle PostgreSQL Database Administrator
Company: Cloud Works
Category: SQL
Experience required: 2y
English level: upper

Cloud Works is looking for Middle PostgreSQL Database Administrator. Vacancy ONLY FOR KHARKIV!

Requirements:
2+ years of experience
Setup, maintenance, tuning of PostgreSQL on Windows, Docker, Google Cloud SQL
Solid understanding of relational theory, database design
Solid knowledge of SQL and PL/pgSQL, Good skills at writing both SQL and PL/pgSQL code
Query tuning, optimization, indexing
Knowledge of .Net/ORM related issues would be good

Responsibilities:
Develop, maintain, support and tune database for multiuser POS application
Design database schema to meet new enhancement requirements
Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks
Develop simple and complex stored procedures, functions and views to provide business logic
Provide best practice guidance to the development team with regard to database design and usage
Develop appropriate corrective actions to resolve production data issues
Design and implement redundancy and HA strategies, including read replicas
Design and implement backup/restoration strategies per data retention requirements
Maintain database security and auditability