soho square solutions is Hiring a Senior Database Administrator Team Lead (PostgreSQL) Near New York, NY
Description 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.