Manage MSSQL and PostgreSQL databases, including installation, configuration, monitoring, performance tuning, security, backup and recovery. Develop optimized SQL queries, stored procedures, triggers, and views. Use AWS services for database deployment and scaling, Git/GitHub for version control, and collaborate with developers and system administrators. Support data warehouse design, ETL processes, reporting requirements, and database troubleshooting.
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.
Similar Jobs
Information Technology • Insurance • Software
Administer and optimize enterprise SQL Server databases across on-premises and AWS environments. Responsibilities include performance tuning, query optimization, high availability and disaster recovery, replication, backup and recovery, migrations, security, automation, monitoring, and production support. The role collaborates with application, SRE, and cloud teams, provides architectural guidance, supports database reliability, and participates in a 24x7 on-call rotation.
Top Skills:
Amazon Ec2Amazon RdsAmazon RedshiftAnsibleAurora PostgresqlAWSGitlabKubernetesMicrosoft Sql ServerOraclePerformance MonitorPostgresPowershellPythonServicenowSql ProfilerSsrsT-SqlTerraform
Aerospace • Information Technology • Security • Cybersecurity • Defense
Designs, installs, configures, maintains, secures, and optimizes SQL Server databases across multi-cloud environments. Responsibilities include backup and restore strategy, disaster recovery, high availability, failover clustering, SAN replication, performance tuning, capacity planning, monitoring, permissions management, troubleshooting, and database migrations. The role requires Microsoft SQL Server DBA expertise, Azure and AWS experience, SSIS/SSAS/SSRS knowledge, U.S. citizenship, and eligibility to obtain and maintain an agency security clearance.
Top Skills:
Amazon AwsAzureMicrosoft Sql ServerSan ReplicationSql Server Failover ClusteringSsasSsisSsrs
Cloud • Business Intelligence • Consulting
Provide production support and administration for large Oracle EBS environments. Responsibilities include implementation, upgrades, patching, performance tuning, backup and recovery, RAC and Data Guard administration, lifecycle project participation, effort estimation, documentation, and support across multiple operating systems. The role requires flexibility for rotational shifts and occasional evenings or weekends while managing multiple projects in a collaborative consulting environment.
Top Skills:
Engineered SystemsEnterprise Manager Grid ControlLinuxOem 12COem 13COracle 12COracle 19COracle Data GuardOracle Database ApplianceOracle Ebs R12.1.3Oracle Ebs R12.2Oracle Identity ManagementOracle MultitenantOracle RacOracle RdbmsRmanSolarisSQLUnixWeblogicWindows
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
