Ken Smith Email & Phone Number

Salem, OR, US

Salem, Oregon

• Primary Database Administrator/Developer supporting the Integrated Road Information System (IRIS) migration from a terminal services VB program to an ASP.net MVC web based application
• Installed, setup, and administered Microsoft SQL Server and Postgresql databases.
• Migrate database from SQL Server 2012 to SQL Server 2016
• Migrated SQL Server 2016 databases to Postgresql 15
• Developed the DevOps/Source Control pipe line to automate the delivery and integration of the database using RedGate, Jenkins, GitHub, and Powershell tools
• Re-engineered multiple individual databases into a multi-tenant single database using Row Level Security

Salem, Oregon

• Coordinate with management staff to develop and prioritize the long range, agency-wide IT project plan
• Supervise a motivated and dynamic 11 person technical team as a "working manager" ensuring projects continue on time and within budget
• Database Administrator for the Agency's enterprise SQL Server 2012 databases. This includes hardware and software purchasing, installation, upgrades, performance tuning, backups, and recovery
• Database Developer designing relational databases and applications ranging from simple applications such as performance metric tracking to complex, team-oriented projects such as the Water Right Information System
• Assign tasks to staff, prioritize workloads, monitor progress of projects, and provide support to technical staff
• Planning and monitoring the agency IT budget

• Serve as team lead for many projects and provide support for other developers with technical issues
• Manage contract programmers working on hydrographic projects as the Project Leader. This included assigning tasks, monitoring progress, reviewing completed work, and providing technical support
• Developing programming standards and safe coding practices, creating automated code generation tools, and reviewing the work of other developers to ensure adherence to standards
• Developing web based programs accessing corporate data including water rights, well logs, and document images using ASP.net and C#
• Performing database administration duties for the department's enterprise SQL Server 2005/2008 databases. This includes hardware and software purchasing, installation, upgrades, backups, performance tuning, and recovery
• Designing relational databases and applications ranging from simple applications such as performance metric tracking to complex, team-oriented projects such as the Water Right Information System

Eugene, Oregon

• Served as Team Leader for many software development projects which ranged from downsizing mainframe applications into Client/Server platforms to developing GIS applications using Arc/Info and Arcview
• Managed rural land mapping project, which included writing grant proposal, developing budget, hiring and supervising temporary staff, managing budget, creating GIS tools, and packaging final deliverables
• Performed database administration functions for Oracle and Access databases
• Created a GIS system for the county road network and integrated corporate road information databases via dynamic segmentation
• Installed, configured, and administered a heterogeneous network of Novell, NT, Macs, and UNIX based servers. Managed Local Area and Wide Area network infrastructure
• Managed Internet services such as World Wide Web, FTP, NFS, and Telnet. Developed a World Wide Web Page for Lane County

Salem, Oregon

• Developed relational database applications including a Road Inventory System, Timecard System and a Construction Project Tracking System using products such as Informix, Vax RDB, "C", and Powerhouse
• Installed, configured, and administered a Novell network for the department
• Designed and implemented Local Area and Wide Area Networks
• Installed and Administered a VAX/VMS Cluster and a Unix based server
• Provided technical assistance to end-users both in person and remotely
• Taught classes in the use of office automation tools

Bs, Computer Science

Activities and Societies: Minor in Communication

Associates, Computer Science/Data Processing