Lead Database Administrator (PostgreSQL)
About us
ENSO Financial Analytics (ENSO) is revolutionizing the way that hedge fund and prime brokers communicate, enhance relationships and derive value. We do this by providing hedge fund managers with everything they need to optimize counter party relationships. The result is data-driven informational alpha that empowers both buy- and sell-side firms to extract more value in a complicated regulatory environment with multi-dimensional constraints.
With more than $1 Trillion in total assets under advisory, ENSO provides operational insights and alpha-generating analytics to many of the world’s most successful fund managers.
Our Database Administrator professionals will be solving unique and exciting challenges, which will genuinely appeal to someone looking for something distinctive. We’ve had very positive customer feedback, we’re growing fast and we’re proud to be part of the iCap Family. ENSO can be special, and this is an opportunity to build something truly unique, which you’ll be able to look back on with pride and industry-wide recognition – our technical requirements are complex and the right person will be a major part of the ENSO Financial success story.
Responsibilities
- Formulate and define systems scope and objectives through needs analysis and business requirements.
- Manage and administer the study, analysis, and evaluation of current and projected database systems and procedures, as well as the design, implementation, and maintenance of revised or new systems.
- Develop and establish department standards and procedures, and coordinate the technical support and direction to programming, operations and other departments.
- Overall responsibilities for team members, project status, meetings, reporting, scope changes, financials, administrative and technical issues.
- Primary liaison for Technical & Business teams.
- 24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance required by our business.
- Able to work non-standard office hours to meet critical maintenance and release schedules.
- Administration, performance monitoring, reporting, and tuning of Oracle databases.
- Management and maintenance of backups and recovery procedures
Installation and maintenance of database server, replication and client environments - Ability to troubleshoot and solve complex problems independently.
- Ability to manage conflicting priorities effectively.
- Expert knowledge of database security methodologies.
- Ability to troubleshoot and solve complex problems independently.
- Strong understanding of business continuity and disaster recovery processes and procedures.
Requirements
- 5-7 years as an PostgreSQL Database Administrator ( knowledge of version 9.2 )
- Exceptional experience administering various multi-Terabyte, 24x7 uptime PostgresSQL databases as a Systems/Infra DBA required
- Strong, proven Database Performance Diagnostic skills (at both the SQL and system levels) required
- Strong programming experience in PL/SQL and UNIX Shell Scripting and/or Python (preferably) required
- Extensive experience with Backup and Recovery using Oracle RMAN.
- Self-starter capability, ability to acquire new skills autonomously.
- Experience working with Oracle versions 11gR1/2 in a UNIX environment required
- Demonstrably solid written and verbal communication skills to drive projects to successful conclusion.
Preferred Skills
- Database system experience ie. PostgreSql, Oracle
Desired Major(s)
- Bachelor’s degree in Computer Science or a related discipline or equivalent work experience.
____________________________________
Mike McMahon
Chief Technology Officer
mike.mcmahon@xxxxxxxxxxxxxxxxx
____________________________________
450 Park Avenue South, 3rd Floor
New York NY 10016
_____________________________________
Most Innovative Technology Provider |
______________________________________
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any transmission errors. If you receive this message in error, or if you are told that this message contains incorrect information, or if you are asked to delete this message for any reason, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message including any attachments if you are not the intended recipient of this message or any of its attachments or any part thereof. ENSO LP, ENSO Financial Management LLP and each of its subsidiaries (“ENSO”) each reserve the right to intercept and monitor all e-mail communications through its networks if legally allowed. Message transmission is not guaranteed to be secure. This e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of ENSO. Any views or opinions presented are solely those of the author and do not necessarily represent those of ENSO. ENSO does not render legal, financial or tax advice, and the information contained in this communication should not be regarded as such.
