Develop and optimize database solutions using MS SQL Server and PostgreSQL. Involves ETL processes, data warehousing, reporting, and performance tuning within a collaborative environment.
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.youtube.com/watch?v=tASq7Ld0JsQ
About the Role:
We are looking for an 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
- 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
- 4. 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.
- 6. 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.
- 7. Documentation:
- Document database architecture, processes, and configurations.
- Provide detailed RCA (Root Cause Analysis) for any database-related issues.
Requirements
- 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.
We’re on a Mission
In 2005, we disrupted the life sciences industry by introducing the world’s first digital validation lifecycle management system. ValGenesis VLMS® revolutionized compliance-based corporate validation activities and has remained the industry standard.
Today, we continue to push the boundaries of innovation ― enhancing and expanding our portfolio beyond validation with an end-to-end digital transformation platform. We combine our purpose-built systems with world-class consulting services to help every facet of GxP meet evolving regulations and quality expectations.
The Team You’ll Join
Our customers’ success is our success. We keep the customer experience centered in our decisions, from product to marketing to sales to services to support. Life sciences companies exist to improve humanity’s quality of life, and we honor that mission.
We work together. We communicate openly, support each other without reservation, and never hesitate to wear multiple hats to get the job done.
We think big. Innovation is the heart of ValGenesis. That spirit drives product development as well as personal growth. We never stop aiming upward.
We’re in it to win it. We’re on a path to becoming the number one intelligent validation platform in the market, and we won’t settle for anything less than being a market leader.
How We Work
Our Chennai, Hyderabad and Bangalore offices are onsite, 5 days per week. We believe that in-person interaction and collaboration fosters creativity, and a sense of community, and is critical to our future success as a company.
ValGenesis is an equal-opportunity employer that makes employment decisions on the basis of merit. Our goal is to have the best-qualified people in every job. All qualified applicants will receive consideration for employment without regard to race, religion, sex, sexual orientation, gender identity, national origin, disability, or any other characteristics protected by local law.
Top Skills
Adf
Asp.Net
Azure Data Lake
C#
Etl Tools
Ms Sql Server
Postgres
Ssis
Ssrs
ValGenesis Chennai, Tamil Nadu, IND Office
C S I R Road, Taramani, 705-708, 7th Floor, Phase II, TICEL BIO Park Limited, , Chennai, Tamil Nadu, India, 600113
Similar Jobs
Software
Develop efficient database solutions using MS SQL Server and PostgreSQL, optimize queries, implement ETL processes, and create reports while ensuring data integrity and performance tuning.
Top Skills:
AdfAsp.NetC#DynatraceGitJIRAMs Sql ServerNewrelicPostgresSQLSsisSsrsSvn
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The PowerPoint Design Specialist refines presentations, creates visuals, collaborates on design standards, and improves brand engagement through effective storytelling in presentations.
Top Skills:
Adobe Creative SuiteAdobe XdCanvaFigmaIllustratorIndesignPhotoshopPowerPoint
Cloud • Fintech • Food • Information Technology • Software • Hospitality
The Sr. Lending Operations QA Analyst will ensure the accuracy and compliance of lending processes, optimize operations, and enhance quality assurance practices while collaborating with cross-functional teams.
Top Skills:
ExcelGoogle SuiteSnowflakeSQL
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
