Database Administrator III and IV (Contingent) - Remote

iWorks Corporation; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a skilled Database Performance Engineer to enhance its Target State Architecture. This exciting role involves optimizing Oracle databases, implementing materialized views, and supporting application deployment in modern server environments. The ideal candidate will possess strong expertise in database performance tuning and query optimization, contributing to innovative solutions for federal clients. Join a forward-thinking company that values continuous improvement and offers a comprehensive benefits package, including bonuses and opportunities for growth. If you're passionate about data and technology, this position is a perfect fit for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401(k)

Profit Sharing

Health and Wellness Benefits

Paid Sick Time

Vacation Time

Holiday Time

Qualifications

• 3-8 years of relevant experience in database administration and performance tuning.
• Must maintain a Secret security clearance or higher.

Responsibilities

• Define data capture requirements and optimize Oracle database performance.
• Support application re-platforming and deploy test applications.

Skills

Database Performance Tuning

Query Optimization

Application Deployment

Oracle Database Administration

Data Capture & Metrics Definition

Concurrency & Resource Locking

Education

Degree in Computer Science

Security+ CE Certification

Tools

Oracle 12c/19c/21c

PL/SQL

SQL

Oracle Cloud Infrastructure (OCI)

Job description

Title: Database Administrator III and IV (Contingent)

Location: Remote

About iWorks:

iWorks Corporation, founded in 2005, is a leading provider of information technology and professional services to the federal government. We are a recognized leader in personnel security and vetting solutions, Agile, DevOps, DevSecOps, data analytics, and cloud solutions. Our continuous process improvement approach, combined with our business and technology expertise, results in innovative solutions.

We offer exceptional comprehensive benefits (Medical, Dental, Vision, Life and Disability); 401(k); Profit Sharing; Health and Wellness Benefits; and Paid Sick Time, Vacation Time, and Holiday Time. You're eligible for bonuses throughout the year as part of our incentive program for innovation, and business development. All employees are also considered for an annual raise, commensurate with performance and company commitment.

About this position: We are seeking a skilled Database Performance Engineer to support the development and optimization of our Target State Architecture (TSA). This role involves defining data capture requirements, creating tools and configurations for data collection, and analyzing production data. Responsibilities include Oracle database performance tuning (PL/SQL, SQL, and schema optimization), implementing materialized views for complex queries, and transitioning database audits to flat files. Additionally, you will assist in re-platforming applications onto a lightweight application server, deploying test applications in the new environment, and identifying resource locking and concurrency controls.

Ideal candidates will have strong expertise in database performance tuning, query optimization, and application deployment in modern server environments.

Experience Levels:

• Database Administrator III: 3-5 years of relevant experience
• Database Administrator IV: 5-8 years of relevant experience

Salary Range: 90k - 130k - commensurate with candidate's skills, experience, location, and qualifications.

On a day-to-day basis you will:

1. Define Data Capture Requirements: Identify key data points necessary for analysis, performance monitoring, and optimization. Establish criteria for data collection to ensure accuracy and relevance.
2. Develop Target State Architecture (TSA): Design and document the future-state architecture with a clear approach to data metrics, correlation, and performance measurement.
3. Create Tool Commands & Configurations: Develop scripts, configurations, and automation tools to streamline data capture and analysis.
4. Capture & Analyze Production Data: Gather real-time production data, monitor system performance, and identify trends or potential bottlenecks.
5. Optimize Oracle Database Performance: Perform PL/SQL, SQL, and schema code tuning to enhance database efficiency, reduce query execution time, and improve overall performance.
6. Implement Materialized Views: Design and deploy materialized views to optimize and accelerate complex queries, improving data retrieval speed.
7. Migrate Database Audits to Flat Files: Transition database audit logs from internal storage to flat files for improved efficiency and easier data management.
8. Support Application Re-Platforming: Assist in migrating applications to a lightweight application server to improve scalability and performance.
9. Deploy & Test Applications in a New Environment: Set up, configure, and validate applications in the new application server environment to ensure stability and functionality.
10. Identify & Address Resource Locking & Concurrency Issues: Analyze and resolve database locking and concurrency challenges to prevent performance degradation and ensure system reliability.

Required Education/Qualifications:

• Clearance: MUST be fully adjudicated & maintain a Secret security clearance or higher.
• Certifications: Security+ CE required
  • Oracle Cloud Infrastructure (OCI) Certified Architect Associate/Professional preferred
• Education: Degree in Computer Science or an equivalent major.
• Oracle Database Administration - Hands-on experience managing Oracle 12c/19c/21c in enterprise environments.
• Performance Tuning & Optimization - Expertise in AWR, SQL Execution Plan analysis, PL/SQL tuning, and schema code cleanup.
• Data Capture & Metrics Definition - Define data types, metrics, and data correlation approaches for Target State Architecture (TSA).
• Materialized Views Implementation - Optimize complex queries using materialized views.
• Database Auditing & Logging - Migrate database audit logs to flat files for efficiency.
• Data Access & Schema Management - Support middleware development teams with schema versioning, DDL/DML code review, and data access administration.
• Concurrency & Resource Locking - Identify and resolve resource locking and concurrency issues.
• Re-platforming & Testing - Assist in re-platforming to a lightweight application server and deploying test applications.

Preferred Qualifications:

• Oracle Cloud (OCI) & Exadata - Familiarity with Oracle Cloud Infrastructure (OCI) and Oracle Exadata for cloud-based deployments.
• Automation & Scripting - Experience in automating database administration tasks using shell scripting or PL/SQL.
• Middleware & Application Server Support - Experience supporting deployment and testing in a new application server environment.

Note: This role is contingent upon contract award.

FLSA & EMPLOYMENT STATUS: FLSA EXEMPT AND FULL-TIME POSITION

iWorks Corporation is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, Veteran status, sexual orientation, or other protected characteristic.

iWorks is committed to maintaining a safe and productive work environment for all employees and ensuring the security and well-being of our clients. As part of our standard hiring process, we may conduct background checks and drug screenings on potential candidates to assess their suitability for employment.