Software Engineer - Database

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.

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