What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- 5+ years of professional database engineering experience
- Expert knowledge of Microsoft SQL Server 2016 or later
- Strong T-SQL development skills including complex queries stored procedures functions and triggers
- Experience with index strategies and execution plan optimization
- Hands-on experience with MSSQL Always-On Availability Groups
- Experience with MSSQL mirroring and log shipping
- Strong experience with PostgreSQL
- Hands-on experience with MongoDB or other NoSQL databases
- Strong experience managing databases on AWS RDS and Aurora
- Proficiency in backup restore recovery models and disaster recovery planning
- Knowledge of database security encryption authentication and compliance standards
- Strong troubleshooting and problem-solving skills with attention to detail
Nice to have
- Azure certified
- IaC experience
- ETL familiarity
- Monitoring tools knowledge
- HA architecture knowledge
- CI/CD familiarity
- Agile/DevOps experience
Day to day
- Design and build enterprise database infrastructure across Microsoft SQL Server PostgreSQL and MongoDB platforms.
- Optimize complex database environments for high performance reliability and scalability in cloud and on premises settings.
- Collaborate with developers and architects to improve data models schemas security backup recovery and disaster readiness.