数据库管理员（DBA）
Database Administrator (DBA)
关于公司：
OptionMetrics总部位于纽约州纽约市，是一家充满活力和创新的技术公司，是来自期权市场的金融信息和研究的可信提供商。我们处于开发赋能企业解决方案的最前沿。我们对卓越的承诺，加上协作、前瞻性的文化，使我们成为顶尖人才的首选。我们的数据和分析模型被全球350多家投资银行、对冲基金、资产管理公司和学术机构使用，巩固了我们在行业中的领先地位。
OptionMetrics正在寻找一位技能娴熟、经验丰富的数据库管理员，具备管理MSSQL和PostgreSQL数据库的扎实背景。理想的候选人应具备开发和优化SQL查询的能力，设计复杂的存储过程，并确保PostgreSQL的高效安装、配置和故障排除。此外，熟悉Amazon AWS服务并熟练使用Git/GitHub是加分项。成功的DBA候选人将在维护数据库的稳定性、安全性和性能方面发挥关键作用。
此职位可在全美远程办公，或采用混合模式，在我们的纽约市或佛罗里达州迈阿密办公室工作。
您将负责：
- 管理和维护MSSQL和PostgreSQL数据库，确保其稳定性、可用性和性能。
- 开发和优化SQL查询，以高效地检索和操作数据，提升系统性能和响应时间。
- 设计和维护复杂的存储过程、触发器和视图，以满足业务需求，确保数据的一致性和完整性。
- 安装、配置和监控PostgreSQL数据库，及时处理出现的任何问题或错误。
- 实施和维护数据库安全措施，包括用户访问控制、认证机制和数据加密。
- 制定和执行备份与恢复策略，降低数据丢失的风险，确保业务连续性。
- 利用Amazon AWS服务，如EC2和RDS，进行数据库部署、监控和扩展，以满足业务需求。
- 与跨职能团队，包括开发人员和系统管理员，协作排查和快速解决数据库相关问题。
- 使用Git/GitHub进行版本控制和协作开发，确保代码管理得当和团队协调顺畅。
·
查看英文原文
About Us:
OptionMetrics, headquartered in New York, NY. is a dynamic and innovative technology company, a trusted provider of financial information and research derived from the option markets. We are at the forefront of developing solutions that empower businesses. Our commitment to excellence, coupled with a collaborative, forward-thinking culture, has made us the preferred choice for top-tier talent. Our data and analytics models are utilized by over 350 investment banks, hedge funds, asset management firms, and academic institutions globally, solidifying our position as a leader in the industry.
OptionMetrics are seeking a highly skilled and experienced Database Administrator with a strong background in managing MSSQL and PostgreSQL databases. The ideal candidate will have expertise in developing and optimizing SQL queries, designing complex stored procedures, and ensuring the efficient installation, configuration, and troubleshooting of PostgreSQL. Additionally, knowledge and experience with Amazon AWS services and proficiency with Git/GitHub are desired. The successful DBA candidate will play a critical role in maintaining the stability, security, and performance of our databases.
This position is able to be remote in the United States or hybrid, working out of our NYC or Miami, Florida office.
What You'll Do:
- Manage and administer MSSQL and PostgreSQL databases, ensuring their stability, availability, and performance.
- Develop and optimize SQL queries to retrieve and manipulate data efficiently, improving system performance and response times.
- Design and maintain complex stored procedures, triggers, and views to meet business requirements, ensuring data consistency and integrity.
- Install, configure, and monitor PostgreSQL databases, addressing any issues or errors that arise.
- Implement and maintain database security measures, including user access controls, authentication mechanisms, and data encryption.
- Develop and execute backup and recovery strategies, minimizing the risk of data loss and ensuring business continuity.
- Utilize Amazon AWS services, such as EC2 and RDS, for database deployments, monitoring, and scaling to meet business demands.
- Collaborate with cross-functional teams, including developers and system administrators, to troubleshoot and resolve database-related issues promptly.
- Utilize Git/GitHub for version control and collaborative development, ensuring proper code management and team coordination.
- Assist in data warehouse design and implementation, including ETL processes and reporting requirements.
- Stay updated with the latest advancements and best practices in MSSQL, PostgreSQL, Amazon AWS, and related technologies.
Skills You'll Need:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Administrator, with a focus on MSSQL and PostgreSQL databases.
- Strong proficiency in SQL query optimization and performance tuning.
- Expertise in designing and maintaining complex stored procedures, triggers, and views.
- Experience in the installation, configuration, and troubleshooting of PostgreSQL databases.
- Understanding and practical experience with Amazon AWS services, such as EC2, RDS, and S3.
- Familiarity with Git/GitHub for version control and collaborative development.
- Knowledge of database security principles and best practices.
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Ability to work effectively in cross-functional teams and collaborate with stakeholders.
What Will Make You Stand Out:
· Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or PostgreSQL Certified Professional
OptionMetrics is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. Further, OptionMetrics will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co‐worker, Pay Transparency Nondiscrimination .
If you need a reasonable accommodation for any part of the employment process, please contact us by email and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
Originally posted on Himalayas