Affinity Global Advertising - Director - Database Design & Engineering

Description :

About Affinity :

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 :

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 :

- 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 :

- Build automation scripts using Shell scripting for :

1. Data workflows

2. Monitoring & alerting

3. Backup and recovery

Caching & System Efficiency :

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

Spec-Driven Development & Prompt Engineering :

- 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) :

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 :

1. HDFS, Hive, Spark

- Understanding of distributed data processing and big data architecture.

Programming & Scripting :

- Strong hands-on experience in Shell scripting

Redis & Caching :

- Strong understanding of cache optimization strategies.

Prompt Engineering & Spec-Driven Coding :

1. Writing structured prompts for SQL/code generation

2. Converting business problems into technical specifications

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