高级数据库工程师
Sr. Database Engineer
经验：5+ 年
工作地点：远程
职位数量：多个
学历要求：本科/硕士（计算机科学、信息技术、MCA 或更高）
工作时间：印度标准时间 下午1:30 至晚上10:30
职能领域：数据库开发
我们正在寻找一位经验丰富的高级数据库工程师加入我们的团队。理想的候选人应具备 MySQL、SQL Server 和 PostgreSQL 的深厚专业知识，有设计可扩展数据库架构、开发高性能查询以及确保数据库安全、可靠和可用性的成功经验。
关键职责
- 根据业务和技术需求设计和维护数据库模式。
- 开发和优化存储过程、SQL 查询和脚本以提升应用程序性能。
- 设计、构建和维护结构化和半结构化数据的端到端数据管道。
- 反向工程 SSIS 包以分析和改进数据流和转换。
- 领导数据迁移项目，包括从 SSIS/Informatica 迁移到云原生数据管道框架。
- 使用 Databricks 进行数据处理、转换，并与关系型数据库和数据湖集成。
- 使用标准数据模型（如 OMOP、PCORnet）构建合规且高效的解决方案。
- 管理 SQL Server 数据库，确保高可用性、安全性和性能。
- 使用 DBaaS 解决方案（Azure、AWS）进行可扩展的数据库管理。
- 实施和管理备份、恢复和灾难恢复策略。
- 监控和排查数据库和管道性能，主动解决瓶颈问题。
- 执行 DBA 任务，包括配置、补丁和迁移。
- 与开发、运维、分析和数据工程团队协作以满足项目截止日期。
- 自动化应用程序报告的创建、发布和调度。
- 技能、知识和经验
- 5+ 年数据库设计、开发和管理的专业经验。
- 精通 SQL Server 和 PostgreSQL，了解 MySQL。
- 高级 SQL 脚本编写和查询优化技能。
- 具有数据管道的经验，包括设计、编排和监控。
- 熟练使用 SSIS（SQL Server Integration Services）。
- 有使用 Azure Data Factory 构建和管理 ETL/ELT 工作流的经验。
- 有使用 Databricks 进行大规模数据处理和转换的经验。
- 有 No
查看英文原文
Experience: 5+ Years
Job Location: Remote
No. of Positions: Multiple
Qualifications: BE/B Tech,ME/MTech, MCA or Higher
Work Timings: 1:30 PM IST to 10:30 PM IST
Functional Area: DatabaseDevelopment
We are seeking a seasoned Sr. Database Engineer with 5+ years of experience to join our team. The ideal candidate will have deep expertise in MySQL, SQL Server, and PostgreSQL, with a proven track record in designing scalable database architectures, developing high-performance queries, and ensuring optimal database security, reliability, and availability.
Key Responsibilities
- Design and maintain database schemas based on business and technical requirements.
- Develop and optimize stored procedures, SQL queries, and scripts to enhance application performance.
- Design, build, and maintain end-to-end data pipelines for structured and semi-structured data.
- Reverse-engineer SSIS packages to analyze and improve data flows and transformations.
- Lead data migration projects, including transitions from SSIS/Informatica to cloud-native data pipeline frameworks.
- Utilize Databricks for data processing, transformation, and integration with relational databases and data lakes.
- Work with standard data models (e.g., OMOP, PCORnet) to build compliant and efficient solutions.
- Administer SQL Server databases, ensuring high availability, security, and performance.
- Utilize DBaaS solutions (Azure, AWS) for scalable database management.
- Implement and manage backup, restore, and disaster recovery strategies.
- Monitor and troubleshoot database and pipeline performance, resolving bottlenecks proactively.
- Perform DBA tasks including configuration, patching, and migrations.
- Collaborate with development, operations, analytics, and data engineering teams to meet project deadlines.
- Automate the creation, publishing, and scheduling of application reports.
Skills, Knowledge, and Experience
- 5+ years of professional experience in database design, development, and administration.
- Strong expertise in SQL Server and PostgreSQL, with working knowledge of MySQL.
- Advanced SQL scripting and query optimization skills.
- Hands-on experience with data pipelines, including design, orchestration, and monitoring.
- Proficiency in SSIS (SQL Server Integration Services).
- Experience with Azure Data Factory for building and managing ETL/ELT workflows.
- Working experience with Databricks for large-scale data processing and transformation.
- Experience with NoSQL databases (e.g., MongoDB) is a plus.
- Understanding of Data Lake / Lakehouse architectures is an advantage.
- Familiarity with healthcare data standards is a plus.
- Strong problem-solving and analytical skills with high attention to detail.
- Experience working with international clients (USA/Europe) preferred.
- Strong interpersonal, organizational, and communication skills to work effectively in cross-functional, virtual teams.
- Excellent written and verbal communication skills.
Originally posted on Himalayas