Senior SQL Database Administrator

Xerox - Trenton, NJ

Full-time - Mid Level

Trenton, NJ

Machinery Manufacturing

About the position

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, to identify and resolve any 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. The role also encompasses performing High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server, including database clustering and log shipping, and implementing operational automation through scripting. The use of indexes, index management, and statistics is also a critical part of the job. The ideal candidate will have a strong background in IT operations, particularly with Microsoft SQL Server, and will be expected to actively participate in the application deployment team, deploying code to various environments such as Test, UAT, or production. This position is integral to maintaining the integrity and performance of the database systems that support Xerox's business operations.

Responsibilities

• Own, track, and resolve database-related incidents and requests.
• Fulfill requests and resolve incidents within SLAs.
• Review service-related reports daily to identify and resolve issues.
• Respond to database-related alerts and escalations.
• Collaborate with application developers and systems engineers to find strategic solutions to recurring problems.
• Perform Microsoft SQL Server Database Administration tasks.
• Troubleshoot and resolve database problems.
• Conduct Performance Tuning and Optimization (PTO) using native tools.
• Identify, analyze, and remediate errors in the database.
• Assist with backups, restores, replication, and recovery models.
• Develop SQL Jobs for data exports, data purges, and error monitoring.
• Perform High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server.
• Implement operational automation using scripts.
• Manage indexes, index management, and statistics.

Requirements

• Bachelor's degree in Computer Science, Business Administration, Information Technology, or related field preferred.
• 7+ years of IT operations experience with a strong understanding of database structures, theories, principles, and practices.
• 7+ years of experience with Microsoft SQL Server.
• Understanding of server-client computing and relational database environments.
• Experience with data management and data processing techniques.
• Knowledge of reporting and query tools and practices.
• Application development experience in technologies such as MS Commerce Server, Content Management Systems, .NET, AJAX, and jQuery.
• Active participation in the application deployment team, responsible for deploying code to Test, UAT, or production environments.
• Experience working in an enterprise-level eCommerce environment.
• Involvement with the MS SQL Server Community, active in forums or newsgroups.

Nice-to-haves

• Strong communication skills.
• Excellent customer relationship skills.
• Ability to work in a fast-paced team environment.
• Proficient in Microsoft Office.

Benefits

• Comprehensive suite of benefits including health insurance, retirement plans, and paid time off.