SQL Database Developer, AWS RDS

Job Description:

• Design, develop, and maintain SQL Server databases hosted on AWS RDS, ensuring reliability, availability, and data integrity.
• Perform query and index performance tuning — analyze execution plans, identify bottlenecks, and implement optimizations to support production workloads.
• Conduct load testing to simulate high-traffic scenarios, interpret results, and drive schema or configuration improvements.
• Collaborate with application developers to review and improve database-facing code, stored procedures, functions, and views.
• Develop and maintain data models, schema designs, and documentation following best practices for normalization and scalability.
• Build and maintain ETL/ELT pipelines and data transformation workflows using Python or similar tooling.
• Participate in CI/CD pipelines for database change management, including scripted migrations and version-controlled deployments.
• Ensure all data practices comply with HIPAA regulations and internal data governance standards for handling PHI/PII.
• Monitor database health, capacity, and performance metrics; proactively address issues before they impact end users.
• Contribute to peer code reviews and help establish database development standards across the team

• Bachelor’s degree or equivalent 3–5 years of hands-on experience as a SQL Server Database Developer or Database Engineer.
• Strong proficiency in T‑SQL including complex queries, stored procedures, triggers, and views.
• Demonstrated experience with query performance tuning — reading execution plans, optimizing indexes, and resolving blocking/deadlock issues.
• Experience designing and managing databases on AWS RDS for SQL Server.
• Solid understanding of relational data modeling, normalization, and schema design principles.
• Experience with load testing methodologies and tools; ability to define test scenarios and interpret results.
• Working knowledge of ETL/ELT processes and experience with Python or similar scripting languages for data pipelines.
• Familiarity with CI/CD practices for database change management (e.g., Flyway, Liquibase, or equivalent).
• Understanding of HIPAA compliance requirements as they relate to data handling, access control, and audit logging.
• Strong communication skills and ability to collaborate effectively in a fully remote environment.

• Medical, Dental, Vision, long-term disability insurance, life insurance coverage and more
• 401K with company match
• Holidays, Flexible/Uncapped paid time off
• Allowance for certifications/continuing education