Oracle SQL Developer

Zachary Piper Solutions is seeking an Oracle SQL Developer to join a Federal Program located in Merrifield, VA.

• 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/Web Sphere.
• 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.

• Bachelor’s degree with 7+ years of software development experience.
• Experience supporting ASP/IIS and Java/Eclipse/Web Sphere 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):  / 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.

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

• 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
• Table spaces
• Partitioning
• Materialized Views
• Constraints
• Joins
• Subqueries
• Cursors
• Exception Handling
• Dynamic SQL
• Bulk Collect
• Collections
• 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