See all Work History & Feedback
Related links:
Developed many forms and reports while developing the static and dynamic web pages.
As a DBA i got into to perform backup and recovery as per circumstances using RMAN and script, creating and monitoring datbase space management, creating and managing users, granting users, little bit hands on experince in RAC and Data Gaurd configuration etc.
Used in conjunction with many website development to put in images with special effect.
As back end i have been working on PL/SQL to build sevral ERP products for 8+ years.
Maxim has several modules developed in different applicatonsMy Role -
· Writing packages for customization of Sale Order, Production Plan, Inventory and other modules as per requirement.
· Extracting data from legacy SAP database to Oracle database.
· Merging Unix shell script with SQL script, running Unix jobs etc.
· In tuning complex queries and PL/SQL code with indexes, oracle hints etc.
·
Wonderware has its own developed tools like InTouch HMI (custom graphical views of your real-time industrial processes), Historian database and Active Factory client, System Platform (Application Server, Information Server), ArchestrA, InControl (capable to manage batch process) etc. These products interact with Factelligence ERP and provide compatibility with electronic devices being used in industries. The Factelligence also keeps track and control production, inventory, material etc.
· Production support DBA for several databases, DB Performance Tuning.
· Upgraded various Development/Production Oracle 9i Databases, to Oracle 10gR2.
· Tuning complex oracle queries using cost based optimization, TKPROF, SQL trace, Indexes, table partitioning
· Accessing data from text file to oracle tables and tables to text file.
· Working on Oracle and SQL Server Database scripts and automation, Factelligence ERP.
· In creation of database objects like external tables, tables, views, procedure, function, packages, indexes, sequences, database link etc.
· Creating and monitoring table spaces, users, executing scripts for many clients.