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.

Experience

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.

📌 Software Developer - Database Engineer (India)
🏢 RAMANATHAN SOFTWARE PRIVATE
📍 India