中级 Microsoft SQL Server 数据库管理员
Mid-Level Microsoft SQL Server Database Administrator
职责
Peraton 正在寻找一位中级 Microsoft SQL Server 数据库管理员，要求具备实际生产环境数据库管理员经验，熟悉 AWS EC2 和 SQL Server 的 RDS。合格的人员将负责满足多个用户组的服务级别协议，涵盖性能、可用性、备份和安全性。
地点：远程
班次安排：美国东部时间（EST）上午 8 点至下午 5 点。该职位需要参与生产环境的 24x7 轮班值班。
你将负责：
- 安装各种配置的 Microsoft SQL Server 实例：
- 独立实例、Windows 故障转移集群和可用性组
- 云托管（AWS），包括 SQL Server RDS
- 开发、测试、部署和维护安全与审计解决方案
- 实施中心互联网安全（CIS）和 Safeguard 计算机安全评估矩阵（SCSEM）加固标准
- 审查 NESSUS 扫描以修复漏洞和数据库合规性问题
- 安排、监控和验证数据库备份和恢复
- 负责通过 Datadog 收集性能、可用性和容量规划的指标任务
- 安排并应用数据库升级、补丁和证书
- 遵循最佳实践、工作计划、检查清单和定义的流程
- 主动支持应用团队，按需提供帮助
- 参与项目技术评审。主导工作产品评审
- 编写和维护数据库支持文档
- 负责复杂数据库事件和问题，及时提供解决方案
- 在需要时与专家或供应商合作解决更复杂的事件
- 实施客户数据库变更请求
资格要求
必备资格：
- 必须是美国公民，能够获得并保持所需的公共信任级别许可
- 本科学位加 5 年经验，或专科学位加 7 年经验，或高中文凭或同等学历加 9 年经验
- 至少 5 年 Microsoft SQL Server DBA 经验，包括大量的生产支持经验
- 具备虚拟化 Microsoft SQL Server 2019/2022 和 Microsoft SQL Server 高可用性选项（复制 - 事务或日志传送以及 Always On）的经验
- 具备 SQL 维护计划、SQL Agent 作业和 Ola Hallengren 维护解决方案的经验
- 具备 MS Windows 经验
查看英文原文
Responsibilities
Peraton is looking to add a Mid-Level Microsoft SQL Server Database Administrator with hands-on experience as a production database administrator experienced in AWS EC2 and RDS for SQL Server. The qualified individual will be responsible for meeting service level agreements covering performance, availability, backups, and security for several user groups supporting those application.
Location: Remote
Shift Schedule: 8am – 5pm Eastern Standard Time (EST). This position will participate in 24x7 on-call rotations for the production environment.
What you will do:
- Install Microsoft SQL Server instances in various configurations:
- Standalone, Windows Failover Cluster, and Availability Groups
- Cloud hosting (AWS) including SQL Server RDS.
- Develop, test, deploy and maintain security and audit solutions.
- Implement Center for Internet Security (CIS) and Safeguard Computer Security Evaluation Matrix (SCSEM) hardening standards.
- Review NESSUS scans to remediate vulnerabilities and database compliance findings.
- Schedule, monitor, and validate database backups and restores.
- Responsible for monitoring metrics collection jobs for performance, availability, and capacity planning though through Datadog.
- Schedule and apply DB upgrades, patches, and certificates.
- Follow best practices, work plans, checklists, and defined processes.
- Proactively support application teams as needed.
- Participate in project technical reviews. Lead work product reviews.
- Develop and maintain database support documentation.
- Responsible of complex database incidents and problems, providing resolutions in a timely manner.
- Engage SMEs or vendors to resolve more complex incidents as required.
- Implement customer database change requests.
Qualifications
Required Qualifications:
- Must be a U.S. Citizen with the ability to obtain and maintain the required Public Trust level clearance.
- Bachelors Degree and 5 years of experience, an Associates Degree and 7 years of experience, or a High School Diploma or equivalent and 9 years of experience
- Minimum 5 years Microsoft SQL Server DBA experience including extensive production support required.
- Experienced in virtualizing Microsoft SQL Server 2019/2022 and Microsoft SQL Server High Availability options (replication - transactional or log shipping and Always On).
- Experience with SQL Maintenance Plans, SQL Agent jobs, and Ola Hallengren's Maintenance Solutions.
- Experience with MS Windows Security Domains, Networking, and Group Managed Service Accounts.
- Experienced in AWS cloud operations supporting databases on EC2 and RDS instances.
- Experience deploying and maintaining Cloud Native Databases leveraging Infrastructure as Code (Terraform) and CI/CD automation (GitLab and Liquibase)
Preferred qualifications:
- Excellent written and verbal communications skills.
- Ability to independently work remote and collaborate effectively with team members.
- Experience with transact/SQL language and programming experience/knowledge is a plus.
Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure.
Target Salary Range
$80,000 - $128,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.EEO
EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.Originally posted on Himalayas