About Quantela
We are a technology company that offers outcomes business models. We empower our customers with the right digital infrastructure to deliver greater economic, social, and environmental outcomes for their constituents.
When the company was founded in 2015, we specialized in smart cities technology alone. Today, working with cities and towns; utilities, and public venues, our team of 280+ experts offer a vast array of outcomes business models through technologies like digital advertising, smart lighting, smart traffic, and digitized citizen services.
We pride ourselves on our agility, innovation, and passion to use technology for a higher purpose. Unlike other technology companies, we tailor our offerings (what we can digitize) and the business model (how we partner with our customer to deliver that digitization) to drive measurable impact where our customers need it most. Over the last several months alone, we have served customers to deliver outcomes like increased medical response times to save lives; reduced traffic congestion to keep cities moving and created new revenue streams to tackle societal issues like homelessness.
We are headquartered in Billerica, Massachusetts in the United States with offices across Europe, and Asia.
The company has been recognized with the World Economic Forum’s ‘Technology Pioneers’ award in 2019 and CRN’s IoT Innovation Award in 2020.
For latest news and updates please visit us at www.quantela.com
Overview of the Role
Manages, maintains, and secures data systems so that users can perform business-related functions. Responsible for data storage, organization, display, utilization, and analysis from a technological standpoint.
Key Responsibilities
- PostgreSQL Database DBA on Linux
- The job includes working with the various technology teams, vendors, and management of new hardware and operating systems infrastructure.
- Responsible for the installation, configuration database servers /Replication, Pgpool etc.
- Responsible for interacting with DB OEM team for raising tickets & get resolutions.
- Responsible for monitoring & maintaining database servers in Development, QA, Staging & Production environment.
- Atleast 7 years of experience as a DBA of PostgreSQL in production environment including backup recovery, replication, high availability, monitoring diagnosing and optimizing database performance.
- Ability to detect and troubleshoot database-related CPU, memory, IO, disk space, and other resource
- contention issues.
- Proficient with database tuning and use of PostgreSQL tools such as PgBadger, EDBs PgStatsPack, EDBs DRITA
- Proficient with PostgreSQL replication technologies Binary Streaming Replication, xDB Replication,
- Logical Replication
- Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool)
- Knowledge of high availability, disaster recovery and replication solutions and best practices
- Demonstrated experience implementing deploying database servers.
- Expertise in writing SQL queries, analyzing query performance using query plans and tuning query
- performance.
- Database Performance Tuning and Optimization, using native monitoring and 3rd party tools.
- Strong communications skills and ability to document and present complex designs to a wider audience.
Qualifications:
- BE/MCA or equivalent with specialization in computers
- PostgreSQL RDBMS Database Administration
- EDB PostgreSQL Certification is preferable.