Job Description:
We are seeking a highly skilled Microsoft SQL Engineer to join our IT team. In this role, you will be responsible for the design, implementation, and maintenance of SQL databases that support critical business applications. Your expertise in SQL Server will be pivotal in optimizing database performance, ensuring data integrity, and driving the overall success of our data-driven initiatives.
Key Responsibilities:
- Database Design and Implementation: Design, deploy, and maintain SQL Server databases, ensuring optimal performance, reliability, and scalability.
- Performance Tuning: Monitor and optimize database performance, identifying and resolving bottlenecks through indexing, query optimization, and other techniques.
- Backup and Recovery: Implement robust backup and recovery strategies, ensuring data availability and minimizing downtime.
- Security Management: Enforce security best practices, including user roles, permissions, and encryption to safeguard sensitive data.
- Troubleshooting & Support: Provide advanced troubleshooting and support for complex database issues, ensuring minimal disruption to business operations.
- Automation: Develop and implement automation scripts for database management tasks using T-SQL, PowerShell, or other tools.
- Collaboration: Work closely with application developers, system administrators, and other stakeholders to ensure seamless integration and functionality of database systems.
- Documentation: Maintain comprehensive documentation of database configurations, processes, and procedures.
- Continuous Improvement: Stay up-to-date with the latest SQL Server technologies and best practices, driving continuous improvement initiatives.
Qualifications:
- Minimum of 5 years of experience in a Microsoft SQL Server engineering role.
- Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Certifications: Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, MCSA: SQL Server, or equivalent are highly desirable.
- Proficiency in T-SQL programming and SQL Server Management Studio (SSMS).
- Strong understanding of database security, backup and recovery, and high availability solutions (e.g., AlwaysOn, Failover Clustering).
- Experience with performance tuning, query optimization, and monitoring tools.
- Excellent problem-solving skills and the ability to work effectively in a fast-paced environment.
- Strong communication skills and the ability to collaborate with cross-functional teams.
Preferred Skills:
- Experience with cloud-based SQL solutions such as Azure SQL Database or Amazon RDS.
- Knowledge of NoSQL databases or other data storage technologies.
- Familiarity with data warehousing and ETL processes.
- Experience with DevOps practices and tools related to database management.
