Zachary Piper Solutions is seeking a Tier 3 Database Engineer to join a high-impact federal cybersecurity and data engineering program located in Washington, DC through 100% full onsite presence, supporting national security initiatives through advanced database solutions. The Tier 3 Database Engineer will focus on designing, optimizing, & maintaining complex database systems to ensure secure & high-performance data operations.

Responsibilities of the Tier 3 Database Engineer include:

• Design & develop database applications using PL/SQL, ensuring scalability & reliability
• Optimize performance & troubleshoot issues; writing SQL queries & resolving database-related problems
• Collaborate across teams - working closely with developers, administrators, & stakeholders
• Ensure data integrity & security, applying best practices to safeguard data & maintain compliance
• Maintain documentation & standards, document database architecture, design decisions & changes to ensure transparency & continuity
• Stay current with technologies, keep up with emerging trends in database development, cloud platforms, & automation tools like VBA & Unix scripting

Qualifications of the Tier 3 Database Engineer include:

• 10+ years of experience in database engineering - proven track record in designing, developing, & maintaining complex database systems in enterprise environments
• Advanced expertise in writing & optimizing PL/SQL code, with deep knowledge of Oracle database internals & tuning techniques
• Experience configuring & deploying MongoDB
• Strong Unix/Linux scripting abilities for system operations & VBA automation tasks, enhancing database efficiency & workflow integration
• Hands-on experience with multiple database platforms, such as Oracle, PostgreSQL, MS SQL Server, & DynamoDB, including replication & high-availability tools like Goldengate & Data Guard
• Familiarity with Oracle Cloud Services, Pivotal Cloud Foundry (PCF), and basic web development using HTML/CSS
• Active Top Secret or DOE Q clearance

Compensation for the Tier 3 Database Engineer includes:

• Salary Range: $160,000-$175,000 depending on experience
• Benefits: Medical, Dental, Vision, 401k Plan, Holidays, PTO, Education Incentives, sick leave as required by law

Keywords: tier III, tier 3, database, engineer, Washington, dc, district of Columbia, design, optimize, optimizing, maintain, PL/SQL, procedural language, PL, Oracle, loops, conditions, exception handling, scalable, scalability, reliable, reliability, troubleshoot, SQL, queries, query, develop, administer, stakeholder, data integrity, security, safeguard, compliance, single block, stored procedures, functions, triggers, error, exception block, network traffic, VBA, Unix, Linux, Visual Basic for Applications, automate, automating, automation, database, engineer, MongoDB, DynamoDB, Mongo DB, Dynamo DB, NoSQL, No SQL, Atlas, AWS, Amazon Web Service, JSON, key-value, PartiQL, Query API, scaling, scale, schema, low latency, low-latency, data model, deploy, IT, information technology, cloud, performance tuning, performance tune, NNSA, national nuclear security agency, OCIO, office of the chief information officer, cyber, cybersecurity, telecommunications, DOE, department of energy, Oracle Cloud, Pivotal Cloud Foundry, PCF, basic web development, HTML, CSS, PostgreSQL, Postgre, MS SQL Server, Goldengate, Data Guard, DataGuard, HyperText Markup Language, Cascading Style Sheets, cloud-native platform, cloud foundry, DOE Q, Q, Q clearance, clearance, Top Secret, TS, TS clearance, top secret clearance, tssci, ts/sci, ts-sci, top secret with sci

• Design & develop database applications using PL/SQL, ensuring scalability & reliability
• Optimize performance & troubleshoot issues; writing SQL queries & resolving database-related problems
• Collaborate across teams - working closely with developers, administrators, & stakeholders
• Ensure data integrity & security, applying best practices to safeguard data & maintain compliance
• Maintain documentation & standards, document database architecture, design decisions & changes to ensure transparency & continuity
• Stay current with technologies, keep up with emerging trends in database development, cloud platforms, & automation tools like VBA & Unix scriptin