SQL Server Production Dba

**Job Title: SQL Server Production DBA**

**Job Type: Long Term Contract**

**Experience Level: Mid-Level (7-9)**

**Work mode: Remote**

Job Summary:
We are seeking an experienced SQL Server Production DBA with Postgres SQL

knowledge who will be responsible for ensuring the availability, security, and performance

of our databases. This role involves handling production DBA responsibilities, disaster

recovery (DR), data migration, SSIS, SSRS, and import/export processes. This role with

other team members to ensure 100% uptime, plan future capacity requirements, maintain

analysing, troubleshooting, and designing vital services, platforms, and infrastructure while

always thinking about reliability, scalability, resilience, security, and performance.

**Key Responsibilities**:

- Manage SQL Server production environments, ensuring high availability and

security.

other database technologies.
- Implement and maintain backup and disaster recovery (DR) strategies.
- Perform database migrations, upgrades, and patching.
- Optimize query performance, indexing, and database tuning.
- Develop and maintain SSIS packages for ETL operations and data import/export.
- Generate and maintain reports using SSRS.
- Troubleshoot and resolve database performance, connectivity, and security

issues.
- Implement replication, mirroring, and clustering for high availability.
- Perform capacity planning, monitoring, and proactive maintenance.
- Work closely with Application Developers to design, test, implement, perfect and

maintain efficient transactional and analytical data models. Participates in SQL code
- Lead/engage in tuning, upgrade, and configuration projects to enhance performance

and ensure stability
- Supply Ad Hoc data reporting and data pulls for Analytics teams
- Perform various ad-hoc data loading and data manipulation tasks
- Help support architecture and process flow diagrams for data systems
- Participates in the evaluation, design, implementation, maintenance, support, and

enhancement of sophisticated database systems and technologies.
- Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)
- Once created the database Backups, monitor those backups are being performed

regularly. (SQL Server Agent)
- From time to time recover the databases to a specific point of time, as per the

requests. (Database Backups and Recovery)

**Qualifications & Skills**:

- 7-9 years of experience as a SQL Server DBA in a production environment.
- Expertise in SQL Server 2016 and above.
- Strong experience with SSIS, SSRS, and data import/export processes.
- Knowledge of database security, backup, and disaster recovery (DR) strategies.
- Experience with high availability solutions (clustering, mirroring, log shipping,

Always On Availability Groups).
- Strong knowledge of T-SQL, query optimization, and performance tuning.
- Experience with database migrations and upgrades.
- Familiarity with Windows Server administration and PowerShell scripting is a

plus.
- Familiarity with Data lake is a plus.
- Excellent troubleshooting and problem-solving skills.
- Strong organizational and communication skills and coordination skills and able to

work efficiently under pressure.
- Experience with MS Azure and MS Azure managed instance databases.

Documented hands-on expertise managing high-volume instances of MS SQL setups

featuring high availability.

Nice-to-have:

- Experience with CI/CD in cloud environments and container technology, Docker and

Kubernetes, Docker Swarm
- Experience in telecommunication and networking environment is an asset.
- Postgres SQL management.

**Job Type**: Contractual / Temporary
Contract length: 14 months

Pay: ₹101,137.50 - ₹161,820.00 per month

Work Location: Remote