SQL Developer
Maintec Technologies
ROLE: - SQL developer
LOCATION: - Pittsburgh, PA, 240 Greenwich office, NYC, Lake Mary, FL
DURATION: - Long term contract on W2/FTE
MUST SKILLS: - knowledge of SQL, different database technologies, SQL tuning and optimization The Opportunity
As a part of Reference data modeling team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design and architectural components support the deployment of projects.
Your key responsibilities
LOCATION: - Pittsburgh, PA, 240 Greenwich office, NYC, Lake Mary, FL
DURATION: - Long term contract on W2/FTE
MUST SKILLS: - knowledge of SQL, different database technologies, SQL tuning and optimization The Opportunity
As a part of Reference data modeling team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design and architectural components support the deployment of projects.
Your key responsibilities
- Design, implement and manage the SQL queries to be consumed by multiple stakeholders.
- Detect and resolve data quality and integrity issues in the dataset.
- Enhance or create new logical and physical data model to meet business needs, applying data modeling standards and naming conventions.
- Apply data modeling techniques to ensure development and implementation meets performance expectations.
- Test and debug the deliverable code to ensure they function correctly.
- Develop data mapping from existing systems to the new data structures.
- Experience in data migration using the industry standard tools.
- Experience in SQL tuning and optimization using explain plan and trace files.
- Partitioning and indexing strategy for optimal performance
- Must have a good verbal and written communication skill with strong interpersonal, analytical, and problem-solving abilities.
- Experience in understanding complex source system data structures preferably in Financial Services
- Ability to work with minimal guidance in a time critical environment.
- Work with business stakeholders and Agile scrum teams on design, definition, documentation, and implementation of features for new applications and data structure
- 8+ years of experience working in different database technologies
- Strong hands on knowledge of SQL
- Apply data modeling techniques to ensure development and implementation meets performance expectations.
- Run query plans, query tuning and schema refinement.
- Help with database migrations and building database scripts
- Work with change and release management teams
- Experience with CI/CD and Liquibase is a plus
- Experience with cloud platforms (Snowflake) is a plus
- Strong analytical and problem solving skills.
- A self-starter, independent thinker with ambition and passion
- Excellent inter-personal, communication, collaboration and presentation skills
- Takes responsibility for continuous self-learning.
- Takes the lead and make decisions in critical times and tough circumstances.
- High level of integrity and honesty.
- Ensure deliverables are up to a quality standards at the end of each sprint
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the SQL Developer in Pittsburgh, PA vacancy
- ...SQL Server Developer/Administrator Role Name: SQL Server Developer/Administrator Location: Pittsburgh PA Duration: 6 To 12 Months Need GC/USC/H1B Job Description: Maintain and enhance reporting systems in a manufacturing environment utilizing development...SuggestedH1b
- ...Job Title: Oracle PL /SQL Developer Location: Pittsburgh, PA Job Description: Minimum 6+ years Experience in product development Having good IT experience as an ORACLE PL/SQL Developer, involved in Requirement Gathering, Analysis, Design, Development, Unit...Suggested
- ...need to be able to meet with LOB to go over requirements and gather any additional information needed to complete data request Use SQL to gather all of the necessary data needed in order to meet the request Create documentation related to request, including SQL,...SuggestedFlexible hours
$65 - $70 per hour
Position: Oracle PL/SQL with Apex Front End Location: Pittsburgh, PA (Remote) Duration: 6 Months Plus Rate: $65-70/hr Job Description: Should have good hands on experience in PL/SQL and Oracle Apex Front end. Worked in Onsite...SuggestedRemote work- ...Database Developer Location: Pittsburgh, PA Onsite Hire mode Role Overview: The Database Developer will design, develop, and maintain... ...to meet application requirements. Develop and optimize SQL queries, stored procedures, and triggers for high performance....Suggested
- ...Title Required Skills: Expertise in Python programmer to help develop and maintain a multiplatform web API and services Expertise in Flask framework Hands on experience using Python Flask SQL Alchemy and Flask Blueprints Efficient coding is important to...
- ...Positions: 2 Location: Pittsburgh, PA (Locals only, Day 1 Onsite). Mandatory Skills: Python, Pyspark, Financial Risk Modeling, SQL. Job Description : 9-10 years of experience Good Proficiency in Python pyspark Good proficiency in Financial Risk modelling...Local area
- ...Java Kafka Developer Pittsburgh, PA Contract. Role Description: Developer (Java | Kafka Streaming)We are looking for... ...Connect, Schema registry,have experience with Oracle database (SQL/PL-SQL),are a team player who works well collaborating with others...Contract workImmediate start
- ...Informatica Developer Pittsburgh, PA Fulltime Must Have Technical/Functional Skills: Proficiency with Informatica tools... ...(e.g., PowerCenter). Strong knowledge of ETL processes. SQL and database concepts Scripting (Unix, Python). Troubleshooting...Full time
- ....Net Developer Job title: .Net Developer Location: Pittsburg, PA Duration: Long Term Interview: Skype (Only one round) Required skills... ..., Java script, Ajax, jQuery, ADO.NET. Experience developing SQL Server programming experience (Stored Procedures, Functions, and...
- ...C++ Developer Pittsburgh, PA Long Term W2 only, no C2C Success Criteria: The successful Senior Software... ...or other Agile processes Experience Java, JavaScript, Electron, Motif, Qt SQL database data modeling and interaction...
- ...other Java web frameworks. • Database Knowledge: Proficiency in SQL (e.g., PostgreSQL, MySQL) and ORM technologies. • Web... ...storage using SQL or NoSQL databases. • System Architecture: Developing high-volume, low-latency applications that are secure and scalable...
- ...Client Job ID-ACSLL8P33 Job Title: Python Developer (look for nearby or open to relocate) Location: Pittsburgh, PA (2-3 days onsite... ...such as HTML, CSS, JavaScript 2 Strong understanding of LDAP, SQL and relational databases 3 Good understanding of: Web...Contract workRelocation2 days per week3 days per week
- ...Pittsburgh, PA Duration: W2 Job Description: We are specifically looking for developer with the following skillset. Please share profiles matching this requirement. .Net, C#, Angular, SQL, Microservices Required Skills: Strong knowledge of programming concepts in...Full timeWork visa
- ...Role: SAS Developer Location: Pittsburgh, PA - 100% onsite Contract Requested experience: 10 & Above Skills: SAS, ETL, SQL Description: • Proficiency in Base SAS, SAS Macro, PROC SQL, data steps, and proc steps for data manipulation, creation, and...Contract work
- ...Team Lead Developer This role combines technical expertise with leadership skills. Developers in the Team Lead position will lead a dev... ...storage solutions and schemas utilizing cloud technologies including SQL DBs, Document DBs, and unstructured data ~ Experience with...Temporary workWork experience placement
- ...Junior Java Software Developer Oxford Solutions is working with a client in the East Hills area of Pittsburgh, PA to hire a Junior Java... ...maintenance, and production support. The work will center around Java, SQL, Linux-based systems, legacy code cleanup, system maintenance,...Work at officeRemote work
$100k - $120k
...Power BI Developer Location: Pittsburgh PA / Strongsville OH Duration: Fulltime Salary: $100,000-$120,000/Year Must Have Technical... ...BI Proficiency in DAX, Power Query, Data models Strong SQL skills and experience with various databases. Strong...Full time- ...Job Title : Java Backend Developer Location : Pittsburgh, PA Duration : Full-time Job Description: We are looking for... .... Ensure optimal database design and integration with SQL/NoSQL databases . Work with DevOps teams to optimize CI/CD pipelines...Full time
- ...Dot Net Developer Location: Pittsburgh, PA Duration: Fulltime Job Description: Skills Desired: Strong hands-on experience... ..., SOLID principles, RESTful APIs) Extensive experience with SQL Server, including performance tuning and database design Proven...Full time
- ...solutions company based in Coraopolis is seeking a Sr.Net Fullstack Developer for a 6+ month contract. The ideal candidate will have over 4... ..., C#, AngularJS, and relational databases, preferably MS SQL. The role requires a good understanding of Object-Oriented Design...Contract work
- ...Have Technical/Functional Skills: Languages: COBOL, JCL, SQL, PL/I. Databases: DB2, VSAM. Environments: CICS, IMS,... ...COBOL, PL/I, Assembly, etc., using tools like CICS and IMS. Develop and maintain batch jobs (JCL) and online transaction processing...
- ...Job Description: Role name: Java API Developer Pittsburgh, PA onsite Contract. Role Description: Around 9 Years... ...WebSphere, JBoss, WebLogic. Database : MySQL, Oracle, MS Access, SQL, MongoDB, DB2. Libraries and Tools : Maven, JQuery. Web...Contract workImmediate start
- ...know if you are available for this role. Title: Informatica Developer Location: Pittsburgh, PA Duration: Fulltime... ....g., PowerCenter). Strong knowledge of ETL processes. SQL and database concepts. Scripting (Unix, Python). Troubleshooting...Full timeImmediate startRelocation
$600 per week
...pathway for motivated learners to gain real-world experience while developing technical skills through immersive training. Whether you're... ...the following languages: Java, Python, C, C#, C , JavaScript, R, SQL, MATLAB, Mathematica, TypeScript, Shell scripting, Go, or...Hourly payWork experience placementH1bImmediate startRelocationWork visaRelocation package$70.8k - $156.7k
...Senior Salesforce Developer We are seeking an experienced Sr Salesforce Developer to oversee the design, development, and implementation... ...computer development software as it relates to systems, such as SQL, VisualBasic, etc. Other Information: CGI is required...Permanent employmentWork at office- ...Job Title - Snowflake Developer Duration - 12+ Months (Contract) Location - Pittsburgh, PA Pay Range - $60/hr -... ...experience in DWH area who can work independently Strong hands on SQL skills/ Stored procedures / writing complex queries Good...Contract work
- ...Senior Cobol Developer We are seeking a highly experienced Senior Cobol Developer to join our technology team at a large retail bank.... ...application development ~ Strong proficiency in: Cobol, CICS, DB2 (SQL, stored procedures, performance tuning) ~ Operating systems:...Permanent employmentFull timeContract workLocal area
- ...Python Data Engineer Strong Python and SQL skills, ETL development experience with Microsoft SSIS, and familiarity with Agile... ...large-scale datasets to ensure reliable data integration. Develop and manage workflows in Microsoft SSIS . Collaborate with...Contract workLocal area
$120k - $150k
...work hands-on with the full AI CTRL stack alongside a team of AI developers. Deep AI research background isn't required — bring your... ...consumption and light API development (FastAPI or equivalent) ~ SQL fundamentals — can write queries for reporting and Retool data...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to SQL Developer. Be the first to apply!

