<h1>Position Summary</h1><p>Orgenesis is seeking a highly motivated and experienced Database Developer to support the design, development, implementation, and maintenance of enterprise database systems that support business operations, research, manufacturing, clinical programs, and corporate functions. The Database Developer will be responsible for ensuring data integrity, security, availability, and performance while collaborating with cross-functional teams to deliver scalable database solutions.</p><p>The ideal candidate will possess strong expertise in database development, SQL programming, data modeling, performance optimization, and data integration technologies within a highly regulated environment.</p><hr><h1>Key Responsibilities</h1><h2>Database Development & Design</h2><ul><li>Design, develop, and maintain relational database systems.</li><li>Create database objects including tables, views, indexes, stored procedures, functions, and triggers.</li><li>Develop efficient SQL queries and database scripts.</li><li>Build and maintain logical and physical data models.</li><li>Support application development teams with database design and implementation.</li></ul><h2>Database Administration Support</h2><ul><li>Monitor database health, availability, and performance.</li><li>Assist with database installation, configuration, and upgrades.</li><li>Perform database backup, recovery, and disaster recovery testing.</li><li>Maintain database environments across development, testing, and production systems.</li></ul><h2>Data Integration & ETL</h2><ul><li>Design and implement data integration processes.</li><li>Develop ETL workflows for moving and transforming data.</li><li>Integrate data from multiple business systems and applications.</li><li>Support data warehousing and reporting initiatives.</li></ul><h2>Performance Optimization</h2><ul><li>Analyze database performance metrics.</li><li>Identify and resolve performance bottlenecks.</li><li>Optimize SQL queries and indexing strategies.</li><li>Improve data processing efficiency and system scalability.</li></ul><h2>Security & Compliance</h2><ul><li>Implement database security controls and user permissions.</li><li>Ensure compliance with company policies and regulatory standards.</li><li>Support data governance initiatives.</li><li>Conduct database audits and maintain security documentation.</li><li>Protect sensitive business, clinical, and operational data.</li></ul><h2>Documentation</h2><ul><li>Create and maintain technical documentation.</li><li>Document database architecture, processes, standards, and procedures.</li><li>Develop user and operational support guides.</li></ul><h2>Collaboration</h2><ul><li>Work closely with software developers, analysts, engineers, and business stakeholders.</li><li>Participate in project planning and system implementation activities.</li><li>Provide technical support and troubleshooting assistance.</li><li>Contribute to continuous improvement initiatives.</li></ul><hr><h1>Required Qualifications</h1><h2>Education</h2><ul><li>Bachelor's Degree in:<ul><li>Computer Science</li><li>Information Technology</li><li>Software Engineering</li><li>Data Science</li><li>Related technical discipline</li></ul></li></ul><p>Equivalent experience may be considered.</p><hr><h2>Experience</h2><ul><li>3–5+ years of database development experience.</li><li>Experience working with enterprise-scale database environments.</li><li>Experience designing and optimizing database solutions.</li><li>Experience supporting data integration and reporting systems.</li></ul><hr><h2>Technical Skills</h2><h3>Required</h3><ul><li>Advanced SQL programming skills.</li><li>Strong experience with:<ul><li>Microsoft SQL Server</li><li>PostgreSQL</li><li>MySQL</li><li>Oracle Database</li></ul></li><li>Database performance tuning and optimization.</li><li>Data modeling and database design.</li><li>Backup and recovery procedures.</li><li>Stored procedures, triggers, and functions.</li><li>ETL development and data migration.</li></ul><h3>Preferred</h3><ul><li>Experience with:<ul><li>MongoDB</li><li>Cassandra</li><li>DynamoDB</li></ul></li><li>Knowledge of:<ul><li>Python</li><li>Java</li><li>C#</li><li>PowerShell</li></ul></li><li>Experience with cloud platforms:<ul><li>AWS</li><li>Microsoft Azure</li><li>Google Cloud Platform (GCP)</li></ul></li><li>Experience with healthcare, biotechnology, pharmaceutical, or regulated industries.</li><li>Knowledge of data governance and compliance frameworks.</li></ul><hr><h1>Preferred Qualifications</h1><ul><li>Experience supporting life sciences or biotechnology organizations.</li><li>Understanding of clinical, manufacturing, laboratory, or quality management systems.</li><li>Familiarity with FDA-regulated environments.</li><li>Knowledge of business intelligence platforms and reporting tools.</li><li>Relevant database certifications are a plus.</li></ul><hr><h1>Core Competencies</h1><ul><li>Strong analytical thinking.</li><li>Excellent problem-solving abilities.</li><li>Attention to detail.</li><li>Effective verbal and written communication skills.</li><li>Team-oriented mindset.</li><li>Ability to work independently.</li><li>Strong organizational and project management skills.</li><li>Commitment to data quality and security.</li></ul><hr><h1>Benefits</h1><h2>Health & Wellness</h2><ul><li>Medical Insurance</li><li>Dental Insurance</li><li>Vision Insurance</li><li>Employee Assistance Program (EAP)</li><li>Wellness Programs</li></ul><h2>Financial Benefits</h2><ul><li>Competitive Base Salary</li><li>Annual Performance Bonus Opportunities</li><li>401(k) Retirement Plan with Company Match</li><li>Life Insurance</li><li>Disability Insurance</li></ul><h2>Time Off</h2><ul><li>Paid Vacation</li><li>Paid Sick Leave</li><li>Paid Holidays</li><li>Personal Days</li></ul><h2>Professional Development</h2><ul><li>Training and Certification Reimbursement</li><li>Professional Development Programs</li><li>Leadership Development Opportunities</li><li>Industry Conferences and Workshops</li></ul><h2>Work-Life Balance</h2><ul><li>Flexible Work Arrangements</li><li>Hybrid and Remote Work Opportunities</li><li>Employee Wellness Initiatives</li></ul><h2>Additional Perks</h2><ul><li>Collaborative Work Environment</li><li>Employee Recognition Programs</li><li>Career Growth Opportunities</li><li>Access to Modern Technology and Tools</li></ul><hr><h1>Working Conditions</h1><ul><li>Primarily office, hybrid, or remote environment.</li><li>Occasional evening or weekend support during deployments and maintenance windows.</li><li>Ability to manage multiple projects and deadlines simultaneously.</li></ul><hr><h1>Equal Employment Opportunity Statement</h1><p>Orgenesis is committed to creating a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected characteristic under applicable law.</p>