Database Engineer

Zachary Piper Solutions is seeking a Database Engineer to join a Federal Program located in Washington, DC. The Database Engineer will support Department of Energy by managing and administering databases, designing and implementing solutions based on user requirements, and collaborating with teams to define data access needs and analyzing transaction rates and volumes.

Responsibilities of the Database Engineer include:

·      Design and develop robust database applications utilizing PL/SQL.

·      Craft and optimize SQL queries, along with PL/SQL procedures, functions, and packages.

·      Collaborate with application developers, database administrators, and other stakeholders to implement effective database solutions.

·      Conduct data analysis and troubleshooting to identify and resolve database-related issues.

·      Ensure database integrity and security by adhering to best practices.

·      Participate in code reviews and provide constructive feedback to enhance code quality.

·      Maintain comprehensive documentation of database designs, architecture, and modifications.

·      Stay informed about the latest trends and technologies in database development.

Qualifications for the Database Engineer include:

·      10+ years of relevant experience

·      Must have an Active Top Secret or Q Clearance

·      Proven experience as a PL/SQL Developer or similar role.

·      Strong understanding of database concepts, design, and normalization.

·      Proficient in PL/SQL, Oracle SQL, and performance tuning.

·      Skilled in VBA for automation tasks.

·      Solid knowledge of HTML and CSS for web development.

·      Experienced with Unix shell scripting for system operations.

·      Programming Languages: PL/SQL, VBA, HTML/CSS, Unix Shell Scripting.

·      Cloud Technologies: Pivotal Cloud Foundry (PCF), Oracle Enterprise Manager (OEM), Oracle Cloud Services.

·      Databases: Oracle, PostgreSQL (4+ years), MS SQL Server (3+ years), DynamoDB.

·      Architectures: 3-tier, 2-tier, N-tier.

·      GIS: PostGIS.

·      Operating Systems: Solaris, Unix, Hyper-V Linux, Windows, Red Hat Linux, Oracle VM.

·      Active Data Guard/Data Guard Configuration (5+ years), GoldenGate (5+ years).

Compensation for the Database Engineer includes:

·      Salary Range: $140,000 - $165,000 depending on experience

·      Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays

This job opens for applications on 4/28/2025. Applications for this job will be accepted for at least 30 days from the posting date.

Keywords:

PL/SQL, Oracle SQL, database, engineer, administrator, architect, database concepts, database design, database normalization, performance tuning, VBA, automation tasks, HTML, CSS, web development, Unix shell scripting, system operations, programming languages, Pivotal Cloud Foundry, PCF, Oracle Enterprise Manager, OEM, Oracle Cloud Services, databases, Oracle, PostgreSQL, MS SQL Server, DynamoDB, 3-tier architecture, 2-tier architecture, N-tier architecture, GIS, PostGIS, Solaris, Unix, Hyper-V Linux, Windows, Red Hat Linux, Oracle VM, Active Data Guard, Data Guard Configuration, GoldenGate, database administration, data access needs, transaction rates, volume analysis, database solutions, data analysis, troubleshooting, database integrity, database security, code reviews, documentation, database trends, database technologies, TSSCI, Clearance, Security, secret, top secret, TS/SCI, TS, Washington DC, Dc, District of Columbia, Department of Energy, DOE, national nuclear security agency, NNSA, OCIO, Q Clearance, Q,

#LI-KG1

#LI-ONSITE