Database Developer

Our customers in the Life Science Industry create innovative medicines, therapies, and devices to improve their patients' quality of life. Our software supports improved efficiency, collaboration, and regulatory compliance, which allows them to focus their resources on their patients.

As a Database Developer at Blue Mountain Quality Resources, you will be instrumental in designing, developing, and maintaining the database infrastructure that powers Blue Mountain RAM (Regulatory Asset Manager), our industry-leading asset management solution for FDA-regulated environments. You'll work with a complex, multi-tenant SQL Server architecture that supports pharmaceutical, biotech, and medical device companies worldwide in their mission-critical calibration and asset management operations.

What You'll Work With

Database Technologies:

• Microsoft SQL Server (primary database platform)
• T-SQL for stored procedures, functions, views, and complex queries
• Entity Framework and Entity Framework Core for ORM
• SQL Server Integration Services (SSIS) for data migration and ETL
• Database migrations using Code First and Database First approaches
• Multi-tenant database architecture with company-specific schemas
• Current Database Projects in Your Scope:
• Core application database with 200+ tables
• Centralized logging and audit trail system
• ETL processes and data transformation logic
• Multi-tenant provisioning and isolation
• Long-term data retention and compliance storage

Day-to-Day Responsibilities

Database DesignArchitecture:

• Design and implement database schemas that support complex business processes for FDA-regulated environments
• Create and maintain database objects: tables, views, stored procedures, functions, triggers, and indexes
• Architect multi-tenant database solutions ensuring data isolation and performance
• Design data models that support calibration workflows, audit trails, and regulatory compliance
• Implement database partitioning and archival strategies for long-term data retention

DevelopmentIntegration:

• Write optimized T-SQL for data access, business logic, and reporting
• Develop and maintain Entity Framework models and migrations
• Build reusable database components and libraries for the development team
• Integrate multiple data sources and ensure data consistency across systems
• Implement data migration scripts and SSIS packages for customer onboarding

PerformanceOptimization:

• Optimize database queries and stored procedures for maximum performance
• Design and implement indexing strategies for large-scale data sets
• Monitor and tune database performance for multi-tenant environments
• Implement caching strategies and optimize data access patterns
• Scale database solutions to support growing customer loads

SecurityCompliance:

• Implement role-based security and data access controls
• Design and maintain audit trails for FDA 21 CFR Part 11 compliance
• Ensure data encryption at rest and in transit
• Implement data protection and privacy controls for multi-tenant architecture
• Support SOX compliance and regulatory audit requirements

CollaborationQuality:

• Write technical specifications for database changes and new features
• Collaborate with API, MVC, Mobile, and Azure development teams
• Work closely with Testing, Implementation, and Configuration teams
• Participate in code reviews and maintain high code quality standards
• Document database schemas, procedures, and architectural decisions

Required Skills and Qualifications

Essential:

• 3+ years of experience with commercial software development focusing on database development
• Strong T-SQL skills: complex queries, stored procedures, functions, views, triggers
• SQL Server expertise: database design, performance tuning, indexing strategies
• Database design principles: normalization, relationships, constraints, keys
• Experience creating database schemas that represent complex business processes
• Understanding of data architecture and database management best practices
• Experience with multi-tenant database architecture and data isolation patterns
• Proficiency with source control (Github) and database versioning strategies
• Experience with debugging and bug tracking systems
• Knowledge of automated testing for database code and unit testing frameworks (TSQLT)

Strongly Preferred:

• Experience with Entity Framework and Entity Framework Core
• Knowledge of SSIS (SQL Server Integration Services) for ETL processes
• Experience with database migrations and schema versioning
• Understanding of FDA 21 CFR Part 11 and regulatory compliance requirements
• Experience with audit trails and compliance logging
• Familiarity with C# for database integration and stored procedure alternatives
• Experience with Azure SQL Database or Azure SQL Managed Instance
• Knowledge of PowerShell for database automation and DevOps
• Understanding of OWASP security principles as applied to databases
• Experience with Application Lifecycle Management tools (Azure DevOps)

Nice to Have:

• Experience in Life Sciences, pharmaceutical, or FDA-regulated industries
• Knowledge of calibration management or asset management systems
• Experience with Azure cloud environments and cloud database services
• Understanding of multi-tenant SaaS architectures
• Familiarity with JSON, XML data formats and their storage in SQL Server
• Experience with database performance monitoring tools
• Knowledge of disaster recovery and high availability configurations
• Experience with reporting databases and data warehousing concepts

About Blue Mountain Quality Resources:

Blue Mountain Quality Resources is the leading developer of asset management software for the Life Sciences industry. Our software solution, Blue Mountain Regulatory Asset Manager (RAM), is used across the globe by pharmaceutical, biotech, and medical device companies.

We will not be able to sponsor a work visa for this position.

Blue Mountain Quality Resources is an Equal Opportunity Employer and qualified applicants will not be discriminated against on the basis of race, religion, gender and gender identity, nationality and origin, disability, sexual orientation, age, veteran status, and experiences.

BMQR is an E-verify employer

Compétences idéales

• Database Design
• T-SQL
• Triggers

• Port Matilda, Pennsylvania, United States

Expérience professionnelle

• Database Developer

Compétences linguistiques

• English