Oracle Database Developer

VSolvit is currently seeking an Oracle DBA to support the U.S. Navy -Naval Surface Weapons Center (Corona) ARPA-IT contract. This position will support the Acquisition and Readiness Department.

As an Oracle Database Administrator, you will be responsible for support and improvement of business processes with information technology solutions. You will develop, design, and analyze applications and programs of moderate scope and complexity. Develop stored procedures, triggers and procedures for the solution of a variety of well-defined business reporting problems. Elements of this work will be complex and difficult problems for which you will use your analytical skills to help develop solutions and code need deliver resolutions. You will use elements of your database administration experience to ensure integrity of the customer's databases, transaction processing and reporting systems, security, resource monitoring, reporting, and the development of specialized systems and processes.

Responsibilities

• Troubleshooting and resolving database integrity, performance, blocking/deadlocking, connectivity and security issues


• Professional knowledge of Oracle database development tools


• Database development or support of a large government business application comprising custom developed web applications, commercial off the shelf applications, large government reporting systems and other environments


• Support design and testing of database partitioning and schema options to support the next generation reporting environment


• Support current environment to optimize stability and performance for all transaction processing and daily reporting


• Develop appropriate database backup strategy, establish backup schedules, monitor progress and completion of all jobs, and take corrective actions as necessary.


• Establish and maintain database health/performance/security monitoring routine checks, automates alerts when feasible and takes corrective action as necessary


• Performs Database Security Technology Implementation Guide (STIG) and Information Assurance (IA) validation quarterly and in support of system accreditation


• Keep databases up to date on patches and supports the roll-out of new versions


• Develops and maintains database documentation, including but not limited to System Security Plan, Data Dictionary, Backup Procedures, Job Queue Monitoring


• performs capacity monitoring and short and long-term capacity planning needed to support new projects or enhance existing products


• Take pro-active approach in identifying potential service level problems and notifying appropriate parties.


• Establish and maintain database disaster recovery plan and recovery procedures.


• Perform database recovery as necessary

Basic Qualifications

• 5+ years' experience Oracle Database Administration


• 5+ years' experience performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools


• 1+ years' Experience in Oracle 11g and 12g


• 1+ years' UNIX/Linux System Administrator


• US Citizenship required


• DoD Secret Security Clearance required


• Bachelor's Degree and 5+ years' experience (i.e. bachelor's and 5+ years' experience OR Master's and 3+ years' experience)

Preferred Qualifications

• Experience with Oracle in Azure or AWS Cloud


• MS SQL experience in addition to Oracle experience


• Oracle RAC, ORDS, Data Pump, Wallet, and PL SQL Experience

Company Summary:

Join the VSolvit Team! Founded in 2006, VSolvit (pronounced 'We Solve It') provides geospatial and information technology consulting services and solutions to government and private section clients. VSolvit is an award winning 8(m)/EDWOSB, and SBA-certified 8(a)/SDB company. We offer Medical, Dental, and Vision Insurance, as well as 401K Retirement Plan options, Educational Reimbursement, and other benefits. Our goal is to grow together and enjoy the work that we do as a team.

VSolvit LLC is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.