- Extensive experience designing, developing, and optimizing complex SQL Server/PostgreSQL database solutions supporting large-scale healthcare or enterprise applications.
- Lead database architecture, data modeling, indexing strategies, partitioning, and performance tuning initiatives to ensure scalability and reliability.
- Develop and review complex SQL queries, stored procedures, functions, views, and ETL processes while enforcing coding and performance standards.
- Work closely with application architects and engineering teams to define data access patterns, database contracts, and integration strategies.
- Troubleshoot production issues, analyze execution plans, and proactively identify opportunities for database optimization and capacity improvements.
- Mentor junior database developers and establish best practices for database design, deployment, monitoring, and maintenance.