Colan Infotech

DBA Architect PostgreSQL, Performance & Enterprise ComplianceJob Description : We are seeking an expert-level DBA Architect with 10+ years of extensive experience to join our team in Chennai. This critical role demands a master practitioner in PostgreSQL and database architecture, responsible for designing, building, and governing the performance, reliability, and security of mission-critical database systems. The Architect will drive strategic initiatives in data security, disaster recovery, ETL processes using SSIS, and ensure robust, high-availability solutions are delivered across the enterprise. We are looking for candidates who can join immediately or within a 30-day notice period.Key Responsibilities : Database Architecture and Scalability : - Own the technical architecture and design of core database systems, ensuring optimal scalability, reliability, and high-availability tailored to complex business needs and environments.- Design, document, and implement scalable, high-availability database solutions that minimize operational risk and guarantee business continuity through rapid system recovery from outages.- Drive implementation and governance of transactional database systems, with strong expertise in PostgreSQL and knowledge of other platforms like MySQL.Performance Tuning and Optimization : - Apply in-depth understanding of database design and performance tuning strategies to ensure robust performance for mission-critical applications.- Possess a proven capability to design, review, and optimize database schema, tables, complex queries, and indexing strategies for maximum efficiency and speed.- Troubleshoot, diagnose, and resolve high-severity database issues quickly, collaborating with development and infrastructure teams to maintain optimal operation.Data Integration and Business Intelligence : - Demonstrate proficiency in SQL Server Integration Services (SSIS) to manage efficient data integration, extraction, transformation, and loading (ETL) processes for complex enterprise environments.- Be proficient in SQL Server Reporting Services (SSRS) to design and deploy interactive, enterprise-level, and insightful business intelligence reports.Security, Governance, and Compliance : - Design and implement enterprise-level data security policies and controls to ensure sensitive information protection across all databases.- Apply comprehensive knowledge of data security policies and best practices for protecting sensitive broad enterprise information and ensuring regulatory compliance.Disaster Recovery and Operational Excellence : - Architect and implement robust disaster recovery strategies (DR) and solutions to minimize operational risk and ensure business continuity through rapid system recovery.- Manage and execute database migration, version upgrades, schema management, and troubleshoot complex database connectivity problems.Stakeholder Collaboration and Leadership : - Utilize exceptional communication, analytical, and leadership qualities to collaborate effectively with cross-functional technical teams.- Evaluate business needs, automate processes, and customize database solutions for different workflows to support broader business objectives.Required Skills : - 10+ Years of experience as a Database Administrator or Architect.- Expertise in PostgreSQL and core concepts of Database Architecture is mandatory.- Deep technical proficiency in SQL and advanced database design principles.- Extensive hands-on experience in performance tuning, complex query optimization, and resource management.- Strong proficiency in SSIS (SQL Server Integration Services) for ETL process design and management.- Strong skills in SQL Server Reporting Services (SSRS) for enterprise reporting solutions.- Comprehensive knowledge of data security policies, controls, and best practices (e.g., GDPR, compliance standards).- Proven experience in architecting and implementing Disaster Recovery (DR) solutions and high-availability systems.Preferred Skills : - Familiarity with cloud-based database solutions (AWS RDS, Azure SQL, GCP Cloud SQL).- Strong expertise in managing large-scale transactional database environments.- Certification in PostgreSQL or relevant cloud database technologies.- Experience with database migration and version upgrade projects. (ref:hirist.tech)