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
Similar jobs
We are seeking a highly skilled Backend Developer to join our team and contribute to the development and improvement of both our customer-centric SaaS platform and internal systems.
As a Backend Developer, you will be responsible for designing, implementing, and maintaining the server-side logic of our application, ensuring high performance, scalability, and security.
Responsibilities:
• Collaborate with cross-functional teams, including front-end developers, product managers, and designers, to understand project requirements and translate them into technical specifications.
• Design and develop server-side logic, APIs, and database schema to support the functionality and performance requirements of our SaaS platform.
• Write clean, modular, and well-documented code using any relevant programming language preferably Java with SpringBoot.
• Optimize the backend systems for maximum speed and scalability, ensuring high performance and responsiveness of the application.
• Implement data storage solutions using PostgreSQL or other relational databases, ensuring data integrity and security.
• Conduct thorough testing and debugging to identify and resolve any issues or bugs in the backend code.
• Stay up-to-date with emerging technologies, industry trends, and best practices in backend development and contribute to the continuous improvement of our development processes.
Requirements:
• Proven work experience as a Backend Developer or similar role, with a focus on server-side development.
• Proficiency in working with relational databases, particularly PostgreSQL, and writing efficient SQL queries.
• Familiarity with SaaS concepts and architecture.
• Experience with API design and development, including RESTful APIs. • Solid understanding of software development principles, including object-oriented programming, design patterns, and data structures.
• Experience with version control systems, such as Git.
• Strong problem-solving and analytical skills, with keen attention to detail. • Excellent communication and teamwork skills, with the ability to collaborate effectively with cross-functional teams.
• Bachelor's degree in Computer Science, Engineering, or a related field is preferred, but not mandatory.
As a Backend Developer with expertise in Java, and PostgreSQL, you will play a critical role in developing and maintaining the backend infrastructure of our SaaS and internal platforms, ensuring its reliability, scalability, and performance. Join our team and be a part of building cutting-edge software solutions that empower our customers and drive business growth.
What’s the opportunity?
Are you a backend developer looking to fast-track your learning and growth? Have you looked at world-class products like Asana, Notion, or Airtable, and felt “I wish I were part of the early team that built these products”?
We’re a team that has previously built and rolled out globally successful SaaS products used by tens of thousands of customers. We’re laser-focused on delivering a world-class product again, and looking for an ambitious backend engineer to join our existing team of 9 engineers.
If it excites you to think of a fast-paced start-up environment, building something big from scratch, breaking down new problems, creating new APIs, working on performance issues, getting hands-on with DevOps initiatives, and showcasing demos of your work every Friday with a happy and passionate team, then this is the right opportunity for you.
Some of the tech problems you get to work on as a backend engineer would be to build the backend for a modern spreadsheet experience from scratch, work on infra as code, write robust code that is fault-tolerant, work on performant code that adheres to SLOs set by the organization.
About you:
● 3- 5 years of experience
● Expertise in the following areas ○ Java ○ HTTP Protocol
● You’ve heard of or worked with some of the following tech stacks/products ○ Spring ○ PostgreSQL ○ Redis ○ Docker ○ Message brokers ○ GitHub
● These non-functional areas are familiar to you ○ Performance ○ Debugging ○ Log management
Nice to have:
● Familiarity with AWS
What’s in it for me?
● Great opportunity: We genuinely care about everyone we hire. You’ll learn new things and grow no matter how experienced you are; you will be working with founders who have more than three decades of collective experience in building significant B2B SaaS startups.
● Great team: Work with a world-class, high-velocity team that truly embodies the values of empathy, curiosity, and customer-centricity. Check out the MTT(Meet The Team) videos on our LinkedIn.
● Great culture: An open, fun, and exciting startup culture that empowers its people to champion big problems with the freedom to think and innovate.
● Growth: You could easily and quickly transition into other roles you might like.
● Impact: You get to be part of a global, passionate team in a fast-paced and growth-oriented environment. The team has a work philosophy of being high on ambition, ownership, and a bias for action.
● Monetary rewards and benefits: Competitive stipend, flexible leave policy, and more
Primary Skills: Database Systems (SQL), Python Flask/Fast API/Django frameworks specifically
Requirements:
- Highly proficient in fundamentals of Python web development frameworks like Flask, Django and Fast API
- Demonstrated experience in developing APIs using Python frameworks
- Should have deep knowledge in PostgreSQL, MS SQL Server and other SQL based Databases
- Knowledge and proficiency in NoSQL is a bonus
Greetings from Ellixtra Technologies Private Limited!
Ellixtra technologies is a bunch of young, self- motivated individuals that came together to create something significant for our society. A start up where we develop new business models for the pharmacy industry to keep our customers engaged on the right track. Our key components are authenticity and affordability, and we continue to look forward to a society in which access to affordable healthcare is no longer an issue.
We are looking to hire a Backend Engineer with outstanding organizational and research skills with 2 years experience,
About The Role
- Design, develop, test, deploy, maintain, and improve software and new user-facing features across Ellixtras products and services.
- Optimize applications for maximum speed and scalability and analyze feedback from customers and internal teams to identify issues and improvement opportunities.
- Champion a passion for engineering best practices such as code quality, linting, and testing.
- Ensure our software is reliable, extensible, maintainable, debuggable, secure, well-tested and performs well under load.
- Stay engaged with the latest technologies and evaluate strategies to keep the Novo technology stack up to date.
Requirements for the Role
- 2+ years experience in a highly technical role at a hyper-growth startup or fast-paced company.
- Extensive background in designing, developing, testing, deploying, maintaining, and improving the software.
- Good understanding of Node.js & Javascript ecosystem.
- Demonstrated ability to translate business goals and initiatives into technical requirements.
- Strong understanding of SQL database.
- Demonstrable experience architecting scalable and cost-effective solutions to ensure and support customer growth.
- Understanding of system design and architecture.
- Interest in engaging with the latest technologies and evaluating strategies to keep the Novo technology stack up to date.
- Excellent written and verbal communication skills with the ability to collaborate with both technical and non-technical teams effectively.
Role & Responsibilities:
- Handle multiple products/modules simultaneously, lead the team in development and support
- Lead development teams
- Daily updates to customers and Product Managers/Delivery Managers
- Participate in design discussions
- Design and Architect small modules
- Effort estimations for modules, subsystems or use cases.
- Learn new skills and mentor the new team members
- Champion best practices within the team, including code reviews
Work Experience & Skills:
- B.E/B.Tech or any relevant Masters degree from reputed college.
- Strong 5+ years of experience in Java, J2EE, Spring IOC, Spring Annotations, Spring JDBC, Jquery, Java script, HTML 5 and CSS
- Strong experience in Postgres or any SQL technology
- Experience with working on Tomcat, Apache, JBoss or any similar application server
- Should have 3+ years of experience in leading team.
- Good experience in JSON / RESTful API / Web Services.
- Experience in working on Agile methodology using Scrum and sprints
- Experience in using build tools, Maven, GIT, Bugzilla or similar tools.
- Experience in cloud technologies, Microservices and frameworks such as AWS or GPC, container technologies like Docker is a plus.
- Ability to adapt to new development environments, changing business requirements and learning new systems highly desired
- Experience in Microservices, SpringBoot and Angular is a plus.
- Experience with tuning deployed applications for scalability and performance.
- Good knowledge of deployment and scripting on Linux/Unix servers
- Strong technical documentation skills.
- Good oral and written communication skills
We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.
For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.
Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.
We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.
Working as Senior Microsoft SQL Developer at Navtech, you will:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- Should have excellent logical, analytical, and communication skills with client interaction experience.
Benefits
- Working with industry giants while following your passion for technology.
- Competitive pay package with additional bonus and benefits.
- Performance review and Appraisal Twice a year.
- Family Health Insurance cover for self and family.
- Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
- Work with a culturally diverse team from different geographies
Essential duties and responsibilities include the following.
- Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
- Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
- Convert complex business requirements into technical specifcations to build scalable and reliable data solutions
- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.
- Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
- Flexibility to work after office hours for any production issue or production deployment.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Qualifications include:
- 4+ years of database and backend development experience
- Good understanding of database systems and architectures
- Expertise in writing complex SQL queries and stored procedures
- Hands on experience with RDBMS and NoSQL data stores like MySQL and MongoDB
- Experience working with Python scripting and application development
- Experience working with Cloud applications and data stores like AWS RDS is a plus
- In-depth understanding of data management and ETL processes