Senior PL/SQL Developer / Database Administrator (DBA)

The Senior PL/SQL Developer / Database Administrator (DBA) is a highly skilled, independent performer responsible for designing, developing, optimizing, and maintaining complex Oracle database systems supporting enterprise and mission-critical applications.

This role combines advanced PL/SQL development with database administration expertise, ensuring optimal performance, scalability, security, and reliability particularly in federal or public-sector environments.

The ideal candidate is a self-motivated professional capable of working independently with minimal supervision, while also collaborating effectively across technical and business teams.

Key Responsibilities:

PL/SQL Development

Design, develop, and maintain complex PL/SQL stored procedures, functions, packages, and triggers to support business logic and application requirements.

Independently analyze, design, and implement database solutions aligned with project goals.

Optimize and tune SQL queries for maximum performance and efficiency.

Develop and maintain ETL (Extract, Transform, Load) processes and data pipelines.

Implement and manage data validation, integrity, and quality controls.

Participate in code reviews and enforce best practices for database development.

Database Administration

Install, configure, and maintain Oracle database environments (11g, 12c, 19c or higher).

Independently perform database backup, recovery, cloning, and disaster recovery operations using RMAN or Data Pump.

Monitor and tune database performance using AWR, ASH, and SQL tuning tools.

Manage user access, roles, and security in accordance with organizational policies.

Plan and perform database patching, upgrades, and migrations.

Automate administrative tasks using scripts (Shell, Python, or PL/SQL).

Ensure compliance with data governance, privacy, and security standards (FISMA, HIPAA, NIST 800-53).

Collaboration & Leadership

Serve as a technical lead and independent contributor, capable of driving initiatives from concept to completion.

Collaborate with application teams, system administrators, and project managers to ensure seamless database integration.

Participate in architecture and design discussions to enhance system scalability and performance.

Develop and maintain comprehensive documentation for database structures, configurations, and processes.

Education:

Bachelor's degree in Computer Science, Information Systems, or a related field (Master's preferred).

Experience:

7+ years of experience as a PL/SQL Developer and Oracle DBA.

Demonstrated ability to work independently on complex database design, development, and performance tuning projects.

Experience supporting large-scale, high-availability databases in mission-critical environments.

Familiarity with cloud-based database services (Oracle Cloud, AWS RDS, Azure SQL) is a plus.

Technical Skills:

Expertise in Oracle SQL, PL/SQL, and database architecture.

Strong experience with performance tuning tools (AWR, ADDM, OEM, SQL*Plus).

Proficient in Unix/Linux shell scripting.

Skilled in data modeling, indexing, and normalization.

Experience with backup/recovery tools (RMAN, Data Pump).

Familiarity with version control systems (Git, SVN).

Soft Skills:

Proven ability to operate as an independent performer with strong ownership and accountability.

Excellent analytical, problem-solving, and communication skills.

Able to manage multiple priorities in a fast-paced environment.

Detail-oriented with a focus on reliability, precision, and performance.

Preferred Certifications and Clearances

Oracle Certified Professional (OCP) Database Administrator or Developer.

AWS Certified Database Specialty (optional).

Clearance: (or ability to obtain) Public Trust