Wilen Group Coldwell Banker Burnet - Deerfield Beach, FL

posted 3 months ago

Full-time - Mid Level
Deerfield Beach, FL
Professional, Scientific, and Technical Services

About the position

Wilen is driven by industry-leading agency services and cutting-edge direct mail production. We provide strategic direct marketing solutions for national brands, leveraging innovative variable data technology, to turn concepts into finished digital and physical products, all in one seamless process. The successful candidate will be responsible for the development and sustainment of SQL Server, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of software developers, data analysts, and other stakeholders. This position requires a hands-on approach, solid technical skills, and excellent interpersonal and communication skills. The candidate must be capable of working independently as well as collaboratively with various teams.

Responsibilities

  • Design and develop database structures, including schemas, tables, indexes, views, and stored procedures to support application development and business requirements.
  • Optimize database performance through indexing, query optimization, and other performance tuning techniques.
  • Implement and maintain data integrity and security policies, including backups, disaster recovery, and access controls.
  • Work with software developers to integrate databases with applications, ensuring data consistency and reliability.
  • Perform regular database maintenance tasks such as backups, indexing, and defragmentation to ensure optimal performance.
  • Diagnose and resolve database-related issues and provide technical support to development and data analysis teams.
  • Create and maintain reports and dashboards using tools like SQL Server Reporting Services (SSRS) or Power BI.
  • Document database designs, configurations, policies, and procedures to ensure comprehensive records for future reference.
  • Refine and automate regular processes, track issues, and document changes.
  • Develop and document database standards.
  • Provide 24x7 support for critical production systems.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Minimum 6 years experience with MSSQL with 2 years of MSSQL 2016 or newer.
  • Proven experience as a MSSQL Database Developer or similar role.
  • Experience with database design, data modeling, and normalization.
  • Experience with ETL process design and implementation.
  • Knowledge of database performance tuning and optimization techniques, using native monitoring and troubleshooting tools.
  • Familiarity with version control systems like Git.
  • Strong analytical and problem-solving skills.
  • Excellent communication and teamwork abilities.
  • Attention to detail and a commitment to data accuracy and integrity.

Nice-to-haves

  • Familiarity with data warehousing and BI tools is a plus.
  • Experience with C# is a plus.
  • Experience with scripting languages like Python, Perl, or Bash is a plus.
  • Knowledge of Azure cloud-based database services is a plus.

Benefits

  • 401(k)
  • Dental insurance
  • Health insurance
  • Paid time off
  • Vision insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service