Microsoft SQL Data Base Specialist

Job Objective

The Microsoft SQL Database Specialist will be responsible for the administration, optimization, security, and maintenance of the organization's SQL Server databases. This professional will ensure optimal performance, high availability, disaster recovery, and data protection. Additionally, they will play a key role in implementing innovative solutions that support business needs and the continuous growth of the database infrastructure.

Responsibilities

• Database Administration: Configure, maintain, and optimize SQL Server database servers to ensure high performance and availability.
• Security: Implement and maintain security policies to protect data and database servers, including permissions, auditing, and encryption.
• Backup and Recovery: Design, implement, and test backup and disaster recovery procedures to ensure data integrity and availability.
• Query and Performance Optimization: Monitor database performance, identify bottlenecks, and optimize SQL queries, indexes, and stored procedures.
• Updates and Patches: Manage SQL Server instance updates and patches to ensure databases follow best practices and include the latest security improvements.
• Monitoring and Troubleshooting: Use monitoring tools and diagnose issues related to database performance and availability.
• Documentation: Maintain detailed documentation for database configurations, backup procedures, disaster recovery plans, and other related processes.
• Automation: Develop scripts and tools to automate repetitive database administration tasks.
• Support and Training: Provide second and third-level support to other IT teams and end users regarding database management.

Requirements

• Education: Bachelor's degree in Computer Science, Systems Engineering, or a related field. Microsoft SQL Server certification (e.g., MCSA or MCSE) is preferred.
• Experience: Minimum 3-5 years of experience in SQL Server database administration, including administration, security, optimization, and disaster recovery tasks.

Technical Skills

• Advanced experience with Microsoft SQL Server (recent versions, SQL Server 2016 and later).
• Proficient in T-SQL for writing and optimizing queries, stored procedures, and functions.
• Deep knowledge of high availability and disaster recovery (HA/DR) using Always On, Clustering, Replication, etc.
• Experience with database monitoring tools and automation solutions (PowerShell, SQL Server Management Studio, etc.).
• Knowledge of backup tools such as SQL Server Backup, Veeam, or similar.

Soft Skills

• Ability to work under pressure and resolve critical problems quickly.
• Excellent communication skills for technical interaction and collaboration with other departments.
• Proactive attitude and the ability to learn new database technologies.
• Desired: Experience with other database systems like MySQL, PostgreSQL, or NoSQL.

Benefits

• Health insurance.
• Ongoing training and certification opportunities.
• Flexible schedule.
• Opportunities for professional growth in a dynamic and high-tech environment.