Database Engineer

Orion Innovation Systems IntegratorOrion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.Position Description and Responsibilities:Part of a multi-site organization supporting enterprise relational database platforms in on premise data center and in Cloud computing environments. Working on technical solutions to migrate data stores across different database technologies, data migrations and life cycle management. Integrating and analyzing large amounts of data. Administration of Cloud computing infrastructure used in the discovery and analysis of new drug candidates. Working with colleagues within the scientific computing services team, shared services, and with external providers, this role will support daily activities and new initiatives and implement leading edge technologies and practices. Success will be measured by ability to adapt to a changing environment, track best-of-breed technologies, present a clear and factual point of view, and assist developing new processes in support of both existing and new technologies with guidance from senior staff and management.Role Responsibilities:• Provide expertise and experience on supporting Enterprise database solutions like Oracle, SQL Server, PostgreSQL and emerging database solutions like MongoDB, Mariadb.• Experience with open source database technologies in Amazon Cloud integration technologies is highly preferred.• Analyze database migration requirements and work with platform engineering and storage teams to provision requirements to complete data store relocations.• Experience in implementing High availability database solutions.• Work with key clients in scientific research areas to deliver data integration, performance tuning and optimization, proof-of-concept prototyping and deliver new capabilities.• Provide operations support to research computing infrastructure, involving servers, databases and applications and networking, as part of the team.• Interpret structured and unstructured data, analyze results, and provide information insights to clients to help them prioritize business needs.Must have:• 5 years or more experience in managing commercial Database systems like Oracle, SQL Server, PostgreSQL, MySQL, Mongo DB is a must.• Experience in database migration to Cloud computing platform. Amazon RDS.• Experience in AWS Schema conversion tool and Data migration Services.• 2 years or more experience using AWS cloud services Knowledge of EC2 & RDS solutions required. Familiarity with S3 storage service is preferred.• 2 years or more experience in Oracle ASM, RAC, RMAN and Data guard implementation.• Experience supporting authentication and login protocols, LDAP, SSL, SSH.• Must be able to program in a shell language. Must be able to perform automation tasks.• Experience with application servers such as Apache or other web server, Tomcat.• Communicate with all levels of stakeholders as appropriate, including architects, data modelers, Application developers, business users, and scientists.Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.Candidate Privacy PolicyOrion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, "Orion," "we" or "us") are committed to protecting your privacy. This Candidate Privacy Policy ("Notice") explains:What information we collect during our application and recruitment process and why we collect it;How we handle that information; andHow to access and update that information.Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.