Associate Manager - Development (DB)

Group Company: Sportz Interactive

Designation: Associate Manager

Office Location: Goregaon Mumbai

Years of experience: 6 to 8

Salary Range: INR to (Annual)

Position description:

6+ years of experience in database development.

Primary 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.

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented.

Additional: Team Management, Decision Making & Client Management.

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Performance Optimization, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, Data Integrity Management, DB Backup/Recovery, Cloud Services.