Database Architect

Architecture

• Define and drive the overall system architecture for scalable, distributed, and high-performance platforms.
• Design microservices-based and event-driven architectures, leveraging Kafka for asynchronous communication.
• Architect systems for high availability, fault tolerance, and scalability across cloud environments.
• Standardize on technologies including:
• Spark for large-scale data processing
• HDFS for distributed storage
• Kubernetes for container orchestration
• Ensure architecture supports multi-language ecosystems (Java and Python).
• Lead architecture reviews, design discussions, and technical decision-making.
• Align architecture with business requirements, performance goals, and long-term scalability.
• Define best practices for modularity, extensibility, and service interoperability.

Database

• Design and optimize data platforms using ClickHouse or similar OLAP/columnar databases.
• Develop and tune complex PL/SQL queries, stored procedures, and ETL/ELT pipelines.
• Build scalable batch and real-time data pipelines using:
• Apache Spark (PySpark/Java) (batch + distributed processing)
• Kafka (stream ingestion and processing)
• Utilize HDFS for distributed, fault-tolerant storage of large datasets and data lake architectures.
• Design efficient data models, partitioning, and indexing strategies.

Optimize query performance, storage efficiency, and data retrieval latency.

Ensure data consistency, integrity, and availability across distributed systems.

Support pipelines and transformations built in Java and Python ecosystems.

System Engineering

Design and build robust, scalable, and fault-tolerant distributed systems.

Build event-driven systems leveraging Kafka for messaging and stream processing.

Develop backend systems and services using Java and Python.

Define and monitor system metrics: latency, throughput, scalability, reliability.

Implement monitoring, logging, and alerting frameworks.

Troubleshoot complex production issues and lead root cause analysis.

Collaborate with DevOps to optimize CI/CD pipelines and infrastructure automation.

Drive improvements in performance, resilience, and cost efficiency.

Governance & Practices

• Establish and enforce architecture standards, coding practices, and design principles.
• Ensure compliance with security, data governance, and regulatory standards.
• Promote engineering best practices for Java and Python development.
• Conduct design and code reviews to ensure quality and consistency.
• Maintain architecture documentation, system diagrams, and runbooks.
• Mentor engineers and drive knowledge sharing and technical excellence.

We are seeking an experienced Database Architect with experience in systems engineering to lead the design, optimization, and governance of our on?premises database ecosystem spanning NoSQL/analytic (ClickHouse, ScyllaDB) and relational (Microsoft SQL Server) platforms. This role combines deep database engineering expertise with strong systems architecture skills across compute, storage, networking, virtualization, and security., * 8+ years of architecture/engineering experience in on?prem enterprise environments.

• Proven experience in operating ClickHouse or similar database clusters at scale.
• Strong systems engineering background: Linux (RHEL) and Windows Server.
• Strong scripting/automation skills in PowerShell, Bash, Python, or Ansible., * Bachelor of Computer Science or related technical discipline.
• Familiarity with MPP/on?prem analytics ecosystems beyond ClickHouse.
• Any certifications in PostgreSQL, MSSQL, Linux, VMware, or Hadoop ecosystem.
• Prior experience migrating or integrating on?prem systems with limited cloud components.
• Experience with performance testing frameworks for high?volume data platforms.

• Competitive salary and performance-based bonus.
• Comprehensive health, dental, and vision insurance.
• Retirement plan
• Professional development and training opportunities.
• Flexible work arrangements and generous paid time off.

Founded in 2001, Polaris Wireless Inc. is the leading provider of US FCC compliant, high accuracy, software-based wireless location solutions to operators, law enforcement agencies and location-based application companies. The Polaris Wireless patented Wireless Location Signatures (Polaris WLS ) technology is a cost-effective solution to the location determination problem since no changes in the wireless device or in the network operator's base stations are required. Polaris Wireless markets two main platforms: OmniLocate and Aigis that enable a wide variety of public safety and national security applications. The Company has commercially deployed its location products across 27 wireless networks in the US for E911 Phase II location services and in APAC for 999, and across 22 wireless networks in EMEA and APAC for security applications. Polaris's technology works seamlessly across "all" mobile devices, all air interfaces (2G, 3G, 4G LTE and 5G) and across all environments, including challenging dense urban and indoor locations. Polaris Wireless recently solved the vertical location estimation challenge and successfully demonstrated it to the FCC. Polaris Wireless has received multiple awards from Frost and Sullivan, was listed in the Inc. 500/5000 fastest growing companies list. The company founded in Silicon Valley has expanded its operations and sales globally. Its U.S. operations are headquartered out of Polaris Wireless, Inc. in Mountain View, California, U.S.A. Its international sales operations are headquartered out of Polaris Wireless GmbH in Zug, Switzerland with additional offices in the Middle East and Asia. The company is currently self-funded from its commercial operations.