Senior Sql Database Administrator

Senior SQL Server DBA

• 12 to 15 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)