hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

MSSQL DBA L3

10.00 to 15.00 Years   Chennai   14 Sep, 2020
Cambridge Technology Enterprises Ltd
Job LocationChennai
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaDBA / Datawarehousing
EmploymentTypeFull-time

Job Description

Key Roles Responsibilities:

  • Installing and Configuring the SQL Server 2005, 2008, 2008R2, 2012, 2014 2016.
  • Expertise in Database backup, Recovery, Restoration Disaster Recovery Plans, involved in DR Test.
  • Experience in automation of regular DBA maintenance activities using powershell and native DB scripts.
  • Experience in creating Maintenance plans, Jobs, Configuring Alerts using DB Mail and applying Service Packs for SQL Server and Hot fixes.
  • Co-ordinating with developers on data validation and creating SSIS package if required.
  • Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
  • Fixing the Login issues such as orphan users, logins and users creation in newly Installed instances and existing instances.
  • Configuring, Maintaining, and troubleshooting the Database Log Shipping as part of DR Plan.
  • Extensively worked on troubleshooting and implementing Database Mirroring and Always on.
  • Proficiency in implementing different types of Replication models like Snapshot, Transactional, and Merge Replications.
  • Hands on Experience in Configuring, Troubleshooting SQL failover Cluster to provide High Availability for the critical production service, which include (Active- Active, Active-Passive), and adding the nodes in the respective servers in SQL Server 2008, 2008R2, 2012 2016.
  • Good Experience in Performance tuning activities like handling the slow running queries.
  • Should have knowledge on Service Broker and CDC (Change Data Capture) Technologies.
  • Expert in automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
  • Strong Experience in Backup and Recovery strategy.
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Experience in setting up, trouble shooting and maintenance of production server.
  • Experience in providing Production support for Database and Applications.
  • Having experience configuration, migration and managing SSIS,SSRS and SSAS packages.
  • Migrated SQL server 2008 R2, SQL Server 2012 to SQL Server 2014, 2016 in Microsoft Windows Server 2012, 2016 Enterprise Edition.
  • 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.
  • Highly motivated with strong commitment to quality and customer service.
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Configuring Cluster and adding nodes to existing cluster setup when required.
  • Strong knowledge on Database security.
  • Creation of Azure SQL Database and integrate with Azure Active Directory.
  • Taking SQL server backup to Azure Blob storage.
  • Moving local SQL server database to Oracle cloud platform.
,

Keyskills :
sql databaserecovery planswindows servercustomer servicesql serverlog shippingshell scriptingsql server 2008active directorysql server 2012data validation

APPLY NOW

MSSQL DBA L3 Related Jobs

© 2019 Hireejobs All Rights Reserved