Job Summary This role exists to develop, maintain, optimize, and support enterprise database solutions primarily on SQL Server and PostgreSQL platforms while contributing to database reliability, performance, security, and scalability. The role supports business-critical applications and assists in delivering high-quality data solutions that enable organizational growth and digital transformation.

Responsibilities

- Develop and maintain database objects including Stored Procedures, Functions, Views, Triggers, and Scripts in SQL Server and PostgreSQL.
- Create productive database objects based on application and business requirements.
- Support application teams in database design and query development.
- Participate in database deployment activities across Development, UAT, and Production environments.
- Ensure adherence to coding standards and database development best practices.
- Monitor and optimize database performance through indexing, query tuning, and execution plan analysis.
- Troubleshoot performance bottlenecks and production issues.
- Assist in backup, recovery, database maintenance, and housekeeping activities.
- Support database migration and upgrade initiatives.
- Implement database security standards and user access controls.
- Collaborate with application developers, QA teams, DevOps teams, and architects.
- Maintain technical documentation and database deployment artifacts.
- Provide status updates on assigned tasks and ensure timely delivery.
- Continuously learn emerging database technologies and performance optimization techniques.

Key Decisions / Dimensions

- Identifying indexing and query optimization strategies.
- Determining database object design approaches to improve scalability and maintainability.
- Recommending performance tuning and database housekeeping measures.




- Deciding troubleshooting and root-cause analysis approaches for database incidents.
- Suggesting automation opportunities for database monitoring and deployments.

Major Challenges

- Managing large transactional databases while maintaining optimal performance.
- Identifying and resolving complex query performance issues within defined SLAs.
- Supporting multiple database environments and ensuring data integrity.
- Balancing operational support activities with project delivery timelines.
- Adapting to evolving technologies and database modernization initiatives.

Required Qualifications and Experience Qualifications: Strong understanding of Relational Database Management Systems (RDBMS).

Knowledge of Database Design, Data Modeling, SQL Programming, and Performance Optimization.

Understanding of SDLC, Agile methodologies, and DevOps practices.

Exposure to cloud database services will be an added advantage.

Work Experience: Experience should be between 2 to 3 years.

Skills

- Microsoft SQL Server
- PostgreSQL
- SQL Programming
- T-SQL
- PL/pgSQL
- Stored Procedures
- Functions
- Views
- Azure Data Factory (ADF)

Good to Have Skills

- Oracle Database
- Oracle PL/SQL
- SSIS
- CI/CD Pipeline Knowledge

Preferred Domain Experience Financial Services / Banking / Broking

Role: Data warehouse Architect / Consultant, Industry Type: Banking, Department: Engineering - Software & QA, Employment Type: Full Time, Permanent Role Category: DBA / Data warehousing Education UG: Any Graduate PG: Any Postgraduate read more

Key Skills Skills highlighted with ‘‘ are preferred keyskills agile agile methodologiesautomationazureazure data factorybankingbrokingbusiness requirementscloudcloud database servicescoding standardsdata architectdata modelingdatabase designdatabase developmentdatabase maintenance

📌 Senior Delivery Manager - Data Architect (Pune)
🏢 Bajaj Finance
📍 Pune