- KCLUG - kclug.org

RDBMS recommendation?
by Billy Croan 02 Sep '25

02 Sep '25

I have had a pretty massive spreadsheet for a while that I need to get a little bit more out of and I don't have the time to write a bunch of custom code to do it. Many years ago I used Microsoft Access for this sort of thing. Don't you dare tell anyone..... Actually I think I've even used Borland Paradox before for this sort of thing if any of for recall that. So I'm looking for a rapid self-hosted rdbms software. Not just "install mariadb and write some php". I might be okay with a free or paid cloud-based solution. I've tried a couple. But they look centered around simple customer/order tracking. That's really not what I'm doing though. I need to be able to generate printable PDFs "reports" from the data, I need input forms to add records to different tables. I need to import a csv, and normalize its contents into multiple tables. And do that a couple times a year. I need to be able to visualize some of this data on maps. It has names and addresses, voting and party affiliation history. It's voter data actually. I'm running for office in Merriam Kansas by the way. I wonder if I could become the first mayor that uses Linux.... Lord help us. Check out my campaign at https://Croan.org if you're interested! ESPECIALLY IF YOU LIVE IN MERRIAM, OR HAVE FRIENDS HERE. I need a small team to be able to collaborate on this data and be able to create filter views myself without affecting others' access to it. And without creating disparate copies. I need to be able to set up views for the data the draw from multiple tables and provide buttons and links to accomplish certain tasks. There are web services that do some of these things but they're geared towards much larger races. My city is only 10,000 houses and only about 1500 voters that regularly vote in City elections. Nearly all the services I've tried come with their own issues. I know there's a handful of CRM softwares that might kind of apply but voter data is not exactly a match for CRM software. I'm more interested in demographics and history and relationships and mapping than products and sales. What RDBMS software would you guys recommend? And would any of you be interested in bringing the basics of this online and then I'll put the rest together as I need it?

1 0

Renewal
by Jonathan Hutchins 04 Aug '25

04 Aug '25

I renewed kclug.com. Don't want squatters grabbing it.

6 10

AT&T Tower
by Jonathan Hutchins 22 May '25

22 May '25

Does anybody know what the tower on what appears to be the AT&T compound at 5400 Foxridge Dr. is for? -- Jonathan

3 3

Fwd: CPKC - Sr Linux Administrator opening (6 month contract to hire, $50-54.65/hr)
by Jonathan Hutchins 16 May '25

16 May '25

This is probably on either the PTC project or the mainframe migration. KC Southern was notorious for severe bureaucracy and departmental politics. I haven't known anybody who has worked with CPKC. -------- Original Message -------- Subject: CPKC - Sr Linux Administrator opening (6 month contract to hire, $50-54.65/hr) Date: 2025-05-16 10:34 From: "Fellers, Brian" <bfellers(a)teksystems.com> To: "Fellers, Brian" <bfellers(a)teksystems.com> Hello, Below is the job description for the Sr Linux Administrator opening we have with CPKC (Canadian Pacific Kansas City Southern Railway). 6 month contract to hire and will work 100% onsite at the downtown CPKC location. Please let me know if you know anyone who might be interested in this opening. 100% On site Kansas City MO for a Mid/Sr Level Linux Admin. Below are the details. There are multiple vendors so I would get it to your network asap. This is a 100% on site at their downtown location. Address [1]: 114 West 11th Street, Kansas City, MO 6 month contract to hire Pay Rate: $50-54.65/hr KEY: Middle to Senior Linux Administrator with VMware and/or Nutanix Hypervisor knowledge and experience. Linux (SUSE, RHEL, CentOS, BSD) VMware Ansible is a plus Linux based security would be a plus as well Overview - Individuals are responsible for Linux operational support, troubleshooting, maintenance, upgrades and expansion, on-call rotation. In addition, they will provide support to provisioning/operational staff, as well as work closely with the architecture group in design support and validation of new designs and installations. This position will lead the containerization effort for Datacenter services. - Provide direction and advice pertaining to capacity planning - Provide direction and advice pertaining to future installations and design - Provide direction to automate and orchestrate future use of Linux environments (Tanium, Orchestrator, automation suites) - Configuration management utilizing Ansible, SaltStack, Puppet, Chef, Desired State Configuration (DSC) - Knowledge and use of containerization platforms (Docker, OpenShift) - Scripting languages (PowerShell, bash, python) _______________________________________________________________________________________ Knowledge in the following preferred: - Virtualization Technologies using VMware/Nutanix/Hyper V (MS suite) - Provide direction and advice pertaining to design and configuration of converged infrastructure - Cluster experience (SLES, RH would be good) - Vcenter or Nutanix tools - Storage Technologies using Dell/EMC and Netapp - Dell/EMC and Netapp replication technologies - Protocols including CIFS, NFS, iSCSI, FC - Cisco Networking Products - Networking technologies including, but not limited to TCP/IP, DNS, Routing Protocols, Switching - Cisco UCS Servers - VMWare Hypervisor as well as some UCS bare-metal) - Strong Communications Skills, both verbal and written - Demonstrated experience documenting environments, runbooks, etc. - Azure Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and automation technologies - Infrastructure as Code platforms: Terraform, Packer, Azure Resource Manager/CloudFormation templates - Enterprise service bus platforms - Ability to work independently to achieve goals - Ability to work as part of a strong technical delivery team to deliver computing needs Skills: -10 to 15 years Infrastructure experience Best regards, Brian Fellers | Lead Professional Recruiter T 913.982.4972 | M 785.250.7060 | bfellers(a)TEKsystems.com 800.318.2074 | F 913.982.5053 7421 W 129th St, Suite #300, Overland Park, KS 66213 -- Jonathan

1 0

Test
by Jonathan Hutchins 15 May '25

15 May '25

Cleaning up some old configs on the server. -- Jonathan

1 0

Server Update
by Jonathan Hutchins 15 Apr '25

15 Apr '25

We had a 30 minute outage of kclug.org last night. I suspect NetStandard maintenance. As long as I was thinking about that system I ran an update and rebooted to the new kernel. I suppose we need to do a release update some time, I think we're still on Oldstable. -- Jonathan

1 0

Fwd: Systems Administrator opening (partial remote work from home) (1 year contract with possible extensions or conversion to a permanent employee)
by Jonathan Hutchins 04 Feb '25

04 Feb '25

-------- Original Message -------- Subject: Systems Administrator opening (partial remote work from home) (1 year contract with possible extensions or conversion to a permanent employee) Date: 2025-02-04 15:35 From: "Fellers, Brian" <bfellers(a)teksystems.com> To: "Fellers, Brian" <bfellers(a)teksystems.com> Hello, Below is the job description for the Systems Administrator opening. Working onsite 3 days a week and remote from home 2 days a week. This is a 1 year contract with possible extensions or conversion to a permanent employee. Please let me know if you know anyone who would be interested in this opening. From the manager: We have quite a few technologies in our environment that we support (Windows Servers, VMware, Storage and Backups, AD, DNS, some Linux/Kubernetes/Ansible, etc). Also a lot of datacenter and on prem support and not as much work in the Cloud. Linux, Kubernetes, and Ansible are really nice to have skills. Technical: * This person will be covering a lot of their on-prem data center focused infrastructure, even though they are a hybrid environment with CGP and on prem the Sr Engineer will cover their Cloud environment * This is more of a Swiss Army knife type of position since they cover a lot of their infrastructure - They will support their Windows and Linux Servers, VMware (moving from ESX to VXRails), Storage Tapes, Backups, Active Directory, Horizon View, Database Management, etc. * Kubernetes, Ansible are nice to haves since they do have some critical applications running on Linux. Just need someone with a high technical aptitude that can pick things up quickly if they lack this experience * Will partner with the Managed Service Provider (Fujitsu for now) Other Details: * This will start as a 12 month contract. Could extend if they do a great job and stay engaged. Potential to go full time but definitely not a guarantee * This role is a hybrid role (3 days on site, 2 days remote). They will start out a 100% on site to learn the lay of the land and once they feel comfortable with the environment they will move to the hybrid schedule. * 7am-4pm is the preferred shift. Can be flexible to 8am-5pm. * No on call support Open to Mid-level or Sr Candidates. Prefer more tenured candidates since they will be covering a lot of aspects of their infrastructure and need to have a high technical aptitude. Core data center services: * Server Management (Windows, Linux, File Management, VMWare ESX, VXRails) working with 3rd party Managed Service Provider * Storage and Backup Management (including weekly tapes) * Core Network general understanding (working with the Network Engineers) * Onsite Support in a physical datacenter * Application Management (AD, DNS, DHCP, Horizon platform management, IPAM, DCIM, Kubernetes) * Database Management * Middleware Support (Application Support, Ansible) Job Description: __ Top Skills - Must Haves * windows * system administrator * active directory * linux Top Skills' Details 1.) Windows and/or Linux Server Administration 2.) VMware (ESX or VXRails) 3) Storage/Backups 4) Active Directory, Horizon View 5) Kubernetes, Ansible - Nice to Have Secondary Skills - Nice to Haves * windows server * vmware * migration * server administrator Job Description Responsible for driving initiatives and projects related to the design, implementation of support of server, storage, and application environments. Takes ownership of various operational environments, both internally and externally hosted, ensuring highest levels of performance, stability, and security. Work with team members and vendors to develop technology strategy and implement chosen solutions. Responsibilities: - Manages all aspects of the Data Center's servers, storage and application processing and develops recommendations for new or enhanced systems, services and technologies throughout the company - This person will be covering the on-prem infrastructure. They have another Engineer on site that covers their Cloud Infrastructure - This is more of a Swiss Army knife type of position since they cover a lot of their infrastructure - They will support their Windows and Linux Servers, VMware (moving from ESX to VXRails), Storage Tapes, Backups, Active Directory, Horizon View, Database Management, etc. - Kubernetes, Ansible are nice to haves since they do have some critical applications running on Linux. Just need someone with a high technical aptitude that can pick things up quickly if they lack this experience - They will also help with any physical datacenter support, some rack and stack if needed. - Will partner with the 3rd party Managed Service Provider as well Additional Skills & Qualifications Candidates should be able to cover the core data center services: * Server Management (Windows, Linux, File Management, VMWare ESX, VXRails) working with 3rd party Managed Service Provider * Storage and Backup Management (including weekly tapes) * Core Network general understanding (working with the Network Engineers) * Onsite Support in a physical datacenter * Application Management (AD, DNS, DHCP, Horizon platform management, IPAM, DCIM, Kubernetes) * Database Management * Middleware Support (Application Support, Ansible) Work Environment - This role is a hybrid role (3 days on site, 2 days remote). They will start out a 100% on site to learn the lay of the land and once they feel comfortable with the environment they will move to the hybrid schedule. - 7am-4pm is the preferred shift. Can be flexible to 8am-5pm. - No on call support - 3rd party provider handles after hours typically. Best regards, Brian Fellers | Lead Professional Recruiter T 913.982.4972 | M 785.250.7060 | bfellers(a)TEKsystems.com 800.318.2074 | F 913.982.5053 7421 W 129th St, Suite #300, Overland Park, KS 66213 [1] [2] This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic mail or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately by reply e-mail so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. Thank you Links: ------ [1] http://www.teksystems.com/ [2] http://www.linkedin.com/in/brianfellers -- Jonathan

1 0

Fwd: Comcast - Linux Systems Administrator / coding skills opening (100% remote work from home) (1 year contract)
by Jonathan Hutchins 05 Dec '24

05 Dec '24

-- Jonathan

1 0

Fwd: GEHA - Cloud Engineer opening (remote work from home) (4 month contract, $80-85/hr)
by Jonathan Hutchins 26 Nov '24

26 Nov '24

-------- Original Message -------- Subject: GEHA - Cloud Engineer opening (remote work from home) (4 month contract, $80-85/hr) Date: 2024-11-25 17:14 From: "Fellers, Brian" <bfellers(a)teksystems.com> To: "Fellers, Brian" <bfellers(a)teksystems.com> Hello, Below is the job description for the Cloud Engineer opening we have with GEHA. This is a 4 month contract opening with an hourly rate range of $80-85/hr. Please let me know if you know anyone who might be interested. Placement - Contract - 4 month Must have skills: Azure Data Factory and Azure Synapse Cloud Engineer Design, develop and optimize cloud-based solutions, ensuring seamless operations for Enterprise Data Warehouse team. This is a contract position, and the successful candidate in this position will be expected to bring knowledge and experience with Azure Data Lake Storage Gen 2, Azure Data Factory (ADF), Azure Synapse and Snowflake Data Cloud. The successful candidate will apply design and development fundamentals to these cloud platforms by providing the best practices and expertise for seamless data integration. Essential Functions & Accountabilities: * Take direction from Manager/Architect/Senior Programmer for ADF, Azure Synapse, and Snowflake on daily tasks and activities. * Develop and maintain data pipelines, data storage solutions, data processing and data integration using ADF and Snowflake. * Test new or modified programs to ensure that they conform to design. Develop test data for use in program testing. * Write documentation of system changes in conformance with department standards * Write any necessary user documentation (report descriptions, user procedures, operations procedures) * Provide timely and concise summaries of project status to manager. * Works closely with business data analyst and data architects to understand the requirement to create effective data workflows. Knowledge, Skills, and Abilities: * Proficiency in designing, building, and testing on Azure * Experience developing data pipelines using Azure Data Factory with ETL techniques to load from various sources into data warehouse or data lake * Experience developing Microsoft SQL Server Integration Services (SSIS) is a plus * Demonstrate experience in using different ADF components (Pipelines, Data Flows, Triggers, Linked Services etc.) * Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred. * Proficient in using Snowflake Data Cloud including creating databases, schemas, tables and views. * Developing an optimizing ETL process for loading data into Snowflake * Software development life cycle and software quality assurance best practices and methodologies. * Proficient in SQL query writing and editing. * Develop complex ETL routines to load a dimensional star schema with a strong focus on data quality, error handling, and logging processes. * Assess requirements for completeness and accuracy and determine actionable steps for the ETL team. * Identify necessary changes to current business and data integration processes. * Communicate risks and ensure understanding. Work Environment: Standard office environment Experience: * 7 years of IT Development experience with advanced experience working on Azure Data Factory and Azure Synapse. Snowflake experience is a plus. * Advanced experience developing data pipelines using Azure Data Factory and Snowflake * Experience in using ADF and Snowflake's components to move data using different ETL techniques * Experience with Azure, Azure DevOps, Azure Data Lake, Azure SQL Server * Advanced experience with T-SQL, data warehousing design, BI concepts, and best practices * Optimize data loading, querying, and performance within Synapse workspaces and Snowflake * Experience with ETL processes using Snowflakes build in features * Bachelor's Degree from an accredited college or university or equivalent practical and relevant experience. * Clear verbal and written communication skills. * Previous experience in the health industry, SSRS, or Power BI is a plus. Best regards, Brian Fellers | Lead Professional Recruiter T 913.982.4972 | M 785.250.7060 | bfellers(a)TEKsystems.com 800.318.2074 | F 913.982.5053 7421 W 129th St, Suite #300, Overland Park, KS 66213 [1] [2] This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic mail or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately by reply e-mail so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. Thank you Links: ------ [1] http://www.teksystems.com/ [2] http://www.linkedin.com/in/brianfellers -- Jonathan

1 0

Fwd: Bass Pro - DevOps Engineer opening (100% remote work from home) (1 year contract)
by Jonathan Hutchins 05 Oct '24

05 Oct '24

Pretty high level, no salary mentioned. -------- Original Message -------- Subject: Bass Pro - DevOps Engineer opening (100% remote work from home) (1 year contract) Date: 2024-10-05 08:55 From: "Fellers, Brian" <bfellers(a)teksystems.com> To: "Fellers, Brian" <bfellers(a)teksystems.com> Hello, Below is the job description and details for the DevOps Engineer opening we have with Bass Pro. 100% remote work from home on a 1 year contract. Please let me know if you know anyone who would be interested in this opening. Top Skills - Must Haves * Devops * System administrator * Linux * red hat linux * ansible * azure * java * kubernetes * websphere * github Top Skills' Details - Linux Red Hat System Admin Experience - Operations, Support, Debugging, Troubleshooting - Ansible Automation and Scripting - Cloud Operations - Azure - Working in Java Environment Secondary Skills - Nice to Haves * Python * Aws * Automation Job Description Bass Pro is looking for a contractor to help support their eCommerce DevOps/Infrastructure team. This team specifically supports both basspro.com [1] and cabelas.com [2] and works very closely with the Dev team. POSITION SUMMARY (Objective/Purpose of Position): We are seeking a DevOps Systems Engineer to help us build and operate functional systems to ensure site reliability and improve software delivery workflows. The Systems Engineer will be responsible for deploying product updates, identifying production issues, and working with our software team to implement integrations that meet their needs. If you have a solid background in software engineering and are familiar with HCL Commerce, React, and cloud infrastructure we would love to speak with you. ESSENTIAL FUNCTIONS: Key Responsibilities: * Implement and manage continuous delivery systems and methodologies. * Implement systems that are highly available, scalable, and self-healing on a cloud platform. * Design, manage, and maintain tools to automate operational processes. * Develop and maintain solutions for operational administration, system/data backup, disaster recovery, and security/performance monitoring. * Continuously evaluate existing systems with industry standards and make recommendations for improvement. * Work with others in cross-functional teams to integrate new deployment processes and strategies to meet feature requirements. EXPERIENCE/QUALIFICATIONS: Required * Minimum 2 years' experience as a DevOps Engineer, Site Reliability Engineer, or similar software / support role. * Experience with monitoring tools like Dynatrace, Splunk, New Relic, DataDog etc. * Experience in Linux Systems Administration * Experience provisioning Java environments. * Experience with Cloud infrastructure, preferably Azure. * Experience with Ansible, Python, Bash, or other automation languages. Preferred * Experience in IBM Websphere or HCL Commerce * Experience with Kubernetes engineering / provisioning * Experience with GitOps methodologies Additional Skills & Qualifications * More of a Support role and keeping up with operations - Keep the lights on * Need to be familiar working in a Java Environment and Linux Redhat (System Admin experience) * Ansible is a must - Main tool they use for scripting and automation. * Debugging, troubleshooting, provisioning experience * Understand Cloud Operations - Mainly in Azure. Do not need an expert * Nice to have - Kubernetes, IBM Webshpere or HCL Commerce, GitHub * Looking for a Mid-Level Engineer - Will also look at Sr level candidates as well. * Might need to work on call on the weekend every 6 weeks - not 100% sure because his team might cover it. Best regards, Brian Fellers | Lead Professional Recruiter T 913.982.4972 | M 785.250.7060 | bfellers(a)TEKsystems.com 800.318.2074 | F 913.982.5053 7421 W 129th St, Suite #300, Overland Park, KS 66213 -- Jonathan

1 0