Database Architect Job in Colan Infotech
- Colan Infotech
- 5 to 9 Yrs
- Chennai
- 7 days ago
- Email to a friend
- Report this job
Job Description
- Greetings from Colan Infotech!!! Designation - Database Admin Architect Experience - 9+ Years Location - Chennai Notice Period - Immediate to 30 Days 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): Proficiency in Database Administration, Database Design Experience in Data Modeling and Data Architecture Skilled in Extract Transform Load (ETL) processes Strong analytical and problem-solving skills Excellent communication and collaboration abilities Experience in handling large datasets and ensuring data integrity Knowledge of industry best practices and emerging technologies 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 hidden_email,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: IT Operations / EDP / MIS
Functional Area: Not Specified
Role/Responsibilies: Database Architect Job in Colan Infotech
Contact Details:
Company: Colan InfotechLocation(s): Chennai
+ View Contact
Keyskills: Database Administration Database Design Data Modeling Data Architecture Analytical skills Communication skills Data integrity SQL Performance tuning Database backup Database security Database integrity SSIS SSRS Data warehousing
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Colan Infotech
Colan Infotech Pvt Ltd Colan Infotech is an IT services company, having an offshore software development office located in India and serving to clients across USA, Canada & UK We are a Nasscom listed & CMMI Level 3 customer-centric technology firm
Plugin template missing! Fix or contact support.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in