Software Engineer - Database
ValGenesisover 2 years ago
Chennai, IndiaMid Level / Senior
Responsibilities
- Design and develop efficient, scalable database solutions using MS SQL Server and PostgreSQL.
- Write and optimize complex SQL queries, stored procedures, and functions, and perform database tuning and server configuration.
- Design and implement ETL processes using Azure Data Factory and SSIS while maintaining data integrity.
- Contribute to Azure Data Lake and Azure data warehousing solutions and extract large datasets for reporting integrations.
- Develop and maintain SSRS reports based on customer requirements.
- Analyze production database performance using Dynatrace, New Relic, or similar tools and resolve issues within specified SLAs.
- Use Git and SVN for database scripts and configurations and collaborate through JIRA.
- Document database architecture, processes, configurations, and root-cause analyses.
Requirements
- Requires 2–5 years of hands-on IT experience focused on C# ASP.NET and MS SQL web application development.
- Proficiency in SQL, MS SQL Server, SSRS, and SSIS is required.
- Experience with C# ASP.NET programming is required.
- Experience with PostgreSQL and Azure Data Lake is preferred.
- Ability to learn new concepts and facilitate continuous learning, with a strong sense of responsibility and accountability.
Benefits
- The Chennai, Hyderabad, and Bangalore offices require onsite work five days per week.
- ValGenesis is an equal-opportunity employer.
Tech Stack
Categories
BackendData Engineering
About ValGenesis
ValGenesis builds enterprise software for digitizing validation and manufacturing workflows in the life sciences, centered on its Validation Lifecycle Management System (VLMS) and eLog tools. Customers use it to manage equipment, cleaning, process, and computer system validation with audit trails and compliance support. Founded in 2005 and headquartered in Santa Clara, the privately held firm says its products are used by 30 of the top 50 global pharma and biotech companies.