Senior Database Developer- Oracle

Responsibilities

• Serve as a primary Oracle database development resource, designing, developing, configuring, optimizing, and maintaining database solutions and objects, including packages, procedures, functions, triggers, views, and data structures using PL/SQL and SQL.
• Support Microsoft SQL Server database solutions using T-SQL, including stored procedures, functions, views, and performance-optimized queries. Prior SQL Server experience is beneficial; candidates must be willing to develop proficiency as needed.
• Develop, enhance, and support ETL and data integration solutions using SQL Server Integration Services (SSIS) and related technologies. Prior SSIS experience is preferred but not required.
• Design and implement database and data warehouse solutions, including relational and dimensional data models, to support operational, analytical, and reporting needs.
• Perform data analysis, validation, and reconciliation to ensure data accuracy, completeness, consistency, and integrity across systems.
• Troubleshoot and resolve complex Oracle and other database, ETL, integration, query, and performance issues across production and non-production environments.
• Participate throughout the full Software Development Life Cycle—including requirements analysis, design, development, testing, deployment, documentation, maintenance, and production support—using Agile and Waterfall delivery approaches.
• Contribute to AI-enabled data solutions and integration initiatives using iPaaS and other modern technologies for data orchestration, system connectivity, and automation, with a willingness to learn and apply emerging technologies.
• Ensure database solutions comply with organizational standards for security, privacy, regulatory compliance, performance, availability, and scalability, while following established IT policies, development standards, change-management procedures, and service-level agreements.
• Conduct code reviews and provide technical guidance, knowledge sharing, and mentoring to junior and mid-level developers.
• Communicate effectively with technical and non-technical stakeholders, translating business requirements into practical, reliable, and supportable technical solutions.
• Perform other related duties as assigned.