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 an accomplished SQL Database Administrator (DBA) with demonstrated experience in SQL Server and Production Operations. The primary role of the DBA is to monitor, maintain, and update SQL Clusters within a 24/7 production environment. The DBA will diagnose database-related application problems, perform root cause analysis and recommend corrective action in coordination with other Engineering DBAs and Application Developers. The candidate will also provide SQL support for other non-production environments as required.

Key responsibilities for the SQL DBA:

  • Optimize production system and identify bottlenecks, ensuring high levels of data availability.

  • To liaise with Developers and Engineers and provide SQL Server database expertise when needed.

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

  • Monitors business critical production SQL Server clusters during peak hours and respond to incidents to ensure high levels of availability.

  • Performs SQL Server 2008 R2 – 2016 cluster and standalone installation and configuration in accordance with documented standards.

  • Collects detailed SQL Servers performance metrics and makes tuning recommendations.

  • Investigates root cause for database related application errors (SQL timeouts, deadlocks, unexpected data condition, etc.), provides document explaining root cause and recommends fixes (including recommending changes to application stored procedures) to avoid future recurrences.

  • Coordinates the database portion of the disaster recovery plan and participates in the planning, testing. and implementation of recovery procedures.

  • Manages SSRS data warehouse and provides guidance and assistance to reports developers working to meet business reporting requirements.

  • Monitors and optimizes schedules for SQL Server Agent based maintenance jobs (backups, statistics maintenance, index maintenance, etc.)

  • Coordinates with Senior DBA staff and engineers to provide input for capacity planning.

  • Coordinates with Senior DBA staff to establish and document standards for database administration relevant to the RUN application.

  • Provides aid and guidance to application developers with database schema and stored procedure optimization according to company conventions and best practices.

  • Provides SQL Server DBA support for non-production SQL Server environments.

For the SQL DBA position you must have:

  • Solid understanding of relational database concepts and best practices

  • Intermediate level knowledge of 2008-2016 Database Administration

  • SQL Server Reporting Services (SSRS)

  • SQL Server Integration Services

  • SQL Clustering

  • SQL Profiler

  • Experience with scripted database maintenance

  • Experience troubleshooting stored procedure performance (executions plans, IO statistic)

  • Experience troubleshooting deadlocks

  • Excellent knowledge of T-SQL, Stored Procedures, Functions, Triggers, and Linked Servers

  • Exposure to enterprise-level database systems with distributed data architectures

  • Excellent knowledge of database monitoring, SQL Server internals, and root cause analysis

  • Outstanding oral communication and writing skills

  • Strong analytical and business process skills

  • Ability to effectively prioritize and execute tasks under pressure to meet tight deadlines

  • Ability to work unsociable hours as needed

  • Experience working in a team-oriented collaborative environment

  • Highly self-motivated and directed

  • Keen attention to detail

 

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.