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.
