Citi
Citi
Citi — жеке тұлғаларға, корпорацияларға, үкіметтерге және ұйымдарға қызмет көрсететін жаһандық банк және қаржылық қызметтер компаниясы. Оның қызметтері жеке банкингті, кредиттік карталарды, әл-ауқатты басқаруды, корпоративтік банкингті және инвестициялық банкингті қамтиды әрі 100-ден астам елдегі операцияларымен қамтамасыз етіледі. Ірі халықаралық қаржы ұйымы ретінде Citi банк ісі, қаржылық қызметтер және финтех салаларында жұмыс істейтін командаларды біріктіреді.

Oracle PL/SQL Database Developer

Develop and optimize Oracle and Sybase databases for Citi’s global FX technology platform. Support ETL, performance tuning, deployments, and database development standards.

Сипаттама

  • Build and maintain Oracle and Sybase database solutions.
  • Create and optimize SQL queries, stored procedures, PL/SQL packages, functions, and triggers.
  • Write high-performance PL/SQL using collections, pipelined functions, global temporary tables, and other advanced features.
  • Monitor database performance and improve it through query tuning and optimization.
  • Review explain plans and use other tools to diagnose database performance.
  • Create and maintain logical and physical data models.
  • Protect data integrity, consistency, and security across databases.
  • Build and support ETL processes and data integration solutions.
  • Work with application developers, business analysts, and other stakeholders.
  • Review code and encourage sound database development practices.
  • Support production deployments and resolve database issues.
  • Contribute directly to integration, modernization, cloud enablement, and practical best-practice standards.

Талаптар

  • At least four years of database development experience.
  • Strong practical experience with Oracle and Sybase databases.
  • Experience supporting enterprise-scale applications and databases.
  • Strong SQL and PL/SQL development skills.
  • Extensive experience writing and optimizing complex Oracle SQL queries.
  • Practical experience with Oracle SQL Developer and other database development tools.
  • Knowledge of query tuning, explain plans and performance analysis tools, indexes and index access methods, index-organized tables (IOTs), partitioning, joins, and query optimization.
  • Knowledge of stored procedures, functions, packages, and triggers.
  • Basic understanding of data modeling.
  • ETL process and data integration tool experience is preferred.
  • Exposure to MongoDB or other NoSQL databases is an advantage.
  • Knowledge of CI/CD pipelines and tools such as Jenkins, TeamCity, UDeploy, and SonarQube.
  • Familiarity with design patterns, code reviews, coding standards, and unit testing.
  • Strong analytical and problem-solving skills.
  • Excellent written and verbal communication skills.
  • Ability to work independently and take ownership of deliverables.
  • Careful attention to detail and commitment to data quality.
  • Ability to work under pressure and manage shifting priorities and deadlines.

Артықшылықтар

  • Equal opportunity employer.
  • Reasonable accommodations are available for people with disabilities.

Ұқсас жұмыс орындары

Neuron

Senior Frontend Engineer, Angular

Neuron

Lead frontend architecture and build Angular experiences for web and mobile on Neuron’s AI service-resolution platform. Own reusable UI components, integrations, performance, and engineer mentoring.

Ашу
Weekday

Senior Full-Stack Java Engineering Manager

Weekday

Lead engineering teams building scalable Java and Spring Boot services with modern frontend applications. Guide architecture, reliability, mentorship, and delivery for a software development client.

Ашу
Citi

Spring Boot Microservices Developer – Pune, Hybrid

Citi

Develop and support Citi financial services applications built with Spring Boot microservices. The role includes improving application security, debugging systems, and advising technology stakeholders.

Ашу
AtkinsRéalis

Lead EICA Engineer, Water and Wastewater

AtkinsRéalis

Lead electrical engineering design for water and wastewater treatment plants and pumping stations at AtkinsRéalis. Guide multidisciplinary project delivery, standards compliance, design reviews, and the development of electrical engineering teams.

Ашу
Nokia
Nokia