Talent.com
This job offer is not available in your country.
Algoleap Technologies - MS SQL Administrator - Cluster Configuration & Management

Algoleap Technologies - MS SQL Administrator - Cluster Configuration & Management

AlgoleapMumbai
10 days ago
Job description

JOB Description For MS SQL-L2

Customer Name : : : Database Management

Level (L1 / L2 / L3) : L2

Required Relevant Domain : Experience 3-6 years in Database

Job Type (Onsite / Remote) : Onsite

Shift details (General / 24X7) : General shift

Qualification : B.E. / Diploma / BSc Full Time (CSC and ECE). No gaps in Academics and No Distant Learning.

Certifications Required (if ANY) : Azure Certification on Requirement (If Any) Purpose : Database Management Services for enhancing the service quality to their business users.

Job Responsibilities :

MUST Have :

  • MS-SQL and working Knowledge of POSTGRESQL Administration and Management
  • MS-SQL Cluster Configuration and Management
  • Replication configuration between DC-DR in MS-SQL
  • Always-On Configuration and Troubleshooting Knowledge in MS-SQL
  • Configuration of Data Encryption
  • Tuning DB parameters
  • Hardening Parameters of MS-SQL / PostgreSQL
  • Monitor generated log and event files for messages indicating errors that will result in an incident
  • DR Database availability Monitoring
  • Report Status of Log Replications as per agreed schedules
  • Monitor the DB for failures and logged system events that indicate an imminent failure
  • Periodic config review to maintain consistent configurations
  • Review and recommendation to maintain availability
  • Monthly report on database availability
  • Monitor the DB for failures and logged system events that indicate an imminent failure
  • Reinstall Database software
  • Reconfigure log Shipping
  • Responding to database related incidents and drive corrective action
  • Correlate related incidents together into a problem ticket and manage through the problem management process
  • Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records
  • Restoration of database
  • Creating jobs / job schedule for routine / Maintenance jobs & Rebuilding of indexes
  • Purging database Logs and trace files & Performance Management
  • Defragmentation of Database and performance tuning
  • Manage all Service requests through the change management process
  • Automate administration tasks where possible
  • Manage and update all Database environment Skills / Knowledge requirement :
  • MS-SQL and PostgreSQL Administration
  • Replication Configuration (DC-DR) in MS-SQL
  • Database Parameter Tuning
  • Hardening MS-SQL and PostgreSQL
  • Disaster Recovery (DR) Database Monitoring
  • Reinstallation and Reconfiguration
  • Change Management for Service Requests

ref : hirist.tech)

Create a job alert for this search

Ms Sql Administrator • Mumbai