Job
Description
Company Introduction Vegayan Systems is a premier provider of advanced networking products and integrated solutions for communication network operators. It provides mission-critical solutions to tier-one telecom operators, CSP and enterprise customers. At Vegayan, we encourage team members to be creative and pursue their dreams by developing cutting-edge products and delivering key solutions to customers. Our work environment is flexible, diverse, and lively, giving everyone the opportunity to do their best and achieve amazing things. We work closely with our customers including major service providers and top enterprises to keep abreast with new technical advances and requirements. Come join us and become a part of an Indian hi-tech products company that is leading the way in telecom software and network technologies. Together, let us shape the future of communication networks with Vegayan. 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 Duties Responsibilities Design, implement, and maintain efficient MySQL database schemas for telecom applications Develop, optimize, and maintain complex SQL queries and stored procedures Ensure database reliability, availability, and performance under high transaction loads Implement and manage MySQL replication, backup, and disaster recovery solutions Work on query optimization and indexing strategies to improve database performance Monitor and troubleshoot database issues , ensuring minimal downtime Conduct database capacity planning and proactively resolve bottlenecks Participate in database migration, version upgrades , and technology enhancements Work closely with software development teams to integrate database solutions with applications Maintain data integrity and enforce database security best practices Education BE / B.Tech. in Computer Science, IT, or a related field (ECE/Telecom/EE also considered) with 1 st class
