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)
