Database Developer

This is a fully remote position, open to applicants in India.

📋 Description

• Design, develop, and maintain high-performance database systems.

• Write complex PL/SQL queries, optimize database performance, and create secure storage structures to support business applications.

• Develop, optimize, and maintain database code for Oracle and MS SQL Server platforms to meet application requirements.

• Execute index rebuilds, update statistics, and optimize schema structures to ensure database performance and efficiency.

• Monitor database growth, fragmentation, and query performance; provide recommendations for enhancements 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 collaboration with application teams to ensure optimal query execution.

• Implement data archival, purging, and retention strategies to maintain database efficiency and compliance.

• Clean up unused or obsolete database objects to sustain a streamlined database environment.

• Assess and validate database changes (schema updates, code changes) to identify downstream impacts and prevent production issues.

• Coordinate database changes during SDLC, Agile, and DevOps release cycles.

• Analyze database resource utilization and support capacity planning to accommodate future data growth and performance needs.

• Perform impact analysis for schema modifications and application enhancements.

• 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

• 1 to 3+ years of database developer experience in the banking or BFSI domain.

• Strong hands-on development experience with Oracle PL/SQL and Microsoft SQL Server (T-SQL) – mandatory.

• Good working knowledge of database design, data modeling, and normalization techniques.

• Strong expertise in SQL query optimization, execution plan analysis, and performance tuning.

• Experience in developing and managing stored procedures, functions, triggers, and packages.

• Exposure to MySQL, PostgreSQL, and MongoDB databases.

• Understanding of indexing strategies, partitioning, and optimization of database objects.

• Experience in handling large datasets, data archival, and data lifecycle management.

• Knowledge of data retention policies, compliance, and data governance practices.

• Experience working in Unix/Linux/Windows environments.

• Familiarity with version control, release processes, and best practices for database deployment.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Good collaboration and communication skills to work with cross-functional teams.

🏝️ Benefits

• Flexible, supportive environment.

• Well-being is prioritized.

• Opportunities that won’t be found anywhere else.

• Hands-on experience.

• Learning opportunities.

• Certification in all four major platforms.

• Access to cutting-edge learning opportunities.