About AvidXchange AvidXchange is a leading provider of accounts payable ("AP") automation software and payment solutions for middle market businesses and their suppliers. By trade, we are a technology company, but if you ask anyone that works here, they'll tell you our people are at the core of who we are. We are all entrepreneurs who love to innovate and win with a passion for serving our customers. While we take personal ownership of our everyday work, we recognize that we only win as a team. Since our founding in 2000 in Charlotte, NC, we've created a company of over 1,600 teammates working in one of our 7 offices across the U.S., or remotely. We're building more than a tech company - we're building an experience. We remain committed to a culture where you can fully be 'you' - connected with others, chasing big goals and making a meaningful impact. If you want to help us grow while realizing your potential and creating stories you'll tell for years, you've come to the right place. AvidXchange is proud to be Certified as a Great Place to Work. The prestigious recognition is based on anonymous data from our teammates and makes official what our teammates have known for years - that AvidXchange is a Great Place to Work. JOB OVERVIEW As a Senior Database Engineer, you will have the chance to become an integral member of the software development team, building best-in-class advancements to our products. You will analyze, design, develop, test, maintain and implement database solutions within AvidXchange's suite of applications. You'll assist with the onboarding and mentoring of Database Engineers which will include, explaining company domain knowledge, sharing standard methodologies, and performing code reviews. Working with other disciplines, such as software, product, architecture, dev/ops, and performance, you will design the best product solutions. You'll also grow your interpersonal skills in an open, engaging, and collaborative environment. You will use your expertise to provide technical leadership for a development team. JOB RESPONSIBILITIES * Performing full life cycle SQL/NoSql code and model development, including researching technical options for features, providing guidance and feedback on the findings and building proof of concepts to confirm the best approach. * Create solutions utilizing the best data storage technology for the use case (i.e. RDBMS, NoSql, Data Lake, etc.) * Work with performance engineers to monitor system health and performance, to ensure high levels of performance and availability. * Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations * Refine and automate processes, track issues, and document changes * Assist developers with complex query tuning, schema refinement, and determining differences between releases/environments. * Provide on-call support for critical production systems and support scheduled maintenance and release deployment activities. * Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. * Accountable for the state of the Data Dictionary definition as changes are introduced to the data model * Performs database code/script/package reviews. Ensuring code follows documented standards and best practices. * Participate in the definition and implementation of database-related goals, objectives, policies, and priorities; Recommend and implement resulting policies and procedures. * Work cross-functionally and provide positive influence and leadership across assigned teams REQUIRED EXPERIENCE, QUALIFICATIONS, and SKILLS * Bachelor's degree in a CS, Engineering, or related field * 7+ years of developing for MS SQL Server or performing Database Engineering duties * Experience with relational databases reaching over 10TB * Heavy performance tuning experience * Experience with non-traditional methods of performance tuning * Mentorship abilities required PREFERRED EXPERIENCE, QUALIFICATIONS, and SKILLS * Strong understanding of SQL Server Db utilities, backup, and recovery * Strong knowledge of physical database design * Ability to perform both DB and OS performance tuning and monitoring * Strong knowledge of SQL Server security, resource management, data integrity, performance tuning and its tools * Experience with .NET is a major plus as communication with Software Engineers will be enhanced * Sound communication skills with management, development teams, vendors and systems administrators * Experience with implementing solutions utilizing Azure Cosmos DB or other NoSql database solution * Ability to utilize Azure technologies such as Azure Data Factory, Logic Apps, Event Grid to move data * Catalogs data definitions, business value, and other pertinent metadata for future consumption * Experience utilizing Azure Integration Services based technologies to respond to enterprise data needs * Extremely detail oriented with documentation Equal Employment Opportunity AvidXchange is an equal opportunity employer. AvidXchange is committed to equal employment opportunity in accordance with applicable federal, state, and local laws. AvidXchange will not discriminate against applicants for employment on any legally recognized basis. This includes, but is not limited to veteran status, race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age and physical or mental disability. Other details * Job Family Software Engineering * Job Function External Database Engineering * Pay Type Salary * Employment Indicator Professional Apply Now