Sr. Database Engineer

Role & responsibilities

• In-depth knowledge of Oracle/PostgreSQL Database architecture and components.
• Strong SQL and PL/SQL or PL/pgSQL programming skills for querying, data manipulation, and stored procedure development.
• Proficiency in writing and maintaining PL/SQL or PL/pgSQL code, including procedures, functions, packages, and triggers.
• Strong understanding of PL/SQL or PL/pgSQL syntax, data types, and control structures.
• Mastery of SQL for querying and manipulating data in Oracle databases.
• Knowledge of complex SQL queries, joins, and subqueries.
• Familiarity with database design principles and data modeling.
• Expertise in optimizing PL/SQL or PL/pgSQL code and SQL queries for performance.
• Knowledge of query optimization techniques, indexing, and execution plan analysis.
• Ability to work with database designers to implement efficient schema structures.
• Proficiency in data migration and ETL processes using Oracle tools like Oracle Data Pump and Oracle Data Integrator (ODI).
• Familiarity with scripting languages (e.g., Shell, Python) for automating routine database tasks and monitoring.
• Understanding of the operating systems that Oracle/PostgreSQL databases run on, such as Linux, Unix, or Windows
• Mastery of Oracle Database tools like SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
• Hands on Experience in Python is a plus
• Experience with AWS Cloud Infrastructure and or other cloud providers, specifically exposure in AWS services (Lambda, Step functions, Kenesis, Kafka etc.)
• Familiarity with monitoring tools like Prometheus, Grafana, and pg_stat_statements.
• Effective communication skills for collaborating with cross-functional teams and conveying technical concepts to non-technical stakeholders.
• Exposure in addressing with production issues in a timely manner with sound analytical and problem-solving skills.
• Expertise in diagnosing and resolving complex database issues

Preferred candidate profile

An Oracle Database Engineer is responsible for designing, implementing, and managing Oracle/Postgres database systems to ensure data integrity, availability, and performance. They collaborate with cross-functional teams to understand business requirements and translate them into efficient database solutions. This role involves strategic planning, architecture design, performance tuning, and database security management.

• Collaborate with stakeholders to gather and analyze business requirements for database systems.
• Design and architect Oracle/PostgreSQL database solutions to meet scalability, security, and performance needs.
• Define data models, schema structures, and database configurations.
• Create, modify, and manage database objects (tables, indexes, views, etc.).
• Perform data migration, data transformation, and data loading task.
• Monitor database performance and identify and resolve bottlenecks.
• Optimize SQL queries and database queries for improved efficiency.
• Implement indexing and partitioning strategies to enhance performance.
• Generate documentation showcasing the team's capabilities in winning new opportunities.