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.
Job Description:
The PostgreSQL Database Engineer will be part of a team of DBAs supporting other teams consisting of application developers, organizational Production and Dev Ops resources. The engineer will be responsible for maintenance, implementation and performance of critical PostgreSQL RDBMSs hosted on local and remote Linux based servers.
The successful candidate will be responsible for database and code analysis, performance tuning, SQL and stored procedure development and testing. As with any engineering position, creating and maintaining technical documentation will be performed.
Responsibilities:
- Manage PostgreSQL databases servers during multiple product lifecycle environments, from design to production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Assist developers with complex query tuning and reference refinement.
- Research, Test and Recommend database structural and performance enhancements.
- Share technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Write PL SQL procedures when needed
Qualifications:
- 5+ years PostgreSQL, Oracle, or similar RDBMS products Administration experience.
- 5+ years of experience with SQL and CLI interfaces such as PSQL and SQL*Plus.
- 5+ years of experience with Linux or UNIX operation systems.
- Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
- Experience with backups, restores and recovery models.
- Experience with range type table/index partitioning.
- Experience with automatic queuing such as PGQ.
- Experience with database stored procedure scripting languages such as PG/PLSQL or PLSQL.
- Knowledge of Physical High Availability (HA) and Disaster Recovery (DR) methods.
- Excellent written and verbal communication.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
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.
Top Skills
What We Do
Orion is a leading digital transformation and product development services firm. Headquartered in Edison, NJ, we have a global team of 6,200+ associates, with engineers in 14 major delivery centers across North America, Europe, Asia Pacific and Latin America.
For over 25 years, Orion has been solving complex business problems for our clients. Our transformative business solutions are rooted in digital strategy, experience design, and engineering, empowering our clients to operate with agility at scale.
Our mission is to serve as an agile and trusted partner for business transformation initiatives, providing deep emerging technology, experience design, and domain expertise.
Our business has more than tripled over the last three years.
We have grown aggressively both organically and inorganically, adding new clients, complementary skills, domain expertise, and strengthening our global footprint.
