Citi
Citi
Citi je globalno bančno in finančno podjetje, ki zagotavlja storitve potrošnikom, korporacijam, vladam in institucijam. Njegova ponudba vključuje bančništvo za prebivalstvo, kreditne kartice, upravljanje premoženja, poslovno bančništvo in investicijsko bančništvo, podprto s poslovanjem v več kot 100 državah. Kot velika mednarodna finančna organizacija Citi združuje ekipe, ki delujejo na področjih bančništva, finančnih storitev in fintecha.

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.

Opis

  • 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.

Zahteve

  • 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.

Ugodnosti

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

Sorodna delovna mesta

Weekday

Senior Full-Stack Java Engineering Manager

Weekday
501 – 1000 Zaposleni
E-trgovinaMaloprodajaModa

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.

Odpri
Nokia

Senior Software Engineer, Cloud-Native Platforms

Nokia

Build Nokia’s MantaRay NM cloud-native network observability platform, working across distributed systems, Kubernetes, and CI/CD automation. Apply AI-assisted engineering tools and automation to improve software development.

Odpri
Nokia

Senior Software Engineer, Cloud-Native Platforms

Nokia

Build Nokia’s MantaRay network management platform for telecommunications providers. Lead cloud-native distributed systems, Kubernetes, CI/CD automation, and AI-assisted engineering.

Odpri