| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name mob. PHONE NUMBER AVAILABLE EMAIL AVAILABLE
ObjectiveChallenging 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/PHONE NUMBER AVAILABLE 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) AND Windows Server NT/2000/2003/2008/2012/2016/2019 ANDAWS (Redshift / Athena / lambda / Glue / Crawler / NiFi / DataLake / S3 / EC2 / EBS / RDS etc) AND Azure (DataLake / Data Factory/ Databricks / RDS) AND GCP (Snowflake / DataLake / DataLab)Data flows / DR / Data Security / Business Continuity / Infrastructure effectiveness based on all those technologies;
Enterprise infrastructure Cost optimization, Data Quality Check, Data cleansing; 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, Azure SQL Managed Instance with Scale UP and OUT options, Informatica, Databricks.
Sep2012 - Sept2017 University of Cape Town, Senior Windows Infrastructure Engineer, 40% SQL Server 2005/2008/2012/ 2014/2016 clustering, tuning performance, troubleshooting, replication, virtualization, Informatica etc, 30% windows server 2003/2008/2012/2016; 20% Lync and Exchange 2003-2013, 10% Networking. PeopleSoft, ImageNow, Symantec, Attix 5, Symantec backup exec, SCOM 2007/2012, Sharepoint 2007/2010/2013, CRM 2011-2016, VEEAM, AZURE Migration ~1500 Instances were moved from PREM to the Cloud and a LOT moreThis is one sample what I was doing there: I automated Application, Testing and Approval for those students who decided to use paper :)We had Scanner and papers with: - Applications,
- Tests, - Approvals / Disapprovals
My goal was: automate a process of entering data from those papers into some "staging" database and link it with our SAP system.
So I went exactly the same way - Conceptual, Logical and Physical models with a lot of meetings and discussions.It ended up with Scanner Software -> ImageNow -> MS SQL Server 2012 St -> Oracle 11g as a linked Server.
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.MSSQLServer 7/2000/2005/2008 (40%)
4.IT Security Firewalls (Cyberoam, SonicWall, Fortinet), Antispam, Antiviruses, Web optimization, application filter, QoS, Network balancing 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. VMWare, Migrating databases MS SQL - Oracle, SAP, CRM, ERPApr2003 - 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
What we were doing: we decided to automate sales and orders for pharmacies (eventually it was 1 pharmacy chain with 5 local pharmaciesand ended up with 2500 pharmacies)1. We had a Vision of what needs to be done (what we are going to automate in general).
- First - pharmacies: sales point automation (till), production automation (preparing a medicine) and order automation. - Second - Headoffice: combine all orders from pharmacies, create Total order and collect offers from supplies for that order. - Third - Reporting and Analyses: tons of reports, ABC Analysis, accounting documentation, contract control with supplies. - Fourth (potentially): Management (Prediction of Sales, Price management from head office, automatic order from pharmacy (restocking), "quality" control of supplies)
2. I created a data flow (Logical) diagram, what document is coming from and where it goes to, what requisites and parameters are, who is responsible for the quality of the document, does it have sensitive data. Spent a LOT of time sitting with Pharmacists, Warehouse Managers, Accounters, Marketologists, Business Analytics, Supplier's workers and CEO to find out what data we can use and what data needs to be added into the system for further use.3. At that point we implemented that system on MS SQL Server 2000, then upgraded (recoded) to MS SQL Server 2005, created metadata of documents, forms, schemas, prepare the main dictionary and single source of truth
- Pharmacy - MS SQL Server Express Edition
- Head office - MS SQL Server Standard Edition (then moved to Enterprise)What tool did I use: ERWIN and Visio!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 EducationMasters of Computer Science, Izhevsk State Technical University, department of Information Technology, 1993-1998MCP, 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 certificatesCTC Salary expectations: According to my experience and skills (Negotiable)Your resignation period: 1 - 2 weeks
|
