Sr. DBA position with financial tech co.--at least some time in NYC/NC required
Sr. DBA with experience using PostgreSQL.
Must be a skilled DBA with a focus on PostgreSQL and Microsoft SQL Server
email resume to nyski _ mnn AT hotmail dot com
Core responsibilities will include:
◾ Keeping existing production and development databases running optimally (and get them running optimally where they're not currently).
◾ Ensuring database environment scales in line with rapid growth in 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 different environments.
Also 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 PostgreSQL.
◾Knowledge of indexes, index management, and statistics.
◾Strong ANSI SQL, T-SQL and PL/pgSQL skills.
◾Good communication and documentation skills.
Desired:
◾Knowledge of High Availability (HA), Replication and Disaster Recovery (DR) options for SQL Server.
◾ 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.
