Job Description: Web Application Architect 2 – Data Engineering

Experience: 5 Years

Working Hours: 9:00 AM EST to 3:00 PM or 5:00 PM EST, as required.

Job Summary

We are looking for an experienced Web Application Architect 2 – Data Engineering professional with strong expertise in database administration, AWS services, and data engineering. The ideal candidate will be responsible for managing PostgreSQL and SQL Server databases, developing and supporting data ingestion pipelines using Databricks, and ensuring reliable application and database operations.

Key Responsibilities

• Administer and support AWS RDS PostgreSQL and Amazon Aurora PostgreSQL databases.
• Perform SQL Server administration, database maintenance, user management, role management, and access control.
• Troubleshoot database performance issues, connectivity problems, and production incidents.
• Develop, maintain, and support data ingestion pipelines using Databricks notebooks, pipelines, and Unity Catalog.
• Contribute to application design, development, integration, delivery, maintenance, and production support.
• Work with AWS services, serverless computing, event-driven architectures, and microservices.
• Support CI/CD pipelines and Infrastructure as Code (IaC) practices.
• Follow DevSecOps practices and collaborate with distributed teams using Agile/Scrum methodologies.
• Identify root causes of production issues and implement effective solutions.

Required Skills

• Hands-on experience with Amazon Aurora PostgreSQL and AWS RDS administration.
• Good understanding of SQL Server administration.
• Experience with database user and role management, permissions, and security.
• Strong database troubleshooting and performance optimization skills.
• Working knowledge of Databricks Unity Catalog, notebooks, and pipelines.
• At least 3 years of software development experience on commercial applications.
• Knowledge of AWS, serverless and event-driven architectures, microservices, CI/CD, and Infrastructure as Code.
• Experience working in Agile/Scrum and DevSecOps environments.

Ideal Candidate

The ideal candidate should have practical experience in database administration and production troubleshooting, along with exposure to Databricks data pipelines and AWS cloud services. Strong problem-solving skills and the ability to work independently in a distributed team are essential.