1. Job description
The company is a 12 Billion US-based unicorn doing payroll and compliance for remote workers and companies.
Responsibilities:
Support Development by:
Supporting and guiding developers on database related development and design best practices
Reviewing and approving database-related code written by developers
Conduct Database Administration tasks by:
Monitoring database health and performance metrics
Support live situations and respond to alerts (errors, locks, deadlocks, availability etc.)
Perform maintenance tasks including backup and restore, engine upgrades, data migrations and parameter changes
Create database functions and triggers
Maintain and improve Data Integrity
Improve performance – find problematic queries or parameters and advise on solutions
2. Requirements
Have 3+ years administering production PostgreSQL databases
Have 1+ years of High-Level Programming experience
Have 1+ years of managing cloud databases (AWS, GCP)
Are proficient in reading and writing SQL queries including window functions
Are proficient in DB programming – creating triggers, functions etc.
Are proficient in Data Modelling – designing tables and relations
Are proficient in performance tuning
Are capable of giving support in a live situation
Nice-to-haves:
Have experience with other RDBMS systems
Have experience with NoSQL and other database types such as timeseries and graph
3. Benefits
Annual salary: $65,000 to $100,000 USD
Other benefits: negotiable
Visa sponsorship: not available