Experience

• Helping spread the word about Postgres - The world's most advanced open-source database



• Responsible for Cloudflare's mission critical databases. We are hiring. https://boards.greenhouse.io/cloudflare/jobs/3585928?gh_jid=3585928



• https://badges.education/Chico/el-lvignesh-ravichandran/ - Member of the Engineering Leadership Advisory Council - Helping engineers in the early stage career with mentorship



• Currently working on migrating various RDBMS and NoSQL databases to AWS. Technologies: Oracle, MySQL, Mongo, Aurora, RedShift, Python



• Providing database support for 100 plus databases running on Postgres, SQL Server, Oracle and GreenPlum. Planning and migrating the oracle RMAN backups from HP's Data Protector tool to Dell's NetVault. Building a continuous data integration environment using tools like Git, BitBucket, TeamCity, Octopus, and Red Gate's add-on. Working on continuous data replication on Postgres databases (approx 2 TB) between production and lower environments using symmetry tool.



• Performing web scrapping on various online sites using Python to draw insights from customer reviews. Designed and built a replica set sharded Mongo Database for the online web scrapping tool. Database monitoring using cloud tools and involved in pro-active measures for maintaining the High Available systems.



• *Administered over 300+ Oracle, and Progress production databases along with their corresponding development, and test databases. *Active member of the Performance Tuning team, and resolved 20 plus SQL related issues in batch jobs. *Automated database refresh in Oracle and Progress databases which were hosted in Linux environment using shell scripting. The script helped the team to complete the refresh by 30% faster than manual method. *Performed Data Guard broker setup, Disaster Recovery , and Database restorations using RMAN utility Key responsibilities handled: *Performed database cloning in QA from a production database of size 1 TB using RMAN active duplication *Reduced the CPU Consumption of a Database Server for a critical application from 90% to under 5%. *Fine-tuned 20 plus PL/SQL application packages and the packages executed 4 times faster than before. *Contributed to space regain project, and helped the team to regain space of around 1TB using Oracle Advanced Compression option. *Fixed approximately 6000 odd violations as being a SCRP and ISCRP specialist. Carried out Database, and Tablespace Point in Time recovery during multiple DB crash incidents. *Recognized as Build Champ for successfully completing 25 Database builds in three months. *Implemented database migration, upgrade and patch activities on 15 Linux production servers. *Engaged in the SGA standardization project which proactively avoided the shared memory issues.* Show less



• *Worked on web based application ‘Billing and Inventory Management System' *Modified the designs of legacy websites which were created using HTML, CSS and XML.