SQL Server Database Administrator

**Job Title: SQL Server Database Administrator (DBA)**

**Location**: [Insert Location]
**Work Type**: Full-Time Employee (FTE), Contract to **Vtricks Technologies**
**Experience**: 5+ years as a SQL Server DBA
**Preferred**:Immediate Joiners**

**Job Summary**:
**Key Responsibilities**:
**1. Database Patching and Configuration**:

- Plan, test, and execute **database patching** for SQL Server environments to ensure **security** and **stability**.
- Troubleshoot SQL Server configurations and ensure **high availability** and **disaster recovery** mechanisms (e.g., AlwaysOn, Clustering, Log Shipping, Replication) are in place.

**2. Performance Optimization**:

- Continuously monitor **database performance**, identify bottlenecks, and implement **query tuning** strategies to improve efficiency and reduce latency.
- Address issues related to **slow queries**, **index fragmentation**, **locking and blocking**, and **hardware limitations**.
- Use **monitoring tools** (e.g., SQL Server Profiler, Extended Events) to detect performance issues and implement corrective actions.

**3. Hardware and System Changes**:

- Collaborate with IT infrastructure teams to evaluate and upgrade **hardware configurations** to ensure **optimal performance**.
- Plan and coordinate **hardware changes** with mínimal disruption to business operations.
- Assess and mitigate the impact of hardware changes on **database performance** and **availability**.

**4. Collaboration with Development Teams**:

- Work closely with developers to review, optimize, and approve **SQL code** and **database schema** changes.
- Provide guidance on **indexing**, **query optimization**, and best practices for **database design**.
- Develop and communicate **database improvement plans** and potential risks associated with changes.

**5. Risk Assessment and Change Management**:

- Evaluate risks associated with **database modifications** and **patching**, and develop strategies to minimize these risks.
- Implement and enforce **change management processes** to ensure thorough testing and minimize disruptions to production environments.
- Maintain detailed documentation of all changes, optimizations, and upgrades for future reference.

**6. Database Maintenance and Troubleshooting**:

- Perform regular **database maintenance tasks** such as backups, restores, indexing, and integrity checks.
- Troubleshoot and resolve database incidents and problems within defined **SLAs**.
- Conduct **root cause analysis** for recurring issues and implement long-term solutions to improve **database stability**.

**Requirements**:
**Education**:

- Bachelor’s degree in **Computer Science**, **Information Technology**, or a related field, or equivalent experience.

**Experience**:

- Minimum of **5 years** of experience as a **SQL Server DBA**.
- Proven experience with **database patching**, **configuration**, and **performance tuning**.
- Strong understanding of **SQL Server internals**, database architecture, and hardware requirements.

**Technical Skills**:

- Proficiency with **SQL Server** (versions 2016 and later).
- Strong knowledge of **indexing**, **query optimization**, and **performance tuning** techniques.
- Familiarity with **SQL Server monitoring and profiling tools**.
- Experience with **high availability** and **disaster recovery** solutions (e.g., AlwaysOn, Clustering, Log Shipping, Replication).
- Understanding of **Windows Server environments** and **hardware configurations** for database performance.
- Working knowledge of cloud platforms like **Azure SQL** or **AWS RDS** is a plus.

**Soft Skills**:

- Excellent **analytical** and **problem-solving skills**.
- Strong **interpersonal skills** with the ability to explain complex technical concepts to non-technical stakeholders.
- Ability to **collaborate effectively** with developers, infrastructure teams, and other stakeholders.
- **Detail-oriented**, **proactive**, and able to manage multiple tasks simultaneously.

**Preferred Qualifications**:

- **Certifications**: Microsoft Certified**:Azure Database Administrator Associate**, **MCSA: SQL Server**, or similar certifications.
- **Scripting Knowledge**: Proficiency in **PowerShell** or **T-SQL** for automation and scripting tasks.
- **SQL Server on Linux**: Familiarity with running **SQL Server on Linux** environments.
- **Immediate joiners** are preferred to minimize downtime and ensure timely project delivery.

**Job Types**: Full-time, Permanent

Pay: ₹1,389,791.54 - ₹1,936,035.38 per year

**Benefits**:

- Health insurance
- Provident Fund

Schedule:

- Day shift
- Monday to Friday
- Morning shift

Supplemental Pay:

- Performance bonus

**Experience**:

- SQL Server Database Administrator: 5 years (required)

Work Location: In person