What are the responsibilities and job description for the Database Architect position at SSI People?
Job Details
Job Description:
The nature of the work is focused in designing, implementing, and optimizing robust database solutions to support our organization's information management needs.
- Develop and design scalable and efficient database architectures that align with business requirements.
- Collaborate with stakeholders to understand data needs and ensure data models support current and future use cases.
- Create logical and physical data models, defining relationships, constraints, and data integrity rules.
- Ensure data models are optimized for performance, scalability, and maintainability.
- Evaluate and recommend database management systems (DBMS), tools, and technologies based on project requirements.
- Stay abreast of emerging trends and technologies in the database field.
- Implement strategies to optimize database performance, including indexing, partitioning, and query optimization.
- Monitor and analyze database performance metrics to identify areas for improvement.
- Integrate security best practices into the database architecture.
- Collaborate with security teams to implement measures that protect sensitive data and ensure compliance with regulatory requirements.
- Plan and execute data migration projects, ensuring smooth transitions between database systems.
- Collaborate with integration teams to facilitate seamless data flows between applications.
- Maintain comprehensive documentation of database architectures, configurations, and data models.
- Ensure documentation is accessible to relevant stakeholders.
- Work closely with development teams, system administrators, and other stakeholders to ensure the effective integration of database solutions into the overall technology stack.
- Proficient in Python, SQL, Databricks, Snowflake
- Expertise in setting up Databricks environment - Cluster setup (Schemas, Stages, Volumes, etc), Delta sharing (csv, tableau, SaaS solutions,..), Unity Catalog policies, RBAC, Data Governance & Compliance policies, Data Lineage, Different Teams, Service Principals, CI-CD, etc.
- Design efficient Data models, apply Medallion Architecture, Query optimization, Workflow orchestration (Brickflow, Notebooks).
Migration :
- Review current Snowflake-based product layouts, recommend migration strategies, schema conversion, performance tuning, and ensuring data consistency, Backward compatibility strategies.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
