Database Architecture Specialist

1 week ago

Chennai, Tamil Nadu, India beBeeDatabaseAdministrator Full time ₹ 15,00,000 - ₹ 28,00,000

Job Opportunity:

PostgreSQL Database Administration Expert

We are seeking a skilled PostgreSQL database administrator to join our team. As a key member of our database administration group, you will be responsible for ensuring the smooth operation and optimal performance of our PostgreSQL databases.

Responsibilities:

  • Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
  • Develop SQL reports that meet client expectations for the application (used by custom application).
  • Tune auto vacuum parameters to ensure up-to-date table stats and reclaim space consumed by dead tuples.
  • Contribute to decreasing the need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
  • Stay current on features and functionality of PostgreSQL and apply this knowledge in your work.
  • Proactively manage standby replication methodologies like Streaming replication and hot standby for disaster recovery.
  • Schedule daily Point-in-Time Recovery (PITR) to the development environment for proper product testing.
  • Proactively update the latest security patches to the database, provided by the PostgreSQL open source community.
  • Identify, troubleshoot, and resolve live database system issues.
  • Have knowledge of disaster recovery principles and practices, including planning, testing, backup/restore.
  • Gain hands-on experience with database administration, backup recovery, and troubleshooting in co-location environments.
  • Thrive in a fast-paced, deadline-sensitive environment.
  • Configure, integrate, and maintain all Development, QA, Staging, and Production PostgreSQL databases within the organization.
  • Perform all backup, recovery, and upgrading of all PostgreSQL databases.
  • Experience code migration and database change management through various stages of the development life cycle.
  • Respond to all system/database issues on a 24x7 schedule, responding to critical events and situations outside normal work hours.
  • Install and monitor PostgreSQL databases using standard monitoring tools like Nagios/relevant tools.
  • Monitor DB growth for every month in DWH databases and plan to implement table partitioning for better performance.
  • Monitor bloat reports on every table and perform maintenance with minimal downtime.
  • Perform minor and major level upgrades using minimal downtime by prior testing in test boxes with accurate time notifications.
  • Install and Configure PostgreSQL from source or packages on Linux machines.
  • Design database structures, indexes, views, partitioning.
  • Implement backup and recovery (Logical and Online).
  • Setup and maintenance of PostgreSQL master-slave clusters utilizing streaming replication.
  • Cross-datacenter disaster recovery and backup architecture.
  • Perform schema management, database sizing, maintaining privileges.
  • Data migration while upgrading database versions.
  • Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).
  • Scheduled maintenance activities to vacuum, analyze to improve query response time.
  • Maintain custom vacuum strategies at table and db level.

  • SAP HANA Database Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 80,00,000 - ₹ 1,20,00,000

    Job Title: SAP HANA Database SpecialistSeeking a skilled and versatile HANA database administrator with excellent communication skills, analytical thinking, and the ability to collaborate effectively.About the RoleThe ideal candidate will have in-depth knowledge of SAP HANA Database architecture, enabling efficient management of installation, maintenance,...

  • High-Performance Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India beBeeDatabaseSpecialist Full time ₹ 12,00,000 - ₹ 36,00,000

    Database Architectural SpecialistJob DescriptionAs a high-performing Database Architectural Specialist, you will play a pivotal role in ensuring the seamless operation of our global infrastructure. You will be responsible for providing critical database administrative support across various environments, including Development, QA, client test, and production...

  • Data Architecture Specialist

    1 week ago

    Chennai, Tamil Nadu, India beBeeBigDataEngineer Full time ₹ 1,80,00,000 - ₹ 2,50,00,000

    Job OverviewVeltris partners with clients to deliver cutting-edge big data analytics solutions, leveraging expertise in Spark, Druid, Drill, and ClickHouse.Main ResponsibilitiesDesign scalable architecture for real-time data processing using distributed systems.Maintain complex data pipelines with Apache Spark, Kafka, Glue, EMR, Hudi, Schema Registry, and...

  • Database Solutions Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India beBeedatabase Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Database Solutions SpecialistThis is an exciting opportunity to work with us as a Database Solutions Specialist and contribute your expertise in designing and delivering high-quality database solutions.

  • Database Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Title: Database SpecialistWe are seeking an experienced and skilled professional to join our team as a Database Specialist. In this role, you will be responsible for designing, developing, and maintaining data-driven applications and integrations that support business needs.Key Responsibilities:Design and implement database solutions using SQL queries,...

  • Enterprise Database Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 15,00,000 - ₹ 28,00,000

    Enterprise Database SpecialistWe are seeking an experienced Enterprise Database Specialist to join our team.Job Description:The successful candidate will be responsible for designing, implementing, and maintaining large-scale databases in an enterprise environment.Required Skills and Qualifications:Strong knowledge of database design principles and...

  • Database Optimization Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 20,00,000 - ₹ 40,00,000

    Job Title: Database Optimization Specialist ">About the Role:">The role of a Database Optimization Specialist is to design, develop, and implement database systems based on client requirements. This includes creating complex functions, scripts, and stored procedures to design databases that optimize application efficiency."> ">This involves working with...

  • Architecture Design Specialist

    1 week ago

    Chennai, Tamil Nadu, India beBeeDesign Full time ₹ 6,00,000 - ₹ 12,00,000

    Role OverviewWe are seeking an Architecture Design Specialist to join our team. In this role, you will be responsible for creating and preparing architectural drawings based on specifications and requirements.About the RoleThe Architecture Design Specialist will work closely with architects, engineers, and construction teams to ensure all drawings comply...

  • Data Architecture Specialist

    7 days ago

    Chennai, Tamil Nadu, India beBeeDataArchitecture Full time ₹ 4,50,000 - ₹ 8,00,000

    Job Title: Data Architecture SpecialistAre you passionate about building and managing scalable data pipelines? We are looking for a highly skilled Data Architecture Specialist to join our team.Design, develop, and maintain robust, efficient, and scalable data pipelines that meet business needs.Work with cross-functional teams to understand requirements and...

  • Database Architect Position

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 15,00,000 - ₹ 25,00,000

    Database Specialist RoleWe are seeking a skilled Database Specialist to join our team. In this role, you will be responsible for designing, developing, and maintaining complex relational databases.Main Responsibilities:Database Design and Development: Create efficient database architectures and develop high-quality SQL code.Data Integration and...