Develop and maintain database documentation, including data standards, procedures and definitions for data elements and tables.Identify and implement database requirements for new or existing applications by working collaboratively with other teams.Optimize database performance and efficiency by evaluating and recommending new database technologies.Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.Monitoring usage, transaction volumes, response times, concurrency levels, etc.Designing database backup, archiving, and storage strategy.Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.Performing database housekeeping, such as tuning, indexing, partitioning.Write scripts related to stored procedures and triggers. Integrate data from various sources into the database system, ensuring data accuracy, consistency, and integrity. Which may involve using ETL processes or other data integration techniques.Design, implementation, setup, testing and training of users to support, rollout or upgrade Oracle ERP systems.

▣ Performance, reporting and tuning of Oracle Databases.▣ Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures on ERP System.▣ Development of web-based interfaces for Oracle databases and web base applications (Apex).▣ Researching, designing, implementing and managing software.▣ Testing and evaluating software module.▣ Identifying areas for modification in existing ERP and subsequently developing these modifications.▣ Problem’s diagnosis, bug fixing and solve software fault.▣ R&D process continue for better achievement on this organization.

▣ As a Team Leader, Database Developer, Database Architected, Business Analyst, DBA and PL/SQL Developer & ▣ ▣ ▣ ▣ Forms/Reports Developer. ▣ Lead Oracle Team, Report to the management, Maintenance Servers. ▣ Manage & Develop Garments ERP System using Oracle 12c, 11g Database and Oracle Fusion Middleware 12c, 11g and ▣ ▣ Oracle Developer Suite 12c, 11g, 10g also Using Oracle APEX 19.1.▣ Build Module: Develop and Responsible for HR & Payroll, Inventory Module Forms & Reports.▣ Tuning Database (Using TOAD, SQL Developer), Backup & Restore Database.

▣ Design, Develop & Maintains ORACLE Database 11g & ORACLE Developer Suite 10g & 6i. ▣ Completed a Project Human Resource Management System. ▣ Create & Modify Forms & Reports.▣ Analysis software requirement and produce basic design for customize inventory management system. ▣ Create Database stored procedure, Function and Triggers as per requirements.▣ Design and Develop Oracle Forms & Reports Using Oracle Developer Suite 10g.▣ Produce simple and complex Report as per customer requirement.▣ Build Module: Develop and Responsible for HR, Inventory & Accounts Module. ▣ Support Client over TeamViewer, AnyDesk or Phone conversation etc.