Oracle PL/SQL Developer / DBA
*Oracle PL/SQL Developer / DBA*
*Location:* Pentagon, Arlington, VA
*Schedule:* Hybrid – 60% onsite / 40% remote
*Clearance:* Interim or active Secret required
*Salary: *$145K
Loyola Enterprises Inc. is seeking a Senior Database Specialist to support a Department of Defense program at the Pentagon.
*This is a hands-on database development AND administration position. Candidates must have recent, hands-on Oracle SQL and PL/SQL development experience. This is not primarily an Oracle DBA/operations position.*
The successful candidate will support enterprise Oracle database environments while also troubleshooting and resolving application data, SQL, PL/SQL, and business-logic issues. The position requires someone comfortable moving between database administration, engineering, development, performance tuning, and production troubleshooting.
*Required Experience*
- Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent relevant experience.
- At least 10 years of combined experience in database development, administration, or related database engineering roles, including hands-on experience in both development and administration.
- Experience developing, administering, and supporting Oracle relational database management systems (RDBMS) in enterprise environments.
- Experience with SQL and PL/SQL, including developing and maintaining database objects such as tables, views, stored procedures, functions, packages, and triggers.
- Experience with database design, data modeling, query optimization, and performance troubleshooting.
- Experience supporting database administration activities, including installation, configuration, patching, upgrades, monitoring, maintenance, backup and recovery, and troubleshooting.
- Experience managing database users, privileges, access controls, auditing, and other database security functions.
- Experience supporting large-scale relational databases and developing secure, scalable data solutions using established database and data engineering practices.
- Ability to collaborate across technical teams and clearly communicate solutions, findings, risks, and recommendations to technical and nontechnical stakeholders.
- Must possess an interim or active Secret clearance.
- Must meet DoD 8140 foundational compliance requirements through a qualifying degree or certification.
*Preferred Experience*
- Experience supporting financial, budgeting, logistics, or other enterprise business systems.
- Experience with cloud-hosted databases and related compute, storage, security, monitoring, and backup services, particularly AWS services such as RDS, EC2, S3, IAM, CloudWatch, CloudTrail, and AWS DMS.
- Experience with additional relational database platforms, such as PostgreSQL or Microsoft SQL Server.
- Experience with data integration, migration, synchronization, or extract, transform, and load (ETL) processes.
- Experience automating database development or administration tasks through scripting or other tools.
- Experience supporting DoD cybersecurity requirements, Risk Management Framework (RMF) processes, Security Technical Implementation Guides (STIGs), and security controls.
- Experience using version control and work tracking tools, such as Git and Jira.
- Relevant Oracle, AWS, PostgreSQL, Microsoft SQL Server, or other database and cloud certifications.
*Candidates Should Be Prepared to Discuss*
Candidates should be prepared to discuss recent examples of SQL/PLSQL code they personally developed or modified, production database or data problems they personally diagnosed and resolved, query/performance tuning, and their experience balancing database development with administration and engineering responsibilities.
Please contact me to discuss the position and with an agreement on your compensation am prepared to send you an offer letter.
I look forward to working with you.
Sincerely,
Benito Loyola
CAPT USN (ret.)
President
Loyola Enterprises Inc.
Office 757-498-6118 x101
Cell 757-718-0699
Fax 757-498-6110
Pay: From $145,000.00 per year
Benefits:
- 401(k) matching
- Dental insurance
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Professional development assistance
- Referral program
- Relocation assistance
- Retirement plan
- Tuition reimbursement
- Vision insurance
Application Question(s):
- Within the past 3 years, have you personally developed or materially modified Oracle PL/SQL stored procedures, functions, packages, or triggers in a production or enterprise environment?
- Do you have experience with RMF, DISA STIGs, and DoD cybersecurity requirements.
- Do you have experience with Git, Jira, scripting, automation, and Agile/DevOps environments.
- Have you personally troubleshot production SQL/PL/SQL problem involving incorrect data, business logic, or poor query performance?
- Have you personally used within the last 3 years Stored procedures / Functions / Packages / Triggers / Execution plans / AWR-ASH-ADDM / Oracle RDS / Oracle on EC2.
Location:
- Pentagon, DC (Required)
Security clearance:
- Secret (Required)
Work Location: Hybrid remote in Pentagon, DC