Database Architect

Job Description

Skill Set: Database Design and Architecture, Data Modeling & Management, AWS, Python, Oracle based Data Warehouse Job Description: Roles & Responsibility Database Design and Architecture: Lead the design, implementation, and optimization of scalable and efficient database architectures to support business requirements. Data Modeling and Management: Develop data models, database schemas, and data pipelines for efficient storage, retrieval, and management of data across platforms. AWS Database Services: Manage AWS databases, including Aurora (PostgreSQL/MySQL) and DynamoDB, optimizing for cost, performance, and scalability. Python Scripting: Use Python for data manipulation, automation of database tasks, and integration with other systems. Database Performance Optimization: Monitor and optimize database performance, troubleshoot issues, and ensure high availability and disaster recovery. Documentation and Reporting: Maintain up-to-date documentation for database architectures, processes, and configurations. Generate reports on database performance, issues, and improvements. Primary Skills (Essential): At least five years of professional programming experience writing performant stored procedures/functions/SQL statements Database Management: Expertise in database administration, tuning, and troubleshooting. SQL Expertise: Strong SQL skills across various database systems. AWS Databases: Proficiency with Amazon Aurora (MySQL/PostgreSQL) and DynamoDB, including setup, optimization, and scaling. Python: Strong Python skills for data manipulation, automation, and database task management. Data Modeling: Proficiency in designing logical and physical data models to support business processes. Secondary Skills (Highly Beneficial): Snowflake: Hands-on experience with Snowflake data warehousing, data modeling, and data ingestion processes. ETL/ELT Tools: Familiarity with ETL/ELT processes and tools (e.g., Apache Airflow, AWS Glue) for data transformation and ingestion. Data Governance and Compliance: Knowledge of data governance practices, including data security and regulatory compliance standards.