Database Developer/Engineer

Company Description

Nirmalya is a leading provider of advanced cloud-based systems including Enterprise Resource Planning, Supply Chain Management, Smart Warehouse Management, and more. Headquartered in Bhubaneswar, India, Nirmalya serves clients across 10 countries globally, catering to industries such as manufacturing, retail, and healthcare. Nirmalya's customized solutions enable digital transformation, helping enterprises optimize their agility, efficiency, and resilience amidst unpredictable environments. Our comprehensive suite of platforms ensures enterprises can achieve growth, transformation, and efficiency.

Role Description

This is a full-time on-site role for a Database Developer/Engineer, located in Bhubaneswar. The Database Developer/Engineer will be responsible for designing, developing, and managing databases, performing database administration tasks, writing complex queries. Day-to-day tasks include analyzing system requirements, troubleshooting database issues, and ensuring data integrity and security.

Responsibilities

• Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
• Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment
• Provide solutions to promote data integrity in enterprise systems.
• Participate in code reviews to validate effectiveness and quality of code.
• Liaise with developers to improve applications and establish best practices
• Publish documentation and collaborative information using internal tools.

Requirements

• Expertise in Database Architecture in an environment that handles large volume of data, excess of 100 million of new data records every day.
• Strong analytical and organizational skills. This job involves analyzing existing databases and the client s needs to develop effective data driven solutions.
• Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3 rd party solutions.
• Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Hands-on development experience in MySQL/PgSQL
• Experience in troubleshooting and resolving data related issues.
• Excellent oral and written communication skills
• Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies

Nice to have

• Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
• Performance tuning experience using 3 rd party tools
• Audit/compliance experience in highly regulated environment.
• Experience using Jira & Confluence as part of development life cycle
• Familiar with Continual Improvement processes
• Familiar with Git

Experience

• 3 years + relational database and SQL experience
• Creativity, curiosity, initiative, and self-management are key attributes candidate embodies.
• Solid experience (3 years +) in coding complex SQL queries and stored procedures.
• The ability to explain the details of performance tuning internals of the database.