Senior Database Engineer

InvestCloud, Inc.; Bengaluru; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

InvestCloud, Inc. in Bengaluru is seeking an experienced database engineer to design, optimize, and maintain complex schemas and queries across relational and non-relational systems.

You will implement backup, recovery, and archiving strategies and ensure data integrity and security. The role involves monitoring performance, collaborating with software teams to integrate databases with applications, and documenting configurations and processes.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience working with relational databases and non-relational databases.
• Strong knowledge of SQL and database optimization techniques.
• Experience with database design, data modeling, and normalization.
• Proficiency in data warehousing concepts and ETL processes.
• Familiarity with database management tools and technologies.
• Experience in automated deployment of database changes across all regions.
• Understanding of data security best practices.
• Excellent problem-solving skills and attention to detail.
• Ability to work both independently and as part of a team.
• Effective communication skills to collaborate with technical and non-technical stakeholders.

Responsibilities

• Develop, optimize, and maintain database schemas, queries, and stored procedures.
• Design and implement backup, recovery, and archiving strategies.
• Monitor database performance, perform optimization, and troubleshoot issues.
• Collaborate with software developers to integrate databases with applications.
• Create and maintain documentation related to database configurations, processes, and procedures.
• Implement data migration and transformation solutions.
• Perform capacity planning and scaling strategies.
• Support the development of data-related features and provide technical guidance on database-related matters.

Skills

Relational databases

SQL optimization

Data modeling

ETL processes

Data security best practices

Problem solving

Education

Bachelor's degree in Computer Science/IT

Tools

Oracle

MySQL

PostgreSQL

SQL Server

MongoDB

Cassandra

Job description

• Develop, optimize, and maintain database schemas, queries, and stored procedures.
• Design and implement backup, recovery, and archiving strategies.
• Monitor database performance, perform optimization, and troubleshoot issues.
• Ensure data integrity and security through proper design and implementation.
• Collaborate with software developers to integrate databases with applications.
• Create and maintain documentation related to database configurations, processes, and procedures.
• Implement data migration and transformation solutions.
• Perform capacity planning and scaling strategies.
• Support the development of data-related features and provide technical guidance on database-related matters.
• Serve as an expert on database and provide technical support.

• Participate in requirements analysis.
• Develop, optimize, and maintain database schemas, queries, and stored procedures.
• Design and implement backup, recovery, and archiving strategies.
• Monitor database performance, perform optimization, and troubleshoot issues.
• Ensure data integrity and security through proper design and implementation.
• Collaborate with software developers to integrate databases with applications.
• Create and maintain documentation related to database configurations, processes, and procedures.
• Implement data migration and transformation solutions.
• Perform capacity planning and scaling strategies.
• Support the development of data-related features and provide technical guidance on database-related matters.
• Serve as an expert on database and provide technical support.

Basic Qualifications and Skills for Consideration

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience working with relational databases (e.g., Oracle, MySQL, PostgreSQL, SQL Server) and non-relational databases (e.g., MongoDB, Cassandra).
• Strong knowledge of SQL and database optimization techniques.
• Experience with database design, data modeling, and normalization.
• Proficiency in data warehousing concepts and ETL processes.
• Familiarity with database management tools and technologies.
• Experience in automated deployment of database changes across all regions.
• Understanding of data security best practices.
• Excellent problem-solving skills and attention to detail.
• Ability to work both independently and as part of a team.
• Effective communication skills to collaborate with technical and non-technical stakeholders.