PostgreSQL Database Developer

You will be a part of the Data Feeds Unit at Sportz Interactive, where you will play a crucial role in developing high-performance database solutions using PostgreSQL and MS SQL / PL SQL. Your responsibilities will include designing and optimizing complex queries, stored procedures, functions, triggers, views, and transactions. It will be essential for you to tune database performance through indexing, partitioning, and query optimization to ensure seamless data solutions. As a Database Developer at Sportz Interactive, you will collaborate closely with product managers, engineers, and QA teams throughout the development cycle. You will also be responsible for mentoring junior developers, reviewing code, and promoting engineering best practices. Additionally, you will monitor and troubleshoot database performance issues in real-time production environments, providing on-call support during critical deployments and marquee events. **Key Responsibilities:** - Designing and optimizing complex queries, stored procedures, functions, triggers, views, and transactions - Tuning database performance through indexing, partitioning, and query optimization - Collaborating with product managers, engineers, and QA teams throughout the development cycle - Mentoring junior developers, reviewing code, and promoting engineering best practices - Monitoring and troubleshooting database performance issues in real-time production environments **Qualifications Required:** - 6+ years of experience working as a Database Developer with expertise in PostgreSQL and MS SQL / PL SQL - Proven experience in database design, development, stored procedures optimization, SQL queries, and performance tuning - Hands-on experience with indexing, partitioning, and query optimization techniques - Familiarity with database monitoring tools and performance tuning - Proficiency in data modelling, database visualization tools, and working with data structures like XML and JSON - Knowledge of database security best practices and policies - Proficient in Project Management tools such as JIRA and Agile methodology Tech & Tools You'll Use: - Databases: PostgreSQL (primary), MS SQL, PL SQL - Performance: EXPLAIN ANALYZE, pgAdmin, indexing, tuning strategies - Monitoring: pgBadger, Prometheus, custom scripts - Data Modelling & Formats: ER diagrams, normalisation, partitioning, JSON, XML - Security: Role-based access, encryption, secure architecture design - Dev Tools: JIRA, Agile workflows,