Database and Solution Architect

We are looking for a versatile database and solution architecture professional with expertise across data modeling, SQL development, data architecture, database administration, and solution architecture. The ideal candidate has hands-on experience with distributed databases (CockroachDB, PostgreSQL, DB2), data lakes (Iceberg, Parquet, query engines), and microservices/Spring Boot ecosystems. You will design end-to-end data solutions, optimize performance, and ensure high availability across enterprise systems.

Key Responsibilities:
• Design scalable end-to-end solution architectures integrating databases, data lakes, and microservices.
• Build and maintain conceptual, logical, and physical data models for OLTP and OLAP workloads.
• Develop and optimize SQL queries, stored procedures, and views.
• Architect and implement distributed database and data lake solutions using Iceberg, Parquet, and query engines.
• Integrate database components with microservices and Spring Boot applications, ensuring correct transaction isolation and concurrency control.
• Perform performance tuning, indexing, partitioning, and query optimization for large-scale, distributed systems.
• Administer CockroachDB, PostgreSQL including installation, configuration, backup/recovery, and DR.

Required Skills & Experience:
• Strong experience across database development, data modeling, data architecture, DBA functions, and solution architecture.
• Strong proficiency in SQL, CockroachDB, PostgreSQL.
• Strong performance-tuning expertise for distributed and high-throughput systems.
• Understanding of microservices architecture, Java, Spring Boot, and transaction isolation levels.
• Knowledge of ETL, data warehousing, and data integration best practices.

Preferred Skills:
• Cloud experience (IBM Cloud, AWS, GCP, Azure) and OpenShift (On-prem).
• Automation/scripting (Python, Shell, ansible etc).
• Familiarity with data governance, MDM, and data quality frameworks.