Database Administrator (DBA)

OptionMetrics; United States; Hybrid; USD 110,000 - 140,000; Full time

Job summary

OptionMetrics, headquartered in New York, NY, is seeking a highly skilled Database Administrator to join our team and manage MSSQL and PostgreSQL databases, ensuring stability, security, and performance.

You will develop and optimize SQL queries, design complex stored procedures, and leverage AWS services to deploy, monitor, and scale databases, while collaborating with cross-functional teams. This role offers remote US or hybrid options from NYC or Miami.

Qualifications

• Bachelor's degree in CS or related field.
• Proven experience as a Database Administrator with MSSQL and PostgreSQL.
• Strong SQL tuning and performance optimization skills.
• Experience designing and maintaining stored procedures, triggers, and views.
• Experience with PostgreSQL installation/configuration/troubleshooting.
• Familiarity with AWS services (EC2, RDS, S3).
• Git/GitHub for version control.
• Knowledge of database security best practices.

Responsibilities

• Manage MSSQL and PostgreSQL databases for stability, availability and performance.
• Develop and optimize SQL queries.
• Design and maintain stored procedures, triggers and views.
• Install, configure, and monitor PostgreSQL databases.
• Implement and maintain database security measures.
• Develop backup and recovery strategies.
• Utilize AWS services for deployments and scaling.
• Collaborate with cross-functional teams to resolve issues.
• Use Git/GitHub for version control.
• Assist in data warehouse design, ETL processes and reporting.
• Stay updated with MSSQL, PostgreSQL, AWS, and related tech.

Skills

SQL performance tuning

Stored procedures development

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

MSSQL

PostgreSQL

Git/GitHub

AWS (EC2, RDS, S3)

ETL tooling

Job description

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 skillsExcellent communication and interpersonal skillsAbility 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-based approach. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Pay ranges at OptionMetrics are established based on an analysis of salaries for positions with a similar level of accountability and impact in the relevant labor market. Salary levels are expected to change to reflect an employee’s job performance (results and impact) over time. Salaries at the time of hire are typically offered in the lower to middle of the above-referenced range in order to provide the opportunity to reflect performance-based increases over time. In addition to base salaries, employees at OptionMetrics are eligible for a comprehensive package of benefits.