Database Expert

Database and AI automation Expert

Freelancing Career • Tiempo completo

Aug 2020 - Present • 5 yrs 11 mos

- Built AI automation workflows using n8n, Zapier, LangChain, IBM App Connect, and Microsoft Power Automate. - Developed AI agents and LLM powered solutions for workflow automation and intelligent decision making. - Integrated APIs, databases, CRMs, ERPs, and cloud services to automate business processes. - Automated lead management, email workflows, reporting, approvals, and data synchronisation. - Optimised automation solutions with secure integrations, monitoring, error handling, and scalable architecture. - Managed Oracle EBS R12 environments including multi node cluster administration, database and grid upgrades from 12c to 19c. - Performed RMAN backups, patching, cloning, and ongoing monitoring using OEM and custom health check scripts to ensure system stability. - Managed Exadata based environments including load balancers, DMZ configurations, and Linux server management for high-availability setups. - Designed and optimized PostgreSQL databases, including schema design, complex query writing using CTEs, window functions, and triggers. - Integrated PostgreSQL with AWS services such as S3, Lambda, DynamoDB, Glue, and Redshift to build efficient ETL pipelines and data workflows. - Executed PostgreSQL performance tuning, schema partitioning, and seamless database migrations to AWS RDS and Aurora. - Tuned MongoDB replica sets by addressing replication lag, optimizing slow queries, and managing shard key distribution and balancing. - Administered MySQL NDB Clusters, resolving node synchronization issues and ensuring high availability and performance. - Developed and maintained automated scripts for backup monitoring, system health checks, and proactive incident prevention. - Oversaw Linux OS space management, including log and backup directory maintenance to ensure optimal server resource utilization.