Database Architect

Experience

6+ years.

Mandatory skill

• PostgreSQL/Oracle-Architect/Lead Amazon Aurora PostgreSQL

Job Purpose

• An Oracle/PostgreSQL back-end architect is responsible for designing and managing the Oracle 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, database backup and recovery strategy on cloud.
• Expertise in optimizing PL/SQL or PL/pgSQL code and SQL queries for performance.
• Knowledge of query optimization techniques, indexing, table partitioning, 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.
• Experience with AWS Cloud Infrastructure and or other cloud providers, specifically exposure in AWS amplify.
• 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.
• Expertise in diagnosing and resolving complex database issues.
• Good understanding on AWS services such as API Gateway, Lambda, Bath jobs, Apache Kafka and S3.
• Knowledge in Implementing authentication and authorization mechanisms using AWS Cognito and other relevant services.
• Exposure to any programming languages such as Java, Python and understanding of Web API, REST, SOAP, JSON.
• Understanding on any of the source/version control system (Git/Bitbucket).
• Good understanding on CI/CD implementation using terraform/serverless.

 

Job 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.
• To adhere to the Information Security Management policies and procedures.