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• Managed GIS data using SQL Server and PostGIS.• Replaced and extended manual audit tables/triggers with Temporal tables

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 • Recruiting, interviewing, and hiring technical staff • Identify, Review, Approve, and Purchase all Information Technology (IT) products, including hardware, software, and licenses• Develop a lifecycle replacement plan and budget for desktop computers • Planning, evaluating, and implementing IT security policies and procedures to comply with Department of Administrative Services rules • Develop inter-agency agreements, such as the agreement to share server room costs between Oregon Department of Parks and Recreation, Oregon Department of Housing and Community Services, Oregon Secretary of State, and Oregon Department of Water Resources • Manage personnel issues such as vacation scheduling, time card review, training requests, furlough scheduling, progressive discipline, and staffing reductions • Purchasing, installing and maintaining agency servers running Windows 2008 R2 and Windows 2012. Provide for all system administration functions including user management, patching, backups, upgrades, system security, and firewall configuration.

• 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 • Purchasing, installing and maintaining agency servers running Unix, Linux, Windows 2000, and Windows 2008. Provide for all system administration functions including user management, patching, backups, upgrades, system security, and firewall configuration. • Performed a major hardware and software upgrade project which included planning, budgeting, purchasing, installing, configuring, and migrating to Active Directory, Virtualized Windows 2008 Servers, VPN access, DFS file systems, and SQL Server 2008 • Developing a biennial lifecycle replacement plan and budget for server room hardware and software • Coordinated with GIS staff to tightly integrate GIS information with water rights relational databases • Developed online mapping tools that allow the public and staff to graphically view water right information

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 • Installed, configured, and maintained multiple Arc/Info installations

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