Sr. Database Engineer

Zachary Piper Solutions is seekinga Sr. Database Engineer to support a library modernization program for National Geospatial Agency in  Rancho Bernardo, CA.  The team is seeking a skilled engineer to define and develop upgrades to an enterprise-wide Imagery Archive and Geospatial Intelligence System.

Clearance : Active Top Secret, TS / SCI highly preferred

Location : Rancho Bernardo, CA (% on-site)

This job opens for applications on 8 / 1 / 5. Applications for this job will be accepted for at least days from the posting date

Responsibilities of the Sr. Database Engineer :

• Design, develop, and maintain Oracle databases across the full software development lifecycle, ensuring high performance, availability, and security.
• Develop and optimize complex PL / SQL code, including functions, procedures, packages, and user-defined types, to support application functionality and data processing needs.
• Write and tune advanced SQL queries to ensure efficient data retrieval and manipulation.
• Administer Oracle RDBMS environments (c and c), including configuration, patching, upgrades, and performance tuning.
• Manage Oracle pluggable databases and perform basic server operations in RHEL Linux environments (versions 7 / 8), including shell scripting in Bash and CSH.
• Implement and enforce Oracle STIG compliance and database hardening procedures to meet security and regulatory standards.
• Design and implement database schemas, data models, and architecture to support scalable and maintainable systems.
• Support cloud-based database environments, particularly AWS RDS, including deployment, monitoring, and maintenance.
• Collaborate with cross-functional teams using tools like Jira and Git to manage tasks, track issues, and maintain version control.
• Install and configure Oracle Instant Client as needed for application and development support.
• Contribute to a collaborative and secure team environment, demonstrating a proactive attitude and strong communication skills.

Qualifications of the Sr. Database Engineer :

Compensation of the Sr. Database Engineer :

Keywords : SQL, NoSQL, relational databases, data modeling, normalization, indexing, query optimization, database design, schema management, stored procedures, triggers, transactions, ACID properties, data integrity, replication, sharding, backup and recovery, database security, performance tuning, ETL processes, data warehousing, cloud databases, distributed databases, PostgreSQL, MySQL, Oracle Database, Oracle SQL Developer, Oracle PL / SQL, Oracle RAC, Oracle Data Guard, Oracle ASM, Oracle Exadata, Oracle GoldenGate, Oracle APEX, Oracle Enterprise Manager, top secret, ts / sci, topsecret / sci, top secret / sci, security clearance, W2, hiring, San Diego, California, imagery, intelligence, geospatial, data, Oracle Cloud Infrastructure (OCI), Oracle Autonomous Database, database migration, version control, database administration, scalability, high availability, concurrency control, database monitoring, data lakes, big data integration, DevOps, CI / CD pipelines, database testing, data governance, metadata management