Role: SQL Database Developer
Location: Remote
Let’s create our future together at The AES Group!
About The AES Group:
The AES Group is a premier technology and engineering consulting company that has been bringing businesses and talent together for over 20 years to deliver innovative solutions that have the greatest positive impact on society. AES has helped over 40 business enterprises, including Fortune 500 companies, engage their customers, empower their employees, and transform their business operations with the power of cloud, data, AI, engineering, and other emerging technologies.
Position Overview
Database Design & Development
• Design, develop, and maintain complex SQL Server databases supporting enterprise healthcare applications.
• Create and optimize database schemas, tables, indexes, views, stored procedures, functions, and triggers.
• Develop scalable data models supporting patient, provider, care management, clinical, and operational workflows.
• Ensure database structures support evolving business and regulatory requirements.
Performance Optimization
• Analyze and resolve database performance bottlenecks.
• Optimize complex T-SQL queries and stored procedures.
• Design indexing strategies to improve application response times.
• Perform execution plan analysis and SQL code optimization.
• Monitor database performance and proactively identify areas for improvement.
• Support high-volume transactional workloads while maintaining performance SLAs.
Scalability & Capacity Planning
• Assess current database limitations and recommend scalability improvements.
• Design solutions capable of supporting increased user concurrency and transaction volumes.
• Implement partitioning, archiving, caching, and data lifecycle strategies.
• Optimize database architecture for future platform growth and new feature rollouts.
• Collaborate with Technical Architects to define long-term database modernization strategies.
Healthcare Data & Integrations
• Support healthcare interoperability initiatives using FHIR standards.
• Develop and optimize ETL processes for healthcare data exchange.
• Design database structures supporting FHIR resources and healthcare integrations.
• Work with API and integration teams to ensure efficient data access patterns.
• Ensure compliance with healthcare data governance and security requirements.
Reporting & Analytics
• Design and optimize reporting databases and operational data stores.
• Develop SQL-based reporting solutions and data extracts.
• Support Power BI and enterprise reporting initiatives.
• Create scalable reporting mechanisms that minimize application performance impact.
Data Security & Compliance
• Implement database security best practices.
• Manage data access controls and encryption strategies.
• Ensure compliance with HIPAA and healthcare data privacy regulations.
• Participate in audits and compliance reviews.
Never miss an opportunity! Create an alert based on the job you applied for.