Sr. Database Engineer
Education:
BE / B.Tech preferred in CS, IT, ECE, Telecom, EE with 1st class OR MCA/M.Sc-IT with 1st class can also apply
Experience:
3-4+ years of relevant industry experience
Job Summary:
- Participation in the design, development, and optimization of database solutions for telecom products.
- Leading efforts at different stages of database development life cycle.
- Fast learning & implementation of advanced MySQL technologies for high-performance solutions.
- Primary contributor to database architecture, query development, and integration.
- Participation in all aspects of database development, including schema design, query optimization, indexing strategies, and data modelling.
- Configuration management, issue tracking, and performance tuning in MySQL.
- Responsible for MySQL database setup, maintenance, replication, and high availability solutions.
Database & Software Skills:
- Expert in MySQL with in-depth knowledge of SQL and database internals.
- Strong experience in MySQL database administration, query writing, and optimization.
- Strong understanding of ACID properties, database normalization, and data integrity constraints.
- Proficient in writing queries, stored procedures, triggers, functions, and complex joins.
- Expertise in MySQL CLI and hands-on experience in managing databases through the command line.
- Strong knowledge of MySQL indexing, keys (primary, foreign, composite, unique), and performance tuning.
- Experience in partitioning strategies to enhance database performance and scalability.
- Hands-on experience with MySQL High Availability (HA) replication, failover mechanisms, and backup strategies.
- Experience in query profiling, EXPLAIN plans, and performance optimization techniques.
- Sound knowledge of MySQL InnoDB, MyISAM, and other storage engines.
- Strong understanding of database security best practices.
- Experience in designing and implementing database sharding and horizontal scaling solutions.
- Exposure to NoSQL databases (MongoDB, Redis) is a plus.
- Familiarity with revision control systems like Git, SVN.
- Strong understanding of client-server mechanisms.
- Hands-on experience with Linux/Unix environments for database administration.
- Exposure to cloud-based databases (AWS RDS, Azure, GCP) is a plus.
- Understanding of CI/CD pipelines for database versioning and automation is a plus.
General Skills:
- Excellent problem-solving and analytical skills for debugging and performance tuning.
- Ability to collaborate effectively with developers, network engineers, and other stakeholders.
- Excellent team player with good communication skills.
- Ability to document database structures, workflows, and best practices clearly.
|