Patrick Macdonald Email & Phone Number

Athens, Ga, Us

· Design & implementation of an online certification testing website for the construction industry. Infrastructure built with Cloudformation, Cloudwatch alerts to up/downscale infrastructure and instances + Aurora DB are loaded in real-time via AWS CLI from a remote login page.· GitLab pipeline implementation with python for synchronizing Jira tickets with a custom ticket system. · Design and implementation of Ansible production config deployment template that enforces GitLab synchronization.· Built docker images for a python based contact database microservice and a shared Linux CLI tool environment· Migration of college certification testing application on legacy LAMP to AWS cloud using EC2 and Aurora DB. Web layer auto scales from Lambda / python student counter. Entire platform built from Cloudformation. Automated load testing. · Troubleshooting MySQL database issues like delayed or halted replication and SQL performance.· Linux administration of cloud native MongoDB clusters

Atlanta, Ga, Us

· Cracked a worldwide SMTP abuse criminal botnet better than any industry vendor. Infiltrated their communication system to retrieve stolen credentials in real-time as they stole them allowing us to mark them as compromised before the hackers had even used them.· Cybersecurity: Developed methods and monitors to identify botnet activity on all IPs and SMTP AUTH accounts used by botnets over linux servers using remote and concurrent perl script log parsing. Identified 100s to 1000s per day. Developed methods to intercept botnet administration. (self-initiated)· Automated abuse related tasks using linux, PHP and shell scripting so that abuse department could process their own requests without admin intervention. (self-initiated)· Troubleshooting lead for sysadmin team managing all 200+ linux and Solaris mail servers (physical and some virtual) serving 4 million residential customers and tens of thousands of business customers. This included physical and virtual instances over KVM. LDAP administration, automation, complex report generation.· Streamlined Remedy ticket support work by automating log research and automating backend solutions. Took over all 4th tier ticket support for email platform that had previously been distributed to the team of 4 to 6 people servicing 4 million residential and business customers. This allowed all other team members to focus entirely on project work. Reduced ticket response time to meet group goals for first time. (self-initiated)· Reduced outbound residential spam volume by 60% (over 5 million emails per day.) This was self-initiated and accomplished by observing spam runs and implementing shell and perl based monitoring scripts. The customer care and abuse departments reported significant decrease in calls and work required for a $2k per week cost savings. (self-initiated)

· Daily PHP, MySQL, Apache2, Perl and linux shell development and administration for 200+ websites spanning six linux system.· Setup and manage a small cluster of web/database servers using Unison file synchronization, mysql replication, and DNS IP round robin. · Administrate, trouble-shoot, and develop web databases for over the 200+ customer websites in Linux, PHP, Apache2, and MySQL.· Performed three cluster migrations to new hardware and linux versions with zero downtime for customer websites.· Wrote several TCP/UPD/IP security programs that dynamically detect and block common hacking and abuse scenarios. We see an average of at least one hack attempt every 30 seconds. · Maintained 99.9% uptime for all customer websites, databases, and linux servers since 2003 (includes ALL downtime.) Almost everyone excludes scheduled maintenance downtime from stats.· Designed and managed primary and secondary DNS services for 500+ domains. Developed custom botnet attack protection service in Perl.

Atlanta, Ga, Us

· Implemented asset management system for 500+ production Solaris and Linux systems. Develop custom probes for contract and vendor management.· Authored document template for Operation documentation guides. Wrote several 20 page plus operational guides.· Provisioning administrator and architect (for LDAP). I forecast future capacity for the LDAP architecture (12 enterprise servers) based off of detailed monitoring and statistics gathering I implemented.· General developer for all System Operations needs. For example, I maintained and developed the internal ticketing system, time tracker, and group scheduler. All in PHP. I also design automation scripts for systems including NetBackup, Oracle, Apache, and many, many more.· Initiated, designed, and implemented a centralized repository for server configuration files and scripts. T.R.A.M. periodically scans all servers and looks for changes, pulls changes back, and checks the changes into the centralized CVS repository. (self initiated)· Saved Cox $10,000/year by simplifying architecture in first major project implementation. Eliminated need for unnecessary external storage and related hardware for LDAP replication project.· Owner and sole system administrator for 20 enterprise level servers.

Dublin 2, Ie

· Designed and implemented Java daemon process to synchronize various authentication databases with centralized customer database.· Designed and implemented an automated EJB service component tester tool. 100% of my EJBs’ functionality was tested (120+ test cases) by running one command. It communicated directly with the Iplanet Application Server. Department followed my lead in unit testing. Perl and Java. (self initiated)· Designed and implemented the provisioning EJB that maintains email business logic and accounts in Openwave’s Intermail through the LDAP interface.· Responsible for production support of all developed applications.

· Every SDC build used the ‘make’ framework I initiated. Designed and implemented enhanced Solaris Package support for Iplanet EJB building and deployment where deployment descriptor variables become configurable at pkgadd installation. Perl and Shell Scripting. (self initiated)· Automated System Administration for 40 servers and 50+ users. Allowed over 40 system administrative tasks to be requested via the web, approved over pager, and completed automatically. When I was on vacation, my non-technical manager was successfully able to fulfill the sysadmin job. Written in Perl. (self initiated)· Designed and implemented an automated installer for Iplanet Application, Directory and Web Servers with special consideration for easy administration. Perl and Shell Scripting. (self initiated)· Designed and implemented RadiusService (Oracle backend) and DnsService (HTTP backend) provisioning EJBs for CRM based project.· Designed and implemented provisioning interface to administrate email accounts in Software.com’s Intermail system using Java and LDAP.· Maintained production Java and C++ applications.· Provided senior support for production Unix systems and applications including AAA, Mail and PWP Provisioning Clients and Targets, Hermes, SBR LDAP, Sendmail, and Radius.

· Saved company $220,000 annually by designing and implementing a replacement for Tivoli management which has proven to be crucially more reliable and more versatile. Received BellSouth.net Red Dot award for CRUSADE project. Perl and Shell Scripting. (self initiated)· Lead role in interviewing, training and developing other administrators. Designed interviewing guidelines and questions for technical interviews.· Senior level trouble-shooting of most production applications for BellSouth.net services. Designed administration scripts for system administration team.· Designed and implemented advanced monitoring solution for all 200+ production systems and 25+ unique applications. Created English-like monitoring language. Perl. (self initiated)· Owner for the application responsible for tracking services for all business customers and Usenet News architecture. Sole admin over 18 Enterprise Unix servers.· Developed custom control for Tivoli enterprise management.

· Developed custom billing application in MS Access with automated service provisioning to Linux services for PPP dialup and email services.· Managed and developed custom features all Internet services including: Radius authentication, dialup equipment, Usenet news service, web services, ftp services, email services. Most was in C with embedded SQL. · Lead role in interviewing, training and developing other staff.