数据库管理员
Database Administrator
关于职位
我们正在寻找一位经验丰富的数据库管理员，为涉及MySQL和Microsoft SQL Server的客户项目评估并稳定数据库操作。该职位从对现有系统的清晰审视开始——访问模型、备份状态、监控覆盖范围和运营责任，并迅速进入修复脆弱部分和记录未明确的部分。
理想的候选人曾在真实压力下管理过生产数据库，了解备份存在与可恢复备份之间的区别，并能将混乱的现状转化为优先级明确、可执行的计划。
你将负责
评估当前状态
· 审查数据库管理实践、访问模型和运营责任
· 评估监控覆盖范围、备份状态和常规维护
· 识别性能问题以及需要优先稳定的事项
· 将发现转化为客户可执行的清晰、优先级明确的视图
实施与修复
· 找出存储过程、函数、触发器和视图中的问题原因：错误结果、错误数据写入、NULL处理错误、隐式数据类型转换、缺少ORDER BY和不完整的事务或错误处理。
· 在更改生产环境之前，在还原的副本上重现问题。
· 做最小的改动来解决问题，并说明该改动还会影响什么。
· 添加一个测试来证明修复，并在问题再次出现时捕获它。
· 区分数据库代码问题、数据问题和应用程序问题，并将非数据库问题发送给正确的团队。
· 在两个平台上实施已达成一致的运营卫生习惯
· 推荐并应用性能调优，优化成本最高的查询，修复死锁，添加缺失的索引并改进等待情况。
· 验证备份并测试恢复——确认它们有效，不要假设
· 改进监控和警报，使问题在用户报告前就显现
· 处理并解决出现的事件
· 记录现有内容、变更内容以及如何运行
你将带来的能力
· 具有MySQL和Microsoft SQL Server的生产DBA经验
· 具有与遗留数据库合作的经验，以及编写和调试存储过程的强项
· 备份与恢复：设计、验证和实际恢复测试
· 查询与索引调优、执行计划分析、等待统计
· 在任一平台上设置监控和警报
· 对数据库感到舒适
查看英文原文
About the Role
We're looking for an experienced Database Administrator to assess and stabilize database operations for a client engagement spanning MySQL and Microsoft SQL Server. This role starts with a clear-eyed look at what'sactually in place — access models, backup posture, monitoring coverage, and operational ownership — and moves quickly into fixing what's fragile and documenting what's not.
The ideal candidate has run production databases under real pressure, knows the difference between a backup that exists and one that's been proven to restore, and can turn a messy current state into a prioritized, actionable plan.
What you'll do
Assess the current state
· Review database management practices, access model, and operational ownership
· Evaluate monitoring coverage, backup posture, and routine maintenance
· Identify performance concerns and the issues that need stabilizing first
· Turn the findings into a clear, prioritized picture the client can act on
Implement & Fix
· Find the cause of problems in stored procedures, functions, triggers, and views: wrong results, bad data written, NULL handling errors, implicit data type
conversion, missing ORDER BY, and incomplete transaction or error handling.
· Reproduce the problem on a restored copy before changing production.
· Make the smallest change that fixes it, and say what else the change affects.
· Add a test that proves the fix and catches it if it comes back.
· Tell the difference between a database code problem, a data problem, and an application problem, and send the ones that are not database problems to the
right team.
· Put agreed operational hygiene practices in place across both platforms
· Recommend and apply performance tuning, optimizing queries that cost the most, fixing deadlocks, adding missing indexes and improving waits.
· Verify backups and test recovery — confirm they work, don't assume it
· Improve monitoring and alerting so problems surface before users report them
· Triage and resolve incidents as they come up
· Document what exists, what changed, and how to run it
What you'll bring
· Solid production DBA experience with both MySQL and Microsoft SQL Server
· Experience working with legacy databases and strong experience coding and debugging store procedures.
· Backup and recovery: design, validation, and real restore testing
· Query and index tuning, execution plan analysis, wait statistics
· Monitoring and alerting setup on either platform
· Comfort with database security and access models — roles, least privilege, auditing
· Clear written documentation. Runbooks that someone else can follow
· The ability to work inside a client's constraints and escalate rather than improvise when scope is unclear
About Nimble Gravity
Nimble Gravity is a team of outdoor enthusiasts, adrenaline seekers, and experienced growth hackers. We love solving hard problems and believe the right data can transform and propel growth for any organization.
Nimble Gravity is an Equal Opportunity Employer and considers applicants for employment without regard to race, color, religion, sex, orientation, national origin, age, disability, genetics or any other basis forbidden under federal, state, or local law. Nimble Gravity considers all qualified applicants.
Originally posted on Himalayas