Andrei S.

## BIO A senior **Web** and **Database developer** with advanced database and system skills: **MySQL**, **Oracle DBA**, **Unix and Linux Systems Administrator** and **System Integrator**, over **12 years experience** in financial, pharmaceutical and telecommunication industries. **Perl:** has in-depth knowledge and experience with Perl techniques like **regular expressions, hash and arrays,** general data processing, IPC, multi-threads, **CGI** web applications, automatic web-based scripts and back-ends, email and paging alarms, collecting information from websites (spiders), **DBI** interface for Oracle, Sybase and MySQL, data compression techniques. **VOIP:** up-to-date experience with the open source PBX systems installation and maintenance: **Asterisk** 1.2, 1.4, 1.6, hands-on **PRI/T1/E1,** analog **Zaptel** cards and channel banks configuration, **IAX2, SIP**, STUN, hardware and software phones, **Asterisk GUI**, **IVR** menus, voicemail, custom **AGI** scripts, reviewing and provisioning connections with VOIP providers, resolving **NAT** and **firewall** issues, software phones installations. Fax-to-Email, Email-to-fax gateway configuration based on **spandsp** and **Fax For Asterisk**. Monitoring calls using web-based flash panel. Sound files preparation, format conversion. **MySQL:** general database development experience and planning, optimized SQL queries, web front-ends with **PHP, Perl, Java**, utilizing solid ground-breaking approach for database development. Tuning performance issues, bulk data load implementations and **automatic backup** scripts, handled big tables with millions and billions of records sized in gigabytes and terabytes, under both **MyISAM** and **InnoDb**, troubleshooting, complicated cases of slowness and imperfections with database design. **Unix:** worked with SunOS, Solaris, HP/UX, SCO, BSDi, **Red Hat** Linux family,** Debian** and most of other Linux based systems, has extensive experience with **Shell**-scripting and Unix standard set of commands. Administration, upgrades, **high-availability**, clustering, **DRBD**, performance fine-tuning, providing support for end-users and developing system software. **Windows:** has advanced administration skills for Windows based servers and PC: Windows NT, 2000, XP, 2003, 2008, Vista, Windows 7. **VmWare:** has completed tens of successful VmWare installations on low-end hardware with limited resources and more powerful server platforms, **HP** and **Dell** servers. Solved inefficiencies and shortcomings, performance tuning, migrations to virtual machines, fixed networking troubles like slowness and connectivity issues with virtual environments for a range of guest operating systems: Unix and Linux, as well as Windows OSs. Optimized VmWare host platforms including popular versions ESX Server 1.x and 2.x for Windows and Linux, ESXi 3.x, and firewall engines and virtual router setup under VmWare, such as m0n0wall versions 1.3.x. **Web:** worked with Web and Application servers like Tomcat, Weblogic, Apache 1.x and 2.x, IIS, provided support, maintenance, installation and configuration for the Web servers. Developed Web applications using CGI, JSP, Java servlets and AJAX. Has advanced dynamic HTML and Javascript skills. **Oracle:** possesses Oracle DBA skills to solve performance problems, complicated tuning, troubleshooting, database design, automatic backup and maintenance solutions, Advanced Replication, developed stored procedures, triggers. Worked with and supported databases over 100+Gb, managed LOBs and partiotioned tables. **Historical projects:** Andrei has participated with Eugene Roshal in development and promotion of famous **WinRAR archiver** (mentioned on Acknowledgements page of Help in WinRAR program) and **FAR manager**. **Andrei’s detailed formal resume is available upon request.** ## Area of Expertise In-deep experience with MySQL 4.x and 5.x, PHP, Oracle, Unix OSs - FreeBSD, Solaris, HP/UX, many flavors of Linux: Debian, Red Hat, Gentoo and more, VmWare; VOIP, SIP, IAX2, Asterisk open source PBX experience. Windows 9x/NT/2000/XP/2003/2008/Vista/7, advanced data processing using Perl, Java, Web and database programming. Rent-A-Coder strategy and promise: taking real projects that will be completed in time and to the maximum customer satisfaction.