Technical Support
Nizwa College of Technology(Oman)
مجموع سنوات الخبرة :12 years, 1 أشهر
Examining the resources available and their utilization.
•Developing project in module based. Verifying each module separately and combined, to check its reliability.
•Developing procedures, functions, packages needed for the project.
•Troubleshooting any problem arises and makes sure the project functioning as needed by the client.
•Providing Knowledge Transfer (K.T.), to junior programmers to maintain project sustainability in future
Creating tables for storage of data, with the columns with
Needed constraints as per the project need.
•Verifying the project modules both as differentiated and integrated modules.
•Maintaining the project by recreating the indexes after every structure change in the associated tables.
•Inserting new or updating old data in procedures and verifying the operation of the procedures, functions, packages in the project.
•Writing codes for the triggers with the mentioned events for which it has to be fired.
•Writing exception handlers to catch the particular exception(s).
•Reports produced on daily basis, regarding maintenance of the project by explaining any new or updating data were inserted in the project.
PROJECT--2
Work Profile (DBA ) in PageOne Technologies and NCT
•Installation of Oracle 10g on Linux operating system
•Manually creating databases and maintaining databases
•Creating users and granting the user privileges
•Creating Non system tablespaces and assigning quotas to the users
•Creating Undo and temporary tablespace and assigning it for a database
•Creating Index for columns of tables and to analyze the indexes
•Analyzing the tables and defragmentation of tables
•Defragmentation of index and validating the index
•Monitoring the growth of database
•Multiplexing the control files and recreating the control file
•Adding log file groups and members into a group
•Backup and recover the database using Cold and Hot backup, Export and
import, RMAN
•Creating catalog mode in RMAN
•Creating the clone database using RMAN or Hot and Cold backups
•Checking the consistency of datafiles using DBverify Utility
•Loading the data into table using SQL loader
•Analyzing the Query using explain plan and tuning
•Gathering the statistics of a database using AWR
•Taking backup of control file, datafiles and archivelog files using RMAN
•Taking backup using RMAN(incremental level 0 and 1)
•Restore and Recover the datafiles using RMAN when required.
•Creating catalog mode and register the database in RMAN
•Crosscheck the backups and report, delete obsolete backups
•Creating database links to share the objects from one Database to another
•Export/Import of tables, schemas
•Inserting data into the table using Sql-loader
•Applying archive threads for user managed backup to recover the database
•Configuring LISTENER & TNSNAMES using netca
•Collecting and storing database statistics using automatic workload
repository, generates snapshots and tuned database
Maintenance of Oracle Databases including managing Tablespaces, Indexes
And disk space
•Backup the full database, tablespace level, schema level using exp/imp based on request
•Renaming and relocating the datafiles and logfiles
•Managing Undo and temporary Tablespaces
•To manage control file multiplexing and to trace the control file
•Adding log file groups and members into a group
•Checking growth of database size, tablespace size, schema size using shell
script
•To backup the database, tablespace and schema using export
•Import the backups from one database to another database
•Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc
•Identify columns for Primary Keys in all the tables at the design time and create them
•Creating tables, indexes, synonyms. Have got multiple customer tickets for resolving several critical, pending issues
•Monitoring the database growth and Re-Organizing the tables and indexes whenever required
•Creation of oracle users, roles and profiles
•Granting privileges to roles and users
Affiliation of Engineering Colleges (C.E.P), Anna University, Chennai 25.
Automated Fees Collection Module
Client AcademicInformationManagementSystem(AIMS), AnnaUniversity, Chennai25.
Description Modules and work details for A.I.M.S
•Fees Collection with 5 data blocks and 1 control block.
•Facilitated by individual and cumulative report generation.
•Modification page with auto executable tab.
•Page hosted in intranet.
Other
Responsibilities •Assisted in TNEA (Tamil Nadu Engineering Admissions).
•Assisted in developing an application for MCA faculty program.
•Developed application for Teacher’s assignment by students.
Work profile in Hardware & Networking (Anna University)
Troubleshooting like HP, IBM, Sun Sparc various Branded systems Solaris, DELL
O.S Installation - Windows 2000, 2003, XP, NT
Solaris - 8, 9
Linux - Fedora Core 6, Red hat
Hardware Maintenance for SOLARIS E350 SERVER.
Brief knowledge in handling Operating systems like Solaris, Linux, UNIX, Windows.
Good knowledge in handling Network tools like Putty, Hummingbird.
Work Profile in Nizwa College of Technology Sultanate of Oman
•Installing Oracle Software in Systems
•Troubleshooting Oracle software
•Marinating Hardware of Computer, Printer and projector.
•Troubleshoot other software if any issue arises.
•Maintenance of lab and lab activites of students
•Tutor to students in their subjects and Projects.
(
i , 10g, 11g
Solaris/Unix Administration and Networking SIDO (Government of India