InvestCloud - Senior Database Engineer - PostgreSQL/SQL Server

Role Overview :

Participate in requirements analysis and collaborate with software developers to integrate databases with applications.

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

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