Senior Software Engineer, Database

Database Development

Utilize expertise in MS SQL Server, PostgreSQL to design and develop efficient and scalable database solutions.

Collaborate with development stakeholders to understand and implement database requirements.

Write and optimize complex SQL queries, stored procedures, and functions.

Database tuning & configurations of servers

Knowledge on both Cloud & on-premises database

Knowledge of SaaS based applications development

ETL Integration

Leverage experience with ETL tools such as ADF and SSIS to facilitate seamless data migration.

Design and implement data extraction, transformation, and loading processes.

Ensure data integrity during the ETL process and troubleshoot any issues that may arise.

Reporting

Develop and maintain SSRS reports based on customer needs.

Collaborate with stakeholders to understand reporting requirements and implement effective solutions.

Performance Tuning

Database performance analysis using Dynatrace, NewRelic or similar tools.

Analyze query performance and implement tuning strategies to optimize database performance.

Conduct impact analysis and resolve production issues within specified SLAs.

Version Control and Collaboration

Utilize GIT and SVN for version control of database scripts and configurations.

Collaborate with cross-functional teams using tools such as JIRA for story mapping, tracking, and issue resolution.

Documentation

Document database architecture, processes, and configurations.

Provide detailed RCA (Root Cause Analysis) for any database-related issues.