Logo
Let AllegiantVETS

Senior Database Architect and Developer

Let AllegiantVETS, Orange, California, United States, 92613


Job DescriptionPosition Overview:

We are seeking an experienced and proven Senior Database Architect and Developer with at least 10 years of experience in designing and developing enterprise-level database solutions. The ideal candidate will be skilled in data modeling, architecting database access and security, and creating high-availability databases that meet the performance and volume demands of the enterprise. This role requires a hands-on approach to forming best practices, implementing design patterns, and delivering innovative database solutions.

Key Responsibilities:•Design and model enterprise-level databases, ensuring scalability, high availability, and performance optimization.•Architect and implement database access control and security practices to safeguard enterprise data.•Develop and maintain database objects such as tables, views, stored procedures, and indexes to meet application and reporting needs.•Address data availability needs, ensuring databases meet both functional and non-functional requirements.•Define entity relationship models that accurately represent business processes and system requirements.•Establish and enforce best database practices and design patterns to promote consistency and efficiency.•Participate in designing, developing, and optimizing database solutions across various projects.•Collaborate with cross-functional teams to ensure database solutions align with overall project and business goals.•Mentor and assist other team members with complex database issues and troubleshooting.•Ensure Agile Scrum methodologies are followed during database development cycles.

Requirements

Required Qualifications:•Minimum of 10 years of experience in database architecture and development.•Strong expertise in SQL Server, with experience in designing, implementing, and optimizing enterprise databases.•Extensive experience in data modeling, including conceptual, logical, and physical data models.•Proven track record of architecting high-availability databases to support large-scale enterprise systems.•Strong understanding of database security best practices and access control mechanisms.•Experience with Agile Scrum methodologies.

Preferred Qualifications:•Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.•Experience with cloud-based database services (e.g., Azure SQL, AWS RDS).•Familiarity with performance tuning and optimization techniques for high-transactional databases.

Soft Skills:•Excellent problem-solving and analytical skills.•Strong leadership and mentoring abilities.•Effective communication skills, with the ability to collaborate with both technical and non-technical stakeholders.

Benefits

This role is critical in shaping the database architecture and strategy for our enterprise solutions, ensuring data integrity, security, and performance. The Senior Database Architect and Developer will play a pivotal role in driving innovation and excellence across our database projects.