ERP Database Administrator

1 week ago

Chennai, Tamil Nadu, India Colan Infotech Private Limited Full time ₹ 9,00,000 - ₹ 12,00,000 per year

Greetings from Colan Infotech

Position - ERP Database Administrator

Location - Chennai

Job Description:

The ERP Database Administrator will oversee the installation, configuration, upgrading, administration, monitoring, maintenance, and security of PostgreSQL databases supporting the ERP system. This role requires close collaboration with IT teams, developers, and end-users to ensure seamless integration and optimal performance of the ERP applications.

Key Responsibilities:

  • Database Management:
  • Install, configure, and upgrade PostgreSQL database servers and related applications.
  • Design and implement database schemas tailored to ERP requirements.
  • Monitor database performance and implement necessary changes to enhance efficiency.
  • Expertise in working with popular DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL (preferred), or MongoDB.
  • Data Integration (SSIS):
  • Develop and manage SSIS packages to extract, transform, and load (ETL) data from various sources into the data warehouse.
  • Ensure data integrity and consistency across multiple systems.
  • Performance Tuning:
  • Analyze and optimize database performance to ensure high availability and reliability.
  • Identify and resolve performance bottlenecks, ensuring efficient data retrieval and processing.
  • Conduct regular reviews and enhance SSIS packages and SSRS reports for efficiency.
  • Security and Compliance:
  • Implement and maintain database security protocols, including user account management and data encryption.
  • Ensure compliance with data protection regulations and organizational integrity.
  • Develop and manage backup and recovery plans to prevent data loss.
  • Perform regular data backups and conduct recovery tests to validate backup policies.
  • Collaboration and Support:
  • Work closely with IT and development teams to integrate ERP systems with other applications.
  • Provide technical support and training to end-users regarding database functionalities.
  • Documentation and Reporting:
  • Maintain comprehensive documentation of database configurations, procedures, and policies.
  • Generate regular reports on database performance, usage, and security compliance for management.
  • Design and deploy SSRS reports to provide actionable insights to stakeholders.
  • Cloud Database Services:
  • Understanding of cloud-based database solutions and services, such as AWS RDS, Azure SQL Database, or Google Cloud SQL.
  • Experience in migrating, managing, and scaling databases in cloud environments.

Experience (5+ yrs):

  • Proven experience as a Database Administrator, with a focus on PostgreSQL databases.
  • Experience managing databases within ERP systems is highly desirable.
  • Experience with SSIS for ETL processes and SSRS for report development.
  • Familiarity with data warehousing concepts and BI methodologies.
  • Proficiency in SQL and PL/pgSQL.
  • Strong knowledge of PostgreSQL architecture, performance tuning, and optimization techniques.
  • Experience with database backup, recovery, security, and integrity.
  • Familiarity with database design, documentation, and coding.
  • Experience with DBA tools and utilities specific to PostgreSQL.

Interested candidates send your updated resume to

  • PostgreSQL Database Administrator

    3 days ago

    Chennai, Tamil Nadu, India Softone HR Solutions Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Dear All,This is a full-time on-site role for a PostgreSQL Administrator located in ChennaiLocation : ChennaiExperience : 4 to 10 YearsBudget : OpenMode : Work from OfficeRole DescriptionThis is a full-time on-site role for a PostgreSQL Administrator located in Chennai. The PostgreSQL Administrator is responsible for managing and maintaining the database...

  • Database Administrator

    38 minutes ago

    Chennai, Tamil Nadu, India Naethra Technologies Full time ₹ 2,76,240 - ₹ 8,73,720 per year

    Proven working experience as a Database Administrator Hands-on experience with database standards and end user applications Excellent knowledge of data backup, recovery, security, integrity and SQL Familiarity with database design, documentation and coding Previous experience with DBA case tools (frontend/backend) and third party tools Familiarity with...

  • Oracle Database Administration

    1 week ago

    Chennai, Tamil Nadu, India Kiya Full time ₹ 8,00,000 - ₹ 20,00,000 per year

    Position : Oracle Database Administration (Oracle DBA)Experience: 3 to 6 YearsNotice period : Immediate to 15 DaysLocation : Chennai.Required Skills: Oracle DBA/Oracle APP DBA, Fusion Middleware administration and SQL Server DB administration.To have some experience working with the below products.Oracle Databases (EBS & Non EBS Databases)Oracle Enterprise...

  • MySQL Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Crew Kraftorz Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description: MySQL Database Administrator (DBA)Position Overview:We are looking for an experienced MySQL Database Administrator (DBA) to manage and support our database infrastructure. The ideal candidate will be responsible for ensuring high availability, performance, security, and scalability of MySQL databases in production and development...

  • Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Sankara Software Services Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Database Management: Install, configure, and maintain database servers (e.g., MySQL, PostgreSQL, SQL Server, MongoDB) and database instances (on-premises, cloud-based such as Azure SQL, or hybrid environments).Performance Tuning: Monitor and optimize database performance, query execution, and indexing strategies, using tools such as SQL Profiler, Extended...

  • Senior Database Administrator

    1 day ago

    Chennai, Tamil Nadu, India Brainvault Technologies Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    JD for Database AdministratorKey Responsibilities:Administer and maintain multi-tenant MySQL databases hosted on AWS Cloud.Review database-related pull requests from developers for schema modifications and updates.Monitor, analyze, and optimize SQL queries and indexes to enhance database performance.Partner with DevOps and development teams to support...

  • MySQL Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Headsbase Select Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    Database AdministrationInstall, configure, upgrade, and patch MySQL database servers.Manage schemas, tables, indexes, partitions, and storage engines.Create and maintain stored procedures, triggers, and functions.Performance OptimizationMonitor database performance using Performance Schema, MySQL Enterprise Monitor, Percona PMM, or similar tools.Optimize...

  • MySQL Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Miratech Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Company Description Miratech helps visionaries change the world. We are a global IT services and consulting company that brings together enterprise and start-up innovation. Today, we support digital transformation for some of the world's largest enterprises. By partnering with both large and small players, we stay at the leading edge of technology, remain...

  • Server & Database Administrator

    5 days ago

    Chennai, Tamil Nadu, India Ibode Technologies Full time ₹ 1,50,000 - ₹ 28,00,000 per year

    We are looking for a skilled Server & Database Administrator responsible for maintaining servers, managing database systems, ensuring reliable backups, and handling application deployments. The ideal candidate should have strong technical expertise, proactive problem-solving skills, and experience in production support environments.Preferred candidate...

  • Oracle Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Lider Consultancy Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Role: Oracle Database AdministrationExperience: 3 to 7 yearsMinimum 2 years of experience(Hands-on oracle)Location: ChennaiWork mode: Work from OfficeRoles and Responsibilities:Good understanding of the Oracle database architecture (Single Instance, RAC and ASM),related utilities and tools on 12c and 19c(Multitenant).Defining database standards and...