SQL Server DBA

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 :

Skills :

SQL,Server,Troubleshoot,Configure