MSSQL Database Administrator

Job Responsiblities: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

Desired Skill:1) MS-SQL and working Knowledge of POSTGRESQL Administration and Management 2) MS-SQL Cluster Configuration and Management 3) Replication configuration between DC-DR in MS-SQL 4) Always-On Configuration and Troubleshooting Knowledge in MS-SQL 5) Configuration of Data Encryption 6) Tuning DB parameters 7) Hardening Parameters of MS-SQL/PostgreSQL.

Relevant Experience:3-6 years in Database