Database Engineer II

Database Engineer II

AvidXchange is seeking a Database Engineer II to build build best-in-class database solutions that provide the needed backend capabilities to our products. You will analyze, design, develop, test, maintain and implement database solutions within AvidXchange's suite of applications. You will work inside a cross functional scrum team to deliver solutions that use the latest technology including cloud-based solutions.

What you'll do:

• Develop database objects and structures for data storage, retrieval and reporting according to project specifications
• Write database procedures, functions, and triggers
• Perform data research, analysis, conceptual and logical data modeling
• Implement and test database design and functionality and have an understanding query tuning
• Review deploy requests and facilitate the deployment DB Scripts in the test and other lower environments
• Assist in determining optimal database solutions for architecture, efficiency, maintainability, and scalability
• Assist with preparing release and rollback scripts
• Responsible for upkeep of the Data Dictionary as changes are introduced to the data model
• Help with mentoring junior Database Engineers
• Ensure changes follow AvidXchange Security Policies
• Work with Senior Database Engineer to analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Assist with on-call support for critical production systems

What we're looking for:

• Bachelor's degree required in CS, Engineering, or related field
• 5+ years of developing for MS SQL Server or another enterprise RDBMS or performing Database Engineering dutiesor Master's degree in a CS, Engineering, or related field and 3+ years of experience performing Database Engineering duties
• Using Advanced SQL Server including stored procedures, indexes, and functions
• Experience with physical and logical database design
• Experience with SQL Server security management
• Experience with SQL Server data integrity
• Azure Data Factory Experience
• Experience in implementing Source Control Best Practices
• Experience with web-based financial systems
• Practicing Agile software development processes (Scrum/Kanban)

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 who works here, they'll tell you our people are at the core of who we are. We focus on creating a culture of Diversity, Inclusion & Belonging, and are proud to be a safe place where teammates can bring their whole selves to work.At AvidXchange,mindset is everything. We are Connected as People, Growth Minded, and Customer Obsessed. Thesethree mindsets represent our culture - who weare, who we've always been, and they guide usto improve every day.Since our founding in 2000 in Charlotte, NC, we've created a company of over 1,600 teammates working in one of our 5 offices across the U.S., or remotely. AvidXchange is proud to be Certified™ as aGreat 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®.

Who you are:

• A go-getter with an entrepreneurial mindset - that meansyou arenot afraid of taking risks,winning bigorfacing the unknown.
• Someone who understands that business ispeople centric. Connecting with others as humans first allows you to develop mutually beneficial working relationships.
• Focused onmaking a difference for our customers. AvidXchange exists to help solve complex problems for our customers so we can all realize our potential.

What you'll get:

AvidXchange teammates (we call them AvidXers) get the perks and prestige of a publicly traded tech company paired with the flexibility of a founder-led startup. We help our AvidXers develop as professionals and as human beings, providing work/life balance, development programs, competitive benefits and equity options.At AvidXchange, we are building more than a tech company - we are 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.

AvidXers enjoy:

• 18 days PTO*
• 11 Holidays (8companyrecognized & 3floatingholidays)
• 16 hours per year ofpaid Volunteer Time Off (VTO)
• Competitive Healthcare
• High Deductible Heath Plan Option that has $0 monthly premium for teammate-only coverage
• 100% AvidXchange paid Dental Base Plan Coverage
• 100% AvidXchange paid Life Insurance
• 100% AvidXchange paid Long-Term Disability
• 100% AvidXchange paid Short-Term Disability
• Employee Assistance Program (EAP) - Providescounseling services, legal and financial consultations and health advocacy for Teammates and their eligible dependents
• Onsite Health Clinic with AtriumHealth**- available to Teammates and their eligible dependents
• Retirement 401k Matchup to 4%
• Parental Leave:8 weeks 100% paid by AvidXchange***
• Discounts on Pet, Home, and Auto insurance
• BrightDimeFinancialWellnessTool, offeredfree toteammates
• WeeCareChildcare Service:helps teammates find affordable daycare,childcare,andtutors 40%less expensivethan traditional daycarecenters
• Perks at Work:free discount program that provides teammates the opportunity to save on items fromelectronics, movie tickets, car buying, vacations,andmore
• Onsite gym fitness center, yoga studio, and basketball court****
• Tuition Reimbursement up tothe federal maximum of$5,250*****
• Hybrid Workplace Flexibility
• Free parking

*Fully granted from beginning of year, pro-rated if hired mid-year

**Charlotte location only

***Must be full-time for at least 3 months

****Charlotte location only

*****Must be full-time for at least one year

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