Overview
WHY MAGICBRICKS
Magicbricks offers you a culture that is all about innovation and winning. It challenges you and brings out the absolute best out of you. The dynamism here is such that it brings out the next level in you, unleashing your true potential much more than you have ever imagined. This will eventually turn you into a high-performer who is full of ideas, solutions and unmatchable confidence.
Driving Culture Through Values:
Values are the foundation pillar of building a strong organisation culture and we at MB are committed to further strengthen our five core values (Ownership,High Performance,Passion for Excellence, Meritocracy and Team Spirit).
We have conducted sessions across locations with the objective of gaining common understanding and interpretation of these values and uncover ways to demonstrate them in day-to-day work.
We facilitate awareness sessions followed with Reward & Recognition ceremonies across locations."
We at Magicbricks believe that strong values can accelerate success. Hence, challenging you and Magibricks to bring out the very best of us.
Come and be a part of this change
With In House Growth Opportunities:
Learning and growth get empowered at Magicbricks. Magicbricks is deeply committed to invest in the development of its people to help them grow into Leaders to truly inspire others with various programs such as:
- Step Up Program
- First Time Managers Training
- Leadership Lecture Series
- External tie-ups for technical up-scaling
- Performance breakthrough workshops on Leadership Mindfulness
- Training on Art of Interviews
https://youtu.be/IIQ783D5Wh0
Life@MB:
In our constant endeavor to provide an "Energizing" experience to our colleagues, we have launched "Different Strokes" - A Fun@Work program which includes:
- Zumba
- Monday Music Therapy
- Giving Back to Society through Cyclothons, Daan Utsav etc.
- Grand Festive Celebrations such as Diwali
- Stand Up comedy shows
- Nukkad Natak
- Empowering women with women in leadership lecture series
- Live Music Band
We are a Home away from Home, so come be part of our Family.
Database Engineer
Location: Noida
About Magicbricks:
Magicbricks, a division of Times Internet Limited, a wholly owned subsidiary of Bennett, Coleman &Co. Ltd (The Times Group) is India's largest and most trusted property marketplace for all property-related needs, enabling buyers, sellers and renters with the help of technology No 1 Property Site website that provides a common platform for property buyers, sellers & renters to locate properties of interest across India, and source information about all property related matters .Magicbricks, is and has been adjudged as the most preferred site in India, by independent surveys. We are 850+ employees, 11 business verticals with offices across 35 cities and Headquartered in Noida.
Role Description:
We are looking for a motivated & passionate MYSQL/ MariaDB Database Engineer to be part of highly scalable multi-tiered real estate portal,applications and platforms to provide the best possible buying and selling experience for Magicbricks customers. The person should be penchant for high quality, consistency, maintainability, efficiency, security and all other things that make a product great and a high performance team.
Job Responsibilities:
- Work on recent versions of MariaDB / MySQL and understanding of MySQL / MariaB underlying storage engines, such as InnoDB, Connect etc.
- Responsible for implementing best practices in MySQL wherever required.
- Familiarity with other SQL/NoSQL databases such as Cassandra, MongoDB, etc.
- As part of the DB team, you will work closely with developers to perform schema level changes or perform DML operations on Test / QC / UAT / Live DB environments.
- Responsible for developing, testing, improving and maintaining new and existing database queries to help users retrieve data effectively.
- Responsible for ensuring our database systems run effectively and securely.
- Responsible to work with Product / Marketing / Sales teams on their Data request.
- Responsible to create / modify Database reports on day to day basis.
- Provide user / access management. Perform Backup and recovery of databases.
- Maintain archived data. Purge expired data etc.
- Generating various ad hoc reports by querying from the database as and when needed.
- Able to work under pressure and work effectively in a fast paced, highly data driven, changing environment
Skills & Experience:
- 5 to 8 years of experience in Developing database queries for applications, program and reporting as needed.
- Good understanding of database design, implementation, troubleshooting an maintenance.
- Must of experience of handling large data warehouse setup with TBs of data.
- Excellent knowledge of MySQL / MariaDB database.
- Excellent in writing and managing complex SQL data queries, stored procedures schema, triggers, etc
- Strong understanding of Linux operating system and Shell scripting.
- Should have hands on experience writing complex Stored Procedures. Should have good understanding of Triggers.
- Ability to work independently with minimal supervision with technical aptitude
- Ability to pro-actively take initiatives and propose solutions
- Extremely motivated and determined.
- Proficient in the scripting languages (shell, Perl, Python etc) for writing custom automation jobs
- Excellent data profiling abilities
- Good to have practical knowledge of Pentaho ETL tool (PDI, Kettle), Tableau Desktop, Tableau Server.
- Good to have ETL skills with variety of data sources like RDBMS, NOSQL, Hadoop,Google Analytics, Facebook AdWords, SAP, Salesforce etc.
Qualifications:
- Any Technical Education
To apply on this job, email your resume at ta@magicbricks.com
- Pune, Maharashtra, India
- Pune, Maharashtra, India
- Pune, Maharashtra, India
- Pune, Maharashtra, India
- Pune, Maharashtra, India