Database Engineering, Security & Advanced Analytics
Database Systems // Security Management & Analytics
Overview
Engineering implementations from advanced database systems, security management, and analytics coursework — spanning relational schema design and transactional control in MySQL, SQL Injection threat emulation and parameterized defense, NoSQL document engineering with MongoDB, point-in-time disaster recovery via binary logging, and predictive analytics and NLP pipelines built on the ELK Stack, Altair AI Studio, and SpaCy.
Major Projects
Secure RDBMS Architecture & Threat Emulation
- Designed a comprehensive Entity-Relationship Diagram (ERD) mapping complex operational workflows, translating business rules into strict DDL schemas.
- Hardened database perimeters by auditing mysql.user dictionaries, provisioning isolated user profiles, and executing least-privilege GRANT authorizations to restrict schema manipulation.
- Conducted targeted vulnerability assessments against the Damn Vulnerable Web Application (DVWA), exploiting un-sanitized input fields to extract administrative authentication hashes.
- Refactored vulnerable backend Python application logic, replacing dynamic string concatenation with strictly parameterized SQL execution paths to neutralize malicious SQLi payloads.
Enterprise Telemetry Analytics & Data Mining
- Provisioned an ELK Stack (Elasticsearch, Logstash, Kibana) utilizing Filebeat shippers to ingest, index, and visualize massive Apache access and error log streams in real-time.
- Imported comprehensive external datasets into Altair AI Studio, structuring advanced predictive models utilizing k-means clustering algorithms to identify hidden data correlations.
- Designed and executed Linear Regression pipelines, splitting datasets into dedicated training and scoring batches to evaluate attribute weights and precisely predict unmapped column values.
Applied NLP & NoSQL Document Engineering
- Provisioned local MongoDB Linux environments to ingest, structure, and query deep-nested unstructured JSON datasets exceeding 1,000 document nodes.
- Programmed an object-oriented Python Natural Language Processing (NLP) engine utilizing the SpaCy machine learning library to sanitize and parse raw text strings.
- Implemented advanced linguistic analysis functions, extracting conversational context via Part-of-Speech (POS) tagging, Named Entity Recognition (NER), Lemmatization, and algorithmic stop-word filtration.
Point-in-Time Recovery & Binary Log Infrastructure Auditing
- Designed an enterprise-grade database backup protocol executing multi-tier validation sweeps using logical mysqldump utilities and internal database administration tools.
- Enabled and structured native MySQL binary logs (binlog) to continuously track active system transactions and mutation events across the data schema.
- Executed data recovery workflows by parsing raw binary log transaction events, compiling sequential point-in-time recovery maps, and restoring deleted data structures with zero telemetry loss.
Skills Gained
Relational Database Administration & Migration
Designed Entity-Relationship Diagrams (ERDs) and provisioned multi-platform RDBMS schemas (MySQL). Engineered complex SQL queries utilizing multidimensional JOINs, nested subqueries, and dynamic view generations (EmployeeList).
Transactional Control & Identity Management (TCL/DCL)
Configured logical isolation tiers via SET AUTOCOMMIT OFF and executed fault-tolerant atomic transactions utilizing SAVEPOINT and ROLLBACK states. Hardened backend security via strict Role-Based Access Control (RBAC), implementing targeted GRANT permissions for non-root users (lab4User).
Enterprise Disaster Recovery & Auditing
Architected comprehensive point-in-time recovery (PITR) workflows. Executed logical system snapshots via mysqldump and configured continuous transaction auditing leveraging MySQL binary logging (binlog) to restore purged table architectures.
Security Operations & Threat Mitigation
Executed manual penetration tests against Damn Vulnerable Web Application (DVWA) to expose backend vulnerabilities. Developed Python utilities to simulate and ultimately prevent SQL Injection (SQLi) attacks by implementing robust parameterized SQL query structures.
NoSQL Data Engineering (MongoDB)
Engineered scalable document-oriented databases using MongoDB. Formatted and ingested massive, multi-layered JSON datasets, programming sophisticated CLI query pipelines to filter, aggregate, and project nested array dimensions.
Big Data Analytics & NLP
Deployed the ELK Stack (Elasticsearch, Logstash, Kibana, Filebeat) to ingest and visualize real-time Apache telemetry. Executed predictive data mining (k-means clustering, Linear Regression) using Altair AI Studio. Engineered Python-based Natural Language Processing (NLP) pipelines utilizing SpaCy for Named Entity Recognition (NER), Lemmatization, and Part-of-Speech (POS) tagging.