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.
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.
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)
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
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 email@example.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