Senior Engineer, Enterprise Database

Applied Medical•Rancho Santa Margarita, CA

20h

About The Position

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. 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.

Requirements

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.
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.

Nice To Haves

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.

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.