Master enterprise Salesforce data architecture from modeling to production governance. Apply entity design patterns, ERD best practices, and Schema Builder diagrams; implement security controls (Profiles, Permission Sets, OWD, role hierarchy, sharing rules, FLS, validation rules) distinguishing field- vs. record-level access. Optimize Large Data Volumes with Query Plan, indexes, skinny tables, and big objects, showing measurable SOQL performance improvements.

Architect production-grade Salesforce integrations by mastering sync (REST/SOAP, authentication, Named Credentials, External Services, idempotency, retries) and async/event-driven patterns (Platform Events, CDC, durable subscribers, delivery guarantees, DLQs). Apply sync vs. async decision matrices based on timing, volume, coupling, error handling, and use cases. Execute large-scale data migration with Bulk API 2.0, leveraging CSV compression, upserts, parent/child sequencing, reference data mapping, job monitoring, partial failure handling, and Async SOQL for massive datasets.

Establish production-ready data quality, compliance-grade security, and operational observability for enterprise Salesforce. Implement data quality controls: Matching and Duplicate Rules, Duplicate Jobs, cross-object validations, Flow vs. Apex logic, and merge strategies with master/child record handling. Deploy Shield-grade security: Platform/Classic Encryption, Field Audit Trail, Event Monitoring, and Transaction Security policies. Operationalize with dashboards and incident response: monitor API/errors, bulk job failures, validation/duplicate trends, set SLOs/error budgets, implement alerts via Reports or monitoring tools, and document runbooks with triage, RACI, rollback, and success criteria.