Senior Database Engineer Job in Thomson Reuters Corporation

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.