Database Developer

Who We Are At Solstice Analytics, we run and reimagine the mission-critical technology systems that drive advantage for the world's leading businesses. We are at the heart of progress; with proven expertise and a continuous flow of AI-powered insight, enabling smarter decisions, faster innovation, and a lasting competitive edge. For our people-Solstice Analyticss-that means doing purposeful work that powers human progress. Join us and experience a flexible, supportive environment where your well-being is prioritized and your potential can thrive. The Role Are you passionate about solving complex problems? Do you thrive in a fast-paced environment? Then there's a good chance you will love being a part of our Software Engineering - Development team at Solstice Analytics, where you will be able to see the immediate value of your work. The Database Developer designs, develops, and maintains high-performance database systems. You will write complex PL/SQL queries, optimize database performance, and build secure storage structures to support business applications. Key Responsibilities 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. 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. Your contributions will have a significant impact on our products' success, and you will be part of a team that is passionate about innovation, creativity, and excellence. Above all else, you will have the freedom to drive innovation and take ownership of your work while honing your problem-solving, collaboration, and automation skills. Together, we can make a difference in the world of cloud-based managed services. Your Future at Solstice Analytics Every position at Solstice Analytics offers a way forward to grow your career. We have opportunities that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here. Who You Are You're good at what you do and possess the required experience to prove it. However, equally as important - you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused - someone who prioritizes customer success in their work. And finally, you're open and borderless - naturally inclusive in how you work with others. Required Technical and Professional Experience 1 to 3+ years of database developer experience in 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 database object optimization. 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 database deployment best practices. Strong analytical, troubleshooting, and problem-solving skills. Good collaboration and communication skills to work with cross-functional teams. Preferre