Senior Database Developer

Experience 4 to 6 Years

JD -Senior Database Developer (MS SQL Server / Oracle / PostgreSQL)
About Us
Novacis Digital Private Limited is a product-based technology company focused on building innovative
digital and analytics-driven products and solutions. We are bases out of IIT Madras Research Park, Chennai
– a leading center for advanced research and development.
Our leadership team brings over 100+ years of global experience in building Centers of Excellence and
Innovation Labs for Fortune 500 companies. At Novacis Digital, we offer a dynamic and collaborative
environment where technological professionals can learn, innovate, and make an impact.
If you are driven by problem-solving, passionate about modern technologies, and want to be part of
building next-gen digital products, we want to hear from you!
Eligibility Criteria
• Bachelor’s degree in computer science, Engineering, or related field
• Minimum 4 years of hands-on experience in MS SQL Server / Oracle / PostgreSQL development
Must-Have Skills
• Expertise in writing complex Stored Procedures and SQL Queries
• Handson experience in performance tuning of complex Stored Procedures, Stored Functions and SQL
Queries
• Strong command of Dynamic SQL, Table Type Variables and Temporary Tables
• Good Knowledge in JSON Handling in Database
• Proven ability to work with large and complex relational database systems
Required Knowledge, Skills, and Abilities
• Solid understanding of software development life cycle and database design principles
• Strong analytical, debugging, and troubleshooting skills
• Ability to work independently and manage tasks with minimal supervision
• Experience in prioritizing tasks, handling escalations, and collaborating with distributed teams
• Comfortable coordinating with onsite stakeholders for requirements gathering and delivery
• Willingness to work extended hours when needed
Good-to-Have Skills
• Exposure to NoSQL, Vector Databases and Graph Databases with a willingness to learn new
technologies
• 1–2 years of experience leading a small development team or mentoring junior developers
Roles & Responsibilities
• Design, develop, and maintain relational database systems for high-performance applications
• Write and optimize complex queries and stored procedures
• Participate in database design, data warehouse structuring, and schema optimization
• Work closely with development teams to integrate backend database logic with front-end applications
• Perform query tuning and performance optimization
• Troubleshoot and resolve issues in existing SQL code or database structures
• Document database structures, procedures, and configuration changes clearly and accurately

1 Check what DB Technology the candidate is familiar with -
MSSQL /Oracle/PostgreSQL

2 Check on their Project -Development Project/ Migration
Project/ Support & Maintenance Project

3 Check if the candidate has any experience in Production
support and handling production issues

4 Experience in Writing complex Stored Procedures

5 Experience in Performance tuning of procedures & SQL queries

6 Experience with Dynamic SQL

7 Experience in Table Type Variables & Temporary Tables

8 Experience in Handling JSON in database

9 Experience in Data Warehousing concepts / projects

10 Experience in Handling Team/ Mentoring Junior developers