Headline

Oracle Cloud Infrastructure| Exadata| SQL and PL/SQL

About

Oracle Cloud Infrastructure| Exadata| SQL and PL/SQL | Python | Informatica Powercenter. Expertise in SQL and PL/SQL Writing PL/SQL objects like function, procedure, Package, views and Trigger. Extensively used collections, Varray, Nested Table, Associative Array, Bulk collect and for All in PL/SQL programming Implemented complex business logics using PL/SQL SQLLDR and External Table for data load and unload UTL_FILE to write to a file or read from a file. Implemented complex business logics using PL/SQL Writing complex and optimized SQL Queries Expertise in Exadata administration and monitoring including Monitoring Cell desk, grid disk, Cell Flash cache, Flash disks Maintain storage availability during patching and other maintenance tasks CellCLI, ExaCLI, dcli commands execution & administration Starting & Stopping Exadata Cell Server Software Connect to Integrated Lights Out Manager (ILOM), verify current system state, identify hardware issue or restart system, and review logs for root cause analysis. Administration of Component Passwords (DB Server, Storage Server, ILOM, InfiniBand switches, Power distribution units etc.) Expertise in Exadata Performance Tuning Using ExaWatcher to Monitor Oracle Exadata Database Machine Performance (IO Stats, CPU utilization etc) Calculating the percentage of Smart Scan and cell offloading taking place for a particular SQL. Re-writing an SQL to take maximum advantage of the Exadata Smart Scan feature. Good experience in Oracle Core Database administration and monitoring including Proactive DB schema, tablespace and disk space monitoring Periodic DB health check-up, Periodic DB Growth and DB capacity monitoring DB start/stop, DB parameters configuration Regular DB operations like create and/or maintain database users/logins/Profiles/Roles/ DB links/Schema/Tablespaces Experience in Patching/Upgrade Applying Oracle Exadata System Software patches or upgrades Operating systems, and component firmware patching and upgrade Use of Exachk utilities during upgrade and patching Evaluate and apply Oracle Database/Grid Infrastructure Software patches or upgrades Apply one off patches when required Experience in Informatica Powercenter Database design concepts - Transactional / Data mart / Data warehouse etc Designing and implementing mapping for ETL Certification Details: Oracle Cloud Infrastructure 2019 Certified Architect Professional Oracle PL-SQL certified (OCA)

Location

Colorado Springs

AI stack

langfuse

langgraph

mcp

claudecode

OpenRouter

Wispr Flow

Work experience

Analytics Manager at noon, Dec 2022 - Present · 3 y 9 mo, Gurugram

Lead Business Analyst at Talent500, Sep 2021 - Sep 2022 · 1 y, San Diego County, California, United States

Associate Consultant at ZS Associates, Aug 2018 - Sep 2021 · 3 y 1 mo, New York City Metropolitan Area

Education

BE, COMPUTER SCIENCE & ENGINEERING, magadh university

10th, S.K. High School