SQL Server DBA

Pune, India

Posted 4 weeks ago

Educational Qualification: B.S. or higher in Computer Science, Engineering

Experience: 5 – 10 years

Location: Pune

Job Description:

  • 3+ years of experience with performing as a DBA for SQL servers, including performing installations and scheduling and managing backup, recovery, tuning, and other maintenance activities
  • Experience with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
  • Experience with performance tuning, query optimization, Performance Monitor, SQL Profiler, and equivalent monitoring and troubleshooting tools
  • Knowledge of indexes, index management, integrity checks, configuration, and patching and how statistics work, how indexes are stored, and how they can be created and managed effectively
  • Knowledge of SQL server tools, including Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system sprocs
  • Knowledge of SQL, stored procedures, and best practices for schemas and ETIs
  • Ability to detect and troubleshoot SQL Server CPU, memory, I/O, disk space, and other resource contentions
  • Advanced working knowledge of SQL and multiple versions of Microsoft SQL Server (2005, 2008, 2008 R2 and higher)
  • Microsoft Certifications a Plus (MCITP SQL 2008, etc.)
  • Understanding of SSIS integration with database systems including use of credentials and proxies.
  • Experience conducting database migrations between different platforms
  • Experience upgrading databases from lower versions to latest versions of the database
  • Background with database administration running on ASM storage
  • Background in Develop/Test backup/restore shell scripts and implement in production systems
  • Solid experience in setting up Dataguard/Standby environments using ASM storage
  • Bachelor’s degree in related technical discipline and 10+years of experience
  • Minimum 4+ years of experience with logical/physical data design

Mandatory Skills:  

  • DBA for SQL servers, including performing installations and scheduling and managing backup, recovery, tuning, and other maintenance activities
  • Experience with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
  • Experience with performance tuning, query optimization, Performance Monitor, SQL Profiler, and equivalent monitoring and troubleshooting tools
  • Knowledge of indexes, index management, integrity checks, configuration, and patching and how statistics work, how indexes are stored, and how they can be created and managed effectively
  • Knowledge of SQL server tools, including Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system sprocs
  • Advanced working knowledge of SQL and multiple versions of Microsoft SQL Server (2005, 2008, 2008 R2 and higher)

Preferred Skills:

  • Microsoft Certifications a Plus (MCITP SQL 2008, etc.)
  • Strong Experience with RAC (Real Application Clusters)
  • Experience with Oracle backup and recovery
  • Experience with Storage management, including Oracle ASM
  • Experience with Unix operating system and Unix scripting
  • Experience with Oracle 12c

 

Apply Now

A valid email address is required.
A valid phone number is required.