Ms SQL Dba

Exp: 5+ yrs

Location: Sector 32, Gurgaon
• *Responsibilities**:

- Good understanding of the MS SQL 2016 database architecture related utilities and tools.
- Defining database standards and procedures to cover the instance parameters, object sizing, storage, and naming. The procedures define the process for install/upgrade, corporate database requirements, security, backup/recovery and automate the same.
- Knowledge of ALL Ms SQL backup, replication and recovery scenarios.
- Experience in code migration, database change management and data management through the various stages of the development life cycle.
- DBA should have sound communication skills with management, development teams, vendors and systems administrators.
- DBA should be able to work independently on P1 issues and prepare RCA documents.
- Good knowledge and hands on experience of Ms SQL high availability solutions.
- Create and manage multiple databases and assist in capacity planning.
- A good knowledge and hands on experience of Ms SQL Enterprise Edition 2016, and SSRS reports.
- Use tools for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
- Develop strategies and implement solutions for managing back-ups, restoration and replication.
- Developing database administration procedures and responsibilities for production systems.
- Coordinating upgrades of system software products to resolve any Ms SQL/operating system issues/conflicts.
- Provide off hours support, and maintenance as required, part of the 24x7 operations support on call rotations.

Schedule:

- Day shift

Application Question(s):

- How many years experience as Ms SQL DBA?
- what is your expected ctc?
- what is your notice period?
- Are you okay with Gurgaon location? work from office Read more