IT Technical Specialist - Oracle

Description

IT Technical Specialist - Oracle

Hyderabad, India.

About the Team & Business Line:

Proprietary software solutions and innovation are at the core of what differentiates Citco in the alternative investment space. Through our network of global development centers, Citco invests heavily in technology development, security, and infrastructure to ensure our clients continue to receive award-winning products that underpin our commitment to service excellence.

As a core member of our Reconciliation IT team, you will work with dedicated professionals to ensure our clients maintain access to their critical information assets while keeping Citco ahead of industry trends. In this role you will be part of a critical application that provide reconciliation services to top financial clients across the globe.

Your Role:

• Expert-level database technical knowledge and skills on Oracle 19c RDS database on AWS.
• Able to provide database technical recommendation on database design and architecture, database high availability solution, database replication architecture, with strong database administration skills.
• Able to monitor and manage proactively of mission-critical production system
• Experience with PL/SQL development, implementing new stored procedures and scripts, resolve complex PLSQL objects.
• Systems Analysis and Performance tuning (Oracle Database 19c, Application SQL and PL/SQL code tuning)
• Experience and knowledge of SQL queries and SQL Trace/Explain plans, SQL performance tuning. Setting Oracle parameters, and options.
• Knowledge of creating and maintaining Tables, Partitioning, indexes, Triggers, stored procedures, etc. in a large terabyte database environment.
• Solid experience in Linux, Linux Shell scripting Experience.
• Writes database documentation, including data standards, procedures, and definitions for the data dictionary.
• Plan growth and changes (capacity planning) Sound knowledge of the SDLC, and experience in code migration, database change management and data management.
• Knowledge of programming languages like Java or Python is huge plus.
• Knowledge of AWS is a plus
• Work closely with other developers and business owners to define development needs.
• Perform code reviews and ensure the quality of the code.
• Participate and contribute on all team activities such as Sprint Planning, Sprint Execution, Daily Scrum, Sprint Review and Sprint Retrospective.
• Work with offshore/ distributed teams and mentor junior resources on an as needed basis.

About You:

• Bachelor's degree in Engineering, Computer Science, or equivalent.
• 8+ years in oracle database development and tuning within an agile cross-functional team environment.
• Excellent Analytical skills and ability to pick up and resolve production issues in high pressure environment.
• Excellent organization and oral/written communication skills.
• Ability to update management on key projects and issues.
• Good understanding of code management using git.
• Must be self-motivated and driven, with demonstrated knowledge and skills in: Creativity, technical analysis, problem solving, communication and client service.