Zachary Piper Solutions
Join to apply for the
Oracle SQL Developer
role at
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
C/C++ development
Classic ASP VBScript
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
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries IT Services and IT Consulting
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.
Referrals increase your chances of interviewing at Zachary Piper Solutions by 2x
#J-18808-Ljbffr
Oracle SQL Developer
role at
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
C/C++ development
Classic ASP VBScript
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
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries IT Services and IT Consulting
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.
Referrals increase your chances of interviewing at Zachary Piper Solutions by 2x
#J-18808-Ljbffr