Position Summary
We are seeking an experienced Database Developer/Database Administrator (DBA) with expertise in Salesforce and Microsoft Azure to design, implement, and maintain scalable and secure database systems. This role involves developing and managing data solutions that integrate with Salesforce and Azure cloud services, ensuring optimal performance, security, and reliability. The ideal candidate will have strong technical skills, a deep understanding of cloud-based database environments, and a passion for delivering efficient data-driven solutions.
Key Responsibilities
Database Development
- Design and develop database schemas, objects (tables, views, stored procedures, and triggers), and ETL pipelines to support Salesforce and Azure-based applications.
- Develop and maintain integration processes between Salesforce, on-premise databases, and Azure cloud platforms.
- Create and optimize SQL queries, scripts, and code for data manipulation and reporting.
- Leverage Salesforce Data Loader, APIs, or similar tools for data imports, exports, and migrations.
- Develop data models that support business intelligence (BI) and analytics initiatives.
Database Administration
- Manage and maintain Azure-based databases (e.g., Azure SQL Database, Cosmos DB) and hybrid environments.
- Monitor and optimize database performance, ensuring high availability and security.
- Implement backup, recovery, and disaster recovery solutions for Azure-hosted and on-premises databases.
- Administer and optimize Salesforce databases and data integrations.
- Apply updates, patches, and manage database upgrades in cloud and on-prem environments.
Cloud Integration & Management
- Work with Salesforce CRM tools, ensuring seamless database integration and synchronization.
- Collaborate with development teams to integrate database solutions with Azure cloud services (e.g., Azure Data Factory, Azure Synapse Analytics).
- Leverage Azure services for scalable data storage, processing, and advanced analytics.
- Assist in the design and implementation of cloud-based data warehousing solutions.
Performance Optimization
- Analyze and optimize database performance using indexing strategies, query tuning, and partitioning techniques.
- Troubleshoot and resolve complex database issues, ensuring minimal downtime.
- Monitor system performance and usage patterns to plan for future scalability.
Data Governance and Compliance
- Enforce data security, privacy, and compliance with relevant regulations (e.g., GDPR).
- Implement and maintain role-based access controls in Salesforce and Azure environments.
- Establish and document database development and administration standards.
Collaboration and Support
- Partner with Salesforce developers, Azure architects, and data engineers to deliver robust solutions.
- Provide technical support to end-users and resolve database-related issues.
- Train team members on database tools, processes, and best practices.
Qualifications and Experience
Education:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
Experience:
- 5+ years of experience in database development and administration, with a focus on Salesforce and Azure ecosystems.
- Proven experience with Salesforce platform (data models, integrations, and APIs) and Azure data services.
Technical Skills:
- Strong SQL programming and database development expertise.
- Hands-on experience with Azure SQL Database, Cosmos DB, or other Azure data services.
- Proficiency with Salesforce data tools (e.g., Data Loader, Workbench, Salesforce Connect).
- Familiarity with ETL tools such as Azure Data Factory or SSIS.
- Knowledge of API integration and data synchronization between Salesforce and external databases.
- Understanding of cloud security, compliance, and data governance best practices.
- Proficiency in scripting languages (e.g., Python, PowerShell) for automation.
Soft Skills:
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration abilities.
- Ability to manage multiple tasks and prioritize effectively in a fast-paced environment.
Preferred Qualifications
- Certifications such as Salesforce Certified Platform App Builder, Microsoft Certified: Azure Data Engineer Associate, or similar.
- Experience with Azure Synapse Analytics or Azure Data Lake.
- Knowledge of DevOps practices and CI/CD pipelines for database deployments.
- Familiarity with Power BI for data visualization and reporting.
