Senior Database Administrator Job in Akal
- S S Infratech
- 5 to 9 Yrs
- Delhi, NCR
- 7 days ago
- Email to a friend
- Report this job
Job Description
- Department- National Informatics Centre Delhi Designation- Senior Database Administrator Experience- 5+ years Location- Shastri Park, Delhi JD for Sql server database administrator: 1.Create new Microsoft SQL Server instances and configure them, including Always On availability groups and failover clustering 2. Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs 3. In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration 4. Assists in the selection of a database management system and the maintenance of database performance 5. Participate in continuous process improvement 6. Download and install SQL Server service packs and updates. 7. Configure and maintain SQL Security controls 8. Make recommendations for system architecture per Microsoft SQL Server best practices 9. Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer 10.Create, change, and improve SQL Server Agent tasks and maintenance plans 11.Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible 12.Troubleshoot application sluggishness and poor performance 13. In charge of T-SQL query tuning 14.In charge of database migrations and server updates 15.Create documentation and training for routine database administration activities, as well as train server operations employees on them 16.In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports 17.Integrate SQL Server with corporate applications 18.T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you. SnoSkillsets 1SQL Versions and their difference 2Auditing of SQL Server User running the Delete Command How to Identify : a Which User b Which IPc Which Application 3Database Backup 4Always ON a Distributed Always ON b How to manage SQL Jobs in Always ON c How to manage SQL Jobs in Distributed Always ON d Data Transfer from one drive to another without any Down time How to setup DR site using Always ON e Using Distributed Always ON for setting up of DR Site. f Data Configuration g Drives used to save the same file need to be same among primary and secondary replicas or can be different h Encryption/Decryption of Data 5Performance Related Activities Creation of Cluster Index a Column Store Index b Row Store Index In which scenario you use each of them 6In Memory Tables a Native Store Procedures in In Memory Tables b How to move Disk based table to In Memory Table 7How to handle Database Crash 8Data Replication from DC to DR Site 9SQL Server Security 10Differential Database 11SQL Guidelines for Password Policy 12Intigration between other Databases 13Prevention of Deadlock 14T Log Vs Tail Log Backup 15Permission Management in SQL 16Technology you use for High Availability,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Administration / Facility / Transport
Functional Area: Not Specified
Role/Responsibilies: Senior Database Administrator Job in Akal
Contact Details:
Company: Akal InformationLocation(s): Delhi, NCR
+ View Contact
Keyskills: Microsoft SQL Server TSQL ETL SQL Server Reporting Services Auditing Database Backup Performance Tuning High Availability
Fraud Alert to job seekers!
₹ Not Specified
S S Infratech
  We need new talented and experienced candidates from any part of the world to join us here in our company, We believe in hiring the best fit and helping our team members develop their professional careers within the Group. Please see below the current list of vacancies: Interested candidat...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in