Senior Database Engineer II, New York

Senior Database Engineer

We are seeking a Senior Database Engineer to join our dynamic team of 100+ software engineers, designers, project managers, and specialists passionate about building innovative, high‑quality solutions. In this role, you will drive the design, development, and optimization of database systems that support mission‑critical, high‑transaction applications across modern cloud environments and microservice‑based architectures.Responsibilities

Develop state‑of‑the‑art database solutions to meet stringent performance, scalability, and integrity requirements of high‑transaction systems. Design database schema based on data modeling of business requirements and entities. Write and maintain stored procedures, functions, views, triggers, constraints, and other database objects.Create deployment and rollback scripts for all database objects, both manually and auto‑generated. Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries. Troubleshoot performance problems and propose short‑term fixes and long‑term solutions.Work with architects and guide developers in the future evolution of the data layer, researching options and developing prototypes before introduction into the tech stack. Stay current with evolving databases, AWS, microservices, and cloud‑native technologies; prototype new tools/features for adoption.Requirements

B.S. in Computer Science (or related field) with 5+ years of related experience, or an M.S. Degree with 3+ years of experience. 5+ years of hands‑on SQL Server development experience. Expert knowledge of all aspects of SQL Server, including triggers, stored procedures, user‑defined functions, concurrency, transactions, and locking.Excellent data modeling and schema design skills, including normalization and denormalization. Thorough understanding of best practices for database maintenance, index and file management, backups, failure recovery, database defragmentation, and documentation. Ability to analyze disk space requirements, hardware utilization, and automate error notification.Basic SQL Server administrative skills: backups, restores, snapshots, and user/role security. Experience operating SQL Server in AWS: Amazon RDS for SQL Server, RDS Custom, or SQL Server on EC2. Familiarity with AWS microservices architecture and designing databases to support microservice‑based applications in AWS.Experience optimizing data access from microservices, minimizing cross‑service latency, and designing efficient APIs. Knowledge of containerization (Docker) and orchestration (Kubernetes, AWS ECS/EKS) in a microservices context. Work Environment

The position is Remote First. Candidates must have a reliable broadband connection (minimum 10Mbps download and 5Mbps upload) and be prepared to participate in video‑based interviews and virtual meetings with camera on. Remote employees receive reimbursement to cover the cost of setting up a home or remote office.Equal Opportunity Employer

We are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, age, religion, sex, gender identity or expression, sexual orientation, national origin, protected veteran status, disability, or genetic information. We will provide reasonable accommodations for qualified individuals with disabilities.

#J-18808-Ljbffr