高级数据库管理员
Senior Database Administrator
Netrio 是北美领先的 MSP，专注于为中小型企业提供 IT 解决方案。我们为跨行业的 1000 多家客户提供服务，包括托管 IT、网络安全、云、连接性、语音和定制应用开发。
高级数据库管理员直接负责客户的数据库完整性和安全性。确保数据库在最佳性能下运行，使客户在需要时能够获得最新信息，从而做出最准确的决策。当出现问题时与客户沟通是最高优先级，这样客户知道他们的数据可能未处于最佳状态。你与团队紧密合作的能力将帮助我们保持同步，并激励彼此持续改进。独立工作的能力将确保我们保持高质量的服务，同时让团队有时间进行培训和整体提升。
职责
向数据库主管经理汇报，你将：
提供卓越的客户服务
- 及时处理自动警报、故障、事件和客户请求
- 清晰高效地与客户沟通
- 记录并详细说明任务中执行的工作
作为 DBA 团队的个人贡献者
- 积极通过自动化改进服务，并寻找优化流程的方法
- 支持团队成员实现团队目标
- 持续提升对数据技术的知识
高级数据库工作
- 精通 SQL Server 内部结构
- 精通安装、配置、补丁和迁移 Microsoft SQL Server 实例
- 精通设计、实施、排查和修复 SQL Server 中所有可用的 HA/DR 架构，包括日志传送、复制、AlwaysOn 可用性组和故障转移群集
- 与客户举行头脑风暴会议，以审查、分析和评估业务系统和需求
- 精通数据库备份与恢复、数据库访问安全与完整性、物理数据存储设计和数据存储管理
- 精通数据库安全与审计
- 创建、修改和改进 SQL Server Agent 任务和维护计划
- 精通监控 SQL Server 维护任务，排查失败流程，并尽快解决这些问题
查看英文原文
Netrio is a leading MSP in North America, specializing in IT solutions for small- to mid-market enterprises. We serve over 1,000 clients across industries with services including managed IT, cybersecurity, cloud, connectivity, voice, and custom application development.
The Sr. Database Administrator is directly responsible for integrity and security of data for our clients. Ensuring databases are running at their peak performance allows our clients to have the most up to date information when they need it, where they need it, in order to make the most accurate decisions possible. Communicating with the client when there is an issue is the highest priority, so the client knows when their data might not be at it’s best. Your ability to work closely with the team will allow us to keep each other on the same page and to motivate each other to continue to improve. The ability to work without supervision will ensure we maintain our high-quality service to the clients while allowing the team their turn to train and improve the team as a whole.
RESPONSIBILITIES
Reporting to the Associate Director of Database, you will:
Deliver Excellent Customer Service
- Addressing automated alerts, failures, incidents and client requests as they come in
- Communicate clearly and efficiently to clients
- Document and detail the work, performed in tasks
Be an individual contributor in the DBA team
- Actively work to improve the service by automation and identifying ways to improve upon our processes
- Support your teammates in achieving team goals
- Consistently work to improve your knowledge of Data technologies
Advanced DB Work
- Expert understanding of SQL Server Internals
- Expert in Installing, Configuring, patching and migrating Microsoft SQL Server instances.
- Expertise in designing, implementing, troubleshooting and fixing all available HA/DR topologies in SQL Server including Log shipping, Replication, AlwaysOn availability groups and failover clustering
- Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs
- Expert in handling database backup and recovery, database access security and integrity, physical data storage design, and data storage administration.
- Expert in Database security and auditing.
- Create, change, and improve SQL Server Agent tasks and maintenance plans
- Expert in monitoring SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
- Hands-on experience writing and optimizing TSQL
- Expert in handling databases which participate in both replication and always on together.
- Expert in creating reports, monitoring, and alerts to better support our clients
- Expert in troubleshooting and resolving server, DB and query performance issues, application sluggishness
- Expert in understanding and fixing anti-best practices in DB design.
- Expert in handling VLDBs
- Expert in Database Partitioning, Data Compression
- Expert in implementing Resource Governor
- Expert in implementing, troubleshooting and fixing CDC
- Expert in implementing, troubleshooting and fixing Distributed Availability Groups
REQUIREMENTS
Applicants must possess:
- 8+ years of MS SQL Server experience
- Good to have PostgreSQL, MongoDB, Azure SQL DB, AWS RDS administration experience
- Extensive experience in designing, implementing, troubleshooting and fixing various HA/DR topologies with special focus on Transactional Replication and Alwayson Availability groups.
- Extensive experience in handling server, DB and query performance issues.
- Hands-on experience writing and optimizing TSQL
- Related formal database education or DBA certification
- Excellent written, verbal and interpersonal communication skills
- Strong analytical and problem-solving skills
- Strong understanding of database platforms in an enterprise infrastructure with the ability to utilize database administration tools
The strongest candidates will also have:
- Industry certifications (MCSA, MCSE, DP-300)
- Ability to meet stringent deadlines and handle multiple tasks
- Familiar with Change Management and ITIL processes
- Ability to provide timely and informative follow-up to end-users
- Ability to efficiently prioritize and organize competing work demands with little oversight
Originally posted on Himalayas