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.