database architect Farmers Branch, TX
Job description
About Fay:
The Fay Group, originated in 2008, is a full-scale real estate services company that offers mortgage servicing, property renovations, business purpose lending, insurance, and more to homeowners, investors, and clients nationwide. Fay handles a wide range of mortgage loan solutions for prospective homeowners with varying credit histories and also offers to refinance for existing mortgages.
The Fay Group is made up of separate business units offering a complete range of home ownership products and services that provide customers with solutions to navigate the challenges of home ownership while helping them build toward their long-term financial goals.
Fay Cares!
While others in our industry focus on collecting money—or else—we take a kinder, more humane approach when homeowners fall short," explains CEO Ed Fay. We consider the people behind those mortgages and work hard to give them the best chance possible to stay in their homes.
The Fay-Constructive Foundation was established to fulfill the philanthropic mission of Fay Financial employees to serve the communities in which they live and work. Over 80% of employees across Fay, Constructive, and GenStone affiliate companies make voluntary contributions to the Foundation. Each quarter, their contributions are donated to organizations focused on improving education opportunities, combating poverty, and supporting military service members and first responders.
Come join us on our journey to serve our customers and be the leader in our industry!
The Data Architect will leverage technology and business acumen to provide superior design/architecture, development, and production support for cloud-based database environments and analytical solutions. In addition, will drive and participate in efforts to ensure platform stability to maximize the performance of database environments. In this position, you will partner with application owners/teams to understand the application and business needs. Participate in architecture design to provide appropriate solutions and level of estimates for the execution of database solutions. You should have had strong implementation experience in workload migration and/or large-scale cloud-native database systems. You should also possess a deep understanding of technical aspects of software development; have strong organizational and communication skills in order to effectively collaborate with customers/partners, business analysts, other project team architects and work with developers & QA; take responsibility for designing and ensuring the validity of the architectural solutions.
What you will do for Fay:
- Understanding of database and analytical technologies in the industry including MPP databases, Data Warehouse design, BI reporting, Dashboard development, and NoSQL storage
- Knowledge of Full Stack development utilizing MS SQL Server interacting with Microsoft® Office® products and web applications
- Must have extensive working experience with Microsoft technologies
- Understanding of Message Broker technology like Rabbit MQ, Azure event BUS
- Application migration from legacy mode to services and microservices
- Experience with communicating with businesses to gather requirements and convert them into technical requirements
- Deep knowledge of Microsoft Azure Cloud and .NET architecture
- Deep knowledge of MS-SQL and/or NoSQL
- Deep knowledge of Data Security and confidentiality in the application by design and development practices
- Knowledge and experience with agile development
- Strong understanding of Application Lifecycle Management
- Lead RCA for Severity 1 tickets
- Understanding of Agile Scrum process
What you will bring to Fay:
- Bachelor's degree in business, computer science, or other technical field with 10+ years of applicable experience in a technology environment; High school diploma/GED required
- 8+ years Data Warehousing (Cloud Preferred), SQL Database and development, and programming views, stored procedures, and functions in SQL
- 6+ years of development and/or DBA experience in Relational Database Management Systems (RDBMS)
- Expert in traditional and cloud Data Warehousing
- 3+ years of proficiency with SQL in cloud-based data warehouses (Snowflake, AWS Data Warehousing, etc.)
- Experience in one or more major clouds providers, AWS, Azure, or have a strong working knowledge of Cloud Native and Cloud Computing technologies Fundamental experience with GIT and Python
- Good understanding of Azure Infrastructure services and their limitations
Experience in configuring & monitoring different attributes and handling scale-up and scale-down scenarios in Azure - Provide best practices around provisioning production and non-production environments on Azure to optimize the usage
- Strong expertise in building cloud-native enterprise-scale database systems and moving data environments from on-premises to cloud environments
Strong understanding of the cloud architecture patterns and solution design principle - Strong understanding of different attributes for cloud application availability, scalability, and ability to propose an optimized design for cloud
- Performance tuning of cloud-based data systems for best performance
- Collaborating with customers for quick technical assessment and proposal development for leveraging platform services of Azure
- Closely work with customers to understand the business objectives and define solutions to meet the business objectives
- Experienced in working in agile/DevOps environment with continuous integration and continuous deployment and application lifecycle management
- Level 3 escalation points for Severity 1 Ticket. Lead RCA for Severity 1 ticket
Diversity, Equity, and Inclusion are deeply embedded into our way of working at Fay. We believe that the best ideas come from having a team that is diverse in backgrounds, experiences, and perspectives. We strive to ensure each of our employees feels valued, respected, included, and is presented with equal opportunities to be successful here at Fay. We are proud to be an equal-opportunity workplace. The Fay Group and affiliated companies participate in E-Verify. For more information go to www.dhs.gov/E-Verify. E-Verify is a registered trademark of the U.S. Department of Homeland Security.
