Senior Database Consultant, PostgreSQL at Pythian

Hyderabad, Telangana, India

Apply Now

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
Experience 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
Skills in 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 understanding client information (warnings, handoffs, briefing notes)
Experience developing, implementing, and maintaining complex data architectures (e.g., normalized/dimensional data models, DDL generation), performing data transformation and migration using scripts or stored procedures
Ability to lead problem management by assessing incidents for recurring patterns, designing technical procedures for requests/changes, and developing/reviewing action plans and documentation
Willingness to participate equally in the team’s on-call rotation (typically one weekend per month)
Strong client engagement skills, including making, managing, and meeting client commitments in collaboration with team members
Proficiency in preparing client status and incident reports, reviewing reports, responding to client requests/inquiries, maintaining alignment with client operating procedures (e.g., change control), and managing client allotments

Responsibilities

Provide comprehensive support for all database and application infrastructure aspects to a diverse client base
Deliver and consult on services, implementing improvements and optimizations for managed services customers
Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance
Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures, ensuring maximum uptime and recoverability for all databases
Administer backup procedures and disaster recovery plans, including proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems
Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases
Develop and review action plans for maintenance, deployment, and upgrades, ensuring all relevant client documentation is completed; maintain thorough understanding of client information, including warnings, handoffs, and briefing notes
Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation); perform data transformation and migration using scripts or stored procedures
Lead problem management efforts by assessing incidents for recurring patterns, designing technical procedures for regular requests and changes, and developing/reviewing action plans and associated documentation
Participate equally in the team’s on-call rotation, typically one weekend per month
Make, manage, and meet client commitments in collaboration with team members
Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries
Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any issues

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

Try Jobo Free