Xerox Sr. Database Administrator - Remote in Rochester, New York

Xerox is the world's leading enterprise for business process and document management. Its services, technology, and expertise enable workplaces - from small businesses to large global enterprises - to simplify the way work gets done so they operate more effectively and focus more on what matters most: their real business. Xerox offers business process outsourcing and IT outsourcing services, including data processing, healthcare solutions, HR benefits management, finance support, transportation solutions, and customer relationship management services for commercial and government organizations worldwide. The company also provides extensive leading-edge document technology, services, software and genuine Xerox supplies for graphic communication and office printing environments of any size. Xerox serves clients in more than 160 countries. For more information, visit www.xerox.com, www.news.xerox.com, www.realbusiness.com or www.xerox.com/businessservices.

Summary:

Conduent is looking for an Oracle Application Database Administrator. The App DBA will be responsible for supporting Oracle database environments and supporting infrastructure, servers, storage and databases to ensure enterprise level performance, availability and security. The App DBA will support the delivery of solutions to production throughout the entire SDLC.

Duties Include:

  • Ensureall database servers are backed up in a way that meets the business’sRecovery Point Objectives (RPO)

  • Testbackups to ensure we can meet the business’ Recovery Time Objectives (RTO)

  • Troubleshootservice outages as they occur, including after-hours and weekends

  • Configureserver monitoring utilities to minimize false alarms and improve earlynotification of potential issues.

  • As newsystems are brought in-house, choose whether to use clustering, log shipping,mirroring or other technologies

  • Definerequirements and install and configure new servers

  • Deploydatabase change scripts provided by third party vendors

  • Whenperformance issues arise, determine the most effective way to increaseperformance including hardware purchases, server configuration changes, orindex/query changes

  • Documentthe company’s database environment

  • Ensurethat new database code meets company standards for readability,reliability, and performance

  • Eachweek, give developers a list of the top 10 most resource-intensive querieson the server and suggest ways to improve performance on each

  • Designindexes for existing applications, choosing when to add or remove indexes

  • Whenusers complain about the performance of a particular query, help developersimprove the performance of that query by tweaking it or modifying indexes

  • ConductDB server lunch-and-learn sessions for application developers

  • Advisedevelopers on the most efficient database designs (tables, datatypes,stored procedures, functions, etc)

Requiredskills :

  • On-calltroubleshooting experience with at least one production DB server for ayear. You don’t have to be the only DBA or have DBA in your jobdescription, but you should have been the one person that the companywould call if the DB server service stopped working.

  • Writingand improving SQL queries for at least a year. You may have technicallyhad “C# Developer” or “Java Developer” on your job title, but you wereknown amongst the office as the go-to person for SQL questions.

  • Designingtables and picking datatypes

  • UsingProfiler traces and other tools to find the most frequently run queries

DesiredSkills:

  • TuningSQL queries to improve performance

  • Troubleshootinghardware using tools like Dell OpenManage, HP System Insight Manager, andIBM Director

  • On-calltroubleshooting for DB Server service outages

  • Decidingwhether clustering, log shipping, mirroring, replication, etc are theright fit to solve a business problem

Xerox is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, sex, marital status, sexual orientation, physical or mental disability, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. People with disabilities who need a reasonable accommodation to apply or compete for employment with Xerox may request such accommodation(s) by sending an e-mail to accommodations@xerox.com. Be sure to include your name, the job you are interested in, and the accommodation you are seeking.

Job: Software Engineering

Organization: PS Transportation PDSI

Title: Sr. Database Administrator - Remote

Location: New York-Rochester

Requisition ID: 16030515

Virtual/work from home? Yes