SQL Server / Oracle Developer

Visionary Innovative Technology Solutions LLC
Raleigh, NC, United States
4 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Amazon Web Services Data Analysis Automation of Tests Microsoft Azure Big Data Databases System Configuration Continuous Integration Data Integration Extract Transform Load (ETL) Data Mining
+25 more
Relational Databases Database Development Database Queries Python (Programming Language) Microsoft SQL Server Oracle Databases Oracle (Applications) Oracle SQL Developer Windows PowerShell Scrum Methodology Query Optimization Regression Testing Software Configuration Management Software Engineering SQL Stored Procedures PL-SQL SQL Databases Software Licensing Freeform SQL Enterprise Software Applications Database Optimization Git Data Analytics Data Management Jenkins

Job description

We are seeking an experienced SQL Server / Oracle Developer with PowerShell expertise to join an Agile development team responsible for designing, developing, configuring, and supporting enterprise software solutions. The ideal candidate should have strong hands-on experience with SQL Server, Oracle PL/SQL, database development, PowerShell scripting, data analysis, and software configuration., * Design, develop, and configure enterprise software solutions within an Agile environment.

  • Develop and maintain database solutions using SQL Server and Oracle.
  • Write complex SQL queries, stored procedures, functions, triggers, and PL/SQL programs.
  • Perform data mining, analysis, reconciliation, and validation across SQL Server and Oracle databases.
  • Develop automation scripts using PowerShell for application and database-related processes.
  • Analyze large datasets and identify trends, inconsistencies, and potential issues.
  • Work with Starburst Enterprise / Trino or similar data integration and analytics platforms.
  • Design and implement data-driven solutions based on business and technical requirements.
  • Perform functional, integration, and regression testing.
  • Troubleshoot application, database, and data-related issues.
  • Conduct technical research, prototyping, and proof-of-concept activities.
  • Evaluate new tools, technologies, and components to improve existing solutions.
  • Perform technical impact analysis for complex features and enhancements.
  • Ensure development and engineering approaches align with overall enterprise architecture.
  • Collaborate with developers, QA engineers, architects, product owners, and business stakeholders.
  • Prepare technical documentation and communicate solutions effectively.
  • Participate in Agile ceremonies including sprint planning, stand-ups, reviews, and retrospectives.
  • Identify opportunities for process improvement, automation, risk reduction, and quality enhancement., * Starburst Enterprise
  • Trino
  • Data Mining
  • Data Analytics
  • ETL / Data Integration
  • PowerShell Automation
  • Python
  • Git
  • Jenkins / CI/CD
  • Azure / AWS
  • Database Performance Tuning
  • Software License Management / Compliance
  • Regression Testing
  • Automated Testing

Requirements

The candidate should be comfortable working independently, researching technical problems, evaluating new technologies, and developing innovative solutions for complex data and application requirements., * 5+ years of experience in software development, configuration, or database development.

  • Strong hands-on experience with SQL and relational databases.
  • Strong Oracle PL/SQL development experience.
  • Experience with Microsoft SQL Server.
  • Strong knowledge of:
  • Stored Procedures
  • Functions
  • Views
  • Complex Queries
  • Joins
  • CTEs
  • Query Optimization
  • Hands-on experience with PowerShell scripting and automation.
  • Experience with database performance tuning and troubleshooting.
  • Strong analytical and problem-solving skills.
  • Ability to independently research and develop technical solutions.
  • Experience working in an Agile/Scrum environment.
  • Strong communication and technical documentation skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

1:02 min

Applying an ETL methodology to infrastructure configuration management

Axel Barbier · World Congress 2023

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

57 sec

Extracting API schemas automatically during continuous integration builds

Axel Barbier · World Congress 2023

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all