1. Database Design and Architecture
Schema Design: Create and optimize database schemas that support the platform’s data requirements and scalability.
Data Modeling: Develop data models that align with business requirements and ensure data integrity and consistency.
Database Selection: Choose appropriate database technologies (SQL, NoSQL, NewSQL) based on use cases.
2. Software Development
Software Design and Development:
Extensive experience writing well-designed software using the .Net programming language
Unit testing:
Write unit tests to ensure code works as expected and teach patterns for unit testing effectively when a database is involved
Database Refactoring:
Able to guide teams in best practices to evolve their persistence layer over time.
3. Performance Tuning and Optimization
Query Optimization: Analyze and optimize database queries to reduce response times and improve overall performance.
Indexing Strategies: Implement and manage indexing strategies to speed up data retrieval processes.
4.Scalability and High Availability
Horizontal and Vertical Scaling: Design databases to scale horizontally (adding more machines) and vertically (upgrading existing hardware).
Replication and Sharding: Implement replication for data redundancy and sharding for distributing data across multiple nodes.
Failover and Recovery: Set up failover mechanisms and disaster recovery plans to ensure high availability and minimal downtime.
5.Security and Compliance
Access Controls: Implement fine-grained access control and authentication mechanisms to protect sensitive data.
Regulatory Compliance: Ensure the database adheres to data protection regulations such as GDPR, HIPAA, or SOC 2.
6. Monitoring and Maintenance
Monitoring Systems: Set up monitoring tools to track database health, performance metrics, and potential issues.
Incident Response: Quickly respond to and resolve database-related incidents to minimize service disruption.
Required
-
8 - 10 years: Having overall 5+ years of experience in Development Proficiency in database languages ( e.g. SQL,T/SQL), relational database management systems. ( e.g., MySQL, MS SQL, Postgre SQL) NoSQL datastores (e.g., Cosmos DB, Couchbase) and familiarity with analytics datastores (Fabric, Snowflake)
-
8 - 10 years: Cloud Databases: Familiarity with cloud database offerings like AWS RDS, Google Cloud SQL, or Azure SQL. Data Analytics and Reporting Tools: Knowledge of BI tools like Power BI, Tableau, or custom reporting solutions for healthcare analytics
-
8 - 10 years: Should have experience in DB design, management, performance tuning. Should have hands on security implementation, query optimization, documentation and monitoring.
Preferred
-
8 - 10 years: Preferrable from any healthcare domain. Should excellent analytical and problem-solving skills.
