Mark Aufflick's Technical Skills Matrix

Database

Oracle 8i (SQL, PL/SQL)

• Understanding of database design theory and practice
• Understanding of query design and optimisation
• High level & practical design & implementation
• High level & practical troubleshooting

PostgreSQL (SQL, PL/PGSQL)

Sybase (SQL, Transact-SQL)

MySQL (SQL)

FileMaker & MS Access

Client/Server

XML-RPC

• High level & practical design & implementation
• High level & practical troubleshooting

SOAP

Web/Intranet development Languages/Systems

OpenACS / ArsDigita ACS

• Understanding of system design theory and practice
• Understanding of HCI design theory and practice
• High level & practical design & implementation
• High level & practical troubleshooting

Perl ; Mason ; mod_perl

AOLserver

Perl ; TCL ; PHP ; ASP ; Python

JavaScript/Jscript/ECMAScript

HTML/DOM/CSS/XML/XSLT

Unix application development

C/C++

• System design theory and practice
• HCI design theory and practice
• Practical design & implementation
• Practical troubleshooting

Shell scripting

Perl, Perl OO, Tcl/Tk

Project Source File Version Control

CVS

• Repository management
• Tagging and branching
• Working in large project teams on overlapping projects

IBM/Rational ClearCase

Security

Network Security

• Cisco PIX firewalls
• Linux firewalling (iptables/NetFilter, shorewall)
• SonicWall firewalls
  

Server Security

• Standard Unix server hardening principles
• Standard Windows NT/2000/XP server hardening principles
• Linux firewalling (iptables/NetFilter, shorewall)
• Server log filtering and alerting

Server

Network Services

• DHCP, DNS, WINS
• Platforms inc. NT, Unix, MacOS, Netware

Mail Routing

• SendMail: SMTP
• Microsoft Exchange: X.400, RCP, SMTP TrendMicro VirusWall

Mail Delivery

• SendMail: SMTP
• Qmail: POP, IMAP
• Microsoft Exchange: Exchange, POP, IMAP
• TrendMicro ScanMail

Operating Systems

• Unix (Linux, FreeBSD, OpenBSD, MacOS X, Solaris)
• Microsoft NT (3.x, 4.x, 2000, XP)
• Netware 4.x
• MacOS Classic

File & Print

• Netware 4.x
• SMB - Windows (NT, 2000, XP) - Samba (Unix)
• Unix native (NFS/LPD)
• AFS - Apple File services (Appletalk & IP)

Internet Services

• Apache web server
• Apache Tomcat / JBoss J2EE server
• Microsoft IIS web server
• Squid Caching software

Backup Systems

• CA ArcServe
• Veritas BackupExec
• Dantz Retrospect

Server Hardware

• HP/Compaq Server ranges
• Sun Netra Server range
• Dell Server range

Availability/Performance Monitoring

• HP OpenView / ManageX
• Freshwater SiteScope
• SNMP v1,2,3
• Syslog
• NT Event Monitor / Performance Monitor

Network

Structured Cabling

• Understanding of electrical, RF and Fiber-optic theory
• High level practical design & maintenance
• LAN, Digital & Analogue phone, ISDN

802.11 Wireless

PSTN/ISDN/DSL

Ethernet

• High level & practical design & implementation
• High level & practical troubleshooting, packet analysis

TCP/IP, UDP/IP

• High level & practical design & implementation
• High level & practical troubleshooting (packet analysis)
• LAN (shared/switched) & WAN (routed)
• RIP, ICMP, ARP, RARP, SNMP, NetBios

IPX, SPX

• High level & practical design & implementation
• High level & practical troubleshooting (packet analysis)
• LAN (shared/switched) & WAN (routed)
• NDS
• RIP, SAP

AppleTalk

• High level & practical design & implementation
• High level & practical troubleshooting (packet analysis)
• LAN (shared/switched/routed) & WAN (routed)
• DDP, SDP, ADSP, NBP, AFP, ARP, PAP

Misc Protocols

• DECnet, NetBeui, DLC
• Implementation & Troubleshooting

Network Hardware

• Bay/Nortel Switching Hardware
• Cisco Routers

RAS, PPP (PSTN/ISDN)

• Design, Implementation & Troubleshooting
• Servers (Lucent PortMaster, Intel LanRover)
• Authentication (Radius)
• Telco (Telstra DialConnect, Compuserve)

Telephony

All of the below items

• High level design & implementation
• Implementation management
• High level troubleshooting

Switches

• Nortel Meridian 1 PABX series
• NEC NEAX PABX series
• Various commander-style systems

Voice Messaging

• Avaya/Octel Voicemail messaging
• Nortel Meridian Mail

Voice Recording

• Eyretel MediaStore series recording solutions

Video Conferencing

• Polycom ViewStation videoconferencing series

Carrier

• Business continuity redirection plans
• Exchange based ACD queuing
• Analog (PSTN, fixed wire) circuits
• Digital (ISDN, DDS, DSL) circuits