Zolon Tech Inc. · 3 weeks ago
Senior PL/SQL Developer / Database Administrator (DBA)
Zolon Tech Inc. is seeking a highly skilled Senior PL/SQL Developer / Database Administrator (DBA) responsible for designing, developing, optimizing, and maintaining complex Oracle database systems. The role requires advanced PL/SQL development and database administration expertise to ensure optimal performance and reliability in federal or public-sector environments.
Computer Software
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
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field
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
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)
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
Master's degree in Computer Science, Information Systems, or a related field
Familiarity with cloud-based database services (Oracle Cloud, AWS RDS, Azure SQL)
Oracle Certified Professional (OCP) – Database Administrator or Developer
AWS Certified Database – Specialty (optional)
Clearance: (or ability to obtain) Public Trust