Parm Patram
Phone : (404) 216-4283
Email: ppatram _at_ btsincorporated.com
Summary
Mr. Patram has been an Oracle DBA/Oracle Apps DBA for more than 5 years and a Linux/Solaris Systems Admin for more than 10 years. He holds the Oracle Certified Professional and Solaris Certified System Administrator credentials and is also very versed in Linux (Redhat).
He has proven ability to improve manageability, stability, security and performance. His analytical, troubleshooting, and creative abilities allow him to adapt to any circumstance quickly, accurately pinpoint root cause, and come up with unique solutions.
Skills Summary
* Oracle 10g/11g
* Recovery Manager (RMAN)
* User and Security Administration
* Export/Import (exp, expdp)
* Logminer
* Streams Replication
* Dataguard Standby Database
* Oracle Enterprise Manager (OEM)
* Oracle EBS
* Performance Tuning
* Materialized Views (Snapshots)
* PL/SQL, sqlplus
* Real Application Clusters (RAC)
* mySQL
* postgresql
* Unix Shell Scripting (bash, ksh)
* PHP/Perl, expect, C Programming
* Code Versioning (svn, fisheye)
* Linux/Solaris (kickstart, LVM/Disksuite RAID, NFS, samba)
* Installation/Configuration (rpm, up2date, yum, apt-get)
* Advanced Network Troubleshooting (ping, ipcalc, arping, tcpdump, nmap)
* Advanced Application Troubleshooting (strace/truss, netstat, ipcs, lsof, ps, jconsole)
* Monitoring (Hyperic, openNMS, SNMP)
* Migration (rsync)
* Change/Configuration Auditing (Tripwire, custom scripting)
* Change Control
* Automation (expect, Perl, C, shell)
* Apache/Tomcat
Work Employment History
Nov 2009 – Present: Linux/Solaris & Oracle Database Administrator at Barnhardt.
* Managed development, stage and production databases and application servers for large manufacturing company’s ERP.
* Install/configure Solaris 9 on Sunfire 280R. Developed method to clone the production server to backup/stage for consistency. Did some hardware work with RSC.
* Updated old documentation and wrote new articles in tech services wiki relating to Linux/Solaris/Oracle.
* Developed and implemented method to permit Oracle 10g Dataguard to compress archivelogs using SSH port forwarding (Linux).
* Wrote custom plugins in Perl/bash/ksh for Hyperic to monitor Oracle Streams, Oracle Dataguard, and certain specific metrics on the application server.
* Developed scripts using expect to test ERP functionality in an automated fashion.
* Helped establish Change Control process.
* Installed ERP on Linux (RHEL 5) for functional/development testing.
* Streamlined Dev refresh process by scripting much of the pieces and creating a checklist of the order to execute those scripts. Project time did not permit a fully automated approach, which was the next progression.
* Updated some of the scripts to use command-line arguments. This allowed the scripts to be exactly the same, but function differently based on arguments.
* Updated the ‘standby monitor’ to perform checks to eliminate false alerts.
* Developed ‘Tango’, which is a way to detect changes to an Oracle database’s settings or object properties. Tango consists of Oracle PL/SQL package and bash/Perl OS scripts.
* Developed method to resize the filesystem used for archive logging without needing to stop the database (Linux).
* Installed monitoring/auditing tools: Tripwire, openNMS, and Hyperic on RHEL 5 systems.
* Helped with securing the ERP platform.
* Identified/corrected performance problems resulting from over-sized SGA. Implemented SQL Profiling to improve performance of certain problem queries (Oracle).
Aug 2005 – Nov 2009: Senior Linux/Oracle Database Consultant at Business Technology Services, Inc.
* Specialized in RHEL, Oracle 10g and Oracle EBS.
* Managed company’s dedicated Linux server which services their website and email needs.
* Worked for many clients of BTS, Inc. in various industries.
* On call support.
* Oracle Dataguard standby database implementation, troubleshooting and tuning.
* Oracle Streams replication.
* General Troubleshooting and problem resolution.
* Custom monitoring for Linux OS and Oracle database.
* Oracle database performance tuning.
* Oracle RAC on Linux (RHEL) implementation and monitoring.
* Oracle EBS (11i and 12i) patch investigation and installation.
* Oracle EBS cloning.
Jan 2000 – August 2005: Senior Linux Administrator at Interland, Inc (now Peer1).
* Worked in Dedicated Server Solutions department which offered billable Admin services to company’s Dedicated Server customers.
* DSS also provided Data Center Operations support for company’s Shared Servers in addition to the Dedicated Servers (5000+ total).
* Tier III support for Dedicated Services (non-billable questions and issues).
* Assisted Engineering with build issues by writing work-around scripts and providing diagnostic data.
* Was the leading revenue earner in DSS.
* Some hardware work (HP/Compaq Proliant, Cobalt, white-box).
* Plesk Linux Control Panel SME. Wrote many scripts to manage and migrate Cobalt RAQ, systems with no control panel, and older versions of Plesk to the newest Plesk versions.
* Instituted Clean, Patch, &Lockdown service for customers whose servers had been hacked into.
* Invented ‘Backplane Sharing’ to retrieve data from RAID array on non-booting servers by using the dead system to power up the RAID array so it can be mounted to a running machine in order to perform a data copy.
* Developed unique method of reviving badly hacked servers that fail to boot by booting from CD, chroot, then manual services startup. Used as a stop-gap until a full migration to a new server could be effected.
* Provided excellent sales support for sizing requirements and other technical consulting required for completing the sale.
Miscellaneous Freelance Work
Omega Learning Centers (http://omegalearningcenter.com).
Administer company’s web server and email server. Maintain and add new functionality to company’s suite of proprietary web-based interfaces used for running their business. Instrumental in scaling the products out to meet their need to franchise. Company now has 3 locations and growing.
3D Cellular (http://omegalearningcenter.com).
Administer company’s web and email server. Manage server firewall. Responsible for the SSL certificates in use for both the website and email. Implemented VPN between LAN and Internet server. Designed custom scripts for backing up customer’s project files from their local area network to the server as well as designing and implementing an off-site backup plan for the server itself.
Kagan Creative (http://kagancreative.com).
Server administration and migration. Built and configured a dedicated mySQL server for client. Also responsible for about 10 SSL certificates for various websites running on the web server. Configured 3-node load-balanced web server for client.
HPP Christian Hosting (http://hppchristianhosting.com).
Administered 3 high-traffic and heavily populated web servers totaling about 1000 different websites. Identify and upgrade old vulnerable applications running on the various websites that were being hacked into. Migrated the servers a few times to keep up with growing demand and the need for faster hardware. Assisted with some handover work when client sold the business in September 2007.
Certifications
Oracle Certified Professional (Database and Grids), 2009
Solaris Certified System Administrator, 2003
Microsoft Certified Systems Engineer, 1999
Education
1990, Associates of Arts (Data Processing)
References
Available Upon Request
