Requirement Details are below:

Title: Database Administrator

Experience: 5+ Years

Work Mode: Onsite (5 Days) | Sat/Sun Week Off

Employment Type: Full Time

Notice Period: Immediate Joiners Preferred

Shift: General Shift (10 AM to 8 PM IST)

About Colan Infotech - https://colaninfotech.com/

Colan Infotech is a fast-growing CMMI Level 3 digital transformation and technology services company delivering innovative solutions across AI, Cloud, Mobility, Web Applications, DevOps, and Product Engineering. With a strong global footprint spanning the US, UK, India, and GCC, we partner with organizations to build scalable, future-ready technology products.

Backed by a culture that values innovation, ownership, continuous learning, and collaboration, Colan Infotech provides an environment where people grow, contribute meaningfully, and make a real impact.

About the Role:

We are looking for a skilled Database Developer with 5+ years of experience to support the development, optimization, migration, automation, and maintenance of enterprise-scale ERP applications. The ideal candidate should possess strong expertise in database administration, SQL performance tuning, data migration, backup and recovery strategies, automation scripting, and database security.

This role requires close collaboration with developers, QA teams, business analysts, and implementation teams to ensure high-performing, secure, and reliable database environments across development, testing, and production systems.

Key Responsibilities:

- Manage and maintain PostgreSQL, MySQL, or SQL Server databases across development, testing,



and production environments
- Design, review, and optimize database schemas, tables, views, stored procedures, functions, indexes, and relationships
- Analyze and improve SQL query performance and resolve database bottlenecks
- Support ERP modules including Sales, Procurement, Inventory, Production, Maintenance, HRMS, Finance, and Master Data
- Plan and execute end-to-end data migration activities including extraction, cleansing, transformation, mapping, validation, and reconciliation
- Develop automation scripts using Python, SQL, Shell, or Batch scripting for database administration tasks
- Implement automated backup, recovery, monitoring, reporting, and database maintenance solutions
- Monitor database health, performance, storage utilization, security, and availability
- Prepare and maintain database documentation, ER diagrams, migration plans, backup strategies, and change logs
- Collaborate with development, QA, and implementation teams during ERP development and deployment
- Explore AI-assisted solutions for SQL optimization, database monitoring, data validation, and migration verification

Required Skills & Experience:

- Solid experience in PostgreSQL, MySQL, or SQL Server




- Expertise in SQL query optimization and performance tuning
- Experience in database design, indexing, stored procedures, and functions
- Knowledge of backup, recovery, security, and database administration best practices
- Hands-on experience in Python, SQL scripting, Shell scripting, or Batch scripting
- Experience with data migration, ETL processes, and data validation activities
- Familiarity with Git/GitLab and version control practices
- Experience in creating technical documentation and ER diagrams

Preferred Skills:

- Experience working on ERP, Manufacturing, Finance, Inventory, Procurement, or HRMS applications
- Knowledge of PostgreSQL with .NET / Dapper-based applications
- Exposure to AI tools for database automation, SQL assistance, script generation, or data validation
- Experience with ETL tools, cron jobs, workflow automation, or scheduled jobs
- Knowledge of cloud database services and DevOps practices
- Basic knowledge of Power BI or reporting database preparation

What We Look For:

- Strong analytical and troubleshooting skills
- Hands-on approach to solving database and performance issues
- Ability to work independently and collaboratively in cross-functional teams
- Excellent communication and documentation skills
- Passion for automation, optimization, and continuous improvement
- Ability to manage multiple priorities and meet project deadlines

Please do refer your friends for these opportunities as we have multiple positions across other clients as well

📌 Database Administrator (Chennai)
🏢 Colan Infotech
📍 Chennai