Job Description Bangalore
MSSQLInstallation and Configuration of SQL Server Pre-requisites.
SQL Server Database Basic Administration and Latest Features.
SQL Server user account management
- Test and Apply Patches.
- Migrate Databases.
Database Resource Management and Task Scheduling. Capacity Planning in terms of Growth of Database.
Experience in basic Performance Tuning and Monitoring. Availability Management for Databases.
Handling of daily issues (Blockings, Long running transaction, Deadlocks etc.) Good understanding of Transact SQL.
Automating SQL Server tasks (SQL Jobs, Windows scripts, etc.) Troubleshoot issues related to Temp DB and System Database Basic Knowledge of SSIS, SSRS.
Very good knowledge on SSIS, SSRS and SSAS and one should able to handle MSBI activities.
One should able to deploy the package on production server
Knowledge and troubleshooting Issues related to HA.
Scheduling Database Backups, taking full and Transaction Log Backups.
Job Description -
The SQLServer DBA/Administrator will be responsible for the day to day operations, performance tuning, automation of processes where feasible and the general support for development and production environments ; i.e. workflows, network typology, capacity planning, server updates, routine changes to database operations, logic, user access, and enhancements.
This is a "hands-on role requiring strong technical aptitude and excellent communication skills.
The incumbent must be able to work in a 24x7 queue environment.
Strong experience in Database Administration in SQL Server
Strong communication and negotiation skills with experience in dealing with application leads and management for application DBA engagements requiring enforcement of established company database policies and standards.
Strong Knowledge and experience with scripting languages like PowerShell, VBScript, WSH
Experience in troubleshooting and resolving database integrity issues, performance issues,