Senior SQL DBA

THE COMPANY:

Lanvera is a leading CCM (Customer Communications Management) outsourcing and technology company specializing in the design, production, and delivery of secure customer communications including invoices, statements, tax forms, collection letters, compliance notices and other business critical documents to any delivery channel including print, electronic and mobile platforms. Lanvera has a strong presence in the Financial Services industry and is expanding into other vertical markets.  

THE POSITION:

Seeking an experienced SQL DBA with expertise in T-SQL development, troubleshooting and optimization.  The Senior SQL DBA will manage Microsoft SQL Server databases, services, and tools running in an on-prem environment as well as participate in building a database presence in the cloud (hybrid solution).  In this role you will maintain database uptime, stability, performance, and security to ensure the highest customer service levels. You will also leverage your passion for data engineering to design, develop, and implement ETL solutions, involving close collaboration with development and business intelligence stakeholders.

RESPONSIBILITIES:

  • Review, analyze and debug T-SQL code
  • Optimize data workloads across cloud and/or on-prem environments to stay ahead of business demand while minimizing costs
  • Develop complex SQL scripts, functions and stored procedures
  • Participate in architecture planning to prepare the business for significant future growth
  • Manage production database servers to ensure robust security, high availability and performance
  • Actively monitor databases and take preventive or corrective action to swiftly resolve issues that arise
  • Support and enhance db’s running on Azure Managed SQL Instance(s)
  • Implement policies and procedures for database backups, DR, security protocols, and data integrity
  • Maintain lower-level development, QA, and staging environments to support efficient development throughout the SDLC
  • Create comprehensive diagrams and documentation that accurately captures database state
  • Support development groups with database setup, configuration, optimization, and other modifications
  • Develop a roadmap to establishing a new Data Warehouse model
  • Bring a passion to stay current on industry database trends and related technology
  • Adept at collaborating with leadership and technical stakeholders throughout the organization
  • Adhere closely to change control and related ITIL practices
  • Work in a highly collaborative software development environment that is primarily onsite

ADDITIONAL RESPONSIBILITIES:

  • Provide best practice guidance on the design of data models and database structures across relational database platforms
  • Assist in development, support, and implementation of data engineering projects such as data pipelines and warehouses
  • Assist in development of methods to manipulate large, complex data sets to be effectively consumed and interpreted within reporting toolsets

REQUIRED SKILLS:

  • Bachelor’s Degree in Computer Science or commensurate experience
  • 5+ years’ experience supporting SQL Server databases in production environments that utilize AlwaysOn Availability Groups and Windows Clustering
  • 5+ years’ experience in writing complex T-SQL to develop a variety of database objects (schemas, tables, stored procedures, triggers)
  • 4+ years’ experience in database tuning and query optimization through analysis of Execution Plans and Dynamic Management Views, and usage of Extended Events
  • 3+ years’ experience with developing packages within SQL Server Integration Services (SSIS)
  • 2+ years’ experience with developing reports within Power BI and/or SQL Server Reporting Services (SSRS)

DESIRED SKILLS:

  • Experience with Windows and Linux Server administration
  • Familiarity with automating processes using Powershell or similar scripting language

COMPANY BENEFITS:

Lanvera offers excellent benefits including three weeks of PTO, Health Insurance, 401K with dollar matching, profit sharing, and long-term disability.

Job Type: Full Time
Job Location: Coppell TX

Apply for this position

Allowed Type(s): .pdf, .doc, .docx