Xerox - Providence, RI
posted 3 months ago
The Senior SQL Database Administrator at Xerox is responsible for managing and optimizing Microsoft SQL Server databases to ensure high availability and performance. This role involves owning, tracking, and resolving database-related incidents and requests, ensuring that all tasks are completed within established service level agreements (SLAs). The administrator will review service-related reports daily, including database backups and maintenance logs, to identify and resolve any service-related issues promptly. Additionally, the position requires responding to database alerts and escalations, collaborating with application developers and systems engineers to devise strategic solutions for recurring problems. Key responsibilities include troubleshooting and resolving database problems, performance tuning and optimization using native monitoring tools, and error identification and remediation. The administrator will assist with backups, restores, replication, and recovery models, as well as develop SQL jobs for data exports, purges, and error monitoring. Implementing high availability and disaster recovery options for MS SQL Server, including database clustering and log shipping, is also a critical aspect of this role. Furthermore, the position involves operational automation through scripting and effective index management. The ideal candidate will have a strong background in IT operations, particularly with Microsoft SQL Server, and will be expected to actively participate in application deployment, ensuring smooth transitions to testing and production environments. This role is essential in maintaining the integrity and performance of database systems within the organization, contributing to the overall efficiency of business operations.