Van Metre Companies · 3 hours ago
Senior SQL Developer
Maximize your interview chances
Real Estate
Growth Opportunities
Insider Connection @Van Metre Companies
Get 3x more responses when you reach out via email instead of LinkedIn.
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
An advanced Microsoft T-SQL programming, including complex query optimization and database management skills.
In-depth knowledge of the relational data modeling techniques, including normalization and denormalization, for efficient database designs.
A proven track record of successful database project management from inception to completion.
Skills to effectively communicate with technical and nontechnical stakeholders, translating technical concepts into actionable tasks.
Problem-solving and decision-making abilities, especially in high-pressure situations.
Ability to stay up-to-date with the latest trends and technologies in the database and data warehouse field and adapt to the evolving industry standards.
Design and Program ETLs with SSIS, SQL stored procedures and Azure Data Factory.
DBA skills to create user accounts, to grant permissions, and to implement database security policies.
Have skills to create ODBC connections on users’ computer.
Have knowledge and skills of using data comparison tools, such as Red-Gate SQL Data Compare, and Microsoft Visual Studio.
Benefits
Paid Time Off: 11 paid holidays; 10 vacation days, 10 sick days, Two Volunteer Days off, Two Personal Days, Winter Break, Day off for Annual Physical, Day off for your Birthday; comprehensive parental and bonding leave
Retirement Planning: Company Matched 401(k) Retirement Savings Plan; access to retirement planning coaches
Wellness: Annual Wellness Reimbursement of up to $900; Free and unlimited access to TaskHuman Wellness App for yourself and your family members.
Company
Van Metre Companies
Van Metre Companies is a real estate company providing real estate development services in Northern Virginia.