Fordham University | Bronx, NY | 508-930-9244 | andrewmp409@gmail.com
Objective
Computer Science major with hands-on experience in database administration, system automation, and network security. Passionate about designing scalable and high-availability database systems and optimizing infrastructure. Seeking to leverage these skills in database engineering, system administration, or backend development.
Experience
Database Administrator
Fordham University – IT | April 2024 - Present
MySQL Active Directory Integration
- Designed and implemented a MySQL database to centralize Active Directory relationships for thousands of users, groups, and objects, significantly improving data accessibility and automating lookup and audit tasks.
- Developed Python and PowerShell scripts to automate data synchronization, including user-group-object mapping and metadata management.
Firewall Optimization & Network Audit
- Built and designed custom database tables to track firewall objects, network groups, and associated firewall rules for a comprehensive inventory and rule audit.
- Developed Python scripts to parse and validate active objects via ping, nslookup, and other checks, resulting in the decommission of stale entries and reducing rule conflicts.
- Designed and implemented database tables to track over 3,500 firewall objects and 700 rules, improving inventory and audit accuracy by 100%.
MySQL/MariaDB Database and Server Configuration
- Implemented and configured MySQL installations on six servers, setting up master-slave replication to ensure high availability while supporting the university’s shared and personal metadata storage requirements.
- Created automated backup and restore scripts to Rubrik storage, using custom POST/GET scripts to automate token fetching and purge routines.
- Migrated MySQL instances to a MariaDB HA Galera Cluster, enhancing scalability, reliability, and failover support, minimized downtime and data loss risk, achieving 99.99% uptime and ensuring seamless failover.
IT Budget Application Backend Development
- Assisted in the backend development of an internal IT budget tracking application, ensuring secure deployment and integration with PostgreSQL, Node.js, Express.js, and Angular.
- Installed and secured PostgreSQL, configuring role-based access control, enforcing TLS encryption, and enabling continuous archiving for backups to ensure data integrity and disaster recovery readiness.
Education
Fordham University, Bronx, NY | Expected – 05/2026
- Bachelor of Science in Computer Science
- Major GPA: 3.93
- Dean’s List – 2022, 2023, 2024, 2025
- Relevant Courses: Database Systems, Computer Algorithms, Data Structures, Computer Organization, Mobile Device Programming, Computer Science I and II with Lab, Discrete Structure I and II with Lab
Skills
- Databases & Administration: AWS RDS, MySQL, MariaDB, PostgreSQL, Oracle 19c, SQL Server (SSMS)
- Scripting & Automation: Python, C++, PowerShell, Bash, Swift
- Infrastructure & OS: RHEL, Windows Server, Active Directory, Networking (firewalls, subnets)
- Monitoring & Security: Rubrik, Database Replication & High Availability
- Data Visualization & Reporting Tools: Power BI, Lucidchart, Spotlight
- Productivity & Office Tools: Microsoft Office Suite (Excel, Word, PowerPoint), Google Sheets