Ms Sql Database Administrator

Job Title: MSSQL Server Database Administrator (4+ Years Experience)

COMPANY DESCRIPTION

CAMS

Besides serving as a B2B solutions partner, CAMS brings a unique ability of B2C to serve the end customers through a variety of touch points such as pan India network of Service centers, Call centre and Online Services. The company was incorporated in year 1988, has four back-office delivery centres in Chennai, Business Continuity Plan (BCP) site at Coimbatore and a Pan India network of 270+ customer service centres.

CAMS is a listed company and has Warburg Pincus LLC (a leading global private equity firm) and HDFC Group among its shareholders, headquartered in Chennai, India.

Website: https://camsonline.com

Role Summary

SQL Server DBA

Key Responsibilities

• Install, configure, and upgrade SQL Server instances (2012–2022)
• Monitor database performance and implement tuning strategies
• Manage backups, restores, and disaster recovery plans
• Set up and maintain high availability solutions (Always On, Log Shipping, Replication)
• Implement and enforce database security policies and access controls
• Automate maintenance tasks using SQL Server Agent and PowerShell
• Troubleshoot database issues including deadlocks, blocking, and slow queries
• Collaborate with developers to optimize queries and support deployments
• Maintain documentation for database architecture, procedures, and policies

Required Skills

• Strong expertise in

  SQL Server Management Studio (SSMS)

  and

  T-SQL

• Experience with

  backup/restore strategies

  ,

  recovery models

  , and

  maintenance plans

• Familiarity with

  SQL Server Integration Services (SSIS)

  and

  SQL Server Reporting Services (SSRS)

• Knowledge of

  performance tuning

  ,

  indexing

  , and

  execution plans

• Proficiency in

  security management

  , including roles, permissions, and auditing
• Hands-on experience with

  monitoring tools

  like SQL Profiler, Extended Events, or third-party solutions

Additional Skills

• Knowledge and hands on

  PostgreSQL

• Shell

  scripting
• Azure/ AWS

  Cloud

  experience in data management

• Automation

• Lead experience

Preferred Qualifications

• Bachelor’s degree

  in computer science, Information Technology, or related field
• Certifications such as

  MCSA: SQL Server

  ,

  MCSE: Data Platform

  , or

  Azure Database Administrator Associate

• Experience with

  cloud-based SQL Server deployments

  (Azure SQL, AWS RDS)
• Familiarity with

  DevOps practices

  and

  CI/CD pipelines

  for database changes

Career Growth Opportunities

With 5 years of experience, this role can evolve into:

• Lead DBA

• Database Architect

• Cloud Database Administrator

• Data Platform Engineer

Kindly share your relevant Profiles to swetha.n@camsonline.com