Senior Software Engineer, Database

We are looking for experienced database developer who could join our engineering team to build the enterprise applications for our global customers. If you are a technology enthusiast and have passion to develop enterprise cloud products with quality, security, and performance, we are eager to discuss with you about the potential role.

Responsibilities

• 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.

Requirements

• 6 - 9 years of hands-on experience in software development.
• Must have extensive experience in stored procedure development and performance fine tuning.
• Proficient in SQL, MS SQL Server, SSRS, and SSIS.
• Working knowledge of C# ASP.NET web application development.
• Ability to grasp new concepts and facilitate continuous learning.
• Strong sense of responsibility and accountability.