Job Description :
We are seeking a highly skilled and experienced SQL Server Database Administrator (DBA) to manage, maintain, and ensure the optimal performance, availability, and security of our critical SQL Server database environments. The ideal candidate will be a proactive problem-solver with a deep understanding of SQL Server technologies and best practices, dedicated to maintaining robust and efficient database systems.
Key Responsibilities :
- Install, configure, and upgrade SQL Server instances (including applying patches and service packs).
- Perform routine database maintenance tasks such as index rebuilding / reorganization, statistics updates, and integrity checks.
- Monitor database performance, identify bottlenecks, and implement solutions for performance tuning and query optimization (e.g., query plan analysis, indexing strategies).
- Manage database objects (tables, views, stored procedures, functions, triggers, etc.) and schema changes.
- Monitor and manage database storage, ensuring sufficient disk space and efficient utilization.
- Implement and manage SQL Server security, including user authentication, role-based access control, and encryption.
- Monitor security logs, identify potential vulnerabilities, and ensure compliance with security policies and regulations.
- Manage database permissions and logins for various users and applications.
- Proactively monitor SQL Server health, performance, and resource utilization using tools like SQL Server Management Studio (SSMS), SQL Server Profiler, Extended Events, and third-party monitoring solutions.
- Diagnose and resolve complex database-related incidents and problems in real-time, providing root cause analysis and implementing corrective actions.
- Configure and manage alerts for critical database events.
- Collaborate closely with development teams, system administrators, network engineers, and other stakeholders to ensure efficient database operations and support application needs.
- Assist developers with T-SQL query tuning and schema refinement.
- Provide 24x7 on-call support for critical production systems (if applicable).
- Document database configurations, processes, and troubleshooting steps thoroughly.
- Identify opportunities for automation of routine DBA tasks using PowerShell, T-SQL scripting, or other tools.
- Contribute to the continuous improvement of database administration processes and standards.
Professional Skills :
Bachelor's degree in Computer Science, Information Technology, or a related field.7+ years of experience as a SQL Server DBA or in a similar role.In-depth knowledge of Microsoft SQL Server versions [specify versions, e.g., 2016, 2019, 2022] including installation, configuration, and administration.Strong proficiency in T-SQL for querying, scripting, and troubleshooting.Extensive experience with SQL Server performance tuning and optimization techniques.Proven experience with High Availability (HA) and Disaster Recovery (DR) solutions (e.g., Always On Availability Groups, Clustering, Log Shipping).Solid understanding of database security best practices and implementation.Experience with SQL Server tools (SSMS, SQL Server Profiler, DTA).Familiarity with Windows Server environments and Active Directory.Strong problem-solving and analytical skills with meticulous attention to detail.Excellent communication and interpersonal skills, with the ability to explain complex technical concepts clearly.Ability to work independently and as part of a team, managing multiple priorities effectively.Skills :
SQL,Server,Troubleshoot,Configure