Senior Database Consultant, PostgreSQL at Pythian

Bengaluru, Karnataka, 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 support
  • Ability to coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and maintenance
  • Experience analyzing client infrastructure and processes to recommend best practices for uptime and recoverability
  • Proficiency in administering backup procedures, disaster recovery plans, proactive monitoring, alerting, and troubleshooting
  • Skills in overseeing data integrity, recovery processes including clustering, mirroring, replication, failover, and restoration of corrupted databases
  • Capability to develop and review action plans for maintenance, deployment, upgrades, and client documentation
  • Thorough understanding of client information, warnings, handoffs, and briefing notes
  • Experience developing, implementing, and maintaining complex data architectures (e.g., normalized/dimensional models, DDL generation, data transformation, migration using scripts/stored procedures)
  • Ability to lead problem management, assess incidents for patterns, design procedures for requests/changes, and develop/review action plans/documentation
  • Willingness to participate in on-call rotation (typically one weekend per month)
  • Strong client engagement skills, including making/managing/meeting commitments, preparing status/incident reports, responding to inquiries, and aligning with client procedures (e.g., change control, allotments)

Responsibilities

  • Provide comprehensive support for database and application infrastructure to diverse clients
  • Deliver consulting services and implement improvements/optimizations for managed services customers
  • Design and implement database server configurations and ongoing maintenance
  • Analyze infrastructure and recommend best practices to enhance operations, ensuring maximum uptime and recoverability
  • Administer backup procedures and disaster recovery plans, including monitoring, alerting, and troubleshooting
  • Oversee backup, clustering, mirroring, replication, failover, and restoration of corrupted databases
  • Develop and review action plans for maintenance, deployment, upgrades, and ensure completion of client documentation
  • Maintain understanding of client information, including warnings, handoffs, and briefing notes
  • Develop, implement, and maintain complex data architectures, perform data transformation and migration
  • Lead problem management by assessing incidents, designing procedures, and developing/reviewing action plans/documentation
  • Participate in team's on-call rotation
  • Collaborate with team to make, manage, and meet client commitments
  • Prepare and review client status/incident reports, respond to requests/inquiries
  • Maintain alignment with client operating procedures, manage allotments, and alert Team Manager as needed

Skills

PostgreSQL
Database Management
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