Senior Database Engineer - BlackLine
Pleasanton, CA 94588
About the Job
The FedRamp team plays a critical role in advancing our organization’s mission to deliver secure, compliant, and highly reliable cloud solutions. This team is at the forefront of ensuring our systems meet the stringent requirements of the FedRamp program, supporting both our internal needs and those of our customers.
As part of this team, members will have the unique opportunity to design, deploy, build, and support our FedRamp-compliant cloud environment. They’ll be instrumental in shaping the future of our infrastructure by applying cutting-edge patterns such as Site Reliability Engineering (SRE), DevOps, and DevSecOps to streamline deployments and enhance overall efficiency.
By embracing these modern approaches, the FedRamp team will not only deliver robust and secure systems but also drive innovation and set a new standard for operational excellence across our cloud platform.
The Senior Database Engineer plays a vital role in the performance, delivery, stability, scalability and security of the databases we use, while continually driving forward improvements and optimizations at the database layer.
As a member of the Fedramp database engineering team, you will be involved in the planning, development, and maintenance of the database, including troubleshooting issues, security and access controls, and 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::- Manage SQL Server Databases through multiple product lifecycle environments, including development, research, and mission-critical production systems
- Configure and maintain database servers and processes, including monitoring, system health, and performance in order to ensure high performance, availability, and security
- Independently, or in conjunction with peers as beneficial, analyze, solve, and correct issues in real-time, proving end-to-end problem-solving
- Assist and support development staff with tuning complex queries, generally supporting the delivery of high-quality value and features to BlackLine's customers
- Refine, automate, and advocate for automation, standardized processes, issue tracking, and change management
- Implement, optimize, and regularly test backup and recovery plans for databases, including Disaster Recovery
- Proactively identify issues, bottlenecks, gaps, or other areas of concern or opportunity and work to either directly affect change, or advocate for that change by working with peers and leadership to build consensus and take action
- Perform critical scheduled maintenance, deployment, and release support activities
- Participate in various POC's
- Participate in the creation of various KPI's that help development team optimize queries
- Provide off-hours support for critical production systems
- Minimum of 5+ years MS SQL Server Administration experience required
- 4+ more years implementing operational automation via scripting (i.e., PowerShell) is required
- Advanced working knowledge of T-SQL is required
- Strong experience working with and maintaining backup and recovery strategies
- 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
- SSIS/SSRS experience is a strong plus
- SQL Server 2016/2017 is a plus
- NoSQL is a plus
- MCTS, MCITP, and/or MVP certifications are a plus
- Experience implementing operational automation using scripts (PowerShell)
- High Transaction Replication
- Experience with in-memory column-oriented DBMS
- Experience with NoSQL databases
- Exposure to reporting databases or services such as SSAS/SSRS
- 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.
Salary Range::USD $145,000.00 - USD $193,000.00