Job Description :
Job description:
MySQL Responsibilities
Provision MySQL instances, both in clustered and non-clustered configurations
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders.
Strong proficiency in MySQL database management
Decent experience with recent versions of MySQL
Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
Experience with replication configuration in MySQL
Knowledge of de-facto standards and best practices in MySQL
Proficient in writing and optimizing SQL statements
Knowledge of MySQL features, such as its event scheduler
Ability to plan resource requirements from high level specifications
Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
Proficient understanding of code versioning tools such as Git
{Make sure to mention other frameworks, libraries, or any other technology related to your development stack}}
Shell scripting for setting jobs when needed.
MONGO Responsibility
Schema Design – working with Application/Development team
Query fine tuning
Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fails, disk usage etc
Backup and restores ( Backups should be automated with shell scripts/Ops Manager)
Database Health check ( Complete review of Database slow queries,fragmentation, index usage etc )
Knowledge of Index strategies and best practice to improve performance
Upgrades (Java version, Mongo version, etc)
Writing best practices documents for shading, replication for Dev/App teams
Log rotation/ maintenance ( mongos, mongod, config . etc)
Segregation of duties ( User Management – designing User roles and responsibilities )
Disk usage, CPU, Memory check Alerting
Database Hardening ( Check in DBVersity for what is DB Hardening)
Designing DR (Disaster Recovery)/COB ( Continuity of Business) plans as applicable
Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
Export and Import of Data to and From MongoDB, Run time configuration of MongoDB.
Data Managements in MongoDB Capped Collections Expired data from TTL,
Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB. Capturing various issues related with Database.
Database software Installation and Configuration in accordance with Client defined standards
Perform Database Migrations , Upgrading and patching
Capacity management
Hands on experience in Server Performance tuning and Recommendations
High availability solutions and recommendations
Hands on experience in Root cause analysis for business impacting issues