|
|
|
Professional Profiles |
|
IT-CAREERNET
.
|
From: Ashwani Kumar
Date: Thursday, August 05, 2004
Time: 02:05 PM
ASHWANI KUMAR ashwanijee@yahoo.com Date of Birth: 24 JAN, 1981 Male, Single Mobile: +91-9818739385 Objective: Seeking a challenging position as an Oracle Applications DBA. Summary of Qualifications •Oracle 9i Certified Professional. •Total of 1 yr experience in Oracle Database Administration which also includes 6 month of experience in administration and support of Oracle Applications. •Expertise in Oracle Applications includes Installation, configuration, remote administration, cloning, patch application and tuning of Oracle Applications on Sun Solaris platform. •Expertise in Oracle Database includes installation, configuration, remote administration and support of Oracle Databases on Windows, Linux and Sun Solaris Platforms using OEM, DBA Studio, tkprof, LogMiner, SQL*TOAD, Utlbstat, Utlestat, Statspack, Crontab, RMAN, PL/SQL Developer, PC Anywhere, Terminal Client, VNC, Webmin and WRQ Reflection. •Proficient in Client server system analysis, Designs Implementation and maintenance of large OLTP Database Systems. •Strong communication and Interpersonal skills. Technical Skills Summary OCP: Oracle Certified Professional (9i-DBA) Business Applications: Oracle Applications 11.5.7/11.5.9 Data Warehousing & Business Intelligence: Oracle Express Server, Oracle Financial Analyzer, Oracle Sales Analyzer. Operating Systems: Windows 9x/2000/XP, NT 4x, DOS, LINUX, Sun Solaris 8/9 DBMS: Oracle 8i/9i, SQL Server 2000, MS-Access, FoxPro Programming Languages: C, C++, LISP, FORTRAN, JAVA, VB6.0, VC++ 6.0, UNIX Shell Scripting, Perl Scripting, PL/SQL. IDE: Visual Studio 6.0 Internet Technologies: HTML Tools: SQL*Loader, Export/Import, OEM, DBA Studio, SQL*Toad, PL/SQL Developer, SQL Navigator, PC Anywhere, Terminal Client, VNC, WRQ Reflection. * Expertise level in different skills varies. Education ·MSc (IT) from DAV College affiliated to Punjab University, Chandigarh Year 2003 ( 81% ) ·BCA from DAV College affiliated to Punjab University, Chandigarh Year 2001 ( 77% ) ·Senior Secondary Examination from CBSE Year 1998 ( 83% ) ·Secondary Examination from CBSE Year 1996 ( 73% ) Certifications Oracle 9i Database Administrator (OCP) The Exams includes: ·Introduction to Oracle 9i: SQL (95%) ·Database Administration (90%) ·Backup, Recovery and Networking (95%) ·Performance Tuning (86%) Work History MothersonSumi INfotech & Designs Ltd., NOIDA (http://www.mind-infotech.com December 03 onwards MothersonSumi InfoTech and Designs Ltd. (MIND) provide solutions in Business Process Automation, Integration and Optimization by providing Information Technology Solutions. MIND primarily works in the domains of manufacturing, transport and logistics, healthcare, education and e-governance. MIND is technology partner with the following global software leaders: Microsoft (Gold Partner for E-Commerce Solutions), Oracle and IBM. MIND is a joint venture of the Sumitomo Wiring Systems Ltd., Japan (www.sws.co.jp, turnover USD 2 Billion) and the Motherson Group, India (www.motherson.com, turnover USD 125 Million). Client: Sumitomo Wiring Systems, JAPAN (http:// www.sws.co.jp) *Current project Technology Used: Oracle Applications 11.5.7, Sun Solaris 5.8 Role: Oracle Applications DBA/Oracle DBA Responsibilities: ·Installation and Configuration of Oracle Applications 11.5.9 on Sun Solaris 5.9. ·Cloning of Oracle Applications 11.5.7 production server on local Sun Solaris Server using Rapid clone. ·Application of patches on production server as and when required using adpatch. ·Creation of new application users and assigning responsibilities as and when required. ·Installation and configuration of Sun Solaris Server and mounted Linux partitions using NFS on Solaris Server to compensate for the additional Hard disk Requirements. ·Installation and Configuration of Oracle Express Server, Oracle Financial Analyzer and Oracle Sales Analyzer. ·Implementing automated scripts like monitoring alert log files using grep, disk space checking, hit ratios of Database using dynamic performance views, system statistics and system wait events. ·Resetting the passwords of the application user and sysadmin using FNDCPASS. ·Scheduling the scripts on production server for backup of Oracle Applications, deletion of old archived redo log files, and various other files like out, debug and lst files. ·Running various diagnostic scripts, data fix scripts as provided by Oracle. ·Maintenance of daily log reports describing the status of the database like Invalid objects, tablespace free space, RBS Activity, Archived status, Tables reaching their maximum extents, hit ratios. ·Regularly monitoring the System Statistics at Operating System level using commands like vmstat, iostat, sar ·Configuration of sendmail on Production Server to automate the emails to the administrators describing the output of scripts scheduled on the server. ·Configuration of Samba server to share the Solaris Server mount points with Microsoft Windows Operating System. ·Raising TARs on Metalink and conducting ODC sessions with Oracle on Severity 1 issues like Invoice Stuck problems, Requisition number not generating on 24/7 basis. Other In-house Responsibilities ·Installation and Configuration of Oracle 9.2.0.1 on windows 2000 Server for Organization’s Accounts Department. ·Installation and Configuration of Oracle 9.2.0.4 on Red Hat Linux Enterprise Edition for development purposes. ·Scheduling of physical hot backup and logical backup on daily basis and automated emails of backup status using blat utility on Windows 2000 Server. ·Scheduling of RMAN backups on Linux Server using recovery catalog database installed on Windows machine and automated emailing of backup status using sendmail utility. ·On Regular basis, recovery test is performed with different scenarios on Organization’s Accounts database to ensure that a proper disaster recovery plan is being followed. A-1 Technology, Inc., Chandigarh (http://www.a1technology.com ) June 03-December 03 Designation: Oracle Database Administrator A-1 Technology is a New York based custom software solutions provider with extensive experience in software development. It provides technical and business resources as an outsourced capability. 1.Client: SendWordNow, LLC, USA ( https://www.sendwordnow.com ) Technology used: Windows 2000 Server, IIS 5, PHP, Oracle 8i Role: Oracle Database Administrator Responsibilities: ·Implementation of Oracle database server on remote locations on Windows 2000 Advanced Server Platform. ·Performing day to day database maintenance activities such as observing database object size, its growth on remote locations through Terminal Client and PC Anywhere. ·Responsible for keeping the data model synchronized between the live and test environments. ·Providing help to the developers in designing complex queries, views and stored procedures. ·Creation of Stored Procedures for the merging of databases, deletion of accounts, importing new data from excel sheets into the Oracle database and its distribution into all the tables of database and vice versa. ·Maintenance of table structures, views and Indexes. ·Measuring the performance of the database using various dynamic performance views, system statistics and wait events. ·Automated Backup Scripts using batch files and automated FTP of backup sets to different backup locations and automatic email alerts in case of any failure of scripts. ·Regularly testing the backup scripts with different scenarios to ensure recovery strategy. 2. Client: GotVMail Communications, LLC, USA ( http://www.Gotvmail.com ) Technology used: Windows 2000 Server, ASP.Net, Oracle 8i Role: Oracle Database Administrator Responsibilities: .Implementation of Oracle 8.1.7 database servers on Windows 2000 Platform. ·Performing day to day database maintenance activities such as observing database object size, its growth, log switch timing, alert log files of 24x7 database on remote locations through PC Anywhere and Terminal Client. ·Creation and Maintenance of Standby Server in order to minimize the down time. ·Established connectivity between various clients of Windows 98 and Windows 2000 with Oracle database using NET 8.0 and SQLNET. ·Created, documented, and implemented automated scripts for database backup and recovery and activating the standby servers. ·Responsible for keeping the data model synchronized between the live and test environments. ·Involved in monitoring the space utilization, chained row identification and measuring the degree of database fragmentation. Removed fragmentation of tables by exporting, truncating and then importing the tables. ·Performance Tuning of databases using various dynamic performance views, Statspack report, system statistics, wait events and explain plan. ·Creation of the menu oriented front end application developed in Visual Basic containing various options like date of last Backup, showing offline files if any, backup operations, startup and shutdown of databases. ·Provision of daily reports of backups through automated Email facility. 3. Client: ConnectMe, LLC, USA ( http://www.Connectmevoice.com ) Technology used: Windows 2000 Server, ASP.Net, Oracle 8i Role: Oracle Database Administrator Responsibilities: ·Implementation of Oracle 8.1.7 database server on Windows 2000 Server Platform. ·Security Management - Creating Users, Roles, Profiles ·Space Management - Tablespace creation, adding new data files, creating rollback segments. ·Creation of Database Triggers, Stored Procedures for the application development team. ·Optimizing & Tuning slow running SQL statements. ·Setting optimal parameter for rollback segments to handle fluctuating transactions and assigning separate rollback segments to large transactions. ·Tune SGA by allocating memory and reducing I/O contention. ·Regular backup scripts for the databases using RMAN. ·Responsible for the performance tuning of the Oracle database at times when reported by developers and users using utlbstat/utlestat, explain plan and various dynamic performance views. ·Creation and Maintenance of Standby Servers in order to minimize the down time. ·Provision of daily reports of backups through automated Email facility. ·Listener configuration for connection for multiple instances. 4 months Industrial Training at VASS Services Pvt. Ltd., Panchkula (http://www.vassservices.com VASS Services offers IT automation and turnkey techno-commercial solutions from strategy formation to shop-floor process control for the Process Industries and helps bring savings for it’s customers through IT applications in Marketing, Manufacturing, Procurement, Inventory, Costing & Accounts, Maintenance and HRD functions. Client: Silver Industries, Ludhiana (ERP Project) Technology used: Windows 2000, Red Hat Linux 7.2, Visual Basic 6.0, Crystal Reports 7, Oracle 8i Role: Software Developer, Oracle Database Administrator Responsibilities: ·Involved in the system requirement analysis. ·Database Designing, setting up constraints, tables, views, indexes and stored procedures. ·Implementation and configuration of Oracle 8.1.7 database server on Linux 7.2 Platform. ·Coding of Visual Basic forms comprising all of business activities from Enquiry Generation till Invoicing which includes Generation of Purchase Order, Material Receipt, Customer Order Decoding, Dispatch Plan, Packing Slip, Invoice Generation etc. ·Creation of various value added reports in Crystal Reports 7.0 like ABC Analysis, Item needs PO, Segment wise Sales, Packing Plan vs. Actual Transfer, and Order vs. Stock Status etc. ·Tuning of database queries to minimize the physical and logical reads. ·Used EXPLAIN PLAN and TKPROF statements to monitor execution plan & fine tune the SQL statements ·Established connectivity between various clients of Windows 2000 with Oracle database Server using NET 8.0 and SQLNET. ·Partitioning of tables and indexing on columns to make the execution of queries faster. ·Created, documented, and implemented automated scripts for database backup and recovery using crontab. ·Tuned the database to work efficiently, planned database storage for future requirements, and optimized the database. ·Trained users, migrated database from Dbase to Oracle, conducted a parallel run, and handed over the system to the Organization. Other Academic Projects ·Project on Hotel Management having features like complete room booking for the customer, complete food order processing and billing, full access by the administrator using encrypted password storage mechanism. (Using VB 6.0 and Oracle 8i). ·Project on School Management for B.L .Public School, Baddi H.P. (Using VB 6.0 and MS Access). ·Project on Hotel Management for computerization of the underlying activities such as order processing & billing (Using C++). ·Project on the Personal Assistant for maintaining various details of the persons and automatic reminders of their Birthday and Anniversary (Using JAVA and MS Access). Achievements ·Attended 5 days full time training on Solaris Administration-I from Silicon Comnet in June 04. ·Attended 3 days full time training on Enterprise Java Beans (EJB) in May 04. ·Participated in the NSS Camp in 1997 at GreenFields Public School, Delhi. ·Received Merit Certificate for the Most Regular Student in year 1998. ·Actively participated in various sports activities in the school and won many prizes. ·Received Merit Certificate for securing 60% marks in the National Mathematics Olympiad in 1996. ·Received various Merit Certificates in securing various positions in academic sessions in BCA and MSc (IT). ·Provided technical assistance to Mr. Amit Gupta in his book Understanding Data Structures Through ‘C’. Current CTC: 2.4lac/annum Current Location: NOIDA (U.P.) Joining Time: 1 Month (Ashwani Kumar)
|
|
|
|
|
|
|
|
© 2002-11 IT-Careernet.com
Reproduction, retrieval, copying or
transmission of the content of this site is not permitted without the
publisher's prior consent. Last changed:
January 27, 2012
|
|
-start of code- -end of code- &n bsp; Sponsor: ITC Software
