eClerx - Senior Database Administrator - SQL Server (12-15 yrs)

Role : Senior SQL Server DBA.

Job Description :

- 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)