Jun Sato Email & Phone Number

* Currently running a little SQL Server architecture consultation shop.* Migrated a 3.5TB SQL 2008 database to a clustered 2014 setup on vSphere.* Taught software engineering courses at senior collegiate level, for both theory and practice - tackled tiny real-world problems in class settings with student teams. That was fun, engaging and very educational for me as well.* A speaker at local .NET / SQL communities in the area of CLR programming in SQL 2005/2008* As Lead Developer, localized enterprise-scale ASP.NET search engine + assorted supporting web apps (Classic ASP) to Japanese, with SQL Server 2000 backend (Replication, DTS, bcp). Also functioned as a bilingual project manager* Performed routine feature implementations and bug fixes in C# for enterprise apps at different tiers, from UI to middleware.* Architected several SQL 2005-based systems, utilizing advanced features such as mirroring and replication.* Wrote and maintaned SSIS packages* Performance-tuned SQL 2005 systems that worked with ORM (in which you don't get to mess with query, you optimize for machine-generated query), despite many challenges managed to run 99.2% of the query to return under 50ms with combination of bare-metal tuning and index tuning* Designed and built (recommendation, purchase, install, operation and some end user support) VMware ESX infrastructure on Dell server and storage* Designed and maintained multi-site Active Directory setups, DHCP/DNS integration with existing Cisco infrastructure that supports remote VPN user.* Consulted on right-sizing infrastructure for various systems involving SQL and VMware. Analyzed SQL server performance in various virtualization solutions.* Consulted on Unicode 4.0 (the nitty gritty of UCS-2 vs UTF-16, SQL collation etc)* Integrated ScanTron (OMR) with Electric Medical Record software.* Maintained storage subsystems. One time I recovered a RAID-5 array from a multi-drive failure.Specialties: SQL - (architecture, replication, stored procedure, trigger, audit, security, performance tuning, backup) C#, Classic ASP, Design Pattern, XML, internationalization, localization, Japanese, Networking (DNS, SSL, Cisco router, entry-level IOS stuff), VMware, SAN, iSCSI, Unicode, Active Directory design and implementation, Visual Studio 2005/2008, IIS, Windows Server administration

Listed skills include Microsoft Sql Server, Iis, .Net, Databases, and 46 others.

• 

  Eastern Washington University

  Computer Information Systems