Software Engineer - Database

We are looking for an experienced database developer who could join our engineering team to build the enterprise applications for our global customers. If you are a technology enthusiast and have passion to develop enterprise cloud products with quality, security, and performance, we are eager to discuss with you about the potential role.

Responsibilities

• 1. Database Development:
• Utilize expertise in MS SQL server, PostgreSQL to design and develop efficient and scalable database solutions.
• Collaborate with development stakeholders to understand and implement database requirements.
• Write and optimize complex SQL queries, stored procedures, and functions.
• Database tuning & configurations of servers
• Knowledge on both Cloud & on-premises database
• Knowledge of SaaS based applications development
• 2. ETL Integration:
• Leverage experience with ETL tools such as ADF and SSIS to facilitate seamless data migration.
• Design and implement data extraction, transformation, and loading processes.
• Ensure data integrity during the ETL process and troubleshoot any issues that may arise.
• 3. Data Warehousing:
• Work with Azure Data Lake & Azure data warehousing, including data extraction, transformation, and loading.
• Contribute to the design and maintenance of scalable data warehousing solutions.
• Extraction of huge data for integration of reporting tools like Apache Superset
• 4. Reporting:
• Develop and maintain SSRS reports based on customer needs.
• Collaborate with stakeholders to understand reporting requirements and implement effective solutions.
• 5. Performance Tuning:
• Production database performance analysis using Dynatrace, New Relic or similar tools.
• Analyze query performance and implement tuning strategies to optimize database performance.
• Conduct impact analysis and resolve production issues within specified SLAs.
• 6. Version Control and Collaboration:
• Utilize GIT and SVN for version control of database scripts and configurations.
• Collaborate with cross-functional teams using tools such as JIRA for story mapping, tracking, and issue resolution.
• 7. Documentation:
• Document database architecture, processes, and configurations.
• Provide detailed RCA (Root Cause Analysis) for any database-related issues.

Requirements

• 2 - 5 years of hands-on experience in the IT industry, with a focus on C# ASP.NET, MS SQL web application development.
• Proficient in SQL, MS SQL Server, SSRS, and SSIS.
• Experience in C# ASP.NET programming.
• Preferable experience with PostgreSQL, Azure Datalake.
• Ability to grasp new concepts and facilitate continuous learning.
• Strong sense of responsibility and accountability.