Sportz Interactive - Associate Manager - PostgreSQL (6-10 yrs)

Job Description : Associate Manager - Development - DB (PostgreSQL)

Job Title : Associate Manager - Development - DB

Level in Organization : Level 4 (of 10)

Name of Business Unit : Interactive Solutions

Reporting Manager : Director - Engineering

Location : Mumbai, India

About Sportz Interactive :

We are a global sports-focused data, technology, and content solutions provider with over 20 years of proven excellence in delivering high quality fan engagement products to 150+ clients.

Fueled by a young squad of 700+ players, our vision is to empower sports organizations to maximize fan affinity and commercialization.

Our vision is - Empowering sports Organizations to maximise Fan Affinity and Commercialisation. Working at Sportz Interactive means you & play a crucial role in delivering products to millions of sports fans worldwide and gain invaluable exposure by collaborating with leading global entities in the sports industry such as the Olympics, BCCI, ICC, UEFA, Star Sports, Jio Cinema, NBA, ECN, Dream11, Formula 1 & many more.

About the role :

The Interactive Solutions business unit at Sportz Interactive provides fan engagement products geared towards Digital Transformation such as Websites, Apps, CMS, Fan Loyalty & Rewards, Match Centers and Gaming Solutions such as Fantasy Games, Quiz, Vote, Predictor, Digital Collectibles.

Sportz Interactive is looking for a passionate technologist to join their Interactive Solutions business unit and help with achieving the next leap in the organization's journey.

Key Responsibilities :

- Actively contributing with the development process such as planning, coding, debugging, testing, deployment etc.

- Understanding systems architecture and design and translating into functional applications

- Design and develop complex and dynamic queries, stored procedures, cursors, Indexes, views, functions, transactions and triggers to ensure efficient database performance.

- Optimize the performance of stored procedures and SQL queries to handle large datasets within seconds.

- Perform thorough code reviews to maintain high standards of quality and efficiency in database development.

- Monitor and troubleshoot database performance issues, ensuring minimal disruption.

- Identify and implement scalable solutions to handle high workloads and large user bases.

- Provide solutions for existing and new applications by understanding project requirements from inception to implementation and maintenance.

- Performing code reviews, advocating code quality and engineering best practices

- Being involved with R & D, being aware of technology trends and managing a small-sized development team and providing mentorship.

- Providing On Call escalation support during marquee events and critical system deployments.

Background and Experience :

- Lead the development and maintenance of complex database solutions using PostgreSQL, ensuring scalability, performance, and maintainability.

- Provide technical leadership and mentorship to junior developers, guiding them in best practices and architectural decisions.

- 6+ years of experience working as a Database Developer (PostgreSQL and MS SQL / PL SQL)

- Proven experience with database design, development, optimizing stored procedures, SQL queries and performance tuning in PostgreSQL and database schemas.

- Hands-on experience with indexing, partitioning, and query optimization techniques.

- Familiarity with database monitoring and performance tuning tools.

- Strong proficiency in data modeling and database visualization tools.

- Demonstrate expertise in working with data structures such as XML and JSON, implementing efficient data manipulation and storage solutions.

- Knowledge of database security best practices and policies.

- Proficient with Project Management tools like JIRA and Agile methodology.

- Communicate effectively with stakeholders, including designers, product managers, and senior
management, to gather requirements and provide project updates.

- Proactively identify technical challenges and propose innovative solutions to address them, leveraging strong problem-solving skills and industry best practices.

Other competencies :

- Problem Solving - Has a solution-oriented mindset, provides effective solutions for key challenges.

- Leadership Skills - Provides leadership by example, able to take sound decisions, inspires others.

- Strategic Thinking - Identifies with the company vision to meet the short, medium, and long-term goals.

- Communication - Able to understand and articulate with clarity, presents well-reasoned arguments.

- Sporting knowledge - Follows or participates in sport in any capacity, is familiar with basic rules, awareness of major sporting events and sports persons