[Remote] Senior Database Consultant, PostgreSQL at Pythian

India

Pythian Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Technology, Data Analytics, Cloud ServicesIndustries

Requirements

  • Expertise in PostgreSQL database management and technical expertise
  • Ability to coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance
  • Skills in analyzing client infrastructure and processes to recommend best practices for enhancing operational procedures, ensuring maximum uptime and recoverability
  • Proficiency in administering backup procedures, disaster recovery plans, proactive monitoring, alert response, and troubleshooting operational problems
  • Experience overseeing backup, clustering, mirroring, replication, failover, and restoration of corrupted databases
  • Capability to develop and review action plans for maintenance, deployment, and upgrades, including completing client documentation and maintaining understanding of client information (warnings, handoffs, briefing notes)
  • Knowledge in developing, implementing, and maintaining complex data architectures (e.g., normalized/dimensional data models, DDL generation), data transformation, and migration using scripts or stored procedures
  • Experience leading problem management, assessing incidents for patterns, designing technical procedures for requests/changes, and developing/reviewing action plans and documentation
  • Availability to participate equally in team’s on-call rotation (typically one weekend per month)

Responsibilities

  • Provide comprehensive support for database and application infrastructure to diverse clients
  • Deliver and consult on services, implementing improvements and optimizations for managed services customers
  • Analyze client infrastructure and processes, recommending best practices to enhance operations, uptime, and recoverability
  • Administer backup procedures and disaster recovery plans, including proactive monitoring, alert response, and troubleshooting
  • Oversee data integrity and recovery processes, including backup, clustering, mirroring, replication, failover, and database restoration
  • Develop and review action plans for maintenance, deployment, and upgrades; ensure client documentation is completed and maintain client information awareness
  • Develop, implement, and maintain complex data architectures; perform data transformation and migration
  • Lead problem management efforts, assessing incidents, designing procedures, and developing documentation
  • Participate in on-call rotation
  • Make, manage, and meet client commitments in collaboration with team members
  • Prepare client status and incident reports; review reports regularly and respond to client requests/inquiries
  • Maintain alignment with client operating procedures (e.g., change control), manage allotments, and alert Team Manager to pacing concerns
  • Engage technically with clients

Skills

PostgreSQL
Database Management
Solution Design
Database Optimization
Cloud Databases
AWS
Google Cloud
Microsoft Azure
Oracle
Snowflake

Pythian

Cloud migration and data management services

About Pythian

Pythian assists businesses in managing and optimizing their data and IT infrastructure through services like cloud migration, managed services, and advanced analytics. They help companies transfer their data to cloud platforms such as Google Cloud, AWS, and Microsoft Azure, while providing ongoing support for smooth operations. Pythian differentiates itself by offering specialized services in machine learning and data science, enabling businesses to turn their data into valuable insights. Their goal is to empower organizations to leverage cloud computing and advanced analytics to improve operations and drive growth.

Ottawa, CanadaHeadquarters
1997Year Founded
$20.4MTotal Funding
EARLY_VCCompany Stage
Consulting, Enterprise Software, AI & Machine LearningIndustries
501-1,000Employees

Benefits

Remote Work Options
Flexible Work Hours
Paid Vacation
Paid Sick Leave
Wellness Program
Professional Development Budget
401(k) Company Match

Risks

Emerging cloud providers offering lower-cost services increase competition.
Rapid AI advancements may outpace Pythian's current capabilities.
Economic downturns in key industries could reduce IT service spending.

Differentiation

Pythian offers specialized services in machine learning and AI for data insights.
Their EDP QuickStart provides rapid deployment of enterprise data platforms.
Pythian's global presence with experts in 22 countries enhances their service delivery.

Upsides

Growing demand for cloud migration boosts Pythian's service offerings.
Expansion in database management market offers growth opportunities for Pythian.
Increased focus on cybersecurity drives demand for Pythian's Adminiscope.

Land your dream remote job 3x faster with AI