What are the responsibilities and job description for the Senior Technical Specialist with Oracle PL/SQL position at Inherent Technologies?
Oracle PL/SQL Developer w/ capital markets domain expertise
Skill
Years of Experience
Level of Competence
Oracle PL/SQL
10-15 yrs
Proficient
Snowflake
4-5 Yrs Relevant
Competent
SQL
10-15 yrs
Proficient
Python
10-15 yrs
Proficient
AWS
4-5 Yrs Relevant
Intermediate
JD Responsibilities
Design, develop, and maintain applications using strong Oracle SQL and PL/SQL, Python and Unix technologies.
Collaborate with cross-functional teams to define, design, and ship new features.
Optimize application performance and ensure scalability.
Troubleshoot, debug, and upgrade existing systems.
Write clean, maintainable, and efficient code.
Requirements
12 years of experience building solutions using Oracle, Python and shell scripting.
Proficiency in Oracle PL/SQL and SQL.
Experience in Translating functional and technical requirements into detailed design
Experience in Coding and unit testing, support SIT, UAT and Production deployments
Must have 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.
Preferred Qualifications
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.
Skill
Years of Experience
Level of Competence
Oracle PL/SQL
10-15 yrs
Proficient
Snowflake
4-5 Yrs Relevant
Competent
SQL
10-15 yrs
Proficient
Python
10-15 yrs
Proficient
AWS
4-5 Yrs Relevant
Intermediate
JD Responsibilities
Design, develop, and maintain applications using strong Oracle SQL and PL/SQL, Python and Unix technologies.
Collaborate with cross-functional teams to define, design, and ship new features.
Optimize application performance and ensure scalability.
Troubleshoot, debug, and upgrade existing systems.
Write clean, maintainable, and efficient code.
Requirements
12 years of experience building solutions using Oracle, Python and shell scripting.
Proficiency in Oracle PL/SQL and SQL.
Experience in Translating functional and technical requirements into detailed design
Experience in Coding and unit testing, support SIT, UAT and Production deployments
Must have 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.
Preferred Qualifications
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.
