SQL DBA

Job Description

Senior SQL Server DBA 9 to 12 Years of experience as an MS SQL Server DBA Lead or Similar role 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, and 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 Advanced skills and experience in database design, development, security, backup, recovery, performance tuning, and troubleshooting Leads and mentors junior DBAs, coordinates with other IT teams and communicates with stakeholders and clients. Maintain database integrity for cloud & locally hosted databases Setup Test, Dev, Staging, and Production Environments. (Installing SQL Server) Solve complex problems and develop a proof of concepts to validate ideas and technologies Perform in-depth system analysis, and recognize problems, opportunities, or underlying patterns and relationships. 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 Set up high availability as part of Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication, Always on) 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)