Affinity - Director - Technology - Database

About the job:

About Affinity:

Affinity is pioneering new frontiers in AdTech: developing solutions that push past todayslimits and open up new opportunities.

We are a global AdTech company helping publishers discover better ways to monetize and enabling advertisers to reach the right audiences through new touchpoints.

Operating across 10+ markets in Asia, the US, and Europe with a team of over 500 experts, we are building privacy-first ad infrastructure that opens up opportunities beyond the walled gardens.

Role: Director, Technology (Database)

Work Location: Mumbai (Malad)

About Role:

We are seeking a highly experienced Director, Technology - Database to drive the design, optimization,and scalability of our data and database systems within a high-growth AdTech environment.

This role requires deep expertise in database architecture, complex query optimization, distributed data processing, and system performance tuning, along with the ability to lead teams and drive spec-driven development using modern AI-assisted engineering practices.

Roles & Responsibility:

Database Design & Engineering:

- Architect, design,and manage high-performance, scalable database systems across MySQL, PostgreSQL, and MSSQL.

- Lead the development of complex queries,stored procedures, triggers, and indexing strategies.

- Drive database optimization initiatives, including execution plan analysis and query tuning.

- Ensure data integrity, consistency, and security across systems.

Performance Optimization & Scalability:

- Identify and resolve performance bottlenecks in large-scale systems (millions/billions of records).

- Implement partitioning, indexing, caching (Redis),and query optimization techniques.

- Design high-availability and low-latency systems for real-time data processing.

Big Data & Distributed Systems:

- Lead data processing initiatives using Hadoop ecosystem(HDFS, Hive, Spark).

- Design and optimize large-scale data pipelines and batch/stream processing systems.

- Work with massive data sets such as ad-serving logs, bidding data, and user behavior analytics.

Programming & Automation:

- Develop and maintain ETL pipelines using Python.

- Build automation scripts using Shell scripting for:

1. Data workflows

2. Monitoring & alerting

3. Backup and recovery

Caching & System Efficiency:

- Design and implement Redis-based caching layers.

- Define cache strategies (TTL, invalidation, pre-computation) to improve performance.

Spec-Driven Development & Prompt Engineering:

- Drive spec-driven coding practices by translating business requirements into structured technical designs.

- Leverage prompt engineering techniques to accelerate development using AI tools.

- Validate, optimize, and productionize AI-generated code and queries.

- Establish best practices for AI-assisted engineering workflows.

Required Skills:

Database & SQL (Must-Have):

- Strong hands-on expertise in:

1. MySQL, PostgreSQL, MSSQL

- Deep knowledge of:

1. Joins (all types),subqueries, window functions

2. Indexing (clustered, non-clustered, composite)

3. Triggers, stored procedures

4. Query optimization & execution plans

5. Data operations: INSERT,UPDATE, DELETE, TRUNCATE

- Experience in handling large-scale, high-throughput databases.

Hadoop Ecosystem:

- Strong experience with:

1. HDFS, Hive, Spark

- Understanding of distributed data processing and big data architecture.

Programming & Scripting:

- Proficiency in Python (data processing, ETL, automation)

- Strong hands-on experience in Shell scripting

Redis & Caching:

- Experience in implementing Redis for caching and real-time data access

- Strong understanding of cache optimization strategies.

Prompt Engineering & Spec-Driven Coding:

- Hands-on experience in:

1. Writing structured prompts for SQL/code generation

2. Converting business problems into technical specifications

3. Ability to review, validate, and optimize AI-generated output