Zachary Piper Solutions
Zachary Piper Solutions is seeking an Oracle SQL Developer to join a Federal Program located in Merrifield, VA.
Responsibilities
Optimize Oracle databases using PL/SQL scripting, SQL tuning, and routine maintenance.
Develop and maintain Unix/Linux shell scripts for automation and operational tasks.
Support and maintain legacy applications built on ASP/IIS and Java/Eclipse/WebSphere.
Apply knowledge of data structures and algorithms to improve code efficiency.
Utilize source control tools (Git, SVN) for collaborative development.
Perform full software lifecycle activities: analysis, design, development, testing, deployment, and troubleshooting production issues.
Optional tasks may include working with .NET, C++, ASP, or Perl for web components or integrations.
Qualifications
Bachelor’s degree with 7+ years of software development experience.
Experience supporting ASP/IIS and Java/Eclipse/WebSphere applications.
Oracle database development expertise (PL/SQL scripting, SQL optimization, database maintenance).
Proficiency in Unix/Linux shell scripting.
Strong understanding of computer data structures and algorithms.
Experience with source control software (Git, Subversion, etc.).
Optional skills (a plus): VB.NET / C# .NET development.
Optional skills (a plus): C/C++ development.
Optional skills (a plus): Classic ASP, VBScript, or Perl scripting.
Ability to perform software development, testing, and provide support across all phases of the software lifecycle.
Windows experience.
Strong analysis and design capabilities.
In-depth knowledge of software engineering techniques and concepts.
Excellent oral and written communication skills.
Ability to work independently or as part of a development team.
Capability to troubleshoot and resolve production issues.
Must be able to obtain a Public Trust.
Compensation
Salary Range: $85,000 – $100,000 depending on experience.
Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays.
Keywords
Oracle
PL/SQL
SQL
Database Development
SQL Optimization
Query Tuning
Stored Procedures
Functions
Triggers
Packages
Views
Indexing
Performance Tuning
Data Modeling
ER Diagrams
Normalization
Relational Databases
Oracle 12c
Oracle 19c
Oracle Cloud
SQL Loader
Data Migration
Data Integration
ETL
Unix
Linux
Shell Scripting
Bash
Automation Scripts
Database Maintenance
Backup and Recovery
RMAN
Data Security
User Management
Roles and Privileges
Tablespaces
Partitioning
Materialized Views
Constraints
Joins
Subqueries
Cursors
Exception Handling
Dynamic SQL
Bulk Collect
Collections
Ref Cursors
JDBC
ODBC
API Integration
Git
SVN
Source Control
Agile
Waterfall
SDLC
Testing
Debugging
Troubleshooting
Performance Analysis
Query Execution Plans
Explain Plan
Data Structures
Algorithms
Zachary Piper Solutions
#J-18808-Ljbffr
Responsibilities
Optimize Oracle databases using PL/SQL scripting, SQL tuning, and routine maintenance.
Develop and maintain Unix/Linux shell scripts for automation and operational tasks.
Support and maintain legacy applications built on ASP/IIS and Java/Eclipse/WebSphere.
Apply knowledge of data structures and algorithms to improve code efficiency.
Utilize source control tools (Git, SVN) for collaborative development.
Perform full software lifecycle activities: analysis, design, development, testing, deployment, and troubleshooting production issues.
Optional tasks may include working with .NET, C++, ASP, or Perl for web components or integrations.
Qualifications
Bachelor’s degree with 7+ years of software development experience.
Experience supporting ASP/IIS and Java/Eclipse/WebSphere applications.
Oracle database development expertise (PL/SQL scripting, SQL optimization, database maintenance).
Proficiency in Unix/Linux shell scripting.
Strong understanding of computer data structures and algorithms.
Experience with source control software (Git, Subversion, etc.).
Optional skills (a plus): VB.NET / C# .NET development.
Optional skills (a plus): C/C++ development.
Optional skills (a plus): Classic ASP, VBScript, or Perl scripting.
Ability to perform software development, testing, and provide support across all phases of the software lifecycle.
Windows experience.
Strong analysis and design capabilities.
In-depth knowledge of software engineering techniques and concepts.
Excellent oral and written communication skills.
Ability to work independently or as part of a development team.
Capability to troubleshoot and resolve production issues.
Must be able to obtain a Public Trust.
Compensation
Salary Range: $85,000 – $100,000 depending on experience.
Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays.
Keywords
Oracle
PL/SQL
SQL
Database Development
SQL Optimization
Query Tuning
Stored Procedures
Functions
Triggers
Packages
Views
Indexing
Performance Tuning
Data Modeling
ER Diagrams
Normalization
Relational Databases
Oracle 12c
Oracle 19c
Oracle Cloud
SQL Loader
Data Migration
Data Integration
ETL
Unix
Linux
Shell Scripting
Bash
Automation Scripts
Database Maintenance
Backup and Recovery
RMAN
Data Security
User Management
Roles and Privileges
Tablespaces
Partitioning
Materialized Views
Constraints
Joins
Subqueries
Cursors
Exception Handling
Dynamic SQL
Bulk Collect
Collections
Ref Cursors
JDBC
ODBC
API Integration
Git
SVN
Source Control
Agile
Waterfall
SDLC
Testing
Debugging
Troubleshooting
Performance Analysis
Query Execution Plans
Explain Plan
Data Structures
Algorithms
Zachary Piper Solutions
#J-18808-Ljbffr