Saasvaap - Lead Database Engineer - PostgreSQL/SQL Server/Oracle DB

Role Description : As a Lead Database Engineer, you will be a technical leader and problem solver, responsible for the smooth operation and optimal performance of our database systems. You will leverage your extensive experience in database development to design and implement efficient solutions, troubleshoot complex issues, and ensure data integrity. Your ability to collaborate with cross-functional teams and maintain comprehensive documentation will be crucial for delivering successful projects. Responsibilities : - Design, develop, and optimize relational databases (PostgreSQL, SQL Server, MySQL, Oracle). - Design, develop, and optimize NoSQL databases (MongoDB, Cassandra, Redis). - Create and maintain database schemas and models. - Write and optimize complex SQL queries, stored procedures, triggers, and functions. - Perform query optimization, indexing, and partitioning. - Monitor database performance and implement improvements. - Develop and maintain ETL pipelines for data integration. - Design and implement data warehousing solutions. - Automate data transformation and loading processes. - Ensure database security, backups, and recovery. - Implement high-availability solutions and disaster recovery plans. - Manage database access and permissions. - Collaborate with application development teams to support database requirements. - Troubleshoot and resolve database performance issues. - Provide technical guidance and support to team members. - Maintain comprehensive technical documentation for database designs, ETL processes, and configurations. - Stay updated on database best practices and emerging technologies. - Implement and enforce coding standards and best practices. - Manage and optimize cloud database solutions (AWS RDS, Azure SQL, etc. - Design and implement cloud-based database architectures. Required Skills : Experience : - 5 years of experience in database development. Technical Skills : - Strong expertise in PostgreSQL and proficiency in SQL Server, MySQL, or Oracle. - Experience with NoSQL databases (MongoDB, Cassandra, Redis). - Experience with query optimization, indexing, and partitioning. - Familiarity with cloud DB solutions (AWS RDS, Azure SQL, etc.) - Hands-on experience with ETL tools and data warehousing. - Proficiency in scripting languages (Python, PowerShell, Bash) (ref:hirist.tech)

Location: kerala, IN

Posted Date: 4/19/2025