Database Architect (Designer) - Oracle/PostgreSQL

Job Title: Database Architect (Designer) Oracle/PostgreSQL for Financial Systems
Location: Noida
Experience: 6-15 Years

Job Summary:

We are looking for an experienced Database Architect to design and optimize the data architecture for a high-transaction banking application. The ideal candidate should have deep expertise in relational and NoSQL databases, data modeling, and database security within financial services. Should have knowledge of cloud-based data solutions.

Key Responsibilities:

• Design scalable, secure, and high-performance database architectures for large-scale banking and financial applications.
• Develop database solutions using Oracle 19c and above, PostgreSQL, MariaDB, or other distributed databases.
• Optimize database performance, indexing strategies, partitioning, and query tuning.
• Define data governance policies to ensure compliance with financial regulations (PCI-DSS, GDPR, etc.).
• Design and implement ETL pipelines, data warehousing, and real-time analytics solutions.
• Work closely with application architects, DevOps engineers, and security teams to ensure seamless integration and data flow.
• Automate database deployment and monitoring using Terraform, Ansible, and Kubernetes operators.
• Provide guidance on database migrations, upgrades, and cloud adoption strategies.
• Ensure data security best practices, encryption, and access control mechanisms are in place.

Required Skills and Qualifications:

• Strong expertise in SQL and NoSQL databases such as Oracle 19c and above, PostgreSQL, MySQL, MongoDB, Cassandra, or Google Spanner.
• Good to have knowledge of cloud-native database solutions (AWS RDS, Aurora, DynamoDB, Google Cloud Spanner, Cosmos DB, etc.).
• Proficiency in performance tuning, query optimization, and indexing techniques.
• Experience with database security principles, encryption, access control, and compliance regulations.
• Knowledge of ETL pipelines, data lakes, and real-time data processing.
• Familiarity with DevOps, automation, and Infrastructure-as-Code tools (Terraform, Ansible, Kubernetes, etc.).