Search Jobs

SQL DBA

This requirement is valid till 13-12-2019

Required Skills:

  SQL
Location:  Bangalore
Domain:  IT & ITES
Qualification:  Any Degree
Experience:  3-5 yrs.
Job Description with Roles & Responsibilities: 
  • xperience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Excellent written and verbal communication
  • Ability to multi-task and context-switch effectively between different activities and teams
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
  • Migrated SQL server 2008 to SQL Server 2012/2014/2016 in Microsoft Windows Server 2012 Enterprise Edition.
  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases

 


Skillset: 
  • xperience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Excellent written and verbal communication
  • Ability to multi-task and context-switch effectively between different activities and teams
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
  • Migrated SQL server 2008 to SQL Server 2012/2014/2016 in Microsoft Windows Server 2012 Enterprise Edition.
  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases

 


 

Login to Apply