PL/SQL Developer with UNIX

Request ID: 69310-1

Title: PL/SQL Developer with UNIX
Locations: Seattle, WA 
Duration: 6 Months

Salary Range: $45 - $49/Hour on W2 (All inclusive)

Introduction

We are seeking a highly skilled Oracle PL/SQL Developer with UNIX expertise to join our team. This role requires a strong background in Oracle SQL and PL/SQL development, as well as proficiency with UNIX scripting and tools. The position involves working on-site and collaborating with cross-functional teams to optimize and support database operations.

Required Skills & Qualifications

• Minimum 10 years of experience in Oracle SQL and PL/SQL
• Experience with database design principles and data modeling
• Proficiency in Oracle SQL and PL/SQL
• Understanding of database performance tuning and optimization techniques
• Knowledge of database security best practices
• Design, write, and implement robust and efficient Linux KornShell scripts
• Utilize version control systems (e.g., ADO Repos) to manage code changes
• Understanding of CI/CD pipelines and tools
• Strong analytical and problem-solving skills
• Excellent communication and collaboration abilities
• Experience working in SAFe/Agile/Scrum teams
• Prior work experience at client or in client's Industry

Applicants must be able to work directly for Artech on W2.

Preferred Skills & Qualifications

• Domain experience in Discrete / Mfg. Industry / Aero Industry

Day-to-Day Responsibilities

• Design and implement logical data models and Oracle database schemas
• Develop, maintain, and optimize PL/SQL packages, procedures, functions, and triggers
• Write and tune complex SQL queries to ensure optimal performance and data integrity
• Monitor database performance and resolve SQL/PLSQL-related issues through tuning and analysis
• Automate database and system tasks using Linux KornShell scripting and cron scheduling
• Perform data extraction, transformation, and troubleshooting using awk, sed, and grep utilities
• Manage database code using version control (ADO Repos) and support CI/CD deployments
• Assist with database administration activities such as backups, restores, and data migrations
• Maintain runbooks, SOPs, and technical documentation while collaborating with cross-functional teams
• Support application-specific database schemas and objects, including creation and maintenance of tables, indexes, views, and PL/SQL components to meet application requirements
• Optimize application SQL and PL/SQL performance, working closely with development teams to tune queries and resolve application-related database issues
• Manage application-level database operations, including deployments, patch coordination, data integrity, security controls, and ongoing production support

Company Benefits & Culture

• Competitive compensation package
• Comprehensive health and wellness benefits
• Opportunities for professional growth and development

For immediate consideration please click APPLY to begin the screening process with Alex.