Oversee essential database administration – install, configure, upgrade, back up, and monitor all databases.
Architect and implement solutions to solve database and application problems that involve database performance, scalability, and data security.
Develop advanced database objects, like stored procedures and triggers (T-SQL and PL/pgSQL), to implement database transactions and enforce database integrity.
Collaborate with product architecture and development teams to ensure new features are designed and implemented in ways that will ensure successful client deployment.
Collaborate with DevOps team on capacity planning, disk space management, redundancy/HA, change management, and overall database operations.
Debug production issues brought forth by the Support team.
Our Tech Stack:
MongoDB
PostgreSQL
Node.js
RabbitMQ
Elasticsearch
AWS/Azure
Docker/Kubernetes
CloverDX
Required Knowledge and Skills:
8 or more years of database & software development experience.
Advanced understanding of data modeling, index analysis & optimization in both non-SQL (MongoDB) and SQL (PostgreSQL and SQL Server) database environments.
Advanced understanding of replication, sharding, partitioning, and performance tuning.
Advanced understanding of database ETL (Extract, Transform, and Load) and reporting processes and tools (CloverDX, SSIS/SSRS).
Working experience with source code version control (Git).
Working experience in AWS/Azure or other public clouds.
Proven ability to learn and adapt to change quickly and easily.
Experience with healthcare information technology a plus but not required.
Key Attributes for Success:
Passion for software development and delivery
Effective problem-solving skills
Constantly seeking to evolve and improve current processes
Highly motivated
Positive attitude
Excellent and effective communication, both written and verbal