- Featured in the Wall Street Journal
Status: Logged Off
Search All Resumes | Submit Your Resume
Software Engineer - Telecom - CDMA Resume
Mythri
UK
Oracle DBA
An Oracle DBA offering 2+ years of progressive experience. Experience in Creation,implementation,maintenance and supporting of Production databases. Extensive experience in Backup and Recovery of the databases.Seeking a position where my experience and capabilities can be used to contribute to a company’s objective.
Let us help you find a job, submit your resume now.
Or visit our education page to learn about getting your degree online
tuning experience using EXPLAIN PLAN,AUTOTRACE,TKPROF and STATSPACK utility.
Very good experience in recovering databases.
Wrote sql scripts for database monitoring.
Implemented Purchase order,Stores,Warehouse&Production Systems modules.
Maintained Production package called 'Fabrica' and 'Voyager'.
Can communicate well with people at all levels.
Extremely quick learner with the ability to adapt.
Technical Summary:
Databases: Oracle 7.x/8.0.x/8i/9i ,Sysbase, Ms-Acess
Operating Systems: HP-Unix 10.1.1.0
Windows XP/2000/NT/95
DBA/Development
Languages and Tools: SQL,PL/SQL,DBMS/UTL packages,SQL*Plus,SQL*Net,SQL *Loader,EXPort/IMPort,STATSPACK,SQL trace,EXPLAIN PLAN,TKPROF,Enterprise Manger,Oracle Forms 4.5,Oracle Reports 2.5, TOAD,Foxpro.
Languages: SQL,PL/SQL,VB,VC++,VJ++,C++
Professional Experience:
Employer: Arvind Clothing Limited(01/march/2000 till 15/june/2002)
Position held: Database Administrator / Developer
Worked on custom made packages called 'Fabrica' and 'Voyager' which specialises in Supply Chain. Implemented Purchase Order,Stores,Warehouse and Production Systems. Created Database,Tablespaces,Users,Rollback Segments,Indexes and all other Database Objects. Administration,performance Tuning of Application & Database,SQL tuning and optimisation of the database resources.Installation,Designing & Development of Applications using Forms4.5/Reports 2.5 as per users requirements and delivering effective solutions.
Project Experience
Software Implementation for Warehouse management
The Existing Warehouse Module was upgraded to new sofware called Voyager.The front end is on forms6i and DB is on Oracle 8i on Win2K. This system is the central warehouse for all brands intended to connect the various dealers across the country to a central database.
Role: DBA
Installed Oracle on Win 2k,created users,Involved in designing tables.
Migrating data from old system to new using PL/SQL.
System Analysis,extensive interaction with software vendor as a single point contact for all software issues.
Providing test database to the programmers.
Monitoring performance issues of DB,created indexes,Backup and Recovery plans for 24x7 databases,wrote backup scripts.
Analyzing user requirements and providing solutions,inputs to programmers on software issues.
Support activities for Voyager included writing reports using SQL.
In-house MIS module for a Marketing/Commercial organisation
A Detailed MIS module was designed and prepared which gave detailed analysis of Customer ageing and Stock Ageing.This system involved collection of data from all Carry Forward Agents(CFAs) across India. This was to be consolidated at one centralised location. Data is received in text format from all over India through mail or floppy from a legacy based application.This involved collection and storing large amount of data on a daily basis.
Role:DBA
SQL Loader scripting.
Designing of Tables.
Designing and developing reports using Reports 2.5
DBA activities of the system.
Analyzing user requirements,Development and final testing of the application.
Warehouse system Maintenance for a manufacturing organisation
Warehouse Module was split from the main 'Fabrica'-supply chain software due to excise duty regulation. Took charge of Warehouse systems and Stores systems,fine tuned warehouse system reports-Dispatch Module,Receipt of finished goods from Shop floor Module & Job Workers,Return Inwards,Invoices,Good Receipt Notes,Delivery Challans modules.
Role: DBA
Installed Oracle 8i on Win NT,Maintaining DB,backup scripts.
Modified forms to take in new changes,handled system crash.
Merged stock on hand reports with sales reports which enabled Supply chain to identify exact sku levely thereby enabling a sound production plan.
Production System Maintenance for a garment production unit
This was the production module designed to meet the requirements for the Production and planning control.
Role:DBA
Involved in DBA activities of the system.
Installed oracle software and patches.
Created tablespaces,tables & Indexes and other database objects.
Creating users and assigning privileges to users.
Monitoring Databases.
Implementing security policies.
Resolving Performance issues.
Optimise the init.ora parameters for the best performance.
Ensuring adequate recovery procedures are in place based on
Database Backups being done and verified.
Responding immediately to any critical conditions.
Checking for database corruption.
Low Disk spaces(track and trend space utilisation).
Migration of databases.
Employer: GuruBrahma Concerns (23/oct/98 -01/may/99)
Position held: Junior Faculty
Role : Training students on Oracle /Forms/Reports
Educational Background:
Bachelor of Commerce (April 1998)
Post Graduate Diploma in Software Technology and Systems Management (April 2001)
A job posting is required to veiw full resumes.
Click here to post a job now.
Director Field Operations- Denver
Senior Human Resources Manager
Coordinator of Civic and Community Engagement
Request information about online degrees in:
Advance Your Career with an Online Education
Easily Recognize Your Dream Job by Creating an Ideal Work Profile
How To Interview For a Job With a DWI / DUI Misdemeanor on Your Record
How to Get and Stay Motivated To Accomplish Your Job Search Goals