Vertican Technologies Inc. provides world class software services and solutions in support of ethical recoveries, helping to make operations more efficient, compliant, and profitable. For over 35 years our products and services have helped us build long lasting client relationships with top ranking businesses in our industry.

We are looking for a senior SQL developer who is an expert in TSQL development, data mapping, data quality, and data load to join our team of developers on various Extraction Transform Load (ETL) projects. Our ideal candidate for this position has outstanding SSIS, SSAS, MS SQL skills, and a passion for SQL development. We are an agile team, so you will be a key participant in creating dynamic SQL Server Integration Services (SSIS) packages to solve complex business problems. Our ideal candidate is flexible, adaptive, prefers simplicity over complexity, and is self-motivated.

Responsibilities for the SQL DBA include, but are not limited to:

  • The primary effort the database developer will focus on developing and updating SSIS packages, stored procedures, data warehouse load process, and analytics database.

  • Design logical and physical database structures using Microsoft SQL Server.

  • Design and develop SSIS.

  • Gather user requirements and functional specifications.

  • Provide user training and technical documentation, as needed.

  • Strong SQL Skills and ability to write advanced SQL statements, Stored Procedures and Triggers.

  • Development of high-quality database solutions.

  • Develop, implement, and optimize stored procedures and functions using T-SQL.

  • Analyze existing SQL queries for performance improvements.

  • Develop procedures and scripts for data migration.

  • Interact with development team, QA, and project managers.

  • Data mapping, transformation, and performing ETL based on complex logic.

Skills / Requirements:

  • Bachelor’s Degree (preferred in a Computer Science, Technology, Engineering, or Math field) and expert-level programming skills with 10 or more years work experience in SQL Server 2005, 2008 12/2017.

  • Strong experience in SQL Server 2005, 2008, 2012, and 2017.

  • Five years of Experience in Database Management doing Data Modeling.

  • Five years of Experience with MS SQL Server in the setting up and configuring Microsoft SQL Server in a virtual and clustering environment.

  • Five years of Experience in ETL.

  • Three to five years of Experience in SQL Server Backups, Restore Strategies, and Replication.

  • Three to five years of experience in designing and coding SSIS packages

  • Five to seven years of experience in SQL Server Performance Tuning and Query Optimization

  • Three to five years of dealing with high volume data.

  • Ten years of experience writing complex Stored Procedures, Functions, and views using SQL

  • Excellent organization and communication skills with the ability to work on multiple projects simultaneously and within expected time frames.

  • Excellent analytical, problem-solving and decision-making skills.

  • Excellent at interpreting and analyzing data.

  • Excellent interpersonal skills, the ability to work independently and/or as a member of a team.

  • Excellent oral and written communication skills.

  • Strong knowledge of DTS/SSIS, SSAS, SSRS, SSMS, Visual Studio Data Tool Distributed SQL Servers 2000/2005/2008/2012/2014/2016, and 2017.

  • Windows Server 2003/2008/2012 and 2016.

  • Visual Studio 2008 and 2015.

  • Sound understanding of relational and non-relational databases.

  • Experience using tools such as PowerBI to create reports.

  • Experience working in Azure cloud environment.

Qualifications Include:

  • Five years hands-on experience developing and managing high volume/large scale database structures for both highly transactional and BI purposes.

  • Five years demonstrated expertise in DB/ Data Warehouse architecture.

  • SSIS: Eight years or more.

  • SQL Development: five years or more.

  • Azure Development: three years or more.

  • Ability to solve problems creatively and effectively.

  • Strong analytical and problem-solving skills.

  • Strong communication skill and know how to play well in a team setting.

  • Latest tools and technologies to build high performing data warehouse.

  • Knowledge SCRUM Methodology.

Vertican Technologies offers:

  • Competitive health and wellness benefits including, PTO, 401k, health/dental insurance and much more

  • A top-notch team of dedicated professionals that works together to support multiple product lines

  • A receptive atmosphere for new ideas and methodologies

  • Fantastic facilities that includes an onsite gym, locker room and café

  • A culture that promotes work-life balance

  • A salary commensurate with experience

If you think Vertican Technologies’ SQL DBA role is for you, send your resume to humanresources@vertican.com.