rameshgiri26

Curriculum Vitae N. Ramesh Giri Objective :Suitable position in a challenging environment where I can provide value addition using my expertise Total ExpSummary of Skills and Experience Experience : 13.9 years in IT Skilled Professional with More then Thirteen years experience in the technology field and including eight years in manufacturing / engineering environments, including serving as Data Center Manager (Systems, Network, Security, Database & Applications) for ITC Infotech Ltd, Experience in Data Center operations management with 24x7 Support and administering very large mission critical 24/7 OLTP/Data warehouse databases. Disaster Recovery & Business Continuity Planning, Data warehousing, Implementing corporate IT strategies, Implementing IT Policies, Process management, Asset and Inventory management, Negotiation of Business with Clients, Reviewing Service Level Agreements and Proposals, Strong leadership, communication and organizational skills. Proven ability to implement technology-based solutions for business problems. Developed policies and procedures for cost reduction and improved efficiencies. §Hardware: IBM RS/6000, IBM RS SP/6000, IBM Netfinity, HP Compaq Proliant, Sun Solaris Enterprise Server & Sun Fire, IBM Robotic Tape Library§ Operating Systems: AIX, Linux, Sun Solaris, Windows 2000 Server, DOS, OS2, Windows 3.1, 95, 98, NT3.5 Server, NT4.0 Server, Windows XP §Networking: LAN, WAN, TCP/IP, WINs, DHCP, DNS, NIS, NFS, SAMBA, VPN, ISDN and DSL -Capacity & Policy planning  Tivoli (TSM) & CISCO View (NMS). -Physical & Logical Security implementation  CISCO PIX, IBM Secure way 4.1, DOS Networking, Windows Networking & Expert in Novell Networking 2.6, 3.11 & 4.x worked from 1993 to 2000. -Maximization of Internet presence. §Security: Cisco PIX, Checkpoint Firewall I& II, McAfee Total Virus Defense, Dr Solomn, Trend Micro Interscan Virus Wall, Norton Antivirus Server, LAN Guard, Sniffer, Intrusion detection and control  nPatrol, Audit for access rights / levels & hacking vulnerability. § Network Hardware: CISCO Pix Firewall, RAD Modem and CISCO 2600 Router, Gigabit Cabletron Switches§ Application Software: VB, Oracle D2K, PB 4.x, MS Access, Crystal Reports, JSP, ASP, HTML, Dbase III+, IV, V, Clipper 5, FoxBASE+, Fox Pro, Pascal, Cobol, Qpro, C, C++, Perl, Java, Oracle Financial 10.7 and Oracle Application Server 10g§ Data warehousing: Oracle Warehouse Builder, ER Win, Informatica, Cognos & Powerplay § Database: Oracle, IBM DB2, Sybase, MS SQL 7.x & 2000, My SQL, MS Access, FoxPro, QPRO, Lotus 123, DBase§ Internet: Microsoft IIS, Apache, Lotus Domino Go Web Server, ASP, JSP, Java, FrontPage, .net, Sawmill Log Miner, SSL, e-Weblog Analyzer§ Java Runtime: JRun 3.1, Apache Tomcat, J Boss, Bea Weblogic, IBM Webspheare§ Mail Servers: Send mail, MS Exchange, Mail Enable & IBM Lotus Notes§ Desktop: MS Word, Excel, Outlook, Eudora, PowerPoint, MS Project, Visio, Adobe Photoshop, Solid Edge, Lotus 123, VNC Viewer, And PC Anywhere. § Phone Security Access Systems: Call management, Tata Telecom PARADIGIM Plus a product from TATA & Lucent Technologies, Security Access Log Management from HID Corporation. Sep 2001  Till Date ITC Infotech Ltd Bangalore § Data Center Manager Handling onsite projects as per the requirement. · Estimating the cost and expenditures on project, Softwares, hardwares and Manpower. · Planning and Solution architecting for new project and estimating the time to workout the project within expenditure. · Implementing corporate IT strategies.· Process management, Asset and Inventory management.· Negotiation of Business with Clients,Reviewing and Preparing Service Level Agreements and Proposals· Delivering or hosting the project within time. · Seeking the new Technologies and Solutions and educating the new solutions and tools to project team. · Database Administration· Managing Oracle 8I & 9I production 24x7 databases on IBM AIX RS6000, Sun Solaris, Linux and Win NT Ranging in size from 10GB to 1TB developed the company Backup & Recovery Plan using the toolset of Oracle RMAN and Tivoli Implemented a Disaster Recovery.· Developed the company database security policy, which included encryption of data.· Created databases to support various testing initiatives.· Upgraded development and production databases to latest Oracle release Identified and tuned poorly performing SQL.· Assisted in the design of production interfaces Implemented the database monitoring system using Korn and Perl Scripts.· Created a detailed Capacity Plan to identify future resource needs.· Developed tuning standards documentation for databases and documented to Jr. DBA's.· Successfully implemented Disaster Recovery using Oracle Data Guard Option, Primary Database is Located in Mumbai and Standby Database Located in Bangalore Data Center for Bombay Stock Exchange and Other Corporate Accounting System Databases.· In depth knowledge in RMAN, Loadjava, transportable tablespaces, Creating Materialized views, Table, Index Partitioning, Creating Hash keys, Database Migration, Database Cloning, Replication setting, parallel server management, User accounts privileges and providing excellent security. · OPERATIONS MANAGEMENT1. LOGICAL & PHYSICAL SECURITY CAPACITY PLANNING FOR FACILITIES2. FACILITIES UPTIME OVER 100%3. HARDWARE UPTIME OVER 100%4. SOFTWARE UPTIME OVER 100%5. NETWORK & COMMUNICATION6. EQUIPMENT UPTIME OVER 100%7. PORTAL & COMMERCIAL WEBSITES UPTIME 100%8. CUSTOMER MANAGEMENT· CAPACITY PLANNING WITH BUSINESS UNITS & WEB HOSTING1. PORTAL ACTIVITY(PLANNING FOR GROWTH, HOSTING, MAINTAINING UPTIME AND NEW CONTENTS UPLOADING, PROBLEM SOLVING, CORDINATING WITH DEVELOPER TEAMS).2. WEB HOSTING (PLANNING FOR SPACE, FEATURE GROWTH, HARDWARE, SOFTWARE REQUIREMENTS, DATABASES, and SECURITIES & MONTHLY HITS REPORT GENERATION).3. MAIL SERVER (HOSTING MAIL SERVER AS NECESSARY FOR COMMERCIAL WEB SERVER VENDORS AS [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL]).4. RESULT PUBLISHING (PSEB) Punjab State Education Board & (CISCE) Council for the Indian School Certificate Examinations.5. WEB HOSTING SERVICES for1. BITES WEBSITE 2. WILBURSMITHPL WEBSITE, 3. ASKACC WEBSITE, 4. INVENTUREACADEMY WEBSITE, 5. SCHEVARAN LABS WEBSITE, 6. ETM Express Transfer Money, 7. ITCL Vault Tracking System&.. And many web servers.· DATA CENTER MANAGEMENT/Maintenance.1. IBM AIX RS 6000 MONITORING ERROR LOG TO CHECK THE HEALTH, UPTIME, DOWNTIME AND CORE DUMP, TROUBLE SHOOTING AND REACTIVATING CORE DUMP FAILURES, APPLICATION CONFIGURATION, DATABASE INSTALLETION AND CONFIGURATIONS, HACMP, MAKESYSB BACKUP, RESTORE, FILESYSTEM MANAGEMENT AND ADMINISTRATION ACTIVITIES.2. LINUX SERVERS LINUX WEB SERVERS, MAIL SERVER AND SQUID PROXY SERVER INSTALLATION, CONFIGURATION MAINTAINING AND UPDATING SECURITY RULES, ERROR LOG, FILESYSTEM ALLOCATION AND APPLICATION SERVERS LIKE JAVA, JRUN, TOMCAT, APACHE, SENDMAIL SERVERS INSTALLETION AND CONFIGURTION AND ADMINISTRATION.3. WINDOWS NT / 2000 SERVER INSTALLETION &CONFIGURATION, ERROR /EVENT LOG, SECURITY AND APPLICATION LOGS MONITORING, APPLICATIONS INSTALLETION & CONFIGURING, APPLYING NETWORKING AND SECURITY POLICIES IP ADDRESS (SECURE, UNSECURE), DHCP ENABLING, DNS, NETWORK CARD INSTALLING AND TROUBLE SHOOTING.· APPLICATION SERVERSAPPLICATION SERVERS IIS, JRUN & TOMCAT INSTALLETION, CONFIGURATION AND ADMINISTRATION ON WINDOWS NT SERVER, WINDOWS 2000 SERVER, IBM AIX SERVER AND LINUX SERVERS.· DNS ServerDNS SERVER (APPENDING NEW DOMAINS ENTRIES AS PER THE MANAGEMENTS & CLIENTS REQUIREMENT, MODIFYING AND DELETING AS PER THE MANAGEMENTS REQUEST, SECURITY CHECK ON DIALY BASIS, AUDITING MONTHLY, WEEKLY BASIS UPDATING NEW PATCHES AND SERVICE PACKS.Achievement/Projects:· Managing Datacenter e-Com hub with 24/7 support & Achieving 99.99% uptime.· Managing 1500 Web & Portal Servers, Proxy Servers, Virus Wall, CISCO Pix Firewall, CISCO 2600 Routers, RAD Modem, IBM Storage Manager, IBM Robotic Tape Library and Giga bit Switches etc. April 2001  Sep 2001 Rishinet Pvt Ltd Bangalore§ Senior Oracle DBA / Team Lead Data Warehousing · The application provides business intelligence analysis services to Affiliated Computer Services sales department on cost-margin performance metrics through interactive client tools. · Data from various online transaction processing (OLTP) applications and other sources is selectively extracted, related, transformed and loaded into the Oracle data warehouse using Informatica Power Center ETL tool. · Then the transformed data from data warehouse is loaded into an OLAP server to provide Business Intelligence Analysis Services. · The end users can drill through the information using Business Objects over intranet/internet. Security has been implemented to control the end user data access. · The whole process is completely automated.· System Administration (Installation, configuration and preparation of Sun Solaris & Windows NT Server for Data Warehouse Databases & Scheduling and Maintaining Backup strategies)· Network Administration (Architecting Network diagram and setting up, Installation and configuration of NIC, SQUID Proxy for Internet Sharing, Configuring DHCP for auto allocating IPs, DNS and Administration) · My Contribution:Data cleansing, validation and loading scripts for Oracle data warehouse using Informatica ETL tool.Involved in designing and mappings. Created and Monitored batches and sessions using Informatica PowerMart Server.Created data mappings to extract data from different source files, transform the data using filters, expressions and stored procedures then load to Oracle data warehouse. Prepared Unit test cases for the mappings. May 2000 Apr 2001 [login to view URL] Bangalore, CBSr. Oracle DBA · Maintaining Oracle 8i and 9i Production Databases with Sun Spark Solaris 8.· Installation and configuration of Sun Spark, Sun Intel, Linux, Windows NT & 2000 Servers.· Installing Oracle on Sun Solaris, Linux, Windows Operating systems as per the company needs for Mail Servers and Web Servers.· Managing Remote Mail Server and its Oracle database Located in US Ranging from 1TB to 8TB.· Implementing and Maintaining backup strategies and Shell Scripting.· Database designing, reviews, fine-tuning / optimizing schemas and queries.· Working with Oracle Tools:- Oracle Express, OraExcel Lite, SQL*PLUS, SQL Loader, Loadjava, Dropjava, Tnsping, lsnrctl, tkprof, svrmgrl, Imp, Exp, Ocopy, DBA Tools Oracle Enterprise Manager (SQL Worksheet, Schema Manager, Security Manager, Instance Manager, Storage Manager, InterMedia Text Manager, Oracle Replication Manager (Advanced Replication and Multimaster Replication).· Migration: - Migrating data from One Database Engine to Other Database Engine.· Backup:-· Maintain backup strategies · Scheduling Automatic Backup for daily, weekly and monthly.· Writing Shell Scripts on Unix and Batch programs on Win NT Servers.· Installed Oracle 8i on U.S Sun Sparc Server Designed and Created New database for [login to view URL], Migrated data from SQL Server 7.x to Oracle. Done performance tuning. Mirroring Raid level RAID 0+1 protection against hardware failure, and Wrote Automatic backup procedures and Shell Scripts. The URL is: [login to view URL]· Leaded for Careerindia Project, Created Database in Oracle and Migrated data from Excel to Oracle. Done performance tuning. Configured Advanced Replication and Wrote Automatic backup procedures and Shell Scripts for database On Linux Operating system. The URL is: [login to view URL]· Leaded City guides Project, Created Database in Oracle and Migrated data from Dbase III+ to Oracle. Performance tuning completed. Configured Advanced Replication and Wrote Automatic backup procedures and Shell Scripts for database on Linux Operating system. The URL is: [login to view URL]· Leaded Schedule soft Project, Created Database in Oracle and Migrated data from MS Access to Oracle. Performance tuning completed. Configured Advanced Replication and Wrote Automatic backup procedures and Shell Scripts for database on Linux Operating system. The URL is: [login to view URL] 19932000 BPL Limited Bangalore, WFDOracle DBA· Installed Oracle 5 In Novell 2.x Server for Development and design.· Installed Oracle 7.3.4 and Oracle Financials / Oracle Applications 10.7 on Windows NT Server as per Corporate Office requirement.· Created New Database for Oracle Financials & COREMAN ERP on Windows NT Server based on corporate design and Performance Tuning Completed.· Created New Database for another application VAYU Central Excise Package.· Maintain, upgrade and monitor Oracle databases.· Implement and Maintain backup strategies, including export, cold & hot backups. · Estimate and plan for database growth.· Configure and maintain Oracle Application. Server. Act as Remedy Administrator / Project Manager.· Maintain scheduled reports as necessary. Set up and maintain test servers.· Perform or manage data scrubbing. Install and configure client software, SQL*Net and ODBC drivers.· Interview, hire and train employees as needed, and assist in hearing a Network Operations Manager.· Oracle Client Installations for Client users (Oracle Network and Security Administration).· Allocating system storage and planning future storage requirements for the database.· Creating primary database storage structures (table spaces) once developers have designed an application.· Creating primary database objects (tables, views, and indexes) once application developers have designed an application.· Enrolling users and maintaining system security.· Ensuring compliance with Oracle License agreements.· Controlling and monitoring user access to the database.· Monitoring and optimizing the performance of the database.· Planning for backup and recovery of database information.· Maintaining archived data on appropriate storage devices.· Implementing and maintaining backup and restore strategies.· Estimate and plan for database growth. · Maintaining Vindoor Satellite (VSAT).· Novel Server Administration (Installation and Configuration of Server and Clients Node for DOS Based Applications with Diskless Client Nodes).· Windows NT Administration (Installation and Configuration, Trouble shooting, Daily activities of Backup and Maintenance as per the corporate policy.· Networking (CAT Cabling & Installation and Network Card Configuration with Boot ROM for Novell Diskless Clients), CAT 5 Cabling with RJ45 Connectivity with Hubs and Network Card Installation on Windows NT Servers.· Desktop Support Attending desktop support calls, Application Installation & Configuration, troubleshooting and resolving client problems.· Mail Server Administration· Lotus CC-Mail Administration. May 19921993 BPL Limited Bangalore, WFDEDP Executive· Programming in dbase III+ & Clipper Version 5 Purchase ordering, Sales, Stock Transfer, Central Excise.· Suggested new method data processing operations in dbase and Clipper that helps much better then earlier.· Developed New Application for Factory Production (IFMS Package) Integrated Factory Management System.· Developed Related Reports.· Developed Tool Analysis Package to maintain Tooling Transaction.· Developed many business applications and software packages such as payroll and PMS (Personal Management System) for HR, office accounts, invoicing, record keeping, stock control, sales analysis, financial forecasting and even word processing.· Novel Server Administration, · Windows System Administration, · Networking and Desktop Support.· 1. Preparation of transaction documents.· 2. Control of operations.Projects Done:1 IFMS (Integrated Factory Management) Client : BPL (Internal)Duration : 8 monthsTeam size : 2Software : Clipper5, Dbase III+, FoxBASE+Location : BPL2 PMS (Personal Management System)Client : BPL (Internal)Duration : 2 monthsTeam size : 2Software : Visual Basic 4.0 with MS Access Database.Location : BPL3 TA (Tool Analysis)Client : BPL (Internal)Duration : 5 monthsTeam size : 2Software : Power Builder With Oracle Database, Education Bachelor of Commerce from IGNOU University, Master of Computer Application from IGNOU University. Certifications Diploma in Computer Applications Diploma in ProgrammingDiploma in Database Administration Interests Reading Books, Cricket and Maintaining documentations. Strengths Quick at establishing rapport with other person, Good at Networking and organizing, Well versed with Computer hardware and applications. Date of Birth: 30-06-1973. Martial Status: Married. Refrence : Will be provided on Request