Required Skills

• 4+ year experience as Database Developer
• 2+ years of hands-on Postgres DB or Oracle developer experience and within all layers (RDBMS, ETL, OLAP, BI).
• Bachelor’s Degree in Computer Science or equivalent
• Demonstrated ability to work independently and interact with customers, internal management other tech staff
• Demonstrated expertise in rapid and accurate problem localization, troubleshooting, and resolution
• Passion for getting to the Root Cause and preventing problems from reoccurring
• Knowledge of Best Practices in database monitoring, maintenance, operation, updates, and security
• Experience with large schemas (100+ tables/objects) with large data sets (billions of records)
• Nice to have MySQL experience

Responsibilities

• Work closely with backend and PM team to create data models for new functionality
• Create ETL procedures to gather data from in-house source systems and transform it for reporting purposes
• Help the backend team use database efficiently
• Monitor and tune SQL queries in OLTP and OLAP databases
• Monitor performance of all PostgreSQL instances
• Provide Level 3 support for client requests
• Assist DevOps maintenance tasks
• Constantly look for and propose ways to optimize the system and accommodate the growth
• Apply all knowledge to help the team during big events with high load in realtime
• Own all DB aspects of our SaaS platform, including Lab (Dev, QA, UAT) and Production environments
• Troubleshoot PostgreSQL stability and performance problems at all levels (SQL and data model tuning)
• Design and implement reliability and scalability improvements
• Assist application developers in data modeling (DDL)
• Design and improve ETL processes to support subscription data loads, log harvesting and data mart
• Design and implement cloud (e.g. AWS RDS) solutions, where appropriate
• Have a lot of fun

The Candidate Must be Able to

• Demonstrate experience specifying, developing, building, and maintaining highly reliable PostgreSQL solutions
• Demonstrate project estimation, scheduling skills, and experience working in an Agile environment.
• Provide identification, diagnosis, and resolution of production data problems in a fast-paced setting
• Work well with sysadmins, developers, and customer support
• Speak English well enough to work at times directly with top tier customers facilitated through customer support