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. Skills: Performance Tuning, Database Development, Ssrs, Ms Sql, Postgresql, Ssis Experience: 2.00-5.00 Years