SQL Server Database Administrator

QGenda

Location: Burlington, Vermont

Type: Full Time

Education: Bachelor's Degree

Experience: 3 - 5 Years

QGenda is a fast-growing Atlanta-based healthcare software company, with an amazing corporate culture, where we strive to be the best place to be a customer. Our software is used by thousands of hospital departments around the world to automatically generate the most optimized physician work schedules to accommodate complex business rules and accurately schedule the appropriate medical provider based on their skill level, specialty, availability, and preferences.

Role Overview:

As a SQL Server Database Administrator you will work closely with our Development and Site Reliability Teams to build new features, monitor and ensure performance, lead schema refactoring efforts, and assist in best practices for database design.

 

Responsibilities:

  • Ensure Database Health, Uptime, and Performance
    • Utilize consistent and robust monitoring tools to ensure high availability
    • Conduct performance baselines and continually audit for schema improvements
    • Troubleshoot any performance anomalies and respond to high priority issues
  • Assist in Development Operations
    • Participate in code reviews to ensure new features utilize a robust and scalable schema
    • Train and advise the development team on best practices, indexes, query plans, etc
    • Take an active role in continuous performance tuning initiatives
  • Spearhead and Own Database Projects
    • Review and recommend processes around backup/restore, table compression, partitioning, ERD, automation, etc
    • Establish reporting, BI, and data warehousing capabilities of the databases
  • Assure High Security
    • Establish best practices for database auditing
    • Ensure sensitive information is properly categorized, stored, and transferred
    • Review and install the latest security patches

 

Skills and Qualifications:

  • 3-5+ years of experience with Microsoft SQL Server, with a combination of administration and development
  • Knowledge of best practices in database design and performance optimization of SQL Server databases, query plans, T-SQL, profiler, and monitoring tools
  • Experience with database mirroring, backup strategies, and disaster recovery approaches
  • Bachelor’s degree from an accredited college or university in computing, engineering, or related field or equivalent industry experience
  • Understanding of Agile development processes
  • Understanding of ORM concepts and applying database object changes through code migrations
  • Strong critical thinking and problem-solving skills
  • Excellent communication skills and upbeat personality

 

Preferred Qualifications:

  • Experience with cloud-based SaaS solutions, especially utilizing AWS technologies

 

© 2022 Vermont Technology Alliance

Site by Scout Digital