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)