SQL Database Administrator I (2nd Shift)

US-NY-East Syracuse
6600 Weighlock Drive
Job Type
Full-Time
13057
# of Openings Remaining
1
Travel
0%

Position Summary

Aspen Dental Management, Inc. (ADMI) is the nation’s premier dental services organization. We provide expert business and administrative support to the fastest growing, branded network of dental practices in the country. We recognize that our success is a direct result of empowering and supporting ambitious dental professionals; together we build and develop successful, patient focused dental practices. Our continued growth has created an opportunity to join our Information Technology team as a Database Administrator I (onsite or remote off-hour support - 4pm to 12 midnight).    

Responsibilities

  • Work within a team environment to ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO). Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
  • Troubleshoot SQL Server performance and outages as they occur during but not limited to off-hour (4pm to 12 midnight).
  • Configure SQL Server monitoring utilities to minimize false alarms.
  • Configure new SQL Servers to match the enterprise standard configuration.
  • Deploy/Rollback database change scripts during scheduled MTP (Move to Production).
  • When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes.
  • Test and implement of cutting-edge feature
  • Upgrade/migrate SQL servers to newer versions
  • Manage and troubleshoot replication (SQDR) both to and from the AS400/DB2 environment
  • Control access permissions and privileges to various stakeholders/departments
  • Work closely with DBA team, IT project managers and application developers for issue resolution and performance tuning
  • Communicate regularly with technical, applications and operational staff to ensure database integrity and security
  • Develop database documentation, including standards and emergency procedures
  • Work during off hour (4:00pm to 12 midnight). Onsite/Offsite.

Minimum Education and Experience

Technical and Product Knowledge:

  • Has good understanding of product or of supporting database technology
  • Embraces new technology and is able to learn at a steady pace

 

Versatility of Work:

  • Knows fundamental concepts, practices, and procedures
  • Work is fairly routine; instructions are usually detailed
  • Follows the process Performs work that is varied and more challenging in nature
  • Some evaluation, originality, or ingenuity is required
  • Has increased latitude to make decisions that might not always be reviewed

 

Independence Level:

  • Works under immediate supervision and performs assigned tasks
  • Provides frequent status to manager or lead
  • Needs direction, knows when to ask questions or escalate, takes initiative to tackle tasks relevant to skill level
  • Capable of and responsive to change

 

Process Improvement:

  • Recognizes inefficiencies and makes suggestions for process improvement

 

Troubleshooting:

  • Able to initiate
  • Knows when to seek advice
  • Takes initiative within skill level

 

DBA Job Specific Knowledge:

  • Good understanding of SQL or T-SQL
  • Understands architecture of current RDBMS
  • Good understanding of security best practices
  • Proficient at creating views, stored procedures, functions and table structures.
  • Has command of business process and procedure in writing code.
  • Some understanding of or experience programming languages

 

Teamwork:

  • Fosters teamwork by demonstrating trust, confidence, and commitment in others actions and decisions to create a supportive work environment
  • Helpful to the rest of the team or others in getting work done

 

Communication:

  • Good communication with peers within the department
  • Comfortable having conversations with others
  • Contributes ideas, feedback and suggestions within team
  • Able to communicate effectively with others outside the department

 

Judgment/ Decision Making:

  • Makes some independent decisions
  • May be looked upon to contribute to decision making process
  • Expected to make decisions quicker

 

 

About Aspen Dental Management, Inc.

 

Aspen Dental-branded practices are supported by ADMI, a dental support organization that provides non-clinical business support to licensed, independent dentists.

 

 

Join Us

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed