Manoj Thote

Manoj Thote

Working on Oracle databases, Microsoft office, PL/SQL, data formation
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
40 years old
Location:
Mumbai, Maharashtra, India
Experience:
7 years
Manoj M. Thote -- _________________________________________________________________________________________________________ Software Developer and Support application DBA with 6+ years of experience in .NET and oracle database. Focus areas – Monitoring & maintaining oracle database, OEM, Analysis of ASH, AWR reports, Database backup and restoration using export/import and r-man utilities, Web & Windows development, CSS, HTML, PL/SQL, SQL Server 2005,2008, Shell script. Career Profile Role Organization Tenure Support DBA ICICI BANK, Mumbai 5 Years Software Engineer Sovimal, Pune 1 Years Technical Skills OS : Windows 7, 10., Linux, Solaris, AIX Database: Oracle 10g, 11g, RAC, SQL Server 2000, 2005, 2008. GUI: Visual Studio .Net 2008, 2010. Web Designing: HTML, ASP.Net, JavaScript, CSS, AJAX. Reporting Tools: RDLC Reporting Tool, Crystal report. Tools: PL/SQL Developer, TOAD, OEM. Scripting: SSH Shell Work Experience ICICI BANK, Mumbai (Dec 2014- till date) As Full Time Employee, Designation: Support DBA, Team Size:45 1. Working as Support DBA for banking applications- Credit card applications (PRIME, ONLINE, GEMS), Debit card application (3D Secure, I3D Secure, IPG ), Mobile payment app (IMPS, UPI). 2. Having Experience on database creation using DBCA and Manually. 3. Creating and monitoring the tablespaces, allocating tablespaces for users. 4. Managing Redo log, Control file and Archive log files. 5. Having good Experience in Export / Import and Datapump Utility. 6. Monitor OEM and database performance. 7. Managing Users, Privileges and Roles. 8. Coordinate with TIG team for storage. 9. Tune SQL statement and its objects using Explain plan, SQL Trace. 10. Write shell script for monitoring database, alerts, and reports. 11. PL/SQL code or SQL code such as procedure, function and package. 12. Working with the senior ORACLE ACS TEAM for database related issues, recommendations. 13. Used the utilities like TOAD, SQL Developer, SQL*Plus. 14. Analysis of ASH, AWR reports. 15. Creating and modifying the corn jobs scheduler for alert database space, cleaning up data, maintaining the space & display various database report through mail. 16. Responsible for Exporting/importing dumps, truncating & drop the table in live database. 17. Responsible for database Purging/ Re-Org /Rebuild objects activities on the basis of space availability and secondary and DR Setup replication of purged Data. 18. Implementing new process within the team to increase the productivity of the team. 19. Database backup and restoration using export/import and r-man utilities. Backups and Restoration. 20. Providing first level support to the application users across India for their problems pertaining to the live banking systems. Sovimal Software Pvt. Ltd.(SEP 2013 to AUG 2014 – 1 year) Designation: Software Developer, Team Size:7 As a Software Developer on .NET technology. (VB .Net, C#) 1. Web development: Projects: www.mseb-edbwa.com, www.abcasangli.org, www.prajwalbharat.com Roles & Responsibility 1. Creating dynamic and static web sites in ASP.net, C#.net. 2. Using PLSQL, SQL server 2008, CSS, JScript, AJAX tool. 3. Responsible for requirement analysis, design site as per requirement. 4. Successfully deployment on web host. 5. Supported multiple clients. 2. Windows development: Projects: Weighbridge system, Inventory management system, Dairy management system. Roles & Responsibility: 1. Creating desktop application for various originations. 2. Using VB.NET, C# .NET, SQL, PL/SQL, SQL server 2005, 2008 for database. 3. Responsible for design and coding as per requirements. 4. Implemented various report for project using RDLC tool and crystal report tool. 5. Responsible for deployment and user support after deployment. Education M.C.A. (Master of Computer Application)-68% Personal Details Name as on Passport – Manoj M. Thote. Marital Status – Single . DOB-10th Oct , 1985. Passport: K-
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.