lever
Software Engineer - Database
Valgenesis
Chennai, IND
Full-time
Mid · 2+ years experience
Onsite
Discovered 3 weeks ago
MS SQL ServerPostgreSQLADFSSISAzure Data LakeAzure Data Warehousing
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
MS SQL ServerPostgreSQLADF
Key Skills for This Role
MS SQL ServerPostgreSQLADFSSISAzure Data LakeAzure Data Warehousing
Full Job Posting
• 1. 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
• 2. 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.
• 3. Data Warehousing
- Work with Azure Data Lake & Azure data warehousing, including data extraction, transformation, and loading.
- Contribute to the design and maintenance of scalable data warehousing solutions.
- Extraction of huge data for integration of reporting tools like Apache Superset
-
- Reporting:
- Develop and maintain SSRS reports based on customer needs.
- Collaborate with stakeholders to understand reporting requirements and implement effective solutions.
• 5. Performance Tuning
- Production database performance analysis using Dynatrace, New Relic 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.
- 2 - 5 years of hands-on experience in the IT industry, with a focus on C# ASP.NET , MS SQL web application development.
- Proficient in SQL, MS SQL Server, SSRS, and SSIS.
- Experience in C# ASP.NET programming.
- Preferable experience with PostgreSQL, Azure Datalake.
- Ability to grasp new concepts and facilitate continuous learning.
- Strong sense of responsibility and accountability.
About Valgenesis
Software & SaaS676 employeesFounded 2005
A private software company providing AI-powered digital validation and lifecycle management platforms to life sciences organizations.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Valgenesis
Senior Software Engineering Manager, Fullstack
Chennai, IND
SeniorFull-time
Discovered 1 weeks agoView →
Senior Software Engineering Manager, Fullstack
Chennai, IND
Discovered 1 weeks agoFull-time
Lead Software Engineer - Full Stack
Hyderabad, IND
Discovered 1 weeks agoFull-time
Senior Software Engineer, Fullstack
Chennai, IND
Discovered 3 weeks agoFull-time
Software Engineer, AI/ML
Hyderabad, IND
Discovered 3 weeks agoFull-time
Test Engineer, Automation
, IND
Discovered 3 weeks agoFull-time
Senior Software Engineer, Database
Chennai, IND
Discovered 3 weeks agoFull-time
Site Reliability Engineer - SaaSOps
Hyderabad, IND
Discovered 3 weeks agoFull-time
Senior Software Engineer, Full-stack
Hyderabad, IND
Discovered 3 weeks agoFull-time