Rashid M.

Are slow database queries, high CPU spikes, or locking issues degrading your application's user experience? I am a Senior Oracle & PostgreSQL DBA with 10+ years of hands-on experience optimizing mission-critical databases, tuning complex SQL queries, and building scalable Python backend automation. Whether you are running enterprise Oracle infrastructure, scaling a high-traffic PostgreSQL database, or migrating workloads between the two, I help businesses eliminate performance bottlenecks and ensure 99.9% uptime. -------------------------------------------------- ⚡ WHAT I DO BEST -------------------------------------------------- 1️⃣ Query Optimization & Performance Tuning • Slash query execution times from minutes to milliseconds using execution plan analysis (EXPLAIN ANALYZE, AWR, ASH, TKPROF). • Indexing strategies, partitioning, lock resolution, and query refactoring to drop database CPU/memory loads. 2️⃣ Database Administration & Architecture (Oracle & PostgreSQL) • Schema design, data modeling, normalization, and capacity planning. • High Availability, backup/recovery strategies (RMAN, pg_dump/pg_restore, PITR), and version upgrades/migrations. • Stored procedures, PL/SQL, PL/pgSQL, triggers, and functions. 3️⃣ Python Backend & Automation Solutions • Custom REST APIs and web applications using Flask and Python. • Automated ETL pipelines, data extraction (JSON/CSV/Excel), and web scraping. • Workflow automation scripts to replace manual data processing tasks. -------------------------------------------------- 🛠️ TECHNOLOGIES & TOOLS -------------------------------------------------- • Databases: PostgreSQL | Oracle DB (11g/12c/19c) | SQL | PL/SQL | PL/pgSQL • Python & Backend: Python | Flask | RESTful APIs | Web Scraping | ETL • DevOps & OS: Linux/Unix | Docker | Git | Bash Scripting -------------------------------------------------- 🎯 WHY CLIENTS HIRE ME -------------------------------------------------- ✔ Proven Performance Gains: I focus on measurable outcomes (latency reduction, query speed, cost efficiency). ✔ Dual-Database Expertise: Rare combination of enterprise Oracle administration and open-source PostgreSQL scaling. ✔ Clean & Maintainable Code: Well-structured Python scripts and documented database logic. If you have a database that's lagging, an optimization problem you can't solve, or a backend automation task, click "Invite" or send a message—let’s discuss your project!