Senior Engineer, Enterprise Database

_________________________________________________________________________________

Applied Medical is a new generation medical device company with a proven business model and commitment to innovation fueled by rapid business growth and expansion. Our company has been developing and manufacturing advanced surgical technologies for over 35 years and has earned a strong reputation for excellence in the healthcare field.  Our unique business model, combined with our dedication to delivering the highest quality products, enables team members to contribute in a larger capacity than is possible in typical positions.

Position Description

A Senior Engineer, Enterprise Database, is responsible for designing, implementing, and maintaining high-performance, secure, and scalable database systems. They optimize database performance, ensure data security and compliance, manage disaster recovery and high-availability solutions, and support data integration and migration processes. Collaborating with cross-functional teams, they lead database-related initiatives, mentor junior engineers, and maintain comprehensive documentation. With a focus on innovation, they stay current with emerging technologies, troubleshoot complex issues, align database solutions with organizational goals, and communicate effectively with stakeholders.

Key Responsibilities

• Design, implement, and maintain secure, high-performance databases.
• Ensure scalability, reliability, and alignment with organizational goals.
• Monitor and optimize database performance.
• Identify and resolve performance bottlenecks using advanced tuning techniques.
• Implement database security measures, including encryption.
• Ensure compliance with industry and organizational security standards.
• Manage backups and recovery strategies to ensure business continuity.
• Implement high-availability solutions like clustering and replication.
• Handle ETL processes to integrate data from various sources.
• Perform seamless data migrations across platforms and environments.
• Diagnose and resolve database-related issues promptly.
• Provide support for critical production environments.
• Document database configurations, processes, and standards.
• Generate reports on database health, performance, and capacity planning.
• Mentor and guide junior team members.
• Collaborate with cross-functional teams to support database-related initiatives.
• Utilize scripting, monitoring tools, and performance tuning utilities effectively.
• Stay updated on emerging technologies to enhance database solutions.
• Work closely with stakeholders to ensure database systems meet business requirements.

Success in This Role Looks Like

• Delivers highly available, secure, and resilient database platforms across SQL Server, Azure SQL, and PostgreSQL environments.
• Maintains enterprise database systems that consistently meet performance, availability, and recovery objectives.
• Leads database upgrades, migrations, and modernization initiatives with minimal business disruption.
• Automates operational processes to improve efficiency, scalability, and reliability.
• Serves as a trusted technical expert and mentor for database technologies and best practices.
• Collaborates across teams to ensure data platforms effectively support business and application needs.
• Drives continuous improvement through proactive monitoring, performance tuning, and operational excellence.

Position Requirements

This Position Requires the Following Skills and Attributes

• Expert ability to architect, implement, and support highly available, resilient, and secure enterprise database platforms, including High Availability (HA) and Disaster Recovery (DR) solutions.
• Strong proficiency in administering and troubleshooting Linux-based environments in support of enterprise database infrastructure.
• Extensive experience managing multiple relational database management systems (RDBMS), including Microsoft SQL Server, Azure SQL, PostgreSQL, and IBM Db2 in complex enterprise environments.
• Advanced expertise in Microsoft SQL Server and Azure SQL technologies, encompassing administration, performance optimization, security, HA/DR, and cloud migration initiatives.
• Deep understanding of enterprise applications, distributed systems, web-based architectures, and database services supporting mission-critical workloads.
• Expert knowledge of relational database design, data modeling, normalization, and enterprise data architecture best practices.
• Proven experience creating and maintaining logical and physical data models using Entity Relationship (ER) modeling tools and methodologies.
• Hands-on experience implementing and supporting SQL Server clustering, replication technologies, log shipping, and Always On Availability Groups.
• Strong understanding of database security principles, including encryption at rest and in transit, access controls, auditing, compliance, and security hardening.
• Advanced experience diagnosing and resolving database performance issues through query tuning, indexing strategies, workload analysis, and system optimization.
• Proficiency with enterprise database monitoring, observability, alerting, and performance management tools.
• Experience designing and implementing ETL/ELT processes, data integration pipelines, and large-scale data migration solutions.
• Strong scripting and automation skills using PowerShell, Python, Bash, Perl, or similar languages to improve operational efficiency and platform reliability.
• Expert proficiency in SQL development, including complex queries, stored procedures, functions, triggers, views, performance tuning, and data analysis operations involving ranking, aggregation, filtering, sorting, and joins.

PostgreSQL Expertise

• Extensive experience administering PostgreSQL 15/16 across Development, Test, UAT, and Production environments, including installation, configuration, upgrades, patching, security, health monitoring, and production support.
• Proven experience designing, implementing, and supporting PostgreSQL high-availability and disaster recovery architectures, including replication, failover, backup, recovery, and business continuity planning.
• Strong expertise in managing PostgreSQL migrations using tools such as pg_dump, pg_restore, pg_basebackup, and logical replication, including schema validation, data reconciliation, connectivity testing, and post-migration verification.
• Advanced proficiency in PostgreSQL performance tuning and optimization using pg_stat_activity, pg_stat_statements, EXPLAIN/EXPLAIN ANALYZE, indexing strategies, VACUUM, ANALYZE, and REINDEX.
• Demonstrated ability to troubleshoot and resolve query performance issues, locking and blocking contention, deadlocks, resource bottlenecks, replication latency, and database availability challenges.
• Experience implementing PostgreSQL security controls, role-based access management, auditing, encryption, and compliance best practices.
• Familiarity with PostgreSQL automation, monitoring, and observability solutions such as pgAdmin, Elastic, Prometheus, ELK/OpenSearch, and cloud-native monitoring platforms.

Preferred

The Following Skills and Attributes Are Preferred

• Experience designing, deploying, and supporting database solutions in cloud platforms such as Microsoft Azure, AWS, or Google Cloud Platform (GCP).
• Experience with Infrastructure as Code (IaC) and configuration management tools such as Terraform, Ansible, Chef, or Puppet.
• Knowledge of containerization and orchestration technologies, including Docker and Kubernetes, in support of modern database deployments.
• Experience implementing and supporting PostgreSQL replication technologies, including logical replication, streaming replication, Patroni, or similar HA frameworks.
• Familiarity with DevOps and CI/CD practices for database deployments, schema migrations, and release automation.
• Experience administering managed database services such as Azure Database for PostgreSQL, Azure SQL Managed Instance, Amazon RDS, or Cloud SQL.
• Knowledge of database observability and monitoring platforms such as Grafana, Prometheus, Elastic, Dynatrace, AppDynamics, or Azure Monitor.
• Experience supporting large-scale database modernization, migration, consolidation, or cloud transformation initiatives.
• Knowledge of database governance, data retention, auditing, compliance, and regulatory requirements such as SOX, PCI-DSS, HIPAA, or GDPR.
• Experience mentoring junior database engineers and providing technical leadership on enterprise database initiatives.
• Strong written and verbal communication skills with the ability to translate technical concepts to business and leadership stakeholders.
• Relevant industry certifications such as Microsoft Azure Database Administrator Associate, Azure Solutions Architect, PostgreSQL Associate/Professional, AWS Database Specialty, or related certifications.
• Experience supporting enterprise applications such as SAP, ServiceNow, PeopleSoft, Salesforce, or other mission-critical business systems.
• Familiarity with OpenSearch/Elasticsearch and integration of database operational metrics into enterprise monitoring platforms.

Benefits

• Competitive compensation range: $107000 - $150000 / year (California).
• Comprehensive benefits package.
• Training and mentorship opportunities.
• On-campus wellness activities.
• Education reimbursement program.
• 401(k) program with discretionary employer match.
• Generous vacation accrual and paid holiday schedule.

Please note that the compensation range may be adjusted in the future, and bonus and incentive compensation plans may apply.

Our total reward package reflects our commitment to employee growth and well-being, as we invest in your development and offer a range of benefits designed to enhance your career and life.

All compensation and benefits are subject to plan documents and written agreements.

Equal Opportunity Employer

Applied Medical is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (including pregnancy, childbirth, breastfeeding and related medical conditions), or sexual orientation, or any other status protected by federal, state or local laws in the locations where Applied Medical operates.