MSSQL Database Administrator & Developer

About the Role

We are seeking a skilled and experienced MSSQL Administrator and Developer to manage and optimize our SQL Server databases and provide expertise in developing database solutions.

Key Responsibilities

• Database Administration:
• Install, configure, and maintain SQL Server instances across multiple environments.
• Monitor and optimize database performance, ensuring maximum uptime and efficient resource utilization.
• Implement security measures and access controls to protect sensitive data.
• Plan and execute database backups, recovery, and disaster recovery procedures.
• Troubleshoot and resolve database-related issues promptly.
• Database Development:
• Work closely with application developers to design, develop, and implement database structures and schemas.
• Create and optimize SQL queries, stored procedures, and functions to support application requirements.
• Ensure data integrity and consistency within the databases.
• Develop and maintain database documentation, including data dictionaries and ER diagrams.
• Performance Tuning and Optimization:
• Analyze and fine-tune database performance by identifying bottlenecks and optimizing queries and indexes.
• Implement best practices for database design and performance optimization.
• Data Migration and Integration:
• Facilitate data migration and integration processes between various systems and databases.
• Collaborate with stakeholders to understand data migration requirements and ensure successful execution.
• Security and Compliance:
• Monitor and enforce database security policies and access controls.
• Ensure compliance with data privacy regulations and industry standards.
• Database Upgrades and Patches:
• Plan and execute SQL Server upgrades and apply patches to maintain database security and performance.
• Backup and Recovery:
• Establish and maintain database backup and recovery strategies to safeguard critical data.

Requirements & Tech Stack

• Proven experience as an MSSQL Administrator and Developer.
• Deep understanding of SQL Server databases.
• Proficiency in writing complex SQL queries, stored procedures, and functions.
• Strong knowledge of database design principles, indexing, and performance optimization techniques.
• Experience in database administration, including installation, configuration, backup, recovery, and security.
• Familiarity with data migration and integration processes.
• Knowledge of data privacy regulations and best practices for securing databases.
• Excellent problem-solving and analytical skills.
• Ability to work independently and as part of a team, with good communication and collaboration skills.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Certifications in Microsoft SQL Server or related areas are a plus.