Job Title

About AffinityAffinity 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 & EngineeringArchitect, 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 & ScalabilityIdentify 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 SystemsLead 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 & AutomationDevelop and maintain ETL pipelines using Python.Build automation scripts using Shell scripting for:Data workflowsMonitoring & alertingBackup and recoveryCaching & System EfficiencyDesign and implement Redis-based caching layers.Define cache strategies (TTL, invalidation, pre-computation) to improve performance.Spec-Driven Development & Prompt EngineeringDrive 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, MSSQLDeep knowledgeof:Joins (all types),subqueries, window functionsIndexing (clustered, non-clustered, composite)Triggers, stored proceduresQuery optimization & execution plansData operations: INSERT,UPDATE, DELETE, TRUNCATEExperience in handling large-scale, high-throughput databases.Hadoop EcosystemStrong experience with:HDFS, Hive, SparkUnderstanding of distributed data processing and big data architecture. Programming & ScriptingProficiency in Python (data processing, ETL, automation)Strong hands-on experience in Shell scripting Redis & CachingExperience in implementing Redis for caching and real-time data accessStrong understanding of cache optimization strategies. Prompt Engineering & Spec-Driven CodingHands-on experience in:Writing structured prompts for SQL/code generationConverting business problems into technical specificationsAbility to review, validate, and optimize AI-generated outputs.Education:B.Tech / M.Tech / B.E / M.E from: IITs / NITs / IIITs Or other reputed engineering institutes