Brillio

Senior Engineer, Database & Middleware - R01559798

Brillio

Apply
about 1 month ago
Guadalajara, Mexico
Senior / Mid Level

Responsibilities

  • Develop and maintain database solutions across Oracle, PostgreSQL, and MongoDB platforms.
  • Write and optimize PL/SQL procedures, functions, and triggers.
  • Perform query optimization and advanced performance tuning for large datasets.
  • Design and manage complex database architectures, including partitioning, sharding, and replication.
  • Implement strategies for database resiliency, including replication and failover.
  • Collaborate with application teams to ensure seamless integration.
  • Monitor and troubleshoot database issues to maintain high availability.

Requirements

  • 3–5 years of experience with PL/SQL, Oracle, PostgreSQL, and MongoDB.
  • Strong understanding of PL/SQL programming, including writing efficient stored procedures, functions, and packages.
  • Experience with cursors, collections, and bulk operations for performance.
  • Knowledge of exception handling and error logging best practices.
  • Advanced query tuning and execution plan analysis skills.
  • Proven experience working with complex, high-volume databases and distributed systems.
  • Knowledge of database resiliency concepts such as replication, backup, and failover.
  • Familiarity with data modeling, indexing, and partitioning.
  • Solid problem-solving and analytical skills.
  • Bachelor’s degree in Computer Science, Engineering, or related field.

Tech Stack

MongoDBPostgreSQLRedis

Categories

Data Engineering