Jobless Developer
ValGenesis logo
ValGenesis

Posted 13 months ago

Open

Senior Software Engineer, Database

ChennaiRemoteFull-time

AI Summary

Senior Database Engineer focuses on designing, tuning, and maintaining enterprise SQL solutions (MS SQL Server, PostgreSQL) and ETL/Reporting components for cloud/on-prem SaaS applications.

About this role

About ValGenesis
ValGenesis is a leading digital validation platform provider for life sciences companies. ValGenesis suite of products are used by 30 of the top 50 global pharmaceutical and biotech companies to achieve digital transformation, total compliance and manufacturing excellence/intelligence across their product lifecycle.
Learn more about working for ValGenesis, the de facto standard for paperless validation in Life Sciences: https://www.valgenesis.com/about

About the Role:


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.

    • Skills

    ADFASP.NETC++Database AdministrationDatabase DesignData IntegrationData IntegrityData MigrationDynatraceETLFunctionsGitJiraMS SQL ServerNewRelicPostgreSQLQuery OptimizationRCAReportingServer ConfigurationSQLSSISSSRSSSRS ReportingStored ProceduresSVNTuning

    Explore related jobs

    More jobs at ValGenesis

    Similar ADF jobs

    Jobs in Chennai

    Browse these categories

    C++ JobsData Integration JobsData Integrity JobsETL JobsGit Jobs