Systems/Engineering Software Engineer - Database (Mumbai, India)

mCanvas is an experiential storytelling platform that helps brands emotionally connect with their audiences on small screens. Our mobile ads and content marketing solutions make experiences interactive and memorable by etching phone sensors and device features in to the brand narrative. mCanvas is creating 'wow' moments every day by reinventing formats, building tools and providing a marketplace (of 70+ publishers like Moneycontrol, RepublicWorld, TheHindu, ScoopWhoop, and SportsKeeda) to run these experiences at scale. To see our award-winning work and learn more visit mCanvas.com

The ideal candidate is someone who has interest in handling data and building internet scale products. Our product deals with delivering ads to millions of users from around the world. We need someone who is a creative problem solver, good at writing SQL queries and resourceful in getting things done, and productive working independently or collaboratively. The person will be responsible for developing database processes for our advertising products, generating reports, managing data and deploying large databases across multi-cloud environment and adapting to changing and highly-disruptive advertising technology platform.

Responsibilities

  • Develop database processes, gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries in MySQL, etc.)
  • Work closely with our engineering team to integrate your amazing innovations and algorithms into our production systems
  • Support business decisions with ad hoc analysis as needed
  • Troubleshoot production issues and identify practical solutions
  • Routine check-up, back-up and monitoring of the entire MySQL and Hadoop ecosystem
  • Take end-to-end responsibility of the Traditional Databases (MySQL), Big Data, Analysis and processing life cycle in the organization
  • Build, deploy and maintain real-time streaming pipelines and real-time analytics
  • Manage deployments of big-data clusters across private and public cloud platforms

Required Skills

  • Knowledge of SQL (MySQL) a must
  • Knowledge of writing SQL queries, DDL/DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internals
  • Knowledge of database administration, performance tuning, replication, backup and data restoration
  • Comprehensive knowledge of Hadoop Architecture and HDFS, to design, develop, document and architect Hadoop applications would be added advantage
  • Working knowledge of SQL, NoSQL, data warehousing & DBA
  • Working knowledge of processing large amounts of structured and unstructured data
  • Comprehensive knowledge of extracting and transforming data from remote data stores, such as relational databases or distributed file systems.
  • Strong knowledge and experience with data analytics, mathematics and statistics

Additional Desired Skills

  • Adequate exposure to Linux environment and file system
  • Exposure to handling large datasets (billions of records) is a plus
  • Excellent communication skills, ability to tailor technical information for different audiences
  • Excellent teamwork skills, ability to self-start, share insights, ask questions, and report progress
  • Strong enthusiasm in solving messy problems with good solution design skills
  • Adequate experience with data analysis or software development in a Unix-based system
  • Ability to grasp emerging technical standards and apply in right direction

Benefits

  • Young, Dynamic, Competitive work environment
  • 5-day work week
  • Casual dress code
  • Allowances (medical, maternity, etc.)
  • Bonus- Performance, Referral, Marriage & Child
  • Big Results = Big Rewards
  • Daily Recreational Activities organized by WeWork Community (Stand Up shows, Yoga Classes, Dance Classes, Training Programmes, etc.)

About Us

About mCanvas
mCanvas is an experiential storytelling platform that helps brands emotionally connect with their audiences on small screens. Our mobile ads and content marketing solutions make experiences interactive and memorable by etching phone sensors and device features in to the brand narrative. mCanvas is creating 'wow' moments every day by reinventing formats, building tools and providing a marketplace (of 70+ publishers like Moneycontrol, RepublicWorld, TheHindu, ScoopWhoop, and SportsKeeda) to run these experiences at scale. To see our award-winning work and learn more visit mCanvas.com

About Affinity
Affinity is an ad tech company which creates user engagement products (branding and performance) for digital media. It is in the business of creating sustainable and scalable advertising/media products with special attention to user experience. Established in 2014, Affinity is now a 140+ employee company that operates 5 business units, namely - mCanvas, VEVE, Siteplug, OneDash.ai & Yield Solutions. For more information, visit www.affinity.com.

To apply, please send your resume to careers@affinity.com