Minimum 2 years of experience with MySQL and SQL query writing.
Knowledge of database administration, performance tuning, and data backup.
Experience handling large structured and unstructured data sets.
Familiarity with Big Data ETL processes, data analysis, and processing lifecycle.
Requirements:
Develop and optimize database processes, scripts, and APIs.
Collaborate with engineering teams to integrate database solutions.
Troubleshoot and resolve production database issues.
Manage deployment and maintenance of databases across cloud platforms.
Job description
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.
TheJob:
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 multicloud 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 checkup, backup and monitoring of the entire MySQL and Hadoop ecosystem
• Take endtoend responsibility of the Traditional Databases (MySQL), Big Data ETL, Analysis and
processing life cycle in the organization.
• Build, deploy and maintain realtime streaming pipelines and realtime analytics
• Manage deployments of bigdata clusters across private and public cloud platforms
RequiredSkills:
• 2+ years of experience with SQL (MySQL) a must Experience as a Database developer writing SQL queries, DDLDML 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.
AdditionalDesiredSkills:
• 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 selfstart, 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 Unixbased system
• Ability to grasp emerging technical standards and apply in right direction.
