Develop and support MySQL database replication.• Optimize MySQL database performance.• Estimate MySQL database capacities; develop methods for monitoring database capacity and usage.• Establish mechanisms for data backup/restore of relational databases; provide restoration services as needed.• Develop and optimize physical design of MySQL database systems. * Develop application-specific fault-tolerant distributed database mechanisms.• Demonstrated experience with relational database physical design• Demonstrated experience with relational database performance tuning and capacity planning especially on MySQL based environments• Experience with open source/Linux development and production environment. Preferred Experience:• Experience with MySQL• Experience with distributed database systems
Write, test, debug and ship code and gather feedback on the scale, performance, security to incorporate back into the platform. Work with the founders to identify complex technical problems and solve them. Work with the product design and client experience development team to support them with scalable services Feed into the overall mission and vision of the eParchi’s platform over the period of the coming months and years. An ability to perform well in a fast-paced environment Excellent analytical and multitasking skills. ● Will have to dedicate full time until the college opens, after which he needs to dedicate 6-7 hours on weekdays and full time on weekends.
4+ years of experience working with Enterprise RDBMS, handling database Development/Administration. Able to manage RDS servers. Should have hands on experience in writing SQL, managing indexes and schema. Operational experience in monitoring and tuning production issues majorly involved in optimizing the performance and functionality Deep understanding of MySQL/PostgreSQL parameters Operational experience in data migration at large scale. Configure the machines to meet internal security requirements. Provide on-call support which can require analysis and troubleshooting of complex issues. Lead and contribute to design discussions in a cross functional project setting. Operational tasks assisting Dev/ QA to setup perf/database tools. Develop database standards, guidelines and best practices. Mandatory Skills Strong knowledge on Postgres & Mysql/MongoDB/Elastic Search significant experience with Python, bash/ scripting language Worked on Amazon RDS service. Knowledge and operational experience with linux environments. Experience in troubleshooting, tuning and optimizing performance of database servers. Experience in setting up Monitoring/alerting tools like Nagios/PMM/Monyog/Anemometer In-depth knowledge and experience of software development lifecycle