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.
