Senior Database Administrator - Sql/t-sql

  • Gurgaon, Noida
  • Confidential
  • 5-8 years
  • Views
  • 13 Jun 2019

  • IT/ Information Technology

  • Consumer Durables/ Semi Durables
Job Description

Position Title : Sr. Database Administrator
Job Description Summary :
As part of the SQL Server Database Administrator team your roles and responsibilities will include but not be limited to the following :
- The SQL Server DBA will provide core technical expertise to support and manage SQL Server in a highly challenging environment.
- The DBA will primarily serve SQL Server databases
- Expert in writing complex queries.
Responsibilities :
- 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.
Location : Gurgaon/ Noida
Qualification & Experience required (including key competencies) :
- Graduation
- 5-8 years of relevant experience
- Should be a good team player

Job Posted By

About Organisation