• Collaborate with design and development teams to create database designs that meet specified business and technical requirements • Perform database modeling and effectively communicate schema structures to development teams, ensuring clarity in how schemas support application development • Apply a thorough understanding of relational database concepts, implementing them using SQL DDL to support project goals • Gather requirements from software product managers and architects, and design relational database objects tailored to software objectives • Maintain and update databases used by the product development team across multiple versions of Jenzabar software • Work closely with the Quality Assurance team to test and verify database changes for each release cycle • Provide support in troubleshooting and resolving complex database issues within the customer base • Collaborate with the Data Services team on technical challenges related to data conversions • Stay informed about new releases of Microsoft SQL Server and evaluate their potential impacts on Jenzabar software • Design enterprise-wide database solutions aligned with application design goals

• Own end-to-end Oracle database performance engineering: AWR/ASH analysis, wait event tuning, SQL trace, Statspack, and optimizer plan management. • Design and execute data migration strategies for consolidating EDB, IVM, and VistA REE data into the modernized ES, ensuring data integrity, lineage, and auditability. • Develop and optimize PL/SQL, partitioning strategies, indexing, and materialized views for high-volume eligibility and enrollment workloads. • Implement GoldenGate and/or native Oracle replication strategies to support phased cutovers, near–zero downtime transitions, and rollback plans. • Harden database platforms to VA standards (FedRAMP, FISMA, IRS 1075, HIPAA): encryption at rest (TDE), in-transit (SSL/TLS), key rotation, and privileged access controls. • Engineer backup/recovery and DR patterns (RMAN, Data Guard) with validated RPO/RTO; conduct routine failover testing and RCA following incidents. • Establish observability baselines using Splunk/Microsoft Azure Monitor; publish performance SLOs and weekly capacity reports to the Product Lifecycle Team. • Collaborate with DevSecOps to integrate schema migrations into CI/CD (Liquibase/Flyway), automate change promotion, and enforce configuration management. • Support database security operations: auditing, least privilege, separation of duties, STIG alignment, and vulnerability remediation. • Lead data quality and reconciliation activities post-migration; define controls for duplicates, referential integrity, and cross-system consistency. • Provide Tier 3 escalation for production incidents; perform query rewrites, plan baselines, and emergency performance triage during peak loads. • Contribute to capacity planning and cloud architecture decisions for VAEC-hosted Oracle workloads; right-size compute/storage and IOPS.

• Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity. • Analyze, maintain, and optimize Microsoft SQL database environment to ensure 99.9% availability and data integrity. • Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL and Microsoft SQL. • Update database architecture, build schemas, tables, stored procedures, and manage permissions. • Manage, improve, and work with Legacy databases and Platform as a Service databases. • Provide recommendations on policies, procedures, and emerging technologies. • Monitor systems for availability, oversee database mirroring, replication, and failover. • Support advanced PostgreSQL features like JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip. • Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting. • Restore PostgreSQL databases from backups and support disaster recovery activities using WAL archiving and point-in-time recovery. • Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot PostgreSQL database issues. • Assess future storage and performance needs, and create and maintain comprehensive PostgreSQL documentation. • Work with Platform as a Service pre-built database to optimize and manage as needed for growing solutions. • Communicate effectively with customers, stakeholders, and technical specialists.