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.