Oracle PL/SQL Developer / DBA

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.

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

• 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