Database Manager

As a Database Developer at Sportz Interactive, you will play a crucial role in driving the organization's next big transformation within the Data Feeds Unit. Your main responsibilities will include: - Actively contributing to the development process, including planning, coding, debugging, testing, and deployment. - Understanding systems architecture and design, and translating them into functional applications. - Designing and developing complex and dynamic queries, stored procedures, cursors, Indexes, views, functions, transactions, and triggers to ensure efficient database performance. - Optimizing the performance of stored procedures and SQL queries to handle large datasets within seconds. - Performing thorough code reviews to maintain high standards of quality and efficiency in database development. - Monitoring and troubleshooting database performance issues to ensure minimal disruption. - Identifying and implementing scalable solutions to handle high workloads and large user bases. - Providing 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, staying aware of technology trends, managing a small-sized development team, and providing mentorship. - Providing on-call escalation support during marquee events and critical system deployments. To be successful in this role, you should have the following background and experience: - Leading the development and maintenance of complex database solutions using PostgreSQL, ensuring scalability, performance, and maintainability. - Providing technical leadership and mentorship to junior developers, guiding them in best practices and architectural decisions. - Having 6+ years of experience working as a Database Developer (PostgreSQL and MS SQL / PL SQL). - Demonstrating proven experience with database design, development, optimizing stored procedures, SQL queries, and performance tuning in PostgreSQL and database schemas. - Possessing hands-on experience with indexing, partitioning, and query optimization techniques. - Being familiar with database monitoring and performance tuning tools. - Showing strong proficiency in data modeling and database visualization tools. - Demonstrating expertise in working with data structures such as XML and JSON, implementing efficient data manipulation and storage solutions. - Having knowledge of database security best practices and policies. - Being proficient with Project Management tools like JIRA and Agile methodology. - Communicating effectively with stakeholders, including designers, product managers, and senior management, to gather requirements and provide project updates. - Proactively identifying technical challenges and proposing innovative solutions to address them, leveraging strong problem-solving skills and industry best practices. In addition to the technical skills required for the role, other competencies that will be beneficial include: - Problem Solving: Having a solution-oriented mindset and providing effective solutions for key challenges. - Leadership Skills: Providing leadership by example, making sound decisions, and inspiring others. - Strategic Thinking: Identifying with the company vision to meet short, medium, and long-term goals. - Communication: Being able to understand and articulate with clarity, presenting well-reasoned arguments. - Sporting Knowledge: Following or participating in sports in any capacity, being familiar with basic rules, awareness of major sporting events, and sports persons.,