SQL/ MongoDB Developer

SQL/ MongoDB DeveloperLocation: Irving, TXEmployment Type: Contract - 3 Days Onsite RequiredW2 or IC only - Not open for 3rd Party or any visa sponsorships Interview Process - In Person Only required in Irving Tx Contract can be 1-2 yr long - 3 days onsite required in Irving Tx Please email resume in word format to View email address on click.appcast.io with • Your Current location ( City / State) - • Would you need visa transfer in future – • Can you work on our W2 –Summary• Senior SQL Developer with 5-10 years of professional experience • The ideal candidate will have deep expertise in both Oracle and MongoDB environmentsSQL Development• Hands on with 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.MongoDB Development• 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.Required Qualifications• 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.Skills• Data Modeling and Design: Create and maintain logical and physical data models for both Oracle (relational) and MongoDB (NoSQL) databases. • Performance Tuning and Optimization: implement optimization strategies for both Oracle and MongoDB. • Data Management and Integration: Develop and maintain ETL processes for data migration and integration between Oracle, MongoDB, and other systems.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.