Josh's Portfolio

Skills

Software Development

Data (API, SQL, Document Oriented Storage, Filemaker)

  • General Skills: Indexing, normalization, advanced database administration, security, and monitoring
  • Informatica (“Big” data): Bulk geocoding and address normalization for firm and legal data across the U.S.
  • MySQL/MariaDB, PostgreSQL: Stored procedures/triggers, application storage, backup automation, enforcing referential integrity, replication, partitioning, specialized administration tools (PhpMyAdmin, PhpPgAdmin, Adminer, SQL Buddy)
  • MongoDB: Document-oriented storage for strict encoding-sensitive data
  • Filemaker: PHP/XML publishing, ODBC, script triggers, custom plugins (MonkeyBread)

Server Deployment and Management

  • Apache HTTP Server: Full compilation, output compression, rotatelogs, auto-deploy scripts for vhosts, SSL certificate management
  • PHP5, PHP7: Full compilation, MySQLi, PDO, LibPNG, LibJPEG, PhpRedis, Memcache(d)
  • Operating Systems: Debian, Arch, Alpine, OpenSUSE, CentOS, Windows
  • Container-based and VM Environments: Docker, LXD, VMware, VirtualBox
  • Cloud Deployment: AWS (EC2, Route 53, Load Balancing, CloudSearch, S3), Jenkins/Puppet for OS deployment
  • Network: Load balancing, failover protocol, clustering, Cisco routing, SiteScope monitoring, Bind9 zone management, OpenVPN, firewall/proxy management

Software Quality Assurance

  • Test coverage: Test planning, test cases, regression, acceptance, performance, and production
  • QA Execution: Concurrency and scalability analysis, test automation (Ranorex), grey-box testing, bug reports
  • Reporting: Acceptance criteria, user stories, progress reporting with metrics and graphing tools (TFS, PractiTest)