Opening for Database Developer .
Work Location - Mumbai
Candidate must have experience from Product Based Company.
Skills Required - Traditional Databases (MySQL), Big Data ETL, Analysis and processing life cycle in the organisation.
The Job:
The ideal candidate is someone who has rich experience 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 product, 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 ETL, 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:
• 2+ years of experience with SQL (MySQL) a must Experience as a Database developer 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
• Working knowledge of SQL, NoSQL, data warehousing & DBA
. Experience processing large amounts of structured and unstructured data
• Experience 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 statistic
• PHP knowledge will be added advantage.
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
• Flexible working hours and flexible leaves
• Casual dress code
• Equal opportunity workplace
• Allowances (Leave travel, medical, conveyance, marriage, baby, etc.)
• Annual Bonus
• Big Results = Big Rewards
• Recreational Facilities (Table tennis, Pool etc.)
*Interested Candidate can apply with their updated resume on sagar.v@affinity.com with Headline as Applied for MYSql Database Developer*