Postgres DBA

3 weeks ago

Gurgaon, Haryana, India TecoreLabs Full time
Company Description
Tecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now officially present in 3 countries: India, United States, and Hong Kong.

Role Description
This is a full-time role for a Postgres DBA at Tecore Labs. The Postgres DBA will be responsible for database administration, design, troubleshooting, databases, and replication on a day-to-day basis.

Key Responsibilities:
Database Administration:
Manage and optimize EDB and open-source PostgreSQL databases.
Collaborate with teams to improve database performance and ensure high availability.
Design and implement scalable, highly available database platforms for on-premises and cloud environments.
Security, Backup, and Recovery:
Apply security best practices, including encryption and role-based access control.
Perform backups and restorations using tools like Pgbackrest, Pg_basebackup, Pg_dump, and Pg_dumpall.
Conduct regular restoration testing to validate data integrity.
Maintenance and Monitoring:
Develop and implement standardized database maintenance plans.
Monitor database health using Grafana, Prometheus, Telegraf, Loki, InfluxDB, and Pg_metrics.
Proactively identify and resolve database issues.
Performance Optimization:
Analyze and resolve performance bottlenecks with query and index tuning.
Utilize PGbouncer for effective connection pooling.
Upgrades and Migrations:
Manage PostgreSQL version upgrades and migrations with minimal downtime.
Basic Oracle Knowledge:
Possess foundational knowledge of Oracle database concepts and management.

Skills and Tools:
Databases:

PostgreSQL, TimescaleDB, EDB Advanced Server, Oracle (basic).
Backup/Recovery:

Pgbackrest, Pg_basebackup, Pg_dump, Pg_dumpall, Barman.
Monitoring:

Prometheus, Grafana, InfluxDB, Telegraf, Zabbix, PgWatch2.
High Availability:

RepMgr, Patroni, HAProxy, PgPool.
Containerization:

Docker, Kubernetes, Docker Swarm.
Performance:

Query tuning, caching, PGbouncer.
Platforms:

RHEL, Ubuntu, Azure VMs.

Notable Achievements:
Developed custom database container images for Docker and Kubernetes.
Implemented high availability solutions using RepMgr and Patroni.
Enhanced performance through query optimization and bottleneck resolution.
Designed and deployed scalable database architectures for on-premises and cloud environments.
Successfully managed PostgreSQL migrations and upgrades with minimal disruption.
Seamlessly integrated database systems into application architectures.

Qualifications
Database Administration and Database Design skills
Troubleshooting databases and replication
Experience in managing and optimizing database systems
Strong problem-solving and analytical skills
Excellent communication and teamwork skills
Ability to work independently and remotely
Bachelor's degree in Computer Science or related field

  • Postgres DBA Only 24h Left

    3 weeks ago

    Gurgaon, Haryana, India TecoreLabs Full time

    Company DescriptionTecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Lead- MYSQL DBA

    2 weeks ago

    Gurgaon, Haryana, India PayU Full time

    Job Summary & Responsibilities: Design, implement, and maintain MySQL database instances in AWS environments.  Optimize database performance through tuning, indexing, and scaling.  Monitor database systems to ensure high availability, security, and performance.  Manage backup and recovery strategies in accordance with company policies.  ...

  • Lead- MYSQL DBA

    2 weeks ago

    Gurgaon, Haryana, India PayU Full time

    Job Summary & Responsibilities:Design, implement, and maintain MySQL database instances in AWS environments. Optimize database performance through tuning, indexing, and scaling. Monitor database systems to ensure high availability, security, and performance. Manage backup and recovery strategies in accordance with company policies. Collaborate with...

  • Senior Database Administrator

    3 hours ago

    Gurgaon, Haryana, India United Airlines Full time

    Job DescriptionDescriptionUnited&aposs Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions.Our Values: At United Airlines, we believe that inclusion propels innovation and is the foundation of all that we do. Our Shared Purpose:...

  • Database Architect

    7 days ago

    Gurgaon, Haryana, India TecoreLabs Full time

    About Tecore LabsTecore Labs is a pioneering research and development company with over 50 years of combined executive experience. The company excels in providing top-notch services in technology and crafting cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering.Our MissionWe aim to deliver best-in-class solutions that meet the evolving...

  • IT Specialist

    2 weeks ago

    Gurgaon, Haryana, India Giesecke+Devrient Full time

    Objective Of This Role: Background about IT EOC: G+D's IT Enterprise Operations Center (EOC) is the global delivery and support operations center for G+D groups' global locations and subsidiaries. EOC manages the IT Infrastructure (Server /Datacenter, collaboration and Messaging, Network LAN/ WAN / Wi-Fi and Firewall security) and Enterprise IT...

  • Postgres dba

    5 days ago

    Gurgaon, India TecoreLabs Full time

    Company Description Tecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, Dev Ops, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Postgres DBA

    4 weeks ago

    Gurgaon, India TecoreLabs Full time

    Company Description Tecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Postgres DBA

    3 weeks ago

    Gurgaon, India TecoreLabs Full time

    Company DescriptionTecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Dba - postgresql redis

    4 days ago

    Gurgaon, India Medanta Full time

    Job Location - GurgaonWork Days - 6 days weekKey Responsibilities:- Design, install, configure, and maintain Postgre SQL, REDIS database systems.- Good to have skills on Mongo Db and/or Mysql but NOT Mandatory- Perform regular database performance tuning, monitoring, and optimization to ensure efficient and reliable operation.- Monitor and manage database...

  • Oracle DBA

    3 weeks ago

    Gurgaon, India Tekgence Inc Full time

    Position: Oracle DBAClient: One of our Prestigious clientLocations: GurugramMode of hiring: Fulltime/PermanentExperience:10+ Years.Budget: 17-21 LPANotice Period: 0-30 daysJob Description:Position Summary: We are looking for a highly skilled and experienced Database Administrator (DBA) L2/L3 of around 10 years+ of exp. to join our dynamic team.Primary...

  • Database Administrator

    6 days ago

    Gurgaon, India Schlesinger Group Full time

    Job Title: Database Administrator Location: Gurgaon Working Days: 5 Days in Week Shift Timing: 24X7(Rotational) Experience: 5-7 Years **JOB DESCRIPTION** Job purpose: We are looking for a database administrator who can maintain a successful database environment. The responsibilities include backup, restore, and jobs, as well as writing queries for...

  • Oracle DBA

    4 weeks ago

    Gurgaon, India Tekgence Inc Full time

    Position: Oracle DBAClient: One of our Prestigious clientLocations: GurugramMode of hiring: Fulltime/PermanentExperience:10+ Years.Budget: 17-21 LPANotice Period: 0-30 daysJob Description:Position Summary:We are looking for a highly skilled and experienced Database Administrator (DBA) L2/L3 of around 10 years+ of exp. to join our dynamic team.Primary Skill:-...