Senior Database Adminstrator

  • Gurgaon, Noida
  • Confidential
  • 4-8 years
  • Views
  • 31 Oct 2018

  • IT/ Information Technology

  • Insurance
Job Description

Install, upgrade, configure, and administer SQL Server 2012/2014.
Configure databases, storage, memory, and network.
Analyze existing SQL queries for performance improvements.
Expertise in T-SQL writing complex stored procedures, triggers and functions.
Administration, performance monitoring, tuning, reporting, and root cause analysis
Expertise in T-SQL writing complex stored procedures, triggers and functions.
Develop capacity planning and benchmarking methods.
Plan and implement effective backup and restore strategy.
Implement advanced HA features.
Perform data movement and data refresh operations across environments.
Proactively monitor SQL Server workload and identify areas of improvement.
Optimize database performance.
Develop and implement robust security policies.
Support ongoing database maintenance tasks and implement automation.
Design SQL Server databases by following best practices.
Implement constraints, indexes, views, triggers, stored procedures, etc.
Diagnose concurrency issues.
Assist developers in building highly scalable applications.
Review application and database changes prior to deployments
Monitor and manage database sessions, jobs and scheduled tasks
Experience in monitoring database performance, generate session trace, AWR and ADDM reports and should be able to do first level
Excellent analytical and organizational skills. Ability to communicate and work professionally and effectively in a team environment
Assist with High availability and Disaster recovery setup, Database Health Checks and optimization, Monitoring and management setup/configuration,
Database and applications security, as well as Backup and recovery.
Should be able to work as Independent Resource.
Working with different stakeholders on ad-hoc projects and tool development.
Ensuring onshore communication is necessary, clear & precise ensuring quicker resolution of queries.

Job Posted By

About Organisation