Search Jobs

SQL DBA

This requirement is valid till 20-09-2019

Required Skills:

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




Skillset: 
  • Experience 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


By Location

Overseas