Database Architect

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.

Who We Are and What We Do

Aspire Systems is a global technology services firm serving as a trusted technology partner for more than 250 customers across the globe. Aspire works with the worlds most innovative enterprises in Banking, Insurance, Retail and ISVs, helping them leverage technology to transform their business in the current digital landscape. Aspire s proven approach to Software Engineering & Digital Technologies helps companies run smart business models. Aspire s core philosophy of Attention. Always. communicates its belief in lavishing care and attention to its customers and employees.