About This Role
Leading the design, development, and maintenance of enterprise database solutions is the core of this role. It suits a candidate with strong experience in SQL and NoSQL databases, focusing on performance, scalability, and secure integrations, who can also mentor other developers.
Responsibilities
- Lead the design, development, and maintenance of enterprise database solutions using MS SQL Server and NoSQL databases
- Design and develop complex stored procedures, functions, packages, triggers, and views to support business-critical applications
- Build and optimize large, complex business logic within database objects while ensuring performance and scalability
- Perform SQL query tuning, execution plan analysis, indexing, and database performance optimization
- Integrate databases with internal and external APIs and third-party systems
- Support secure payment gateway integrations by managing transaction processing and database interactions
- Design and maintain ETL processes, data migration, and data synchronization activities
- Perform database code reviews and ensure adherence to coding standards and best practices
- Troubleshoot database performance issues and production incidents
- Mentor database developers and provide technical guidance
Requirements
- B.Tech/M.Tech in Computer Science or others/MCA
- 8+ years of experience in the IT Industry
- Proven experience leading development teams and maintenance of enterprise databases
- Strong expertise in SQL PL/SQL, including Stored Procedures, Functions, Packages, Triggers, Cursors, Collections, Dynamic SQL, and Exception Handling
- Experience with NoSQL databases such as MongoDB, Cassandra, or Cosmos DB
- Expertise in SQL query optimization and database performance tuning
- Experience handling high-volume transactional databases
- Experience integrating databases with REST APIs and external systems
- Experience supporting payment gateway integrations and transaction management
- Strong understanding of relational database design, normalization, and indexing strategies
- Knowledge of database security, backup, recovery, and auditing
Nice to have:
- Experience with SQL Performance Tuning tools (SQL Profiler, Execution Plan)
- Exposure to Azure SQL Database
- ETL tools and data migration experience
- Experience with version control and deployment processes for database objects
