Senior Database Engineer

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

Job summary

InvestCloud, Inc. in Bengaluru, India, is seeking an experienced database engineer to design, optimize, and maintain complex database schemas, queries, and stored procedures for scalable applications.

You will implement backup, recovery, and archiving strategies and monitor performance to proactively troubleshoot issues. Collaboration with software teams will ensure seamless integration of databases with services across regions.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience with relational (Oracle, MySQL, PostgreSQL, SQL Server) and non-relational databases (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.

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.
• 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.

Skills

Oracle

MySQL

PostgreSQL

SQL Server

MongoDB

Cassandra

Data modeling

Data warehousing

ETL

Database tuning

Backup and recovery

Security best practices

Problem solving

Team collaboration

Independent work

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

Database management tools

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.

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.