Sql Server System

OLEKSANDR IANCHEVSKYI

Location: San Francisco, CA, USA (Available to relocate nationwide)

Mobile: 415-***-****

Email: ***.****@*****.***

LinkedIn: http://www.linkedin.com/pub/oleksandr- ianchevskyi/31/2b3/920

OBJECTIVE: Seeking position as a Engineering IT Supervisor.

PROFILE:

•10+ years of experience in the IT industry.

•Strong technical and functional knowledge of ERP, PLM, MRP, CRM, CAD systems.

•Good experience in Project management.

•Excellent experience with MS Windows Server and MS SQL Server Installation, Administration,

Monitoring, Performance Tuning, Backup and Recovery.

•Good experience in system installation, configuration and administration of Linux systems.

•Complete knowledge of Networking and communication devices, protocols TCP/IP & software that

includes DHCP, DNS, WINS.

•Excellent planner, organizer and problem solver.

•Self starter and actually enjoy a good challenge.

•Good communication skills.

•Work experience in international teams.

TECHNICAL SKILLS:

Windows: MS Windows Server 2012/2008R2 (Active Directory, Remote Desktop Service, IIS,

WSUS, DNS, DHCP, TCP/IP, Print Services, File Sharing).

Linux: CentOS (Kernel and application build, FIREWALL, VPN, SSL, TCP/IP, DNS, DHCP,

FTP/SFTP, Samba, Apache, HTTP/HTTPS, PHP, Ruby).

RDBMS: MS SQL Server, Interbase/Firebird, MySQL, Oracle

Virtualization: VMWare ESXi, VMWare Pro.

Java servers: Tomcat, Glassfish.

Software: CRM (MS Dynamics, SugarCRM), PDM/MRP/MES (Csoft Technologics, APS

Enterprise), PDM (Csoft PDMS, Autodesk Vault, Windchill)

ERP (IT Enterprise), MS Office (Word, Excel, PowerPoint, Access, Project, Visio),

Redmine, Adobe Creative Suite (Acrobat, Photoshop) . Antivirus system (KAV,

Dr.Web), CAD (AutoCAD, Inventor, SolidWorks, Kompas)

Programming: Java, Delphi, Scripting, SQL, C#, HTML5, CSS.

Hardware: Dell, Compaq and HP servers. UPS systems. RAID, Cisco, D link, Microtik .

WORK EXPERIENCE:

09/2012 – present Systems Administrator, Promsoft, Sumy, Ukraine.

•Supported LAN with Active Directory server (MS Windows 2012 Server),

2 Fileservers (MS Windows 2012 Server), 1 Terminal Server (MS Windows 2012 Server) and 2

VMWare ESXi servers (Various OS’s for testing) and 50 PCs Windows.

•Tested installation of server and client side APS Enterprise (PDM/MRP/MES system developed our

company).

•Installed and configured Tomcat 7 and Glassfish 3 on MS Windows Server 2012 .

•Installed and configured Oracle 11 on MS Windows Server 2012.

•Tested server side of Java SOAP Web Service.

•Tested data exchange between CAD system (Autodesk Inventor) and APS Enterprise.

•Tested data exchange between APS Enterprise and Teamcenter PLM (Antonov).

•Supported task management system Redmine on MS Windows Server 2012 (WAMP) .

•Created VM templates for tested deploy on client’s side .

•Supported Subversion on CentOS.

02/2008 – 05/2012 Systems Administrator, MunayGas Engineering, Astana, Kazakhstan .

•Redesigned an existing LAN, implementing Active Directory, DHCP, DNS coupled with the upgrade of

all existing servers to MS Windows 2008 server (near 300 users) .

•Installed and configured MS Dynamics CRM.

•Installed and configured VMware infrastructure environment with 2 ESXi servers, 10 virtual machines .

•Created templates from VM’s and deploy VM’s from templates.

•Responsible for server deployments, which include application installations, operating system updates

and security patches.

•Migrated all users PC’s from MS Windows XP to MS Windows 7 .

•Designed WLAN networks on offices and construction site.

•Installed, configured and supported DVR system on construction site.

•Deployed VPN server for remote users.

•Configured and supported Google mail services for all users.

•Deployed task management system Redmine on Linux CentOS (LAMP) .

•Installed and configured internal news website (Drupal + plug ins).

•Installed and configured company anti virus system Dr. Web .

•Troubleshooting LAN Connectivity related problems.

•Managed data backup on hardware and virtual servers.

•Supported local and remote users.

•Deployed and supported Autodesk Vault.

•Supported CAD users (AutoCAD Mechanical, AutoCAD Electrical, AutoCAD Inventor).

•Supported users who work with subcontractor’s Windchill system.

•Supported various engineering software (Hydrosystem, START, MechanicS, MathCAD) .

•Supported Bill of Materials software systems (AVK, Sona)

•Supported printers and plotters

•Supported Mac OS X, IPad, Android clients.

04/2006 – 02/2008 Systems Administrator, MGKA, Astana, Kazakhstan .

•Designed and implemented a network, servers, and security architecture (near 200 users) for

corporation based in the Kazakhstan (Astana, Atyrau, Opornyy), Ukraine (Sumy) and Russia

(Moscow).

•Installed and configured MS Windows 2003 Server (Active Directory, DNS, DHCP, WSUS, and IIS).

•Created user accounts and groups.

•Performed all new installations of end users workstations using Norton Ghost.

•Deployed SugarCRM in corporate network.

•Installed and configured Linux CentOS, MySQL, Apache and PHP.

•Imported to SugarCRM a data from Excel and Access files using SQL.

•Configured authorization using AD accounts for SugarCRM users.

•Installed, configured and supported MS SQL Server 2005 for accountant software 1C Enterprise .

•Maintained Cisco network equipment.

•Managed backup and restore data from servers and users.

•Installed and configured company anti virus system Dr. Web .

•Deployed Csoft PDMS system.

•Developed documentation for network and all servers with MS Project and Visio.

•Supported web site and Internet mail.

•Supported local and remote users (MS Office, Antiviruses, Internet) .

•Supported CAD users (AutoCAD Mechanical, HYSYS).

•Supported Bill of Materials software systems (AVK, АВС-4)

•Supported printers and plotters.

02/2004 – 02/2006 Systems Administrator, UkrRosMetall, Sumy, Ukraine .

•Deployed application server of CSoft TechnologicS (MRP/MES/PDM system) .

•Deployed Csoft PDMS system.

•Installed, configured and supported MS SQL Server 2000.

•Installed, configured and supported Terminal Service Server on MS Windows 2000 server with 50

users for CSoft TechnologicS.

•Configured connection between MES system and CAD systems

•Developed warehouse management system (Delphi5+Firebird)

•Supported Terminal Service Server on MS Windows 2000 server with 20 users for accountant

software (1C Enterprise).

•Migrated from CSoft TechnologicS version 3 to 4.

•Migrated from MS Windows 2K server to MS Windows 2003 server on Terminal Servers.

•Managed backup and restore data from Terminal servers and SQL server.

•Supported MES system CSoft TechnologicS users and barcode readers .

•Supported CAD users (AutoCAD, Inventor, Kompas and SolidWorks).

•Supported migration from Kompas and SolidWorks to AutoCAD and Inventor.

•Supported CAM users (EdgeCAM).

01/2003 – 1/2004 Systems Administrator, NasosEnergoMash, Sumy, Ukraine .

•Managed LAN with 2 Active Directory servers (MS Windows 2000 Server),

1 Fileserver (MS Windows 2000 Server), 1 Terminal Server (MS Windows 2000 Server) and 1

webserver (Linux Red Hat 6) and 150 PCs with Windows 9x and Windows 2000 Workstation.

•Configured and maintained MS SQL Server 2000 for ERP system “IT Enterprise” .

•Maintained Cisco network equipment.

•Updated and patched server’s software.

•Made backup fileserver’s data.

•Responsible for user and computer accounts on Windows 2000 Domain.

•Created group policy on Windows 2000 Domain.

•Managed DNS, DHCP and WINS service.

•Monitored system security.

•Configured and updated company anti virus system KAV.

•Supported various financial applications.

•Supported CAD users (AutoCAD 2000).

•Supported printers and plotters.

08/2002 – 01/2003 Systems Engineer, NasosEnergoMash, Sumy, Ukraine .

•Installed and configured software of an access control system.

•Created user accounts (near 2000 users).

•Installed and configured MS Windows 2000 Server and MS SQL Server 2000.

•Installed and configured hardware (access control points, turnstiles and parking gates) of an access

control system.

•Developed application for HR department (Delphi 5 + MS SQL Server 2000) and integrated with an

access control system.

•Wrote scripts to perform system backups.

EDUCATION:

2012 (summer) Online training “Programing Java and Java EE”, Farata Systems, NJ, USA

2002 MS in Control System Engineering, University of Sumy, Ukraine

REFERENCES AVAILABLE UPON REQUEST.

Contact this candidate