Senior Database Administrator Team Lead (PostgreSQL)

SOHO Square Solutions

$120K — $150K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years as a PostgreSQL Database Administrator with knowledge of version 9.2
  • Experience with large multi-Terabyte, 24/7 uptime PostgreSQL databases as a Systems/Infra DBA
  • Proven Database Performance Diagnostic skills at SQL and system levels
  • Strong programming skills in PL/SQL and UNIX Shell Scripting/Python
  • Expertise in Backup and Recovery using Oracle RMAN
  • Ability to work independently and acquire new skills swiftly
  • Experience with Oracle versions 11gR1/2 in a UNIX environment

Responsibilities

  • Formulate and define the scope and objectives of systems via needs analysis and business requirements
  • Manage the evaluation and maintenance of current and new database systems and procedures
  • Establish standards and procedures for the department and provide technical support and direction
  • Oversee team members, project status, meetings, reporting, and administrative and technical matters
  • Act as primary liaison between Technical and Business teams
  • Provide 24/7 production database services support to ensure operational standards
  • Administer and monitor the performance of Oracle databases, including backups and recovery

Benefits

  • Comprehensive training and career development opportunities
  • Flexible work hours to accommodate critical maintenance schedules
  • Engagement in high-impact projects with visibility across the organization
  • Dynamic and collaborative team environment
  • Opportunities for remote work arrangements
Full Job Description
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.

Similar Jobs

More Jobs at SOHO Square Solutions

More Information Technology Jobs

Find similar Senior Database Administrator Team Lead (PostgreSQL) jobs: