70 applicants

Company

Van Metre Companies · 5 hours ago

Senior SQL Developer

United States

Full-time

Remote

Mid, Senior Level

$120K/yr - $120K/yr

Maximize your interview chances

Real Estate

Growth Opportunities

Insider Connection @Van Metre Companies

Discover valuable connections within the company who might provide insights and potential referrals.
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.

Microsoft T-SQLRelational data modelingETL developmentDatabase project managementSSISAzure Data FactoryODBC connectionsData comparison toolsAdaptability to trends

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.