Ilyas Farrakhov mob. 305-***-**** ad2l4u@r.postjobfree.com

Objective

Challenging position as a Solution Architect, Senior System and Database Engineer, Data Architect

Abilities

Experienced with configuration, optimization of Cloud/Virtual and Hybrid based IT Infrastructure.

Experienced with installation, configuration, and maintenance of firewall, gateway, proxy servers and DNS, web and email servers.

Experienced with installation, configuration, and maintenance of Windows 95/98/NT/2000/XP/Vista/2008/7/8/8.1/10

Experienced with installation, configuration, and maintenance of Windows Server 2000/2003/2008/2012/2016/2019; AD, VPN, DNS, DHCP, LAN, EFS, DFS, Hyper-V, VMWare

IT Security (Hardware and software Firewalls; Anti-viruses, VPN, IPsec, EAP, SSTP, IPS, IDS, IPv6, NAT, NAP, NPS, IGRP, EIGRP, OSPF, SSL, VLANs)

Senior Database Administrator of Microsoft SQL Server 7/2000/2005/2008/2012/2014/2016/2017/2019 BI, OLTP, OLAP, Warehousing, Data mining, SSIS, SSRS, SSAS; Sharepoint 2007/2010/2013

Proven ability to reach goals.

Strong organizational and analytical skills.

Excellent customer service skills.

Strong analytical and problem solving skills. Managing client architecture and solution design

Experience in design and maintenance of clinical databases.

Excellent Hardware Support (compatibility, diagnostics, replacement) the equipment for servers (HP, Dell, IBM), desktops (HP, Compaq, Dell, ASUS), Notebooks (Asus, Toshiba, Dell, HP)

Employment History

Jan2020 - Current, SQL Guy LLC, Senior Data Architect, installation, configuration, tuning performance of MS SQL Server 6.5/7/2000/2005/2008/2012/2014/2016/2017/2019) FCI / AG / DR AND Windows Server NT/2000/2003/2008/2012/2016/2019 AND AD / GPO / SCCM / Intune / Firewall / Powershell / WSFC / Solarwinds

AWS (Redshift / Athena / lambda / Glue / Crawler / NiFi / DataLake / S3 / EC2 / EBS / RDS / DevOps / Aurora etc) AND Azure (DataLake / Data Factory / RDS / DevOps / CosmosDB) AND GCP (Snowflake / DataLake / DataLab)

Data flows / DR / Data Security / Business Continuity / Infrastructure effectiveness based on all those technologies;

Enterprise infrastructure Cost optimization; Cloud migration / transformation;

Nov2017 - Dec2019, JUMO World, Senior SQL DBA, SQL Server 2016 based on Amazon Web Services - biggest database 30 TB, Partitioning, HA, DR, Replication, ETL, Cubes/SSAS, SSRS, Redshift 22 nodes cluster, Athena, Glue, DataLake, Crawlers, S3, Aurora, Azure SQL Managed Instance with Scale UP and OUT options. SCCM / Intune / WSUS / GPO / Powershell / WSFC / Solarwinds / AD

Sep2012 - Sept2017 University of Cape Town, Senior Windows Infrastructure Engineer, 40% SQL Server 2005/2008/2012/ 2014/2016 clustering, tuning performance, troubleshooting, replication, virtualization etc, 30% windows server 2003/2008/2012/2016 Powershell / WSFC / AD; 20% Lync and Exchange 2003-2013, 10% Networking. PeopleSoft, ImageNow, Symantec, Attix 5, Symantec backup exec, SCOM 2007/2012 / SCOM, Sharepoint 2007/2010/2013, CRM 2011-2016, VEEAM and a LOT more

Oct2011 -Aug2012 4th Dimension Technology Senior Network Infrastructure Engineer; Installing, troubleshooting, migrating, upgrading and supporting

1. Windows server 2003/2008 (20%)

2. Windows Small Business Server 2003/2008 /2011 (25%)

3. MS SQL Server 7/2000/2005/2008 (40%)

4. IT Security Firewalls (Cyberoam, SonicWall, Fortinet), Antispam, Antiviruses, Web optimization, application filter, QoS, Network balancing, SCOM, AD etc. (10%)

5. BackUp (NAS, SAN, Tape) Symantec backup exec;

And a LOT more (Servers DELL, HP, IBM, Switches, Routers etc). I had a deal with only difficult problems and situations.

Aug2010 – Sept2011 “Engen” Senior SQL DBA, technical remote support of 350+ MS SQL servers (15 Tb – the biggest database) Mirroring, Clustering, Improvement performance, Monitoring, Fixing, Replication, Upgrading, DR, SSIS, SSRS, SSAS (2005/2008) etc.WSS 3.0, Sharepoint Server 2003/2007/2010, Microsoft SQL 2000/2005/2008, Windows Server 2003/2008, IIS 6.0/7.0 / SCOM / AD. VMWare, Migrating databases MS SQL - Oracle, SAP, CRM, ERP

Apr2003 - Jun2010 «Qwerty-Plus» Senior Solution Architect, IS strategy and budget, Interpret and translate business requests into solution designs, technical requirements, and develop specific solutions to meet defined service level agreements. Produce innovative, integrated, flexible and cost-effective solutions that are aligned and based. Maintain awareness of advancing technologies and how they may be integrated into solutions cost effectively and with minimal risk. Discuss with customers the proposed solution, technology applied and the reasons why it has been chosen. Establishing and ensuring acceptance tests and criteria for delivery of new solutions. Maintain changes to the customer architecture and solution strategy as technology and product changes are introduced. Having specific critical contact with customer and management, peers, representatives and communities involved in; architectural and business governance, strategy, IT planning, and critical change activities. Windows Server 2003/2008, MS SQL Server 2000/2005/2008, Hyper-V, VMWare, Sharepoint Server, Project server, BI, OLTP, OLAP, Warehousing, Data mining, SSIS, SSRS, SSAS, SAP, CRM, ERP

Jun2003 - Jun2010, «Phillip Morris», Senior System and Database Architect, installation, configuration, and maintenance of firewall, gateway, proxy servers and DNS, web and email servers; construction and configuration LAN; installation, configuration, and maintenance of Windows 95/98/NT/2000/XP/Vista/7 and Microsoft Office 2000/2003/2007; installation, configuration, and maintenance of Windows 2000/2003/2008 Server; LAN, AD, Exchange 2003/2007; installation, configuration, and maintenance office equipment (Fax, Xerox, HP LaserJet/DeskJet) Pocket PC, PDA, Hardware, Device drivers, Networking software(Novell, Windows), Networking hardware, Networking security, Intranet, Internet. MS SQL Server 2000/2005/2008 clustering, replication, DR, backups, tune performance, Sharepoint Server.

Feb2000 - Mar2003, JOINT STOCK COMPANY "IZHCOMBANK", Senior programmer of department Automation of control systems, write programs; construction and configuration LAN(Novell, Windows); installation, configuration, and maintenance of Windows 95/98/NT/2000/XP and Microsoft Office 2000/2003 (C++/Clipper/Assembler/VB)

Nov1997 - Feb2000, «Procter & Gamble», System & database Administrator, installation, configuration, and maintenance of firewall, gateway, proxy servers and DNS, web and email servers; construction and configuration LAN; installation, configuration, and maintenance of Windows 95/98/NT and Microsoft Office 98/2000; installation, configuration, and maintenance of Windows NT/2000 Server; LAN, Domain and Administrator; installation, configuration, and maintenance office equipment (Fax, HP LaserJet/DeskJet). MS SQL Server 6.5/7

Education

Masters of Computer Science, Izhevsk State Technical University, department of Information Technology, 1993-1998

MCP, MCTS, MCSA 2003, BDD, ISA 2006, MCITP, MCITP 2008 Enterprise Administrator (MCSE 2003), MCITP DBA 2008, MCIPT Virtual Administrator 2008 (total 17 Microsoft's certificates), CCNA, CCNSP, A+, Linux, ITIL – International certificates

CTC Salary expectations: According to my experience and skills (Negotiable)

Your resignation period: 1 - 2 weeks

Contact this candidate