Software Engineer - Database

Key Responsibilities

1. Database Development:

• Design, develop, and maintain efficient and scalable database solutions using

  MS SQL Server and PostgreSQL

  .
• Collaborate with development stakeholders to understand and implement database requirements.
• Write and optimize complex SQL queries, stored procedures, and functions.
• Configure and tune database servers for optimal performance.
• Work with both cloud and on-premises database environments.
• Support SaaS-based application development.

2. ETL Integration:

• Design and implement ETL processes using tools such as

  ADF (Azure Data Factory) and SSIS

  .
• Ensure seamless data migration and maintain data integrity.
• Troubleshoot ETL issues as they arise.

3. Data Warehousing:

• Work with

  Azure Data Lake

  and data warehousing solutions.
• Contribute to the design, maintenance, and optimization of scalable data warehouses.
• Extract large datasets for integration with reporting tools like

  Apache Superset

  .

4. Reporting:

• Develop and maintain

  SSRS reports

  based on customer requirements.
• Collaborate with stakeholders to implement effective reporting solutions.

5. Performance Tuning:

• Analyze production database performance using tools such as

  Dynatrace, New Relic

  , or similar.
• Optimize query performance and implement tuning strategies.
• Conduct impact analysis and resolve production issues within SLAs.

6. Version Control and Collaboration:

• Use

  GIT and SVN

  for version control of database scripts and configurations.
• Collaborate with cross-functional teams using

  JIRA

  for story mapping, tracking, and issue resolution.

7. Documentation:

• Document database architecture, processes, and configurations.
• Provide detailed

  Root Cause Analysis (RCA)

  for database-related issues.