Source description
About the role
Required Skills & Competencies: Lead the design, development, and maintenance of enterprise database solutions using Oracle PL/SQL, MS SQL Server, and NoSQL, COSMOS 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. Required Technical Skills Strong expertise in Oracle PL/SQL, including: Stored Procedures Functions Packages Triggers Cursors Collections Dynamic SQL 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. Preferred Skills Experience with Oracle Performance Tuning tools (AWR, ASH, Explain Plan). Exposure to Azure SQL Database or Oracle Cloud databases. ETL tools and data migration experiences Experience with version control and deployment processes for database objects. Required Educational Qualification: B.Tech/M.Tech in Computer Science or others/MCA. Required Experience: He/She must have 8+ years of experience in IT Industry Proven experience leading development teams and Maintenance of enterprise databases Required Skills & Competencies: Lead the design, development, and maintenance of enterprise database solutions using Oracle PL/SQL, MS SQL Server, and NoSQL, COSMOS 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. Required Technical Skills Strong expertise in Oracle PL/SQL, including: Stored Procedures Functions Packages Triggers Cursors Collections Dynamic SQL 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. Preferred Skills Experience with Oracle Performance Tuning tools (AWR, ASH, Explain Plan). Exposure to Azure SQL Database or Oracle Cloud databases. ETL tools and data migration experiences Experience with version control and deployment processes for database objects. Required Educational Qualification: B.Tech/M.Tech in Computer Science or others/MCA. Required Experience: He/She must have 8+ years of experience in IT Industry Proven experience leading development teams and Maintenance of enterprise databases
More at Trigyn