Database Engineer

Orion Innovation; Hamilton Township (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

Orion Innovation is seeking an experienced Database Systems Engineer to support enterprise relational databases both on-premise and in cloud environments. You will migrate data stores across technologies, implement high availability, and optimize performance while collaborating with scientists and engineers.

The role requires hands-on AWS, Oracle, SQL Server, PostgreSQL, MySQL, and MongoDB expertise, plus automation via shell scripting and familiarity with Apache/Tomcat servers.

Qualifications

• 5+ years of experience managing commercial database systems (Oracle, SQL Server, PostgreSQL, MySQL, MongoDB).
• Experience migrating databases to AWS cloud (RDS, EC2).
• Hands-on with AWS Schema Conversion Tool and AWS DMS.
• 2+ years in AWS services (EC2, RDS, S3).
• Experience in Oracle ASM, RAC, RMAN, and Data Guard.
• Knowledge of authentication protocols: LDAP, SSL, SSH.
• Ability to automate tasks via shell scripting.
• Experience with application servers such as Apache or Tomcat.
• Excellent communication with architects, data modelers, developers, and scientists.

Responsibilities

• Provide expertise on Enterprise database solutions including Oracle, SQL Server, PostgreSQL, MongoDB.
• Collaborate with cloud integration teams to migrate data stores to cloud.
• Analyze migration requirements and coordinate with storage teams for data relocations.
• Implement high-availability database solutions.
• Partner with scientists and clients on data integration and performance optimization.
• Provide operations support for servers, databases, apps, and networking.
• Interpret data and deliver insights to help prioritize business needs.

Skills

Database management

AWS Cloud

Automation scripting

Stakeholder communication

Security protocols LDAP/SSL/SSH

Web servers Apache/Tomcat

Shell scripting

Tools

Oracle ASM

Oracle RAC

RMAN

Data Guard

Amazon RDS

AWS Schema Conversion Tool

AWS DMS

EC2

S3

Apache Tomcat

Job description

Orion 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 Policy

Orion Systems Integrators, LLC And Its Subsidiaries And Its Affiliates (collectively, “Orion,” “we” Or “us”) Are Committed To Protecting Your Privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) Explains

• What information we collect during our application and recruitment process and why we collect it;
• How we handle that information; and
• How 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.