Microsoft SQL Data Base Specialist

Job Objective

The Microsoft SQL Database Specialist will be responsible for the administration optimization security and maintenance of the organizations 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 thirdlevel support to other IT teams and end users regarding database management.

Requirements

• Education: Bachelors degree in Computer Science Systems Engineering or a related field. Microsoft SQL Server certification (e.g. MCSA or MCSE) is preferred.
• Experience: Minimum 35 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 TSQL 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 hightech environment.