
Senior Engineer, Database & Middleware - R01559798
Brillio
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