Dharam Pal Singh
Bay Area, CA | (925) 568 6962 | dharamdba@gmail.com | https://www.linkedin.com/in/dharam-pal-singh-65a53813/ |
SUMMARY
A consistently high-performing and engaged business and experience AWS data Architect,Snowflake SME/Architect, DataBricks,Oracle(9i-19c), ERP (11i-R12), MongoDB, AWS RDS, MSSQL, and Hadoop Admin, machine learning, distributed systems (SaaS). Have a track record of meeting and exceeding commitments by raising my organization’s bar via strategic thinking to design and execute challenging initiatives. As a leader of cross-functional teams of up to 25 people, have designed, developed, and delivered products at various stages of their lifecycle, including incubating new products, growing existing products, and decommissioning legacy products. Have extensive experience working in and leading diverse multi-cultural teams spread across multiple geos – USA, India & Australia.
TECHNICAL KNOWLEDGE
• Database: Oracle, Snowflake, MongoDB, MS-SQL Server, AWS RDS PostgreSQL.
• Python, SQL.
• Shareplex,Golden Gate (Replication tool)
• Hadoop (HDFS, Map Reduce, Pig, Hive)
• Spark: Stream and Analyze the Big Data
• JIRA, Confluence, Git,GitHub. • AWS Cloud
• Machine Learning with Python
• Libraries: NumPy, pandas
• Python visualization (distplot, jointplot, KDE,pairplot, strip plot, swarm plot, boxplot, barplot, countplot etc)
WORK EXPERIENCE
Architect at Mphasis (Client: JPMC/First Republic Bank) Aug 2015 – Till date
• Experience designing dimensional and snowflake data models for data warehousing and data lakes.
• Onboarded the users into Snowflake and supported the development team by creating the stages (Internal and external) on AWS, file formats in different environments for structured and semi-structured data. Designed logical and conceptual data models, Roles (RBAC), security policies .
• Experience in AWS Cloud, data pipelines, ETL Snowpine etc.
• Experience in Azure Cloud, Data Integration using ADF.
• Configure ETL data pipeline using DBT , Airflow, Fivetran and Kafka.
• Experience of AWS data services including S3, Glue, Redshift, Athena, Lake Formation, Step Functions, CloudWatch and EventBridge.
• Exp in data governance, security, and compliance frameworks following AWS best practices (IAM, KMS, Lake Formation).
• Optimize data platforms for performance, scalability, and cost efficiency.
• Lead data migration initiatives from on-premises or other cloud platforms to AWS.
• Provide technical guidance and mentorship to data engineering teams.
• data ingestion, transformation, and storage strategies using AWS services such as Glue, Lambda, EMR, S3, Redshift, and Athena.
• Slowly Changing Dimensions, tracks historical changes to dimensional data by creating a new record for each change.
• Design and deploy scalable data pipelines using Azure Data Factory, Synapse Analytics,
• Implement workflow orchestration using tools like Apache Airflow or Azure Logic Apps.
• Monitoring & Optimization:
• Set up monitoring and alerting for data pipelines using Azure Monitor and Log Analytics.
• Optimize performance, cost, and scalability of data solutions.
• Governance & Security:
• Ensure data governance, lineage, and compliance using Azure Purview and role-based access control (RBAC).
• Implement data security best practices including encryption, masking, and secure data sharing.
• Collaboration & Leadership:
• Work closely with data engineers, analysts, and business stakeholders to align data operations with business goals.
• Implemented AWS configurations S3, EC2, and SQS. Created internal and external stages and transformed data during load. Implemented a pipeline to import data from the data marketplace which lead to reducing in forecast reporting times. Configure MongoDB replica set and sharded clusters as per the application requirement.
• Experience with Agile and DevOps concepts.
• Knowledge of data governance best practices including data classification, access control, and data lineage tracking.
• Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
• Experience with architecting and maintaining high availability production systems.
• Experience with developing monitoring architecture & implementing monitoring agents, dashboards, escalations, & alerts.
• Knowledge of security controls for the public cloud (encryption of data in motion/rest and key management)
• Experience with AWS CLI .
• Self-starter with ability to manage tasks with minimal supervision within an energized, collaborative, & entrepreneurial environment.
• Experience in development of SQL, Python, and Shell based scripting to build a variety of reporting and application data warehouses Preferred.
• Experience in Data Injection, Data Pipeline, Schema Infrastructure Real time batch data into Snowflake.DBA Lead Consultant at Mphasis (Client: Common Bank of Australia) Jan 2011 – July 2015
• Supporting experience from 9i-19C RAC. Cloning of the Oracle apps from single to single and single to multi and multi to single. Managing the application system by using AD Utilities.
• Cloning from RAC database to Non-RAC database through RMAN Duplicate command. Migrating the database from NON-ASM to ASM and vice-versa. Support End to End Testing for Production Release. Monitoring, maintenance, and troubleshooting of RAC servers.
Senior Database Administrator at Wipro Infotech July 2007- Jan 2011
• Implementing the new architecture with 10g/12c RAC. Cloning of the Oracle apps from single to single and single to multi and multi to single. Managing the application system by using AD Utilities.
CERTIFICATIONS
AWS Certified Solution Architect Associate.
Oracle Certified (11g,10g,10g RAC, 9i OCP, and EBS 11i). ITIL Foundation certified.
Post Graduate Program in Artificial Intelligence and Machine Learning from The University of Texas at Austin.
EDUCATION
Master of Computer Application from UP Tech University, India.
B. Sc (Hons) Mathematics from Aligarh Muslim University Aligarh, India.