What are the responsibilities and job description for the Senior SQL Developer position at Van Metre Companies?
At Van Metre, we believe that each employee contributes directly to our growth, success and culture. We seek out candidates who love to challenge themselves and work with others to fulfill this role. Van Metre Companies is seeking a Senior SQL Developer to work in our New Homes Division!
This is a fully remote opportunity
Position Summary :
The Senior SQL Developer will design relational databases and data warehouses on Microsoft SQL server and Microsoft Azure SQL databases; develop ETLs to update the data warehouse; and write T-SQL queries and stored procedures to perform data analysis and to support reporting.
This role will involve collaborating with developers in the Business Intelligence team to provide the best practice suggestions for application development and the data system upgrade. This role will also take DBA responsibilities to create user accounts, to grant permissions, and to implement database security policies.
Responsibilities :
- Leading the design, development, and optimization of complex SQL database designs, SQL queries, and SQL stored procedures to meet business requirements.
- Proactively identifying and addressing database performance issues, and data quality concerns to ensure scalability and responsiveness.
- Designing and executing data migration projects by using SSIS and Azure Data Factory to ensure seamless transitions and minimal downtime.
- Implementing robust security protocols and compliance measures to protect sensitive data and ensure regulatory adherence
- Investigating and resolving data quality issues and query problems for the data warehouse and the internally developed applications.
- Providing technical leadership on database projects to guide the team in best practices and innovative solutions
- Collaborating with cross-functional teams to align database solutions with organizational goals and the latest new technologies.
- Maintaining comprehensive documentation of database architectures, processes, and best practices.
- Monitoring the logs and notification messages of the data warehouse ETL processes. Resolving the ETL issues effectively and in a timely manner.
Required skills & experience :
Compensation and Benefits information : Van Metre offers excellent benefits, and a work environment that fosters and rewards excellence. We also promote work / life balance, including a robust Employee Wellness Program. We encourage employees to make full use of vacation and other company-paid leave to refresh their bodies and minds.
Van Metre Core Values
Integrity; Ownership; Respect and Dignity; Diversity and Inclusion; Teamwork; Community; Work / Life Balance
Van Metre Mission Statement
The mission of Van Metre Companies is to build and continually improve upon the storied reputation, earned over the years since the Company's founding in 1955, of providing top quality homes, investment properties and services to our customers and clients. The Company's emphasis on integrity, professionalism and philanthropy ingrained by our founder Albert G. Van Metre, Sr. has garnered trust and respect in the Washington, D.C. area and beyond. It is critical to our future that we maintain that reputation and assure that Van Metre Companies continues to excel in real estate development and construction and in the management of apartment, retail and office investment properties, as well as in the provision of mortgage and related services. It is the task of our dedicated, energetic, and involved professionals to advance our ability to set the benchmark for luxury living and refined commercial development. The capstone of our mission is to make the "Van Metre" signature an icon for elegant residential communities, and industry leading condominium and apartment communities, as well as Class A neighborhood retail centers and office developments.
Salary : $120,000
