Senior Database Engineer(PostgreSQL)

JOB PURPOSE

Skills Mandate - PostgreSQL /Oracle ,AWS

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:

• 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

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