Database Engineer

Get to Know Us It s fun to work in a company where people truly believe in what they re doing At BlackLine we re committed to bringing passion and customer focus to the business of enterprise applications Since being founded in 2001 BlackLine has become a leading provider of cloud software that automates and controls the entire financial close process Our vision is to modernize the finance and accounting function to enable greater operational effectiveness and agility and we are committed to delivering innovative solutions and services to empower accounting and finance leaders around the world to achieve Modern Finance Being a best-in-class SaaS Company we understand that bringing in new ideas and innovative technology is mission critical At BlackLine we are always working with new cutting edge technology that encourages our teams to learn something new and expand their creativity and technical skillset that will accelerate their careers Work Play and Grow at BlackLine Make Your Mark As a Database Engineer at BlackLine you will play a vital role in the performance delivery stability and security of the databases we use while continually driving forward improvements and optimizations at the database layer As a member of the database team you will be involved in the planning development and maintenance of the database including troubleshooting issues collaborating with other teams to define and build new features optimize existing features and collaborate in order to drive growth improve controls and processes and reduce overhead and complexity In this role we are looking for people who are team players passionate about their areas of expertise and constantly striving to learn and improve not just in the sense of their own skills but also in growing with peers whom they work with day-to-day If you are someone who strives for excellence in all that they do including helping those in your team and someone who wants to ultimately deliver the best value and success you can then we want to talk to you You ll Get To Participate in cross-functional teams and build relationships across the organization Build high-performance massively scalable always-available Cloud-based systems Ensure data integrity and quality in database systems Maintain standard policies for database development activities Provide database solutions based on technical documents and business requirements Provide technical assistance to resolve all database issues related to performance capacity and access Analyze issues holistically from the application tier through the database down to the storage Database Engineer will ensure that all deadlines are met and that quality is of the highest level throughout the Software Development Life Cycle What You ll Bring BS or MS degree in Computer Science Engineering or equivalent experience 3 years of experience with Microsoft SQL Server 1 years working in high-transaction environments is required Advanced working knowledge of different index types and how they are used columnstore full-text filtered indexes with include columns Advanced Execution Plan understanding Experience with performance tuning and optimization using native monitoring and troubleshooting tools and techniques including complex queries as well as procedure and indexing strategies Excellent written and verbal communication Adaptable team-player with a focus on results and value delivery Able to organize and plan work independently Lead various technology POCs Advance understanding of OLTP vs OLAP environments Working knowledge of relational database internals locking consistency serialization recovery paths Were Even More Excited If You Have SSIS SSRS experience is a strong plus NoSQL is a plus Azure GCP or AWS are a plus MCTS MCITP and or MVP certifications are a plus PowerShell experience is a plus Working knowledge of XML and BAT files is a plus Thrive at BlackLine Because You Are Joining A technology-based company with a sense of adventure and a vision for the future Every door at BlackLine is open Just bring your brains your problem-solving skills and be part of a winning team at the world s most trusted name in Finance Automation A culture that is kind open and accepting It s a place where people can embrace what makes them unique and the mix of cultural backgrounds and varying interests cultivates diverse thought and perspectives A culture where BlackLiner s continued growth and learning is empowered BlackLine offers a wide variety of professional development seminars and inclusive affinity groups to celebrate and support our diversity BlackLine is an equal opportunity employer All qualified applicants will receive consideration for employment without regard to sex gender identity or expression race ethnicity age religious creed national origin physical or mental disability ancestry color marital status sexual orientation military or veteran status status as a victim of domestic violence sexual assault or stalking medical condition genetic information or any other protected class or category recognized by applicable equal employment opportunity or other similar laws BlackLine recognizes that the ways we work and the workplace itself has shifted We innovate in a workplace that optimizes a combination of virtual and in-person interactions to maximize collaboration and nurture our culture Candidates who live within a reasonable commute to one of our offices will work in the office at least 2 days a week