Theo Maiyo

*** * ***** *** *** D

FEDERAL WAY WA 98003

advi5a@r.postjobfree.com

913-***-****

Theo Maiyo

SQL Server DBA/Systems Engineer

Summary

Microsoft Certified Systems Engineer (MCSE) and computer support professional skilled in all facets of desktop and network systems planning/design, programming, installation, configuration and maintenance. Skilled supervisor, highly proficient in database modeling, implementing network security protocols, and evaluating/monitoring system and network performance. Innovative and analytical individual with exceptional project management, organizational and communication skills. Solid interpersonal and communication skills as well as a demonstrated ability to manage multiple projects.

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified Systems Administrator (MCSA)

Microsoft Certified Systems Engineer (MCSE)

Cisco Certified Network Associate (CCNA)

Microsoft Certified Professional (MCP)

Citrix Certified Administrator (CCA)

Technical Skills

Deployment: Mass deployment of windows XP, Windows 10 & 11 using Remote Installation services. Experience with Virtual Device Infrastructure (VDI) deployment and management. Extensive Citrix, Hyper-V & VMware experience. Experience supporting Citrix DaaS, XenApp & XenDesktop environments.

Active Directory & Azure AD administration, GPO administration, site & OU infrastructure design & AD Trust management. Experience implementing multi-domain Role-Based Access Control (RBAC).

Protocols: TCP/IP, IPX/SPX, Net BIOS

Operating Systems: Windows 95/98, Windows NT 3.51/4.0Novell Netware, Windows XP, Windows 10 & 11, IBM OS/400, Windows Server 2012,2016,2019 & 2020.

Programming Languages: Visual Basic.NET, Python, JavaScript & PowerShell. Automated patch deployment and management, experience with SCOM/SCCM/Orchestrator & Shavlik. Experience with security vulnerability scanning tools e.g. Nessus, Malwarebytes, GFI Languard. Experience with Microsoft Intune. Experience with 3rd party monitoring tools including Idera Diagnostics Mngr, SQL Safe, Manage Engine(Ops Manager),SolarWinds & Spotlight. Experience with server upgrades & decommissioning (Hardware & Software).

Software: Office 365 (Word, Excel, Outlook, Visio, PowerPoint), Proxy software, Trading Applications

Networking Experience: TCP/IP Configuration, TCP/IP Troubleshooting, Internet Mail Routing, Network Configuration, Network Troubleshooting. Experience with storage provisioning and management.

Storage array administration Dell/EMC VNX, Dell Compellent array, SAN switches, NAS.

PC Experience: Software installations, Hardware Configuration, PC Repair

NT Experience: Enterprise Networking, Domain Model Planning, Workstation Troubleshooting, Server Troubleshooting. Network load balancing technology with NetScaler. Experience with Network Discovery and Mapping tools.

Business support: Customer Technical Support, Quality Assurance, Disaster Recovery, Staff Technical training. Experience with Change Management processes.

Experience with Network Operations Center (NOC) including monitoring tools, escalations, infrastructure re-designs etc. Familiarity with Aruba, Cisco, Palo Alto, Juniper.

Databases: SQL6.5/7.0, SQL 2000, 2008, 2014, 2016, 2019 Oracle 8i, 9i and 10g.

Professional Experience

SQL Server Consulting Feb 2017 –Present

Senior Consultant & DBA

. Extensive experience with Federal Healthcare Systems including VA Caribou, ICBWeb, HL7, VISTA, VSOA. Responsible for installations, configuration & management of Computerized Patient Record Systems(CPRS) that are mostly utilized in VA hospitals and clinics all across the US.

. Working as a consultant to provide on-going support for multiple Azure SQL server databases for clients. Experience managing Azure multi-domains. Experience with DevOps and cloud operations.

Experience with automation using PowerShell. Experience with Azure blueprints and Azure ARM templates. Experience with Azure Linux compute cluster administration.

. Experience with CI/CD Data processing pipelines in Azure. Experience with Azure Data Factory ETL processes. Familiarity with cloud infrastructure automation deployment systems (Terraform, Ansible, Puppet, Chef etc). Experience with APIs and JSON.

. Working on different client projects while providing consulting services to meet their varied needs. Experience with Azure Cloud Migrations.

. Experience with Identity & Access Management (IAM) with OKTA, SSO and MFA. Project management experience.

. Experience implementing Transparent Data Encryption (TDE) and Always Encrypted data protection solutions. Experience with Data Integration and Data Mapping. Experience building, deploying and managing large enterprise-wide configuration management and monitoring solutions.

. Experience designing and implementing data movement pipelines using real-time event data streams using Apache Kafka and Azure Event Hub.

. Installed and configured First Community Bank’s Banking and processing software and configured it to interface with Fiserv’s network and servers.

. Help prepare financial institutions (Banks) get ready for FDIC audits by auditing their networks and applying remediation measures.

. Installed, build from the ground up and configured a new network for Farmers State Bank.

. Helped Sunshine Technologies install new Microsoft SQL 2016 servers and SQL server 2019 and migrate SQL 2014 databases to the new platform. Experience installing & managing SQL in a high-availability AlwaysOn configuration including Disaster Recovery.

. Experience with Industry Regulatory Compliance Requirements (PCI, HIPAA, etc).

. Responsible for SQL server upgrades and data migrations.

. Experience with Jira and Confluence. Experience with data visualization tools including Microsoft BI and Tableau

. Responsible for SQL server audits, Change Data Capture (CDC) & Data streaming, permissions and rights management.

. In-depth knowledge of cloud technologies and platforms. Experience with integrated and multi-cloud databases (Azure & AWS). Experience with Azure Databricks administration, Kubernetes, Apache Spark, data analytics, log analytics workspace, resource groups, etc.

EPIQ Systems May 2015 –December 2016

Senior SQL server DBA

•Responsible for administration and support of a large complex environment with 500+ Microsoft SQL Server instances on a variety of Windows, Linux and Unix versions.

•Responsible for administration, optimization and maintenance of SQL Server 2008 r2, SQL 2012, SQL 2014 and newer database environments running on Windows platforms.

•Responsible for managing high transaction OLAP SQL database systems, including backup and index management systems. Duties also included performance monitoring, capacity planning and troubleshooting performance issues.

•Support internal and external clients using our kCura Relativity infrastructure and database servers.

•Responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment, optimization and implementation of new technologies.

•Diagnose SQL Server database issues, including performance and data integrity issues.

•Responsible for Planning/advisory/validation of all database installations, patches and upgrades.

•Responsible for after-hours support for SQL server related issues by taking part in on-call rotation.

CSC Corporation September 2012 – January 2015

Senior SQL Server DBA

•Senior database administrator responsible for installation, configuration and maintenance of over 300 SQL servers in five different sites. These servers range from SQL server 2000, SQL server 2005, SQL server 2008, SQL server 2012 and SQL server 2014.

•Experienced in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.

•Participate in On Call rotation for SQL server issues after hours.

•Installed and Configured Always On High Availability Groups and SQL server Clusters on SQL server using SQL server 2012 and SQL server 2014.Experience with Microsoft Exchange 2013/2016.

•Disaster Recovery Planning, Execution and Testing at remote sides.

•Experience with data partitioning, data archiving and scalability.

•Responsible for Encryption of sensitive client data using TDE.

•Solid knowledge of Windows environments.

•Responsible for Technical documentation of SQL server processes and procedures.

•Configuring and managing Clustered SQL server environments, database mirroring, performance tuning and replication.

•Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Brotherhood Bank and Trust September 2010 - September 2012

Senior Network Engineer

•Install configure and manage VMware ESX/ESXi 3.5/4.1/5.0 environments.

•Install configure and maintain Dell MD3000i and EMC Clariion CX SAN systems.

•Configure and maintain Active Directory environment comprising eight geographical sites

•Responsible for Exchange 2007/2010/ installation, configuration and maintenance including routing, switching, Ironport devices and Cisco ASA firewall management.

•Responsible for installation, configuration and maintenance of Citrix XenApp and XenDesktop platforms and Active Directory intergration.

•Responsible for Disaster Recovery planning, testing and implementation for all Bank IT services and deliverables.

•(SAN) Storage Administration including provisioning, fabric switch zoning and performance monitoring.

•Responsible for Active Directory Group Policy implementation.

Service Management Group - K.C., Mo. November 2008 - September 2010

SQL Server DBA

•Managed 40+ SQL Servers with over 40 terabytes of data. Responsible for SSAS, SSRS and SSIS setup and management.

•Conducted ETL development in the Netezza environment using standard design methodologies.

•Responsible for disaster recovery planning for SQL Servers including SQL Server.

•Collaborated with software architects to ensure alignment of the Netezza environment.

•Replication to Disaster Recovery (DR) sites, Database mirroring, SAN to SAN Replication.

•Installed configured and managed SQL 2005 and SQL 2008 Clusters running on Windows Server 2008 and 2003 enterprise systems.

•Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.

•Storage provisioning and administration of EMC SAN (CX-240) Clariion Array units.

•Fabric zoning, Brocade switches management

•Responsible for backups/restores, monitoring SQL uptime, designing, maintaining SSIS packages, index tuning and query optimization.

Unified Gov’t of Wyandotte County - K.C., KS March 2008 – September 2008

Systems Engineer

•Install, configure and maintain Active Directory infrastructure.

•Strong understanding of Storage Area Networking (SAN) technology, including storage provisioning, LUN management, zoning, performance management, and volume management.

•Install, configure and manage both P-class and C-class chassis HP blade systems.

•Install, configure and maintain VMware ESX 3.0/4.0 environment and virtual servers.

•Install, configure and manage Windows hyper-v and their Virtual servers.

•Install and configure Microsoft System Center Operations Manager and Office Communications server suite.

Tallgrass Technologies, Lenexa, KS April 2006 - August 2007

Systems Engineer/SQL DBA

•Responsible for designing, installing and maintaining enterprise network infrastructure comprising Windows 2000,XP, 2003,Cisco routers and switches, Microsoft SQL 2000& 2005, Microsoft Exchange 2000 and 2003 servers.

•Advanced skill sets dealing with the setup, configuration, security, deployment and troubleshooting of Windows 2000 and 2003 servers.

•Design and build solutions utilizing DTS as an enterprise ETL tool. Build DTS packages that populate critical systems reporting marts and exception engines.

•Perform DBA responsibilities including database backups and restores, performance tuning and monitoring, database scalability, redundancy and integrity, replication.

•Responsible for the Evaluation, supervision and mentoring of junior staff.

•Managed all call center IT operations involving 3000 plus employees.

•Participated in several SQL server upgrades.

•Responsible for Convergys Corporation and Encore Receivable Management network integration projects.

•

FCB Consulting - Overland Park, KS October 2003 - March 2007

SQL Server DBA/Systems Admin

•Design, implement and support data warehousing and reporting services for all databases.

•Perform data modeling and design appropriate data structures for datamarts and data warehouses for SQL server databases.

•Upgraded a troublesome 15-server NT 4.0 network to a robust windows 2003 system employing terminal servers, routing and remote access, group policies, IP Sec policies, firewalls, SQL and Exchange servers.

•Design tables, databases, create and optimize queries and stored procedures for more efficient database access.

•Configure front end applications for optimal and secure database access using SSL encryption.

•Developing and managing DTS packages and perform disaster recovery operations.

•Analyze query execution plans and execute queries against linked servers.

•Install, optimize and administer oracle 8i, 9i and DB2 database servers.

•Developed stored procedures, DTS, UDFs, aggregates, replication, indexing, backup/recovery, DRI, SQL, XML, tables, views, linked servers, SQL Agent Jobs, cursors, and data modeling.

Compunet Engineering - Overland Park, KS July 2002 - October 2003

SQL DBA/ Systems Engineer

•Designed, build and maintained an offsite Disaster Recovery center for the entire Gold Bank network that covers Kansas, Missouri, Oklahoma and Florida states.

•Configured and implemented transactional SQL server replication from all Gold Bank branches to the Disaster Recovery center.

•Designed, tested and implemented a database system to record and audit entire Gold Bank’s software and application licensing, version and patch-level monitoring.

•Administer mission-critical payroll and billing databases.

•Used SQL profiler to analyze database performance and manage replication services.

H & R Block - Kansas City, MO January - June 2002

IT Specialist

•Install, configure, monitor and backup/restore Microsoft SQL 2000 database servers.

•Analysis, reporting, maintenance and performance turning of databases to ensure high availability.

•Support all company SQL Server databases

•Install, configure .and troubleshoot file and print servers and Exchange servers on /off site.

•Responsible for testing and evaluating new hardware and software to ensure compliance with established company operational and security requirements.

•Responsible for LAN/WAN interconnectivity and monitor network resources, build user groups and establish network permissions.

•Coordinated and configured network services for implementation of WINS replication, DNS, DHCP, RRAS and VPNs.

•Ensure database integrity and availability by designing database maintenance plans.

Kori Systems Consulting - Kansas City, MO July 1999 - January 2002

Systems Engineer

•Architect SQL Server data structures, database schemas, database standards

•Developed and implemented effective SQL server and client solutions with expertise in system design, development and planning.

•Created, tested and tune data loading and cleansing processes, using a combination of Business Objects Data Integrator, Oracle and SQL Server views, functions and stored procedures, and Microsoft SQL Server replication.

•Designed and built, from the ground up, an NT Network consisting of 45 NT Domain controllers, 7 Exchange 5.5 servers, 10 Exchange 2000, 19 file and print servers, 27Win 2000 servers, 11 Win 2000 RRAS servers, 14 SQL6.5/7.0 2000 servers.

•Responsible for development and implementation of comprehensive back-up procedure for LANs.

•Maintain network infrastructure consisting of Cisco hubs, switches, routers, firewalls plus links and patch panels.

•Load, configure and maintain laptop and desktop computers running Windows 95/98, NT 4.0, 2000, and XP.

•Responsible for troubleshooting all end user problems with applications, operating systems, hardware, network cards and cables, network printers, remote access and routing.

Education

Bachelor’s Degree –Management Information Systems (MIS) 2000

Moi University, Eldoret Kenya.

Abilene Christian University, Abilene, TX,

Risk Assessment and Business Continuity (Web School) 2002

Contact this candidate