Contractor 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. Youll 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 Youll 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 Design & Architecture:

• 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

Development & Integration:

• 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

Performance & Optimization:

• 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

Security & Compliance:

• 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

Collaboration & Quality:

• 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

Required Experience:

Contract