Senior Database Engineer

About the role

The Senior Database Engineer will partner with product and development teams to shape database strategy and execution. You will own the design and delivery of resilient database processes that align with business objectives and quality standards. This role requires collaboration across the organization to prioritize initiatives and drive implementation from conception to production. You will research emerging technologies to maintain a competitive edge in database architecture and performance. The position focuses on ensuring that database systems deliver world class availability, scalability, and security for our intelligence platform.

Key facts

What you'll do

• Partner with stakeholders to set priorities and translate business needs into robust database implementation plans.
• Architect and maintain database systems that meet strict standards for performance, availability, scalability, quality, and security.
• Produce high-quality work-products while championing quality standards, performance benchmarks, and scalability goals.
• Investigate and evaluate innovative technologies to stay ahead of industry trends and database advancements.
• Architect resilient and high-performing database processes, solutions, and integrations that support critical business functions.
• Author custom stored procedures, views, and user-defined functions to solve complex data challenges.
• Synchronize efforts with cross-functional teams to align database initiatives with organizational goals.
• Examine and refine SQL code to resolve issues and improve execution efficiency at scale.
• Augment Tier2 development teams with specialized database support for bug fixes, data manipulation, and feature validation.
• Optimize SQL code paths and troubleshoot performance bottlenecks across application integrations.
• Assume on-call responsibilities to address critical database alerts and coordinate escalations as required.

Requirements

• Bring a minimum of 7+ years of hands-on experience administering PostgreSQL databases in production environments.
• Demonstrate advanced administration and optimization skills specific to MariaDB platforms and workflows.
• Apply extensive knowledge of Pgpool-II to manage query load balancing, failover strategies, and connection routing between nodes.
• Execute hands-on experience with PostgreSQL replication setups, performance tuning activities, and ongoing maintenance operations.
• Create and sustain operational runbooks that standardize PostgreSQL replication, failover recovery, and pooler troubleshooting practices.
• Script database deployment and maintenance procedures using shell scripts and infrastructure automation tools to ensure consistency.
• Leverage deep performance tuning expertise alongside a broad understanding of indexing strategies, In-Memory OLTP technologies, and SQL best practices.
• Construct processes that support both OLTP and OLAP workloads across hybrid data environments.
• Enable and nurture data engineering practices that sustain a multi-source data ecosystem and integration patterns.
• Collaborate effectively with SQL developers to analyze problems and design pragmatic database solutions.
• Function within microservice architectures where each microservice may utilize distinct data sources and connection models.
• Utilize industry standard source control solutions such as Git, with demonstrated experience in DACPAC workflows where applicable.
• Exhibit an intrinsic self-starter mindset and advanced problem-solving capabilities under minimal supervision.
• Apply Agile methodologies and practices to plan, execute, and deliver database initiatives in iterative cycles.

Nice to have

• Architect and manage large scale database systems that operate at enterprise and Internet scale with high throughput demands.
• Design and build Distributed Database ecosystems that span multiple regions and data domains.
• Comprehend data analytics and reporting solution concepts to align database structures with analytical workloads.
• Administer SQL Server instances from 2012 and later versions with enterprise-grade reliability.
• Operate advanced PostgreSQL versions 9 and above with confidence in complex deployment scenarios.
• Administer NoSQL databases and evaluate tradeoffs between consistency, availability, and partition tolerance.
• Implement and administer Event Streaming Platforms such as Apache Kafka for real time data integration.
• Oversee sharded, multi-tenant database deployments that require isolation, security, and scalability controls.
• Apply Database Encryption Strategies including per-client encryption and Platform Independent Protocol encryption methods.
• Scale databases on Cloud platforms with a preference for Azure based implementations and services.
• Administer and tune Elasticsearch clusters for search and analytics workloads.
• Leverage data visualization and analytic tools such as Tableau to translate database metrics into actionable insights.

Practical notes

• This position operates in a remote-first model with no expectation of centralized office attendance.
• Employees may work from home, co-working spaces, or any location that supports reliable connectivity.
• On-call duty may require availability outside standard business hours to respond to critical database alerts.
• High-speed internet connectivity is essential, with a recommended minimum of 100 Mbps dedicated connection.
• The role may involve periodic in-person collaboration during team or company wide gatherings when feasible.
• Candidates must be legally authorized to work in the United States without sponsorship requirements.
• New hires should anticipate consistent engagement with evolving database technologies and continuous learning expectations.
• The position may involve direct interaction with enterprise clients through data products and insights delivery.
• Successful candidates will adhere to security policies and data governance standards in all database operations.
• Professional communication is required to coordinate effectively with distributed teams across time zones.