Hire the Best Oracle Data Guard Specialists
in the United States

I'm a detail-oriented SQL developer with four years of experience in customer service and client-facing roles, currently pursuing a Master of Science in Materials Science and Engineering. I write SQL queries for Oracle Database — including complex JOINs, subqueries, CTEs, window functions, aggregations, and data manipulation using DML and DDL — and I'm actively preparing for the Oracle Database SQL Certified Associate (1Z0-071) certification. I'm comfortable working with schema design, views, constraints, indexes, and Oracle-specific functions like NVL, DECODE, ROWNUM, and hierarchical queries. My background as a Student Technician at a university and in customer-facing technical support roles has sharpened my ability to communicate clearly with both technical and non-technical stakeholders — I can translate data into plain language that drives decisions. If you need clean, accurate SQL work or a dependable generalist who can manage tasks and bridge the gap between data and people, let's connect.

As an Expert-Vetted freelancer, I am in the TOP 1% of ALL talent on Upwork meaning you're working with the best of the best! 🥇 With over a decade of work experience using Oracle technologies I've become an expert at helping clients bring their ideas to life. I have developed multiple innovative Oracle APEX based applications which customers are using to run or support their business . I am a certified Oracle APEX developer with expert level skills in PL/SQL and SQL. Adept at crafting dynamic solutions that transform complex business requirements into easy to use software. I've worked on many projects which combine Oracle APEX with OCI and REST API's to enhance and truly give users an amazing experience! BENEFITS OF WORKING WITH ME 🚀SPEED You need a software stack that is flexible, adaptable, and responsive. Which is I specialize in low-code tools, like Oracle APEX, so that your business can get up and running quickly 📈FINANCIAL GROWTH Streamline your processes, optimize your technology stack, and unlock new revenue opportunities. I can help your business achieve measurable financial success and long-term scalability. 📞TRANSPARENT COMMUNICATON Expect regular updates, clear explanations and honest advice. My goal is to understand your requirements and then bring them to life just how you imagined. ✨TAILORED SOFTWARE SOLUTIONS No matter your industry or line of business our Oracle APEX solutions can meet your project's unique demands. We can adapt the theme style to meet your expectations 📨 NEXT STEPS Send me a message to discuss your project. I'm always willing to share my knowledge, and gives you a preview to see what working together could be like!

• 15+ years of IT experience & over 12 years of extensive experience as Oracle, PostgreSQL, MS SQL Server, Azure SQL, MySQL, MongoDB, MariaDB, AWS Database Administrator, providing 24X7 production and development support on different platforms like Oracle Exadata, HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows. • Experience in Performance Tuning such as tuning of memory, CPU, I/O distribution, shared memory segments using utilities like Explain Plan, Stats pack, OEM, AWR, ADDM, ASM, TKPROF. performing health and performance check of database by identifying bottlenecks affecting Oracle system using PL/SQL. • Excellent Backups and Recovery skills that involve logical backups (Import / Export), Hot/Cold Backup and tools and utilities like RMAN, pgbackrest, barman, Customized Scripts, Import/ Export and Verities Net • Implementation of high availability solutions with Oracle 10g/11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, Golden Gate. • Configuring PostgreSQL streaming replication and pgbouncer for load balancing. Monitoring tools like pgbadger, pgadmin, Graphana, DBeaver. • Excellent SQL skills including query optimization and business analytical reporting. • Experience in upgrading and migrating various versions of PostgreSQL databases on different platforms. SQL Server & Azure Data Platform Management • Administered, tuned, and maintained a large fleet of on-premises and Azure SQL databases, ensuring 24/7 availability and performance for high-throughput claims platforms.

Full Stack Data Engineer and Principal Technical Consultant with decades of experience in Oracle Database Architecture and Administration, Javascript Full Stack Development, Cloud Data Integration Pipelines, and DevOps Core Competencies: Cloud / Database: Azure Data Factory, Azure Databricks, Delta Lake, Unity Catalog, Oracle OCI, Oracle RAC, MongoDB, SQL Server Infrastructure / DevOps: Terraform IaC, Ansible, GitHub Actions CI/CD, Linux, NGINX, VM, Containers Languages / Frameworks: Python, Node.js, Vue/Nuxt, C#, PL/SQL, T-SQL, JavaScript (ES6+) Integration: REST / SOAP APIs, RCP, Twilio, SendGrid, Workday Adaptive Insights, NetSuite, Plex, Dynamics365, QBO, Salesforce, etc. Security: OAuth2, JWT, Databricks RBAC, TLS/SSL Methodologies: PM > Agile, Waterfall, SOW Management, Technical Design Review, Knowledge Transfer Planning Compliance & Security: SOC 2, HIPAA, STIG, SOX Experience: Adam Helm Consulting, Inc: Owner and Principal Technical Consultant (2020-Present) Prism PPM: Senior Data Engineer (1/25 - Current) Partner with third-party vendor to design and implement a new business intelligence platform for the company’s SaaS-based Project Portfolio Management application, modernizing reporting and analytics capabilities. Developed and implemented the Change Data Capture (CDC) in Oracle for reliable downstream replication. Consulted on the design and implementation of Azure Data Factory pipelines to extract and transform Oracle source data into partitioned Parquet datasets in Azure Data Lake Storage Gen2 for downstream Databricks ingestion. Oversaw the implementation of a Databricks Medallion architecture using PySpark and Delta Live Tables to process Oracle-sourced Parquet data — deduplicating Bronze-layer ingests, reconciling CDC changes in Silver, and modeling Gold-layer fact and dimension tables powering embedded Power BI analytics. Introduced row-level security (RLS) and Unity Catalog for governed analytics access. Implemented Databricks Delta sharing capabilities for real time Databricks to Databricks integrations. Assisted with the design and automation of a Terraform-based Infrastructure-as-Code (IaC) framework to deploy Azure Data Factory, Key Vault, Storage Account, SQL Database, Log Analytics Workspace, and Managed Identities across dev, test, and production environments. Integrated environment configuration via YAML templates and automated validation through Go-based Terratest to ensure consistent, repeatable deployments. Ensured full alignment to the Statement of Work, validating deliverables and maintaining accountability. Assisted with the creation of the Technical Design Document (TDD) to eliminate ambiguity and ensure maintainability. Structured and led Knowledge Transfer (KT) sessions to equip stakeholders for post-implementation support. Participated in a cross-functional strategy and innovation summit in Cluj-Napoca, Romania, collaborating with engineering, product, and analytics teams to align on AI enablement, process maturity, and delivery KPIs — resulting in improved clarity around product strategy and execution. Casne Engineering: Principal Oracle DBA (2006 – Current) For BP, Perform Oracle upgrades and lead system migrations Assist with Oracle performance optimization through schema design and indexing strategies. Develop Ansible patch automation process / develop application stored procedures and triggers Create HA and DR / backup and recovery strategy. Dropkick Media: Full Stack Engineer (2022 – 2025) Developed a full-stack Nuxt.js application with a Node.js/Express backend and MongoDB database, designed for large-scale web data indexing and search. Integrated Puppeteer and Cheerio to automate browser sessions and extract structured data from publicly available web pages. Implemented secure authentication using JWTs, bcrypt, and Nuxt middleware for session handling and protected routes. Built a dynamic search and filtering interface using Vuetify, Vuex, and Axios to deliver fast, user-friendly data exploration. Configured a scalable server architecture with environment-based builds, REST APIs, and integrated health monitoring endpoints. CSC - Bath Iron Works Client: Senior Oracle DBA Decouple and redevelop Sybase back-end system in Oracle. Saved the company $30K in recurring licensing fees for a one-off Sybase system. Lead DBA in charge of scoping and deploying Oracle RAC databases infrastructure including CRS and ASM to optimize horizontal scaling. Led the geographic relocation of production database system for Enovia when Bath Iron Works became prime contractor for the DDG1000 program. Stanford University: Self Study, Computer Science: Completed hundreds of hours of self-study in computer science, focusing on algorithms, programming methodologies, and software design principles using CS106A and CS106B course materials.

My extensive experience in Cloud,Database and CyberSecurity over the past years include the following: 1). CISSP Certified Information Security Professional 2). CISA: Certified Information Systems Auditor 3). PCI-DSS Security Audit 3) Information Security/Vulnerability Testing 4). Oracle Performance Tuning 5). Oracle Database technologies, SQL Tuning, RMAN, RAC Clustering 6). Database System Security Scans and Vulnerability testing 7). Oracle Certified Professional 8). Oracle Certified Database Security Implementation 9). AWS Solutions/Administration/EC2/S3/Cloud 10). HiTRust Aware/PCI DSS Professional 11). Microsoft Certified: Azure Fundamentals Dedicated, solution driven and well accomplished IT Security Executive with over 20 years of progressive experience in leading the development and execution of complex security architectures and compliance strategies within diverse organizational frameworks. Expert in enhancing security infrastructures across multiple platforms including cloud environments (AWS) and database systems (Oracle, WebLogic). Proven track record of reducing risks through meticulous gap assessments, penetration testing, and continuous systems monitoring, achieving significant improvements in security robustness. Skilled in leading high-impact teams and projects that fortify information security defenses and compliance protocols, adhering to rigorous standards such as SOC2, NIST, CIS, HIPAA, and OWASP. Demonstrated success in implementing critical security updates, leading security training programs, and managing direct client relationships to protect sensitive data effectively. Recognized for transforming security frameworks and cultivating a culture of continuous improvement and proactive threat management, ensuring the security and integrity of critical information assets.

💼 23+ Years as an Oracle DBA and Consultant 🔐 CompTIA Security+ Certified 🏅 Oracle Database 10g Administrator Certified Associate 💻 Linux Administration Certified 🧾 U.S. Citizen 🛡️ U.S. Top Secret Clearance 🎓 Master’s in Information Technology An Oracle expert who handles everything from database administration to custom development and cloud solutions, bringing more than two decades of experience to your project. I specialize in building, optimizing, and managing Oracle systems that help businesses run efficiently and securely. Available for both standalone and team-based engagements. Oracle Database Administration & Architecture • Oracle installation, configuration, and upgrades • Performance tuning and query optimization • Indexing, partitioning, and capacity planning • High-availability and disaster recovery (RAC, Data Guard, backup & recovery) • Database security, user management, and compliance • Monitoring, troubleshooting, and production support Data Engineering & ETL • Data migration and integration projects • ETL pipelines using PL/SQL and SQL*Loader • Data validation, transformation, and optimization • Data warehousing support • Cross-database experience (Oracle, SQL Server, PostgreSQL, MySQL) Oracle PL/SQL & APEX Development • Advanced PL/SQL development (packages, procedures, functions, triggers) • Dynamic SQL, collections, bulk operations, and tuning • Oracle APEX installation, administration, and troubleshooting • Low-code ERP-style applications • Dashboards, workflow automation, and internal business tools Modern Backend & Full-Stack Systems • Backend development with Node.js, Express.js, and Java • RESTful and GraphQL API design and optimization • Secure authentication and authorization (JWT, OAuth, Bcrypt) • Server-side logic, data flow optimization, and integrations • Payment and third-party integrations (Stripe, WebSockets) Web & Application Development • Full-stack development using MEAN and MERN stacks • Front-end frameworks: React, Angular, TypeScript • Clean, maintainable, and well-documented codebases • Scalable application architecture and long-term support Cloud, DevOps & Deployment • Oracle Cloud Infrastructure (OCI) and AWS • Cloud migrations and environment setup • Docker-based deployments and CI/CD pipelines • Git-based workflows and production release support Why Work With Me? • 20+ years of hands-on Oracle expertise — I have seen it all • Proven track record of successful implementations, including work with US State Departments • Full-service team covering development, administration, and cloud • Results-driven, scalable, and secure solutions Whether you need a high-performing database, a custom-built application, or a seamless cloud migration, I am here to make it happen. Let’s book a call now!