ob Description
Skills - Mandatory
PostgreSQL/Oracle/ /Lead/Developer , AWS
Skills - Primary
Oracle/Pl-sql/PostgreSQL/PL-pgSQL ,AWS
Skills - Good To Have
Amazon Aurora
Experience
6+ years
Budget
12 LPA - 20 LPA
Work Location
Trivandrum/Kochi/Remote
Job Purpose
Technical Skills An Oracle/PostgreSQL back-end Lead/Senior Developer is responsible for designing and managingthe Oracle/PostgreSQL database systems that form the foundation of an organization's datainfrastructure. To excel in this role, they need a robust set of technical skills. Here are the keytechnical 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
An Oracle Database Architect is responsible for designing, implementing, and managing Oracle/Postgresdatabase 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.Skills: database,oracle,sql,data,postgresql,pgsql,pl/sql,database systems,aws
