Key skills
AWSAzureCloudDockerKubernetesMicroservicesMS SQL ServerOraclePostgresSDLCSOAPSQLPostgreSQLSQL ServerGitVersion ControlPerformance OptimizationAgileScrumCI/CDCommunication
About this role
Role Overview
- Develop, optimize, and maintain database code for Oracle and MS SQL Server platforms to support application requirements.
- Perform index rebuilds, update statistics, and optimize schema structures to maintain database performance and efficiency.
- Monitor database growth, fragmentation, and query performance; provide recommendations for improvements and risk mitigation.
- Review, analyze, and optimize complex SQL queries using execution plans, indexing strategies, and query rewriting techniques.
- Design, manage, and maintain database objects including tables, views, indexes, sequences, and triggers.
- Develop and maintain stored procedures, functions, and packages to support evolving business and application needs.
- Manage database indexing strategies in coordination with application teams to ensure optimal query execution.
- Implement data archival, purging, and retention strategies to ensure database efficiency and compliance.
- Perform cleanup of unused or obsolete database objects to maintain a lean database environment.
- Assess and validate database changes (schema updates, code changes) to identify downstream impacts and avoid production issues.
- Coordinate database changes during SDLC, Agile, and DevOps release cycles
- Analyze database resource utilization and support capacity planning to meet future data growth and performance needs.
- Perform impact analysis for schema modifications and application enhancements.
- Perform root cause analysis (RCA) for database-related issues and implement permanent fixes to prevent recurrence.
- Collaborate with System DBA and application teams for deployments, releases, and performance improvements.
- Ensure compliance with regulatory and audit requirements related to enterprise data management.
Requirements
- Strong hands-on experience with Out Systems platform (Reactive Web, Mobile Apps, and Traditional Web).
- 5
- 7 Years of Out systems Developer Experience
- Solid Expertise in: Low-code development concepts and Out Systems architecture (4-layer canvas, modular design) Application Lifecycle Management (ALM) using Lifetime Integration patterns (REST / SOAP APIs, external systems) Data modeling, aggregates, SQL nodes, and relational database concepts Error handling, performance optimization, and debugging techniques API integrations and microservices-based architectures SQL and relational databases (PostgreSQL, SQL Server, Oracle) DevOps practices, CI/CD pipelines, and version control tools (Git)
- Working in Agile/Scrum delivery model
- Cloud platforms (Azure / AWS) and containerized environments (Docker/Kubernetes) (good to have)
- Security standards and compliance requirements in banking/financial services
- Strong problem-solving skills, analytical mindset, and ability to work independently.
- Good communication skills and ability to collaborate across cross-functional teams.
Tech Stack
- AWS
- Azure
- Cloud
- Docker
- Kubernetes
- Microservices
- MS SQL Server
- Oracle
- Postgres
- SDLC
- SOAP
- SQL
Benefits
- Flexible, supportive environment
- Opportunities for hands-on experience and learning
- Chance to certify in major platforms
- Financial, mental, physical, and social health support