Senior Database Engineer

JOB DESCRIPTION

Senior Database Engineer

Skills - Mandatory : PostgreSQL/Oracle/ Lead/Developer

Skills - Primary : Oracle/PLSQL/PostgreSQL/PL-SQL

Skills - Good to have: AWS Services
Qualification :BTech / MCA / Diploma

Total Experience : 6+years
Relevant Experience : 6+years

Work Location : Trivandrum/Kochi
Expected date of onboarding : Immediate

Job Purpose

• An Oracle/PostgreSQL back-end Lead/Senior Developer is responsible for designing and managing the Oracle/PostgreSQL database systems that form the foundation of an organization's data infrastructure. To excel in this role, they need a robust set of technical skills. Here are the key technical skills and knowledge areas that an Oracle back-end architect should possess:

Technical Skills

• 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

Duties and responsibilities

An Oracle Database Architect 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.

• To adhere to the Information Security Management policies and procedures.