Database Developer (MySQL)
Experience
36 years
Key Responsibilities
Database Design & Development
- Design and implement efficient
database schemas and table structures
optimized for performance - Create and maintain
normalized database designs
following industry best practices - Develop and optimize
complex SQL queries, stored procedures, functions, triggers, and views
- Define indexing strategies including
primary keys, foreign keys, and composite indexes
- Ensure
data integrity, consistency, and validation
through constraints and relationships - Design and implement
partitioning strategies
for large-scale 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 datasets - Support and execute
ETL (Extract, Transform, Load)
processes - Maintain data consistency across multiple databases and environments
Automation & Scripting
- Develop and maintain
shell scripts (Bash/sh)
for database automation - Create and manage
cron jobs
for scheduled database operations - Implement
automated backup, restore, and recovery
processes - Automate workflows for repetitive database tasks
- Monitor database health and performance using scripted solutions
- Build
alerting mechanisms
for failures and performance issues
Performance & Optimization
- Analyze and resolve
slow-running queries and database bottlenecks
- Monitor database performance metrics and proactively implement improvements
- Conduct
capacity planning and scalability assessments
- Implement
query optimization, caching, and tuning strategies
- Fine-tune database configuration parameters for peak performance
Collaboration & Documentation
- Work closely with application developers to optimize database interactions
- Collaborate with DevOps teams on deployments and infrastructure planning
- Participate in code reviews and provide database best-practice guidance
- Create and maintain comprehensive
technical documentation
- Provide
production database support
and troubleshooting
Required Skills & Qualifications
MySQL Database (Must Have – Expert Level)
- Strong proficiency in
MySQL 5.7 and 8.0+
- Deep understanding of
MySQL architecture and storage engines
(InnoDB, MyISAM) - Expertise in writing complex SQL queries (joins, subqueries, CTEs, window functions)
- Hands-on experience with
stored procedures, triggers, functions, and views
- Experience with
MySQL replication
(Master-Slave, Master-Master) - Proficiency in
performance tuning and optimization tools
- Strong understanding of
ACID properties and transaction management
- Experience with MySQL utilities such as
mysqldump, mysqlbinlog, pt-query-digest
Table Structure & Database Design (Must Have)
- Expert-level skills in
table structure design and modeling
- Strong understanding of
database normalization (1NF–5NF)
- Experience with
denormalization strategies
for performance - Proficiency in defining optimal
indexes and data types
- Experience with
partitioning and sharding concepts
- Ability to create and interpret
ER diagrams and data models
Bulk Data Management (Must Have)
- Extensive experience handling
large-scale and bulk datasets
- Expertise in
bulk insert, update, and delete operations
- Hands-on experience with
LOAD DATA INFILE
and batch processing - Ability to process
millions of records efficiently
- Strong understanding of
pagination, chunking, and batching techniques
Shell Scripting & Cron (Must Have)
- Strong proficiency in
shell scripting (Bash/sh)
- Experience using shell tools such as
awk, sed, grep
- Ability to write scripts with
error handling, logging, and security best practices
- Solid experience managing
cron schedules and job orchestration
- Understanding of
job dependencies, retries, and monitoring
- Experience with
log rotation and failure alerts
Good to Have Skills
Python
- Experience using
Python for database automation and ETL
- Familiarity with
pymysql, SQLAlchemy, pandas
- Ability to write data transformation and processing scripts
- Exposure to scheduling tools such as
APScheduler or Celery
NoSQL Databases
- Understanding of
NoSQL concepts and use cases
- Exposure to
MongoDB, Redis, Cassandra
, or similar technologies - Ability to evaluate
SQL vs NoSQL
based on system requirements
Soft Skills
- Strong analytical and problem-solving abilities
- High attention to detail and data accuracy
- Ability to work independently and collaboratively
- Clear communication with technical and non-technical stakeholders
- Proactive mindset toward issue identification and resolution
- Ability to work under pressure and meet deadlines
- Strong organizational and time-management skills
- Continuous learning attitude
