Database Developer

Job Summary:

We are looking for a Database Developer to join our team in Bhubaneswar. The ideal candidate will have expertise in database design, development, and optimization, along with experience in writing complex queries and ensuring the performance, integrity, and security of databases. As a Database Developer, you will work with our engineering team to design and maintain high-performance database systems, and provide key insights into improving the structure and performance of our applications.

Key Responsibilities:

• Database Design & Development: Design, develop, and maintain databases, including schemas, tables, views, stored procedures, and triggers.
• Query Optimization: Write and optimize complex SQL queries, stored procedures, and functions to ensure high performance, scalability, and reliability.
• Data Modeling: Work on logical and physical data models, ensuring the proper normalization and denormalization based on business needs.
• Database Performance Tuning: Identify performance bottlenecks and optimize database queries and operations.
• Data Integrity & Security: Ensure data integrity, consistency, and security by implementing best practices for database maintenance and backup strategies.
• Troubleshooting & Support: Monitor and troubleshoot database-related issues, including performance degradation, data anomalies, and outages.
• Collaboration: Work closely with application developers and business analysts to design efficient data storage solutions for new and existing applications.
• Migration & Upgrades: Plan and execute database migrations, version upgrades, and patches with minimal downtime.
• Documentation: Maintain clear and comprehensive documentation for database design, architecture, and procedures.
• Compliance: Ensure compliance with relevant data privacy and protection regulations (e.g., GDPR, HIPAA) in all database solutions.

Required Skills & Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• 3–5+ years of experience as a Database Developer, Database Administrator (DBA), or similar role.
• Strong proficiency in SQL, including complex queries, joins, and subqueries.
• Experience with database management systems (DBMS) such as MySQL, PostgreSQL, SQL Server, or Oracle.
• Knowledge of database design concepts, including normalization, indexing, and query optimization.
• Experience in writing and optimizing stored procedures, triggers, and functions.
• Familiarity with ETL (Extract, Transform, Load) processes and data integration techniques.
• Working knowledge of backup and recovery strategies, and disaster recovery planning.
• Understanding of data warehousing and business intelligence concepts is a plus.
• Experience with NoSQL databases like MongoDB, Cassandra, or Redis is a plus.
• Proficient in using version control systems like Git.

Preferred Skills (Nice to Have):

• Familiarity with cloud databases (e.g., Amazon RDS, Azure SQL Database).
• Experience with database automation tools or scripts for deployment, monitoring, and scaling.
• Knowledge of data security practices and encryption techniques for securing databases.
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Familiarity with Agile development methodologies (Scrum, Kanban).
• Knowledge of Python or Shell scripting for database automation tasks.

Job Type: Full-time

Pay: ₹1,500,000.00 - ₹2,100,000.00 per year

Work Location: In person