SQL Developer

Pay Rate: $74.00 - $78.00 Negotiable based upon years of experience

Global Financial Firm located in IRVING, TX has an immediate contract opportunity for an experienced SQL Developer

Responsibilities:

• Design, develop, and implement complex SQL and PL/SQL stored procedures, functions, triggers, and packages in an Oracle environment.
• Write and optimize advanced queries, views, and scripts to support application development and data analysis.
• Develop and manage data access layers and backend database logic.
• Design, develop, and manage collections and documents within our MongoDB environment.
• Write efficient and complex queries using the MongoDB Query Language (MQL) and aggregation pipelines.
• Implement and manage indexing strategies to ensure optimal performance for MongoDB collections.
• Create and maintain logical and physical data models for both Oracle (relational) and MongoDB (NoSQL) databases.
• Ensure database designs are scalable, reliable, and meet business requirements.
• Proactively monitor database performance, identify bottlenecks, and implement optimization strategies for both Oracle and MongoDB.
• Analyze query execution plans and tune SQL and MQL queries for maximum efficiency.
• Develop and maintain ETL processes for data migration and integration between Oracle, MongoDB, and other systems.
• Ensure data integrity, consistency, and security across all database platforms.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5-10 years of professional experience as a SQL Developer or in a similar database-focused role.
• Expert proficiency in SQL and Oracle databases, including extensive experience with PL/SQL, stored procedures, functions, and performance tuning.
• Hands-on experience with MongoDB, including a strong understanding of MQL, indexing, and the aggregation framework.
• Proven experience in data modeling for both relational (Oracle) and NoSQL (MongoDB) databases.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex database issues.
• Excellent communication skills and the ability to work effectively in a collaborative team environment.

Preferred Skills:

• Experience with cloud-based database services such as Oracle Cloud, AWS RDS, or MongoDB Atlas.
• Knowledge of ETL tools (e.g., Informatica, Talend, SSIS).
• Proficiency in scripting languages like Python, Bash, or PowerShell for automation.
• Familiarity with Agile/Scrum development methodologies.
• Experience with version control systems, such as Git.
• Knowledge of other database technologies is a plus.