Yvette Ndjigui

Migrated 15+ on-premise Oracle databases to AWS RDS and EC2 instances using AWS DMS and Schema Conversion Tool, reducing infrastructure costs by 30% while improving scalability and performance for enterprise applications. Designed and implemented automated backup and recovery strategies using AWS Backup and Oracle RMAN, ensuring compliance with RTO of 30 minutes and RPO of 5 minutes for critical business systems and applications. Configured and managed high-availability architectures using AWS Multi-AZ RDS deployments, Read Replicas, and Oracle Data Guard, achieving 99.99% uptime and seamless failover capabilities for production environments. Developed and enforced comprehensive security policies using AWS IAM roles, Security Groups, and Oracle TDE, ensuring compliance with federal standards including FISMA and NIST 800-53 for sensitive government data. Optimized database performance by 25% using AWS CloudWatch alarms, Oracle AWR/ASH reports, and SQL tuning, implementing automated indexing strategies and query optimization for resource-intensive applications. Automated infrastructure provisioning and database deployments using Terraform and AWS CloudFormation templates, reducing manual configuration time by 40% and ensuring consistent environments across development stages. Implemented monitoring solutions with CloudWatch Dashboards and custom metrics, setting up proactive alerts for database performance issues and capacity thresholds to prevent system outages and degradation. Collaborated with development teams to implement DevOps practices using AWS CodePipeline and Jenkins, enabling automated database deployments and schema changes as part of CI/CD pipelines for agile delivery.

Administered and maintained 50+ mission-critical Oracle 12c/19c databases supporting federal applications, performing regular patching, upgrades, and migrations while ensuring zero downtime for essential government services. Implemented and managed Oracle Data Guard for disaster recovery across geographically dispersed data centers, configuring physical and logical standby databases to ensure business continuity and data protection. Performed comprehensive security audits and vulnerability assessments using Oracle Audit Vault and custom scripts, implementing Database Vault and TDE to protect sensitive data and meet federal compliance requirements. Automated routine DBA tasks including backups, space monitoring, and performance checks using Python and Shell scripts, reducing manual intervention by 40% and improving operational efficiency across the database team. Provided 24/7 on-call support for production databases, resolving critical incidents and performance issues within SLAs to maintain 99.99% availability for high-priority applications and user communities. Designed and implemented database partitioning strategies for large-scale tables containing billions of rows, improving query performance by 35% and reducing maintenance windows during archival operations. Conducted capacity planning and performance forecasting using Oracle Enterprise Manager and custom monitoring tools, ensuring adequate resources for growing data volumes and user concurrency requirements. Documented operational procedures, disaster recovery plans, and security protocols in accordance with federal guidelines, creating comprehensive runbooks and knowledge base articles for team reference.

Managed and maintained 30+ Oracle databases supporting Boeing's aviation and logistics applications, performing installations, configurations, and upgrades across development, testing, and production environments. Implemented comprehensive RMAN backup strategies with disk and tape retention policies, performing regular recovery drills to validate procedures and ensure data integrity for mission-critical aviation systems. Performed SQL tuning and optimization using SQL Tuning Advisor and Explain Plans, rewriting complex queries and implementing strategic indexes to improve application response times by 40% for end-users. Configured and managed Oracle Enterprise Manager 13c for centralized monitoring and administration, creating custom metrics and dashboards to track database health, performance, and resource utilization. Collaborated with application development teams on database design, schema reviews, and performance optimization, providing expert guidance on best practices for PL/SQL programming and database architecture. Implemented database security measures including role-based access control, auditing, and password policies, ensuring compliance with Boeing's strict security standards and regulatory requirements. Developed and maintained documentation for database standards, operating procedures, and troubleshooting guides, facilitating knowledge transfer and ensuring consistent operations across the DBA team. Participated in 24/7 on-call rotation, providing emergency support for production databases and coordinating with infrastructure teams to resolve hardware, storage, and network-related database issues.