Lead SQL Server Administrator

Sr. SQL Server Database Administrator

Roles and Responsibilities :

• Collaborate closely with Application Developers to design, test, implement, optimize, and maintain efficient transactional and analytical data models.
• Lead and engage in tuning, upgrade, and configuration projects to enhance database performance and ensure stability.
• Optimize and manage backup jobs and schedules, while maintaining Production, Disaster Recovery (DR), and Development environments.
• Troubleshoot database and data-related issues as they arise.
• Provide ad-hoc data reporting and data extraction for Analytics teams.
• Perform various ad-hoc data loading and manipulation tasks as needed.
• Manage routine data exports for clients, partners, and Subject Matter Experts (SMEs).
• Create and manage scheduled tasks and data processing scripts.
• Document data collection, processing, and presentation procedures.
• Support the architecture and process flow diagrams for data systems.
• Participate in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies.
• Manage all levels of database security and integrity, including transaction activity and utilization.
• Define and document policies, procedures, and standards related to database administration.
• Troubleshoot database issues, perform recovery, tune the database, install software, and resolve SQL Server errors and failures.
• Facilitate database backup and recovery, documenting and testing all backup and recovery procedures.
• Ensure service level availability for all production and non-production SQL Server environments.

Required Technical and Professional Expertise :