Job Title
Database Developer (MySQL)
Experience Level
3-6 years of professional experience in database development and administration
Location - Bangalore
Work Mode - Hybrid
Key Responsibilities
Database Design & Development
- Design and implement efficient database schemas and table structures for optimal performance
- Create and maintain normalized database designs following industry best practices
- Develop complex SQL queries, stored procedures, functions, and triggers
- Define and implement table structures with appropriate indexing strategies
- Ensure data integrity through constraints, relationships, and validation rules
- Design and implement database partitioning strategies for large datasets
Data Management & Operations
- Manage and manipulate bulk data efficiently using MySQL utilities and custom scripts
- Perform large-scale data migrations, imports, and exports
- Optimize database performance through query tuning and index optimization
- Implement data archival and purging strategies for historical data
- Handle ETL (Extract, Transform, Load) processes for data integration
- Ensure data consistency and quality across multiple databases
Automation & Scripting
- Develop and maintain shell scripts for database automation tasks
- Create and manage cron jobs for scheduled database operations
- Implement automated backup and recovery procedures
- Build workflow automation for repetitive database tasks
- Monitor database health and performance through automated scripts
- Develop alerting mechanisms for database issues
Performance & Optimization
- Analyze and optimize slow-running queries and database bottlenecks
- Monitor database performance metrics and implement improvements
- Conduct capacity planning and scalability assessments
- Implement caching strategies and query optimization techniques
- Tune database configuration parameters for optimal performance
Collaboration & Documentation
- Work closely with application developers to optimize database interactions
- Create and maintain comprehensive technical documentation
- Participate in code reviews and provide database-related guidance
- Collaborate with DevOps teams on deployment and infrastructure
- Provide support for production database issues and troubleshooting
Required Skills & Qualifications
MySQL Database (Must Have - Expert Level)
- Strong proficiency in MySQL (versions 5.7, 8.0+)
- Deep understanding of MySQL architecture, storage engines (InnoDB, MyISAM)
- Expertise in writing complex SQL queries (joins, subqueries, CTEs, window functions)
- Strong knowledge of stored procedures, functions, triggers, and views
- Experience with MySQL replication (Master-Slave, Master-Master)
- Proficiency with MySQL performance tuning and optimization tools
- Understanding of ACID properties and transaction management
- Experience with MySQL utilities (mysqldump, mysqlbinlog, pt-query-digest)
Table Structure & Database Design (Must Have)
- Expert ability to define and design table structures
- Strong understanding of database normalization (1NF to 5NF)
- Experience with denormalization strategies for performance optimization
- Proficiency in creating efficient primary keys, foreign keys, and indexes
- Knowledge of data types and their appropriate usage
- Understanding of partitioning and sharding strategies
- Experience with database modeling tools (ERD diagrams)
Bulk Data Management (Must Have)
- Extensive experience manipulating and processing bulk data
- Proficiency with bulk insert, update, and delete operations
- Experience with LOAD DATA INFILE and other bulk import methods
- Knowledge of batch processing techniques for large datasets
- Ability to optimize bulk operations for performance
- Experience handling millions of records efficiently
- Understanding of data pagination and chunking strategies
Shell Scripting (Must Have)
- Strong proficiency in shell scripting (Bash, sh)
- Experience writing automation scripts for database tasks
- Knowledge of shell commands for file processing (awk, sed, grep)
- Ability to parse and manipulate data using shell tools
- Experience with error handling and logging in shell scripts
- Understanding of shell script best practices and security
Cron Scheduler & Workflow (Must Have)
- Solid experience with cron job scheduling
- Ability to create and manage complex cron schedules
- Experience with workflow automation and job orchestration
- Knowledge of scheduling best practices and error handling
- Understanding of job dependencies and sequential execution
- Experience with log rotation and monitoring for scheduled jobs
Good to Have Skills
Python Scripting
- Experience with Python for database automation and ETL
- Knowledge of Python database libraries (pymysql, SQLAlchemy, pandas)
- Ability to write data processing scripts in Python
- Experience with Python for data analysis and manipulation
- Familiarity with Python scheduling libraries (APScheduler, Celery)
NoSQL Databases
- Understanding of NoSQL database concepts and use cases
- Experience with MongoDB, Redis, Cassandra, or similar NoSQL databases
- Knowledge of when to use NoSQL vs SQL databases
- Understanding of document stores, key-value stores, and column-family stores
Soft Skills
- Strong analytical and problem-solving abilities
- Excellent attention to detail and accuracy
- Ability to work independently and in team environments
- Good communication skills for technical and non-technical audiences
- Proactive approach to identifying and resolving issues
- Ability to work under pressure and meet deadlines
- Strong organizational and time management skills
- Continuous learning mindset to stay updated with technologies
