Senior SQL Database Administrator

Xerox - Jefferson City, MO

Full-time - Mid Level

Jefferson City, MO

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 managing backups, restores, replication, and recovery models. The Senior Database Administrator will also develop SQL jobs for data exports, purges, and error monitoring, and will implement high availability and disaster recovery options for MS SQL Server, such as database clustering and log shipping. Operational automation through scripting is also a critical aspect of this role, along with effective index management and statistics utilization. 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 position is integral to maintaining the integrity and performance of database systems within the organization, contributing to the overall success of Xerox's technology solutions.

Responsibilities

• Own, track, and resolve database-related incidents and requests.
• Fulfill requests and resolve incidents within established 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 effectively.
• Conduct performance tuning and optimization using native monitoring tools.
• Assist with backups, restores, replication, and recovery models.
• Develop SQL jobs for data exports, data purges, and error monitoring.
• Implement high availability and disaster recovery options for MS SQL Server.
• Automate operational tasks using scripts.
• Manage indexes and statistics for optimal database performance.

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.