C Architect

Position Overview
We are seeking a highly analytical and deeply technical C Architect to spearhead the
database and application modernization of our core, high-performance enterprise systems. In
this role, you will design and drive the strategy to migrate a mission-critical, low-latency C
application ecosystem from an Oracle backend to PostgreSQL.
The ideal candidate will bridge the gap between low-level system performance and complex
database paradigms, ensuring that the migrated application retains its strict performance,
concurrency, and reliability benchmarks.
Key Responsibilities
1. Architectural Strategy & Re-engineering
Define and execute the end-to-end architectural roadmap for migrating legacy C
systems from Oracle to PostgreSQL.

2. Database Modernization & Code Translation
Collaborate with DBAs to translate complex Oracle PL/SQL packages, stored
procedures, triggers, and views into optimal PostgreSQL PL/pgSQL equivalents.
Address and mitigate C application vulnerabilities related to database type
conversion, data precision handling, and cursor management.
Conduct deep-dive performance profiling of C database interactions, optimizing query
execution plans, prepared statements, and connection pooling.
3. Execution & Lifecycle Management
Technical Skills & Experience
Experience 8 years of professional C development experience, including 3 years
in a Technical/Solution Architect role for large-scale enterprise systems.
C Mastery Expert-level knowledge of modern C (C 11/14/17/20), multi-
threading, memory management, and low-latency optimization.
Database Migration Proven experience migrating C applications from Oracle to an
open-source database environment (PostgreSQL strongly preferred).
Oracle Expertise Deep familiarity with Oracle-specific C interfaces (Pro*C, OCI,
OCCI), PL/SQL, and Oracle database internals.
PostgreSQL Expertise Strong proficiency in PostgreSQL architecture, native C/C
APIs (libpq, libpqxx), PL/pgSQL, and advanced indexing/partitioning techniques.
Operating Systems Advanced experience with Linux/Unix environments, including
shell scripting, compiler toolchains (GCC/Clang), and performance profiling tools
(Valgrind, gprof, perf).
Soft Skills & Leadership