Siddharth Raj

Sep 2021 – Mar 2022: Oracle Database Administrator.

• Installed, configured, and managed Oracle 12c/19c databases in enterprise environments.
• Performed routine database administration tasks, including backup, recovery (RMAN), patching, and performance tuning.
• Managed data migrations and supported a seamless transition from on-premise databases to Oracle Cloud Infrastructure (OCI).
• Ensured database integrity, optimized query performance, and supported schema design for business-critical applications.
• Worked with SQL, PL/SQL, and database monitoring tools for troubleshooting and performance diagnostics.

Apr 2022 – Present: Azure Data Engineer.

• Designed and developed scalable ETL pipelines using Azure Data Factory for ingesting structured and semi-structured data from multiple sources.
• Used Azure Databricks (PySpark) for data cleansing, transformation, and enrichment of high-volume datasets.
• Built and maintained data warehouses using Azure Synapse Analytics, with effective indexing, partitioning, and security strategies.
• Supported real-time and batch data processing, enabling advanced reporting and analytics using Power BI.
• Implemented CI/CD pipelines using Azure DevOps, and integrated monitoring solutions using Azure Monitor and Log Analytics.
• Collaborated cross-functionally with analysts, scientists, and stakeholders to translate business needs into efficient data solutions.

Oracle DBA Responsibilities (Sep 2021 – Mar 2022):

• Installed, configured, and maintained Oracle 12c/19c databases in development and production environments.
• Performed routine DBA activities, including space management, user access control, and database patching.
• Implemented backup and recovery strategies using RMAN, and handled data export/import using Data Pump.
• Monitored performance metrics, and executed query tuning to improve database efficiency.
• Supported database migration to Oracle Cloud Infrastructure (OCI), ensuring minimal downtime, and high data integrity.

Azure Data Engineering Responsibilities (April 2022 – Present):

Data Pipeline Development:

• Contributed to the end-to-end development of robust ETL pipelines using Python and Apache Spark, facilitating seamless extraction, transformation, and loading of diverse data sources into a centralized data lake.

Cloud Platform Expertise:

• Leveraged Microsoft Azure for scalable, efficient data processing solutions.
• Designed and orchestrated data pipelines using Azure Data Factory (ADF); performed large-scale processing using Azure Databricks.

Database Management:

• Managed large-scale databases, including SQL Server, Oracle, and NoSQL databases, like MongoDB.
• Conducted performance tuning, query optimization, and ensured high-speed data retrieval and transformation.

Data Modeling and Architecture:

• Participated in the design and implementation of scalable, normalized data models for efficient storage and analytics.
• Contributed to building star and snowflake schemas for data warehousing in Azure Synapse Analytics.