SQL Server Developer

Motion Recruitment Partners LLC.
Irving, United States of America
yesterday

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Irving, United States of America

Tech stack

Data analysis
Backup Devices
Bash
Cloud Database
Databases
Data Integrity
ETL
Data Migration
Data Security
Database Design
Query Languages
Python
Microsoft SQL Server
MongoDB
NoSQL
Oracle
Oracle Applications
Performance Tuning
Powershell
Software Engineering
SQL Stored Procedures
PL-SQL
SQL Databases
SQL Server Integration Services
Talend
Scripting (Bash/Python/Go/Ruby)
Informatica Powercenter
Database Optimization
Database Performance
Indexer
GIT
Amazon Web Services (AWS)
Information Technology
Oracle Cloud Infrastructure
Code Restructuring
Software Version Control

Job description

Grow your career as a SQL Server Developer with an innovative global bank in Irving, TX. Contract role with strong possibility of extension and/or conversion. Will require working a hybrid schedule 3 days onsite per week. Not open to third party employment or sponsorship

Join one of the world's most renowned global banks and trusted brand with over 200 years of continuously evolving financial services worldwide. You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you., * 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.
  • Participate in database design and architecture reviews.
  • 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.
  • Work with development teams to refactor and improve existing database code.
  • 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.
  • Assist with database administration tasks, including backups, restores, and security management.

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.

Desired Skills & Experience

  • 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.

Apply for this position