Send Your Resume
If you are interested in joining our team, complete this form and send your Resume in Word or PDF format.
MySQL Database Programmer
Service
: Office
:
Location
: Bangalore
JOB DESCRIPTION
Position Overview
Job Location: Bengaluru (Karnataka)
Work Remotely: Temporarily due to Covid-19
Job Type: Full-Time
Number of Positions: 3
Work Experience: 4-5 yrs of experience
Relevant Work Experience: 5+ years of overall experience in professional software engineering. At least 4+ years of hands-on experience working as a database engineer or a related role.
Academic / Other Qualifications required: Bachelor's degree in Computer Science, Computer Engineering or equivalent combination of technical education and experience
Job Description:
izmo Ltd. (www.izmoltd.com) is a leading software products company based in Bangalore with operations in 7 countries. izmo Ltd., is a publicly listed company on the BSE & NSE and we are expanding rapidly through global expansion with offices in San Francisco, Los Angeles, Paris, Brussels & Bangalore, we are the largest producers of content for the automotive industry globally.
Our automotive division - izmocars is a leading provider of automotive solutions globally with operations in North America, Europe, and Asia. We provide retail solutions for online eCommerce, CRM, and Data Analytics for the automotive industry.
Our clients are Automotive OEMs, large dealer groups, rental car companies, and leading online portals. We are expanding rapidly and are looking for dynamic professionals for our Global Development Center in Bangalore.
Job Description & Duties:
- Develop & maintain a high performing, secure, scalable database design in MySQL
- Generate and test performance data
- Testing and validating work produced as part of the development process.
- Develop diagrams for data structure entity relationships and data flows.
- An ability to understand front-end users’ requirements and a problem-solving attitude
- Ability to efficiently write database code without compromising data quality, privacy, or security.
- Liaise with developers to improve applications and establish best practices
- Create optimized queries, indexes, and data structure.
- Diagnose and address database performance issues using performance monitors and various tuning techniques.
- Identify areas of opportunity and recommend appropriate improvement suggestions.
- Develop new or amended features, bug fixes and carries out other tasks as required to achieve business goals.
- Ensure on-time, high-quality deliverables and meet project milestones and deadlines within budget with minimal supervision. Assists other team members in the business application, development technologies, or Software Development Lifecycle processes (such as reviewing, designing, and testing).
- Collaborate closely with all team members to take shared responsibility for the sprint backlog and the team’s success.
- Maintain broader code quality through peer code reviews.
- Assist with live releases in line with the team’s release schedule.
- The approach works from an Agile mindset applying practices and principles wherever possible. Attend and participate in all Sprint events to achieve desired outcomes.
- Understand, determine and document impact analysis as per the code changes done.
- Participate in the testing process through test review and analysis.
- Performing RCA before coming up with solutions to resolve a support ticket/bug.
- Should learn new development constructs related to the technology used in the product with an objective to improve the productivity of the self and to improve the robustness of the product.
Mandatory / Primary Skills:
- 4-5 years of experience in software development
- 4+ years working as a database engineer or a related role.
- Strong SQL and MySQL expertise must be able to write a complex & dynamic query.
- Deep understanding of fundamental database design and architecture
- Proficient in writing and optimizing SQL statements
- Good knowledge of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
- Good knowledge in Creating databases and tables with proper collation.
- Good knowledge in Table design, Queries, Procedures, Functions, triggers development.
- Good knowledge in identifying bottlenecks in database performance and tuning database and SQL queries.
- Good Knowledge in optimizing MySQL queries, creating/maintaining database indexes.
- Experience with relational database performance tuning and capacity planning especially in MySQL based environments
- Experience with relational database physical design
- Experience working with huge, interdependent, complex datasets and data structures will be a plus.
- Knowledge of schema design and optimizing database design.
- Experience with distributed and scalable applications with a focus on scalability, performance, and availability.
- Excellent analytical and organization skills
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
- Debugging skills and the ability to troubleshoot methodically, identifying, and apply fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
- Strong problem-solving skills, algorithmic skills, and data structures.
- Good written and verbal communication skills in English.
