Job Title: Senior MS SQL Database Administrator

Location: Magarpatta, Pune


Requirements / Qualifications:

  • Bachelor’s or master’s degree in computer science or equivalent education and experience.
  • 10+ years’ experience in administering Microsoft SQL server databases (SQL Server 2012 and above).
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
  • Ability to develop procedure documents and maintain detailed database related documents.

 Key Areas of Responsibility:

  • Create and manage multiple databases and assist in capacity planning.
  • Monitor, maintain database systems and troubleshoot problems that may arise.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
  • Monitor, maintain back-ups, restoration and replication.
  • Support software developers to transport SQL Objects to production.
  • Proactive housekeeping/archiving and shrinking of databases.
  • Manage production, QA and development database environments.
  • Create detailed documentation including diagrams of database infrastructure.
  • Effectively coordinate and communicate with all the stakeholders (internal technical teams).