- Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups
- and failover clustering.
- Highly skilled at database design, installations, conversions Responsible for database backup and
- recovery procedures, access security and database integrity, physical data storage design and
- data storage management
- Participates in Database Management System selection and maintains database performance
- Engage in ongoing process improvement
- Experienced in Database Performance, Maintenance and Development to perform the following:
a) Database management including backups, recovery and maintenance
b) Database management for export, import and mass data loads
c) Analyzes and generation of all tables and index statistics
d) Monitoring and resolving data lock issues
e) Check all statistics related to memory, locks, I/O, database response time, wait events, top
sessions and background processes
f) On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of
transactions
g) Create indexes to achieve critical dataset response time for time sensitive reports.
- Install SQL Server service packs and updates.
a) Configure and manage SQL Security settings.
b) Make system design recommendations according to Microsoft SQL Server best practices.
c) Manage database backup & recovery & DR planning.
d) Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
e) Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.