Position Overview
We are seeking an experienced Database Developer with strong MySQL expertise and proficiency in shell scripting, automation, and bulk data management. The ideal candidate will be responsible for designing, implementing, and optimizing database solutions while ensuring data integrity, performance, and scalability.
Job Title
Database Developer (MySQL)
Experience Level
3-6 years of professional experience in database development and administration
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
We are looking for immediate hires only.
