Alpha Theory is looking for a DBA with experience using both MS SQL Server and PostgreSQL. (REMOTE available but prefer candidates near Charlotte, NC office if possible)
<a href="https://www.alphatheory.com/home#/dba-position" >
Alpha Theory, an award-winning leader in improving investment decision discipline and performance for some of the world's most respected investment managers, is looking for a Senior DBA with experience in PostgreSQL and Microsoft SQL Server. Alpha Theory provides SaaS which allows investment managers to optimize their position sizes and the composition of their portfolios. We're a small company and have worked hard to create an entrepreneurial work environment that challenges and enriches. If you're a skilled DBA with a focus on PostgreSQL and Microsoft SQL Server who is proactive, take initiative, works well without supervision, and identifies problems and solutions and takes action before issues arise, we want to hear from you!
As a Senior DBA reporting to the CTO, your core responsibilities will include:
Keeping our existing production and development databases running optimally (and get them running optimally where they're not currently).
Ensuring our database environment scales in line with the rapid growth in our client base.
Monitoring production performance and taking quick action to remedy any problems, including after business hours.
Taking part in DR planning and testing.
Assisting developers in optimizing queries.
Deploying schema, index, and procedure changes across our different environments.
Additionally, we have a number of significant projects starting:
A phased migration from SQL Server 2012 Enterprise edition to PostgreSQL.
Design and implementation of historical data marts, including investigation of tools, system design.
Introduction of private database instances for each client.
Required:
Experience in monitoring/alerting, troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models, particularly across geographically disparate data centers.
Knowledge of High Availability (HA), Replication and Disaster Recovery (DR) options for MSSQL Server and PostgreSQL.
Knowledge of indexes, index management, and statistics.
Strong ANSI SQL, T-SQL and PL/pgSQL skills.
Good communication and documentation skills.
Desired:
Experience with big data platforms, tools, and technologies.
Experience designing analytic queries for large volumes of financial time series data.
Experience with administration and deployment of schema changes to large numbers of database instances.
Apply here:
<a href="https://www.alphatheory.com/home#/dba-position" >
Ask HN: Who is hiring? (February 2015)