Sign In
 [New User? Sign Up]
Mobile Version

MSSQL Database Administration

Bengaluru, KA
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Candidate should have3 to 5 years of experience in database Administration and support in MS SQL Server environments.Strong experience in Database Administration in SQL Server ( 2005 and 2008 )Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.Expert experience in implementing operational automation.Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )Solid acquaintance with windows server, security delegation, SPNs, storage components.Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )SQL Database Operational support to tech usersPreferred MCSA/MSCE certificationKnowledge in a scripting language like Powershell, VBScript, WSHIncident Management Resolve single and cross technology incidents independently. Work with team members to resolve unusually complex or cross technology incidents.Installation, configuration of SQL Server, including AlwaysOn Availability GroupsRequired Skill MCSA / MCSE certification is must.Knowledge in a scripting language like PowerShell, VBScript Scripting.Understanding of the challenges associated with cross-platform development and support.Outstanding Python development and optimization skills.Excellent understanding of design techniques.Able to create, document, and maintain TDDs and programming schedules.Work directly with customers to provide in-depth technical troubleshooting and recommend appropriate workaround(s) and solutions for all product lines and open-source productsApply best practices, strategies, methodologies and approaches to medium to large scale projects.Playing a key role in designing, developing, and implementing the infrastructure for various products.Each project will require various technical skills and requires a well-rounded and adaptable individual.Experience with open source ETL. Experience with Open Source Database Tools.
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering) | B.Sc. (Science)

Experience: 3-5


Business/Systems Analysis | Configuration/Release Mgmt | Database Administration (DBA) | System Administration
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News