Xerox - Boston, MA

posted about 2 months ago

Full-time - Mid Level
Boston, MA
Machinery Manufacturing

About the position

The Senior SQL Database Administrator at Xerox Holdings Corporation plays a crucial role in managing and optimizing database systems to ensure high availability and performance. This position 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 be responsible for reviewing service-related reports daily, including database backups, maintenance, and monitoring, to identify and resolve any service-related issues promptly. Additionally, the role requires responding to database alerts and escalations, collaborating with application developers and systems engineers to devise strategic solutions for recurring problems. Key responsibilities include Microsoft SQL Server Database Administration, troubleshooting and resolving database issues, and performance tuning and optimization using native monitoring and troubleshooting tools. The administrator will also be involved in error identification, analysis, and remediation, as well as assisting with backups, restores, replication, and recovery models. Developing SQL jobs for data exports, data purges, and error monitoring is also a critical part of the role, along with performing High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server, including database clustering and log shipping. The position also requires implementing operational automation using scripts and managing indexes and statistics effectively. The ideal candidate will have a strong background in IT operations, particularly with Microsoft SQL Server, and will be expected to contribute actively to the application deployment team, deploying code to various environments such as Test, UAT, or production. The role demands excellent communication skills, strong customer relationship management abilities, and the capacity to thrive in a fast-paced team environment.

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 service-related issues.
  • Respond to database-related alerts and escalations.
  • Collaborate with application developers and systems engineers to devise strategic solutions for recurring problems.
  • Perform Microsoft SQL Server Database Administration tasks.
  • Troubleshoot and resolve database problems.
  • Conduct Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting 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.
  • Investigate and resolve job failures.
  • Perform High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server, including database clustering and log shipping.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service