Oracle Database Developer (PL/SQL) - Onsite/Hybrid

MSYS - Jersey City, NJ

Full-time

Jersey City, NJ

Professional, Scientific, and Technical Services

About the position

The Oracle Database Developer (PL/SQL) position at MSys Inc. involves designing, developing, and maintaining applications using Oracle, Informatica, Python, and Unix technologies. This role requires collaboration with cross-functional teams to implement new features, optimize application performance, and ensure data security. The position is long-term and offers a hybrid work environment, allowing for both onsite and remote work.

Responsibilities

• Design, develop, and maintain applications using Oracle, Informatica, Python, and Unix technologies.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Optimize application performance and ensure scalability.
• Implement security measures and data protection protocols.
• Troubleshoot, debug, and upgrade existing systems.
• Write clean, maintainable, and efficient code.
• Stay up to date with the latest industry trends and technologies.

Requirements

• 8+ years of experience building solutions using Oracle, Informatica, Python, and shell scripting.
• Strong knowledge of Python frameworks (e.g., Pandas, Streamlit, etc.).
• Proficiency in Oracle PL/SQL and SQL.
• Hands-on experience with Informatica PowerCenter or similar ETL tools.
• Experience in translating functional and technical requirements into detailed design.
• Experience in coding and unit testing, supporting SIT, UAT, and Production deployments.
• Good database programming skills covering design/development of Stored Procedures, Functions, Tables, and Triggers and tuning SQL queries for optimal performance.
• Develop ETL processes using Informatica to manage data integration tasks.
• Proficiency in shell scripting.
• Experience with performance tuning and optimization of Oracle databases.
• Document system configurations, procedures, and best practices.
• Excellent problem-solving skills and attention to detail.
• Ability to work collaboratively in a team environment.
• Bachelor's degree in Computer Science, Engineering, or a related field.

Nice-to-haves

• Experience with Tivoli Workload Scheduler (TWS).
• Experience with cloud services preferably AWS.
• Experience with Snowflake.
• Knowledge of DevOps practices and tools.
• Familiarity with Agile methodologies.