Gamal Gayitov

Gamal Gayitov

System Administrator,
Developer and Software Engineer

Personal Profile

Experienced IT/Telecom engineer.

I'm the IT guru:
System Administrator/ Software Developer/ DevOps/ System Engineer.

I work with databases.
I know how to cook regular expressions (regexp).

Now (Aug, 2021) I live in Saint Petersburg, Russia.

Work Experience

Software Engineer (DB Developer)
at CLICK LLC, Tashkent

August 2018 - Present

  • Optimization of MySQL structure (MariaDB); creating and executing of marketing reports.
  • Studied network structure and enterprise services.
  • Took part in organizing Microsoft SQL Server 2016 Distributed Availability Groups in two remote datacenters (Windows server failover cluster, AlwaysOn, Distributed Availability Groups, MS SQL 2016).
  • Development, optimization of queries, creating stored procedures for the needs of the organization (marketing, BI) on MS SQL 2016.
  • Attended the Trend Micro information security seminar.
  • Studied haproxy and Linux virtual server load balancing technologies.
  • Supporting Linux and Windows servers.

    • Still in progress...

Software Engineer
at Train Consultancy LLC, Tashkent

September 2016 - July 2018

  • Supporting Linux and Windows servers.
  • Deploying failover cluster on Windows 2012 R2 servers; configuring DNS, AD, DHCP, branch subdomain.
  • Supporting of Subex ROC FM.
  • Maintenance of a virtual machines based on VMware ESXi, Proxmox (kvm, openvz). Non-stop migration of the mail server from the openvz container to the virtual machine Vmware (Rsync, SSH).
  • Providing technical assistance in migrating servers, hardware and software from one datacenter to another (Cisco, Lenovo / IBM, VMware, Oracle DB).
  • Visit of seminars and conferences about IT technologies and information security conducted by Oracle, Cisco, Check Point, Huawei, Legrand, Vertiv, Microsoft, VMware, etc.
  • Participation in the project of launching Exadata Databse Machine as a DB for a pilot project on BI Oracle.
  • Attending Cisco, Huawei courses about Servers and Storages.
  • Development of a personal telegram bot and placing logs from one of the servers to this bot (php, telegram API, expect, curl).

1st category Specialist of Information Security and Information Technologies Service
at Chirchik Center of Telecommunications of Tashkent Branch of Uzbektelecom JSC, Chirchik

April 2016 - September 2016

  • Developed scripts to advice transfer subscribers to another billing system as a result of the merger of the enterprise. In a month and a half, migration of Internet subscribers to another billing without interruption of communication has been made. (php, javascript, datatables, expect)
  • Maintenance, support for billing and servers (MS SQL, Microsoft SQL Server, PostgreSQL, SQLite, php, perl, python, Delphi, Visual Basic, java, c, etc.).
  • Serving the server virtualization project on VMware (ESXi, VSAN). More than 30 servers are in virtual space (Windows, Linux, FreeBSD).
  • Parsing CDR files of ZTE and Huawei vendors (php, excel, ftp, smb (nas), regular expressions).
  • Installation, configuration and support of monitoring tools MRTG and Cacti.
  • Awarded with a commemorative sign "25 years for Independence of Uzbekistan".

Deputy Head of Information Security Department
at CHIRKOM LLC, Chirchik

June 2013 - April 2016

  • Engaged in information security of the enterprise (IS policy, antivirus and password protection, group policies, protection from information leaks, traffic analysis, firewalls etc.).
  • Involved in server support on Linux, FreeBSD, Windows servers. Software update, elimination of critical issues (Bashdoor/Shellshock, Heartbleed, etc.), including outdated operating systems.
  • Implemented a server virtualization project on VMware (ESXi, VSAN). More than 30 servers are in virtual space (Windows, Linux, FreeBSD).
  • Took part in the modernization and installation of station equipment manufacturer Zte, designed a data transmission network and an IP network.
  • Took part in the project of connecting the city's districts to the broadband network using FTTB technology (ring topology, MSTP, Zyxel, Huawei).
  • Took part in the project of providing IPTV television services to subscribers. Developed of data transmission network, traffic transmission and IGMP traffic routing.
  • Took part in the design of the data transmission network GPON, VDSL.
  • Developed a public offer of telecommunications services company.
  • Optimized, improved and serviced billing systems of traditional telephony services (MySQL, Microsoft SQL Server, MS Visual Basic, Delphi, php, perl, java).
  • Supported a new billing system for Internet services. Made optimization of SQL queries (MySQL, Microsoft SQL Server, PostgreSQL, perl, python, bash).
  • Supervised the project of updating the corporate website of the enterprise (MySQL, php, bitrix, virtual machine bitrix on VMware ESXi).
  • Managed the project to develop a personal cabinet for enterprise services (MySQL, MSSQL, python).
  • Took part in the project of the card platform and IVR call center (MS SQL, MySQL, php, bash, cmd (windows), TRANSACT-SQL, phone disconnect automation, telnet, expect, asterisk, trixbox, Olha-9P, E1).

Chief Specialist of Information Security Service
at CHIRKOM JV LLC, Chirchik

June 2010 - June 2013

  • Engaged in information security of the enterprise (IS policy, antivirus and password protection, group policies, protection from information leaks, traffic analysis, firewalls etc.).
  • Involved in server support on Linux, FreeBSD, Windows servers. Software update, elimination of critical issues (Bashdoor/Shellshock, Heartbleed, etc.), including outdated operating systems.
  • Took part in the creation of an autonomous system of IP addresses for the enterprise (AS). The enterprise received own IP address block and routing via BGP protocol (FreeBSD, Zebra, Quagga). An additional uplink (TAS-IX) was added later.
  • Designed, developed a transport network (IPSEC, racoon) and a gateway for online payment for traditional telephony services (php, MySQL, MSSQL, TRANSACT-SQL, Stored procedures in MSSQL).
  • Optimized, improved and serviced billing systems of traditional telephony services (MySQL, Microsoft SQL Server, MS Visual Basic, Delphi, php, perl, java).
  • Supported a new billing system for Internet services. Optimized of SQL queries (MySQL, Microsoft SQL Server, PostgreSQL, perl, python, bash).
  • Managed the project to develop a personal cabinet for enterprise services (MySQL, MSSQL, python).
  • Took part in the implementation of the call center through a server on asterisk and 1xE1. Added services for replenishment of telephony services through cards, information on the status of the telephone number (debts), technical support of the Internet, special numbers (exact time, temporary messages for correct dialing of international numbers), etc.
  • Took part in the project of an automatic technical support service, by IVR on Asterisk. It was supposed to solve the subscriber's problems in the automatic mode (by receiving information from all billing systems, as well as checking the parameters of the subscriber's line and subscriber's equipment) at the stage of the subscriber's call to the call center. The project wasn't completed.

Leading Software Engineer of Department of Electronic Data Processing
at CHIRKOM LLC, Chirchik

September 2003 - June 2010

  • Support for servers on Linux, FreeBSD, Windows.
  • Planning and building a fiber-optic network between key nodes on a city scale, at first 100 megabits on media converters, then 1Gbit on managed switches.
  • Implemented (in 2005) of modem pool cisco AS 5300 for 240 modems (dial-up). The service ceased to exist in 2013.
  • Took part in building the network to key customers (factories and plants) in the city through fiber-optic communication lines.
  • Took part in the modernization and installation of Alcatel Lucent and Huawei station equipment manufacturers, designed a data network.
  • Developed, supported the corporate and other websites of the enterprise.
  • Development, commissioning, support of billing systems of traditional telephony and Internet services.
  • Took part in the project of the card platform and IVR call center (MS SQL, MySQL, php, bash, cmd (windows), TRANSACT-SQL, phone disconnect automation, telnet, expect, asterisk, trixbox, Olha-9P, E1).
  • Developed a database for storage and an interface for providing printouts of telephone conversations (Delphi + report components, MS SQL, Dbase for communication with telephone billing).
  • Developed a test system for testing knowledge of Occupational Health and Safety (Microsoft SQL Server, Delphi, Borland Pascal, cmd).

Computer Operator, Developer
at [Private Firms], Chirchik

August 2000 - September 2003

  • Office work.
  • The conclusion of contracts for Internet access (2000-2001, the small provider, uplink: dial-up US Robotics 33.6Kbit/s). Introduction to Linux.
  • Calculation of wages in Excel (VBA). With the participation of accountants.
  • Preparation of advertising materials for publication in the advertising media (Corel, Adobe).
  • Maintenance and minor repairs of office equipment.
  • Development of ancillary programs on Borland Delphi.
  • Development and support of the page in the Internet. HTML, php, javascript, css.

Laboratory assistant for informatics classroom
at Middle Schools of General Education, Chirchik

October 1997 - August 2000

  • Preparation of examination programs for testing the progress of students, conducted by City&Regional Departments of Public Education.
  • Providing methodological assistance to the teacher in teaching Computer Science.
  • Development of educational software in programming languages BASIC, Turbo (Borland) Pascal, C, machine code (Pravets 8A). Computers: Pravets 8A, IBM PS/2 30-286.

Key Skills

SQLIntegrationFraudcliBashShellOfficeDebianSystemManagementAnalysisExpectnetworksScriptingZyxelSoftwareProjectVisualDNSBasicServerVSANRequirementsnginxRIPTransact-SQLLAMPQuaggaRESTJavaBindapacheTelecommunicationsAsteriskTeamFreeBSDMySQLHTMLPostgreSQLHuaweiCSSPHPPythonMicrosoftSubexLinuxT-SQLImprovementZTEServersROCProcessVMwareJavaScriptWindowsAngularIptablesDatabasesLeadershipPerlJSONAdministrationipfwDevelopmentXML
  • System Administration
  • DNS Bind DHCP AD DC
  • VMware ESXi VSAN
  • Microsoft SQL Server
  • Linux Windows FreeBSD
  • Debian CentOS Ubuntu
  • IP networks VLAN Routing
  • Servers Storage FC iSCSI
  • Iptables IPFW
  • RIP BGP Quagga Zebra
  • Asterisk Trixbox IVR
  • Apache2 Nginx
  • Software Development
  • HTML JavaScript CSS
  • Databases SQL PostgreSQL MSSQL MySQL Transact-SQL
  • PHP Python Java Perl Visual Basic C C++
  • Regular Expressions
  • REST JSON XML Angular
  • Shell Scripting Bash Expect awk sed
  • Requirements Analysis
  • Project Management
  • Process Improvement
  • Integration
  • Telecommunications
  • Zyxel equipment
  • ZTE equipment
  • Huawei equipment
  • Microsoft Office
  • Team Leadership
  • Subex ROC FM
  • Blind typing

Education

Tashkent State Pedagogical University named after Nizami

Bachelor's degree, Mathematics & Computer Science

1998-2003

1101100 1100001 1101101 1100001 1100111 101110 1110101 1111010