Database PostgreSQL

Job Description Why Join Iris Are you ready to do the best work of your career at one of India's Top 25 Best Workplaces in IT industry Do you want to grow in an award-winning culture that truly values your talent and ambitions Join Iris Software one of the fastest-growing IT services companies where you own and shape your success story. About Us At Iris Software, our vision is to be our client's most trusted technology partner, and the first choice for the industry's top professionals to realize their full potential. With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services. Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation. Working with Us At Iris, every role is more than a job it's a launchpad for growth. Our Employee Value Proposition, Build Your Future. Own Your Journey. reflects our belief that people thrive when they have ownership of their career and the right opportunities to shape it. We foster a culture where your potential is valued, your voice matters, and your work creates real impact. With cutting-edge projects, personalized career development, continuous learning and mentorship, we support you to grow and become your best both personally and professionally. Curious what it's like to work at Iris Head to this video for an inside look at the people, the passion, and the possibilities. Watch it here. Job Description - Design and implement efficient, scalable, and secure PostgreSQL database schemas and objects (tables, views, functions, procedures). - Develop and optimize complex SQL queries, stored procedures, and triggers for regulatory data processing. - Collaborate with backend developers, data engineers, and business analysts to understand data requirements and translate them into robust database solutions. Ensure data integrity, consistency, and quality across systems. - Implement indexing, partitioning, and performance tuning strategies for large datasets. Support ETL processes and data pipelines for ingestion and transformation of trade data. - Participate in code reviews, testing, and deployment processes. - Maintain documentation for database structures, processes, and best practices. - Overall experience of 8-10 Year with 4+ years of hands-on experience with PostgreSQL development and administration. - Strong proficiency in SQL, PL/pgSQL, and performance tuning. - Experience with data modeling, normalization, and query optimization. - Experience working with large datasets and real-time data processing. - Knowledge of ETL tools, data warehousing, or data lakes is desirable. - Familiarity with version control systems (e.g., Git) and CI/CD pipelines. - Strong problem-solving skills and attention to detail. Mandatory Competencies Database - PostgreSQL - PostgreSQL Database - Database Programming - PL/SQL Database - Sql Server - SQL Packages ETL - ETL - Data Stage DevOps/Configuration Mgmt - DevOps/Configuration Mgmt - Git Development Tools and Management - Development Tools and Management - CI/CD FS Domain - Brokerage, Wealth & Asset Management - Investment Data Warehousing & Analytics Cloud - Azure - Azure Data Factory (ADF), Azure Databricks, Azure Data Lake Storage, Event Hubs, HDInsight Beh - Communication and collaboration Perks And Benefits For Irisians Iris provides world-class benefits for a personalized employee experience. These benefits are designed to support financial, health and well-being needs of Irisians for a holistic professional and personal growth. Click here to view the benefits.