Roles and Responsibilities

• Work closely with Application Developers to design, test, implement, perfect and maintain efficient transactional and analytical data models
• Lead/engage in tuning, upgrade, and configuration projects to enhance performance and ensure stability
• Optimize and keep backup jobs and schedules as well as maintain Production, DR and Development environments
• Troubleshoot database and data issues as they occur
• Supply Ad Hoc data reporting and data pulls for Analytics teams
• Perform various ad-hoc data loading and data manipulation tasks
• Manage routine data exports for clients, partners, and SMEs
• Create and manage scheduled tasks and data processing scripts
• Document data collection, processing, and presentation procedures
• Help support architecture and process flow diagrams for data systems
• Participates in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies.
• Manage all levels of database security and integrity, transaction activity and utilization.
• Responsible for defining and documenting policies, procedures, and standards related to database administration.
• Responsibilities include troubleshooting database issues, recovery, tuning of the database, software installation, resolving SQL Server errors and failures.
• Facilitate database backup and recovery as well as documenting and testing all backup and recovery procedures.
• Responsible for service level availability for all production and non-production SQL Server environments

Required Technical and Professional Expertise

• Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)
• Disaster Recovery
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)
• Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
• Work as part of a team and provide 24x7 support
• Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
• From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)
• Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication, Always on)
• 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 those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
• Documenting major changes to the SQL Servers. (General)
• Apply Service Packs. (General)