Director - Technology

About Affinity:

- Affinity is pioneering new frontiers in AdTech: developing solutions that push past today'slimits 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:.

- Data workflows.

- Monitoring & alerting.

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

- MySQL, PostgreSQL, MSSQL.

Deep knowledgeof:.

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

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

- Triggers, stored procedures.

- Query optimization & execution plans.

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

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

- Hadoop Ecosystem.

Strong experience with:.

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

- Writing structured prompts for SQL/code generation.

- Converting business problems into technical specifications.

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