
Senior Associate - Database development (PostgreSQL\PLSQL)
About Sportz Interactive
Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others.
Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms.
http://www.sportzinteractive.net/">www.sportzinteractive.net
Designation: Senior Associate
Office Location: Goregaon East, Mumbai
Position description:
3+ years of experience in database development.
Primary Responsibilities:
- Understand requirements from front end applications developers
- Write advanced queries, stored procedures, cursors, functions & triggers
- Conduct code reviews
- Work with high-traffic application servers
- Complete understanding of various DB like Postgresql, Mongo DB, MySQL
- Ability to identify root cause and mitigate issues
- Ability to lead a team of DB developers
Required Skills:
Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills.
Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

About Sportz Interactive
About
Photos
Connect with the team
Similar jobs

Role : Python Django Developer (Immediate Joiner)
Location : Gurugram, India (Onsite)
Experience : 4+ Years
Working Days : 6 Days WFO (Monday to Saturday)
Job Summary :
We are looking for an experienced Python Developer with strong expertise in Django to join our team. The ideal candidate will have 4+ years of hands-on experience in building robust, scalable, and efficient web applications.
Proficiency in RabbitMQ, Redis, Celery, and PostgreSQL is essential for managing background tasks, caching, and database performance.
Mandatory Skills : Python, Django, RabbitMQ, Redis, Celery, PostgreSQL, RESTful APIs, Docker.
Key Responsibilities :
- Develop, maintain, and enhance Django-based web applications and RESTful APIs.
- Design and implement message broker systems using RabbitMQ for asynchronous communication.
- Integrate Redis for caching and session management to improve application performance.
- Utilize Celery for managing distributed task queues and background processing.
- Work with PostgreSQL for schema design, optimization, and query tuning.
- Collaborate with cross-functional teams including front-end developers and DevOps engineers.
- Write clean, maintainable, and well-documented code aligned with industry best practices.
- Debug and troubleshoot issues across the application stack.
- Participate in system architecture discussions, code reviews, and agile ceremonies.
- Ensure performance, scalability, and security of applications.
Technical Skills Required :
- Minimum 4+ years of hands-on experience with Python and Django.
- Proficiency with RabbitMQ for message brokering.
- Experience with Redis for caching and session storage.
- Practical knowledge of Celery for asynchronous task processing.
- Strong command over PostgreSQL including complex queries and optimization techniques.
- Experience developing and consuming RESTful APIs.
- Familiarity with Docker and containerization concepts.
Preferred Skills :
- Exposure to CI/CD tools and processes.
- Experience with cloud platforms such as AWS or GCP.
- Understanding of Django ORM performance tuning.
- Basic knowledge of front-end technologies (HTML, CSS, JavaScript).
Responsibilities
Drive new feature development - from ideation to PoC to testing to scalable production deployments
Writing reusable, testable, and efficient code
Implementing highly scalable, secure, robust, and fault-tolerant systems
Working on continuously improving tools and systems Required Skills
Knowledge of relational databases (MySQL, Postgres) and NoSQL
Demonstrable experience with microservices (design, deployment, monitoring, etc.)
Strong proponent for best practices and code quality
Experience in architecting & building real-time, large scale software applications.
Excellent command over Data Structures and Algorithm Proficiency in implementation of algorithms and use of advanced data structures to solve problems in computing.
Bring software engineering and product delivery experience, with a strong background in algorithms.
Understanding fundamental design principles behind a scalable application.
Good communication skills
Strong Problem solving and analytical skills
Experience in Fintech Industry is a plus
About the company.
It is India's largest Corporate Employee Benefits Platform. Founded by alumni of UCLA, Amazon, and Microsoft. Our major verticals are Corporate Perks, Rewards & Recognition, and financial solutions. We are currently partnered with more than 250+ corporates, including Concentrix, RBS, Fidelity, Walmart, Amazon, etc., whose employees are offered exclusive privileges through our 10,000+ brand partners across categories It is leading the employee benefits market in India which pegged at $2 billion and growing.
Create and maintain database tables, views, indexes, and triggers.
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Develop and maintain high-quality stored procedures.
Write low cost, high-quality database queries and code while maintaining data quality, privacy, and security
Profile databases, measure database performance and troubleshoot complex database issues, and IO bottlenecks.
Optimize database queries and ensure table locking/deadlocks happen in production.
Optimize large, complicated SQL statements & Stored Procedures.
Cost optimization of Amazon instances using databases.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
Knowledge of message queuing, indexing, and high-performance data concept
Knowledge of JSON and PostgreSQL support for JSON.
Good Grasp of ETL concepts
Work with front-end developers to define simple yet powerful APIs
Work with DBAs to ensure the efficiency of database code, integrity of data structures and quality of data content.
Coordinate with product managers and leadership teams to build effective database objects
Excellent verbal and written communication skills
Good attitude towards work and flexibility
Ability and willingness to handle multiple tasks in a fast-paced environment
Ability to evaluate alternative solutions and/or workarounds



We’re Looking for Someone With:
Experience working with startups.
Experience working with ORMs like SQLAlchemy or Django
Experience with SQL and databases (Postgres preferred)
Experience in developing large server side applications and microservices
Ability to create high quality code
Experience with python testing tools (pytest) and test automation
Familiarity with code versioning tools like GIT
Strong sense of ownership and leadership quality
Experienced in the tools of our web stack
o Python
o Celery
o Postgres
o Redis
o RabbitMQ
Nice to Haves:
Prior experience at a growth stage Internet/Software company
Experience with ReactJS, Google Cloud, Heroku
Cloud deployment and scaling experience

Day to Day Responsibilities:
1. Develop Django based RESTful APIs and WebSockets
2. Manage and mentor the junior and intern developers to deliver the project requirements in the given timeline
3. Carry out Database Modelling and Designing
4. Make DFDs, ER diagrams, etc.
5. Integrate Python APIs/endpoints to other Python outputs (JSON, etc.)
6. Work with clean code writing practices and structure the code for collaborated development
7. Analyze different use-cases and coming up with creative solutions
8. Build reusable components and back-end libraries for future use
9. Participate in daily scrums
10. Work on responsive web development
11. Work with the team to manage, optimize, and customize multiple web applications
12. Learn and work using new technologies
13. Work on being involved and participate in the overall application lifecycle
14. Work with a focus on coding and debugging
15. Collaborate with front-end developers




