Sr Oracle/SQL Developer

Charlotte, NC, US • Posted 1 hour ago • Updated 1 hour ago
Full Time
On-site
USD $45.00 - 50.00 per hour
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Oracle SQL Developer
  • Database Performance Tuning
  • Root Cause Analysis
  • Scripting
  • Reporting
  • Migration
  • Database Security
  • Data Security
  • Data Integrity
  • Scalability
  • Regulatory Compliance
  • Technical Writing
  • Unit Testing
  • Integration Testing
  • Performance Testing
  • Acceptance Testing
  • Collaboration
  • DevOps
  • Continuous Integration
  • Continuous Delivery
  • Mentorship
  • Agile
  • Estimating
  • Design Review
  • Computer Science
  • Information Technology
  • PL/SQL
  • Stored Procedures
  • RDBMS
  • Normalization
  • Data Modeling
  • Database Design
  • Oracle
  • Performance Tuning
  • Optimization
  • Statistics
  • Management
  • SQL
  • Version Control
  • Release Management
  • Analytical Skill
  • Data Migration
  • Extract
  • Transform
  • Load
  • Data Validation
  • Database
  • Development Testing

Summary

Role: 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.

Required Qualifications
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • 8+ years of experience in Oracle database development and SQL programming.
  • Strong hands-on experience with Oracle SQL and PL/SQL.
  • Proven experience developing:
    • Stored procedures
    • Functions
    • Packages
    • Triggers
    • Views
    • Materialized views
    • Cursors
    • Dynamic SQL
  • Strong understanding of relational database concepts, normalization, data modeling, and database design.
  • Experience with Oracle performance tuning, including:
    • Explain plans
    • Index optimization
    • Query rewrites
    • Table partitioning
    • Statistics management
    • SQL profiling
  • Experience with database development lifecycle, version control, deployment, and release management.
  • Strong knowledge of joins, subqueries, analytical functions, common table expressions, aggregations, and set-based processing.
  • Experience with data migration, ETL, data validation, and reconciliation processes.
  • Experience troubleshooting database issues in development, testing, and production environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTX1d6413
  • Position Id: cc767098048f2b4bb6022bc07de98bd8
  • Posted 1 hour ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.