Senior Database Engineer

Job Description Behind every great on-line eCommerce site and technology service is an equally great database. These databases provide mission-critical data processing services, and it takes highly skilled DBAs to build and maintain these systems. To meet the challenges of fast-growing business products and service lines, we need to grow our DBA team. We’re looking for exceptional DBAs who are interested in using the latest database technologies to deliver industry-leading systems, with results that go directly to the bottom line. Thomson Reuters (TR) is the world’s largest international multimedia company. With approximately 20,000 employees, TR has more than 300 offices in 93 countries. The technology organization within TR is a centralized unit providing shared software and services to TR business units across the globe. We are looking to add a Database Engineer to our ORACLE Support database team. This global team interacts directly with key technical groups, collaborating to implement change and provide support for major database systems that deliver data to the critical, revenue generating applications that drive the TR business. MAJOR AREAS OF ACCOUNTABILITY Technology (70%) Database Support Provide in-depth critical support for Postgresql databases which will be mostly in the Performance Tuning and administration Provide Cloud – EC2 and Aurora RDS database support on Postgresql and Oracle databases. Provide primary support for critical, complex production Oracle databases Troubleshoot, investigate, and drive the resolution of incidents Administration of Oracle on Unix/Linux environments Perform Oracle Systems Database Administration across multiple Postgresql and Oracle database environments and ensure continuous 24x7 operation and availability in support of mission-critical internal production applications. Strong operational familiarity with RAC on Oracle 11g/12c and above. Perform various project-related database requests for customers. Tasks can include DDL generation, cloning, schema and/or table-level data refreshes, and performance tuning. Support database backup/recovery using storage technologies such as NAS and RMAN etc. Collaborate with application/development partners to address performance reported issues. Manage backup/recovery and provide Disaster Recovery planning. Contribute/write/maintain OS-level scripts (i.e., UNIX shell) for system DB maintenance. Ensure the quality and consistency of data and database systems by following a defined set of procedures (change control, security procedures, user passwords, backups, etc). Contribute to the continued development and documentation of operational and application related database standards and procedures Pro-actively identify database issues and resolutions. Assume ownership of database related problems; work closely with internal technical teams to pursue problem resolution and root cause analysis Coordinate interaction with vendors, creating service requests and escalating as needed to ensure timely resolution Provide problem management and resolution for repeat issues Make recommendations and contribute to the design and development of long-term solutions Respond to inquiries from business partners related to performance, application errors, storage capacity, etc. Participate in new system builds; create databases, schemas and deploy standard jobs and monitoring, and user permissions and login administration. Through review and solid handoffs, ensure system supportability prior to production utilization Adhere to documented change and incident management policies Use established Shared Services support processes and tools to document and track problem resolution Develop technical documentation for use in future incident resolution Provide support outside of normal office hours when necessary and appropriate to support major database implementations or to react to highly critical database production issues. (emergency and infrequent pre-planned occurrences) Learn and stay current on the features and functionality of Postgresql and Oracle databases, focusing on technology to improve performance, availability, reliability, stability and work efficiencies. Learn and stay current on standard database solutions designed by the Systems Engineering Database group. Translate highly technical solutions/problems into clear language useful to audiences at varying technical levels Prepare high quality technical documentation, present it clearly to interested parties Communicate in a concise and professional manner when interacting across staff levels and internal/external customers Mentor and coach database engineers Research and develop team leadership skills. Contribute to and influence a variety of work streams concurrently Set individual goals that are consistent with business goals Participate in initiatives to define, measure, and report on database quality and stability Develop the knowledge of Thomson Reuters product lines and supported technologies Proactively generates relevant ideas for new and improved operations or use of technology Understands the impact of new projects and technical impacts to supported systems Collaborates with peers, Design & Engineering DBAs and managers to determine system strategy and how best to implement and support it Ongoing Education and Training Learn and stay current on the features and functionality of Postgresql, ORACLE databases, and other flavors of Databases, focusing on technology to improve performance, availability, reliability, stability and work efficiencies. Learn and stay current on standard database solutions designed by the Systems Engineering Database group. Leadership and Communication (15%) Translate highly technical solutions/problems into clear language useful to audiences at varying technical levels Prepare high quality technical documentation, present it clearly to interested parties Communicate in a professional manner when interacting across staff levels and internal/external customers Mentor and coach Associate / Database engineers and peers Research and develop team leadership skills. Management and Administration (5%) Contribute to and influence a variety of work streams concurrently Set individual goals that are consistent with business goals Participate in initiatives to define, measure, and report on database quality and stability Business Acumen and Strategy (10%) Has broad knowledge of Thomson Reuters product lines and supported technologies Proactively generates relevant ideas for new and improved operations or use of technology Understands the impact of new projects and technical impacts to supported systems Collaborates with peers, Design & Engineering DBAs and managers to determine system strategy and how best to implement and support it QUALIFICATIONS Bachelor's Degree — Computer Science, technical or engineering degree preferred 5+ years in the IT field with at least 2 years of DBA responsibilities in Postgresql and Oracle environments. Familiarity with AWS - EC2 and other cloud environment is preferable. Experience in Cloud Migrations, Oracle Installation, Configuration and Upgrades Experience with Oracle replication technologies such as Dataguard, Streams and Golden Gate will be added advantage. Strong quantitative, analytical, communication and verbal skills with a strong customer service focus Performance monitoring and tuning skills are desired. Understanding of storage technologies such as NAS and SAN etc. Ability to problem solve in high pressure situations Extensive backup/recovery experience including Disaster Recovery planning. Ability to quickly learn and adapt to changes in database technology Excellent analytical and problem-solving skills Ability to work effectively as part of a team via excellent verbal and written communication, as well as independently toward assigned goals Experience in scripting languages shell, Python and Perl etc. Job Families for Job Profile : Operations/Support Worker Sub-Type : Regular Time Type : Full time Primary Location : Bangalore, IND Scheduled Weekly Hours : 40 Work Shift : 6AM-3PM/2PM-11PM/10PM-7AM (IST) Cost Center : 390000330 Company Code : 0330 Do you want to be part of a team helping re-invent the way knowledge professionals work? How about a team that works every day to create a more transparent, just and inclusive future? At Thomson Reuters, we’ve been doing just that for almost 160 years. Our industry-leading products and services include highly specialized information-enabled software and tools for legal, tax, accounting and compliance professionals combined with the world’s most global news services – Reuters. We help these professionals do their jobs better, creating more time for them to focus on the things that matter most: advising, advocating, negotiating, governing and informing. We are powered by the talents of 25,000 employees across more than 75 countries, where everyone has a chance to contribute and grow professionally in flexible work environments that celebrate diversity and inclusion. At a time when objectivity, accuracy, fairness and transparency are under attack, we consider it our duty to pursue them. Sound exciting? Join us and help shape the industries that move society forward. Accessibility As a global business, we rely on diversity of culture and thought to deliver on our goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace. We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law. Protect yourself from fraudulent job postings click here to know more. More information about Thomson Reuters can be found on https://thomsonreuters.com. Thomson Reuters provides professionals with the intelligence, technology and human expertise they need to find trusted answers. We enable professionals in the legal, tax and accounting, and media markets to make the decisions that matter most, all powered by the world's most trusted news organization.