Job Summary:
We are looking for a highly skilled and experienced Senior Database Developer/Administrator with a strong background in both SQL Server and MongoDB. The ideal candidate will have over 5 years of hands-on experience in database development, administration, and optimization. You will be responsible for designing, implementing, maintaining, and optimizing our databases to ensure high performance, availability, and security.
Key Responsibilities:
- Design, develop, and maintain SQL Server and MongoDB databases.
- Write and optimize complex SQL queries, stored procedures, functions, and triggers.
- Develop and optimize data models to support business requirements.
- Perform advanced database performance tuning and optimization.
- Implement and manage comprehensive database security protocols.
- Conduct regular database backup and recovery procedures.
- Collaborate with software developers and other stakeholders to design and implement robust database solutions.
- Monitor database health, performance, and capacity planning, and troubleshoot issues proactively.
- Ensure data integrity and consistency across databases.
- Create and maintain detailed database documentation, including data dictionaries and schemas.
- Participate in database design and code reviews.
- Mentor and guide junior database developers/administrators.
Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Over 5 years of experience working with SQL Server and MongoDB.
- Proficiency in writing and optimizing complex SQL queries.
- Extensive experience with database design, development, and administration.
- Deep knowledge of indexing, performance tuning, and query optimization techniques.
- Expertise in backup and recovery best practices.
- Strong understanding of data modeling concepts and database schema design.
- Proven experience with database security practices.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and as part of a team.
- Strong communication skills, both written and verbal.
