Hire Bmc Remedy freelancers in United States
VVS - CV for "Production Support MSSQL DBA". V Vs, Websites, IT & Software
Technical Lead - Employee #- 51313308 HCL Technologies Dec 2009 – Jun 2019 (9 yrs 7 mos) Worked as Offshore Production Support MSSQL DBA for US based Healthcare Insurance company. Project Details :- =========== 1. HCSC DB INFRA SUPPORT. (Feb-17 to May-19). Duties And Responsibilities :- • Installation, Administration and Maintenance of SQL Server Instances. • Setup Test, Dev, Staging and Production Environments. • Create Users and assign permissions based on the level of database access the user would need. • Design database Backup and Restoration Strategy. • Once created the database Backups, monitor those backups are being performed regularly. • From time to time recover the databases to a specific point of time, as per the requests. • Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication) • Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured)) • Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc) • Documenting major changes to the SQL Servers. • Apply Service Packs & patches. • Database security administration. 2. NXP/FREESCALE DB INFRA SUPPORT. (May-14 to Jan-17). 3. BOI - TEST COE SQL CONSOLIDATION SUPPORT. (Jan-12 to Mar-14). 4. CBA - MF COE APPLICATION SUPPORT. (Jun-10 to Nov-11). 5. DB - LASER APPLICATION SUPPORT. (Jan-10 to May-10).
Websites, IT & Software
Microsoft SQL Server