SQL Server Administrator/Engineer

Type: Full-Time, Exempt

Location: Greensboro, NC

JOB SUMMARY

The SQL Server Administrator/Engineer will be responsible for the development and sustainment of the SQL Server environment and reporting/analytics platforms, ensuring their operational readiness (security, health, and performance), and providing leadership and support of this environment for developers and other consumers. Must be able to work independently and collaboratively and think forward to future growth and initiatives.

PRIMARY RESPONSIBILITIES

Manage SQL Server instances through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, security, and recovery.

Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.

Assist developers with complex query tuning and schema refinement.

Refine and automate regular processes, track issues, and document changes.

Lead architecture, development, and support of reporting and BI/Analytics platforms.

Perform scheduled maintenance, support release deployment activities and critical production systems, after normal work hours if necessary.

Test Disaster Recovery strategies / solutions to ensure RPOs can be met.

ACCOUNTABILITIES

Take ownership of the performance of database interactions from application code.

Take ownership of support, process improvement, application standards and best practices for the Pay Tel data environment.

Take ownership of documentation, design strategies, and implementation plans in relation to role.

Continue to stay abreast of recent technologies within the industry and evaluate the applicability of those technologies within the company’s environment.

Participate in a quarterly on-call rotation schedule.

EDUCATION AND EXPERIENCE

Minimum Level of Education, Degrees Required or Preferred

Bachelor's degree in computer science, Information Technology, or related field, or the equivalent through a combination of education and work experience.

Relevant Work Experience Required

Min. 5 years’ experience with relational database systems (SQL Server required). Experience with Non-relational/NoSQL environments a plus.

Experience with Analytics, Reporting, and Integration platforms such as SSRS, Tableau, Power BI, SSIS (or other ETL).

Experience with High Availability and Disaster Recovery options for SQL Server (required), Data warehousing is a plus.

Experience working within a virtualized environment (vCenter a plus).

Experience with cloud platforms such as Azure and AWS Integration a plus.

ERP platform support experience is a plus (Microsoft Dynamics especially).

MINIMUM SKILLS, ABILITIES, LICENSES, CERTIFICATIONS

• Excellent SQL Server Administration skills: Backup/restore, index maintenance, partitioning and other archival strategies.

• Excellent SQL Server skills; proven ability working with T-SQL, stored procedures, and scripts.

• Excellent skills in constructing proficient queries and designing tables and databases.

• Exposure to ADO. Net / .NET in context of the data environment a plus, particularly EF and MARS

• Exposure to NO-SQL databases such as Mongo DB, Couchbase, Rabbit MQ (plus)

• Exposure to and/or familiarity with data warehousing (plus)

• Effective oral, written, and interpersonal communication skills

• Strong time management, organizational, prioritization, and planning skills

• Exceptional learning agility

WORKING CONDITIONS AND PHYSICAL REQUIREMENTS

Effort / Physical Requirements

Ability to sit for extended periods of time, continuous use of fingers, hands, and arms.

Working Conditions

Typical office/cubicle environment, onsite requirement for maintenance windows (estimated 2-4 times annually)