数据仓库

$4-8k

全球远程5-10年本科1 年前发布

kimi.chen

CTH Group · HR

职位详情

远程办公5-10年本科

Job Responsibilities 工作职责： Collaboration & Integration 协作与集成： Work closely with developers and global IT teams to design SQL Server database architecture and integrate it with new and existing applications, ensuring efficient system operation. 与开发人员和全球IT团队紧密合作，设计SQL Server数据库架构，并将其与新应用程序和现有应用程序集成，确保系统高效运行。 Performance Monitoring & Optimization 性能监控与优化： Monitor and optimize SQL Server database performance through regular tuning and troubleshooting to ensure efficient data retrieval and storage. 通过定期调优和故障排除，监控和优化SQL Server数据库性能，确保高效的数据检索和存储。 Capacity Planning 容量规划： Analyze SQL Server database usage and growth trends, plan for future capacity needs, and recommend and implement necessary hardware and software upgrades to support business growth. 分析SQL Server数据库的使用和增长趋势，规划未来的容量需求。建议并实施必要的硬件和软件升级，以支持业务增长。 Cloud Database Management 云数据库管理： Manage SQL Server databases on the AWS cloud platform, including deployment, configuration, monitoring, and optimization of cloud database instances (such as Amazon RDS for SQL Server). 在AWS云平台上管理SQL Server数据库，包括部署、配置、监控和优化云数据库实例（如Amazon RDS for SQL Server）。 Automation Management 自动化管理： Develop and maintain automation scripts and tools (such as AWS CLI, CloudFormation, etc.) to streamline daily SQL Server database management tasks, improving efficiency. 开发和维护自动化脚本和工具（如AWS CLI、CloudFormation等），以简化SQL Server数据库的日常管理任务，提高工作效率。 Data Security 数据安全： Implement and enforce data security policies and procedures to ensure sensitive information in SQL Server databases is fully protected, including security groups, IAM policies, and encryption configurations in AWS environments. 实施和执行数据安全政策和程序，确保SQL Server数据库中的敏感信息得到充分保护，包括在AWS环境中的安全组、IAM策略和加密配置。 Troubleshooting 故障排除： Troubleshoot and resolve SQL Server database-related technical issues during integration processes to ensure system stability. 在集成过程中，及时排查和解决SQL Server数据库相关的技术问题，确保系统稳定运行。 Disaster Recovery Plan 灾难恢复计划： Develop and maintain disaster recovery plans for SQL Server database systems. Regularly test and update recovery procedures to minimize downtime in the event of system failures, particularly for cross-region backup and recovery strategies in AWS environments. 为SQL Server数据库系统开发和维护灾难恢复计划。定期测试和更新灾难恢复程序，以确保在系统故障时尽可能减少停机时间，特别是在AWS环境下的跨区域备份和恢复策略。

任职要求

Job Requirements 任职要求： Technical Skills 技术技能： Proficient in Microsoft SQL Server database management, including performance tuning, backup and recovery, and security management. 精通Microsoft SQL Server数据库管理，包括性能调优、备份与恢复、安全管理等。 Familiar with AWS cloud platform, with practical experience in using Amazon RDS for SQL Server or other AWS database services. 熟悉AWS云平台，具有Amazon RDS for SQL Server或其他AWS数据库服务的实际使用经验。 Knowledge of AWS core services (such as EC2, S3, IAM, CloudWatch, etc.) is preferred. 熟悉AWS核心服务（如EC2、S3、IAM、CloudWatch等）者优先。 Experience with other database management systems like MySQL or PostgreSQL is a plus. 具备MySQL或PostgreSQL等其他数据库管理经验者优先。 Certification 证书要求： ITIL certification is a plus. 具备ITIL证书者优先。 AWS certifications (such as AWS Certified Solutions Architect, AWS Certified Database - Specialty) are a plus. 具备AWS相关认证（如AWS Certified Solutions Architect、AWS Certified Database - Specialty）者优先。 Work Experience 工作经验： At least 5 years of experience in SQL Server database management, with a preference for experience in financial or payment industries. 至少5年SQL Server数据库管理经验，有金融或支付行业数据库管理经验者优先。 Practical experience in managing databases on AWS cloud platform. 具有在AWS云平台上管理数据库的实际经验。 Language Skills 语言能力： Proficient in English for oral communication with North American technical teams. 英语能够与北美技术团队进行口语交流。 Working Hours 时差要求： Must be able to accommodate working with North American teams, including support and collaboration during non-standard working hours (such as nights or early mornings). 必须能够接受与北美团队合作的时差安排，包括在非标准工作时间（如夜间或凌晨）进行必要的支持与协作。 Contract Duration 合同期限： 3-6 months, with duration depending on project needs. 合同期为3-6个月，具体时长根据项目需求确定。 Additional Preferred Skills 加分项： Experience in developing automation scripts (such as PowerShell, Python, AWS CLI, etc.). 有自动化脚本开发经验（如PowerShell、Python、AWS CLI等）。 Familiarity with high-availability solutions (such as SQL Server AlwaysOn, failover clusters, etc.). 熟悉高可用性解决方案（如SQL Server AlwaysOn、故障转移集群等）。 Experience with database monitoring tools (such as SQL Server Profiler, Performance Monitor, AWS CloudWatch, etc.). 具备数据库监控工具（如SQL Server Profiler、Performance Monitor、AWS CloudWatch等）的使用经验。 Familiarity with AWS Database Migration Service (DMS) and backup/recovery tools (such as AWS Backup). 熟悉AWS数据库迁移服务（DMS）和备份恢复工具（如AWS Backup）。