Database Administrator-SQL Server

Job Title:

Database Administrator (DBA)

Experience:

4 to 6 years

Location:

Pune, Work From Office

Job Type:

Full-time

Summary:

We are seeking an experienced

Database Administrator

with hands-on expertise in

Microsoft SQL Server

to manage, optimize, and ensure the high performance, availability, and security of our enterprise databases. The ideal candidate will have a strong understanding of SQL, database design principles, and performance tuning, with experience in maintaining multiple environments and driving database-related initiatives.Requirements

• Proven experience as a

  Database Administrator

  with hands-on expertise in managing Microsoft SQL Server & Databases
• Strong knowledge of SQL and database design principles, with familiarity across various DBMS platforms.
  
• Strong command of

  SQL, T-SQL

  and potentially Shell scripting for automation
• Experience in setting up various

  High Availability (HA)

  solutions as part of a

  Disaster Recovery Strategy

  for enterprise databases.
• Establishing and managing

  database backup and recovery

  processes to ensure data integrity and availability
• Monitoring database performance, identifying bottlenecks, and implementing tuning strategies to optimize query execution and resource utilization.
  
• Proficiency with

  SSIS

  (SQL Server Integration Services) and

  SSRS

  (SQL Server Reporting Services).
• Experience with

  Windows and SQL Server clustering

  for high availability and failover configurations.
• Expertise in creating and managing tables, views, stored procedures, functions, triggers, indexes, and other database objects
  
• Experience with

  query optimization, analyzing execution plans

  , indexing strategies, and using tools like SQL Profiler

• Develop

  and optimize complex SQL queries, stored procedures, and functions.
• Proven ability to maintain and manage a four-environment landscapeDevelopment (DEV), Quality Assurance (QA), User Acceptance Testing (UAT), and Production (PROD)to support multiple teams and deployment workflows.
  
• Developing and enforcing data security policies to protect sensitive information
  
• Leading and executing database migration projects
  
• Excellent analytical and problem-solving skills to troubleshoot and resolve complex database-related issues.
  
• Strong verbal and written communication skills for effective collaboration with cross-functional teams and thorough documentation of processes and procedures.
  

Qualifications

• Bachelor's degree