Sr Oracle/SQL Developer

Location: Charlotte, NC (Hybrid – 3 days office in a week)

Key Responsibilities: Design, develop, test, and maintain Oracle database solutions and SQL-based applications. Develop complex SQL queries, stored procedures, functions, packages, triggers, and views using PL/SQL.Analyze business and technical requirements and translate them into scalable database solutions. Design and maintain database schemas, tables, indexes, constraints, partitions, and data models. Perform SQL query optimization, execution-plan analysis, indexing, and database performance tuning. Develop and maintain data migration, transformation, and integration processes. Build and support ETL processes using SQL, PL/SQL, and relevant integration tools. Work with application teams to troubleshoot database-related issues and improve application performance. Perform root-cause analysis for production incidents and implement long-term corrective actions. Develop scripts for data validation, reconciliation, cleansing, and reporting. Participate in database upgrades, patching, migrations, and environment refresh activities. Implement database security controls, including roles, privileges, access policies, and sensitive-data protection. Ensure data integrity, availability, scalability, and compliance with organizational standards. Conduct peer reviews of SQL and PL/SQL code and promote development best practices. Create and maintain technical documentation, data dictionaries, process documents, and support procedures. Support unit testing, integration testing, performance testing, and user acceptance testing. Collaborate with DevOps and infrastructure teams to support CI/CD and automated database deployments. Mentor junior developers and provide technical guidance to the development team. Participate in Agile ceremonies, estimation sessions, design reviews, and release planning.