Senior Oracle Database Administrator (15+ Years)

Syed Farooq Ali Omer

Phone: +1-346-***-****

Email: **********@*****.***

Professional Summary

Senior Oracle Database Administrator with 15+ years of experience designing, administering, and modernizing Oracle database platforms supporting investment banking, healthcare, and enterprise banking operations. Expertise spans Oracle Database 10g through 23ai, Oracle RAC, ASM, Data Guard, Exadata, and Oracle Enterprise Manager across mission-critical production environments. Proven success delivering database architecture, high availability, disaster recovery, performance engineering, security, cloud adoption, automation, and lifecycle management initiatives. Hands-on experience leading complex upgrades, migrations, patching, governance, and operational optimization while partnering with infrastructure, application, cybersecurity, and cloud engineering teams. Recognized for building resilient Oracle platforms that improve service availability, regulatory compliance, and business continuity for globally distributed enterprise applications.

Technical Skills

·Oracle Database: Oracle 10g, 11gR2, 12c, 18c, 19c, 21c, 23ai, Oracle Multitenant (CDB/PDB), SQL, PL/SQL

·High Availability: Oracle RAC, RAC One Node, ASM, Oracle Restart, Oracle Clusterware, Data Guard, Active Data Guard, Data Guard Broker, Fast-Start Failover (FSFO), Oracle Golden Gate.

·Backup & Recovery: RMAN, Recovery Catalog, Flashback Database, Flashback Table, PITR, Block Media Recovery, Incremental Merge Backups

·Performance: AWR, ASH, ADDM, SQL Monitor, SQL Trace (10046), TKPROF, SQL Profiles, SQL Plan Baselines, OEM Performance Hub

·Security: TDE, Oracle Wallet, Oracle Key Vault, Database Vault, VPD, OLS, Unified Auditing, Fine-Grained Auditing, Data Redaction

·Cloud & Engineered Systems: OCI, AWS RDS for Oracle, AWS EC2 Oracle, Oracle Exadata X8/X9/X10, Exadata Cloud@Customer

·Automation & Administration: OPatch, AutoUpgrade, DBUA, RMAN Duplicate, ZDM, Data Pump, Shell Scripting, Python, Ansible, Terraform, Jenkins

·Enterprise Tools: Oracle Enterprise Manager 13c, Grafana, Splunk, AppDynamics, Dynatrace, ServiceNow, Jira, Git, Control-M

Certifications:

·Oracle certified expert, Oracle Exadata X3 and X4 Administrator

·Certified Oracle DBA (Oracle 10g)

·Certified Oracle E Business Suite 11i Applications DBA

·Oracle WebLogic Server Admin (11g)

·ITIL V3 Foundation Certified

Professional Experience

Senior Oracle Database Administrator Nov 2021 – Present

Morgan Stanley, New York, NY

Architected Oracle RAC and Active Data Guard platforms supporting capital markets, trading, and risk applications by optimizing Clusterware resources, ASM storage, service placement, and failover strategies across global production environments.

Directed Oracle 19c modernization programs by planning Grid Infrastructure upgrades, AutoUpgrade execution, rollback validation, and post-upgrade performance tuning while maintaining strict investment banking change governance.

Directed cloud migration readiness by validating application dependencies, rollback procedures, synchronization strategies, and production cutover activities.

Established OEM compliance standards through policy evaluations, target grouping, metric extensions, notification rules, repository optimization, and automated health assessments supporting proactive database administration.

Established post-incident remediation plans, operational reviews, and engineering actions that reduced recurrence of critical production database failures.

Standardized Oracle engineering practices across geographically distributed database environments to improve operational consistency and platform reliability.

Engineered enterprise security using Transparent Data Encryption, Oracle Wallet, Database Vault, Unified Auditing, and Oracle Key Vault to strengthen privileged access controls and protect regulated financial data assets.

Managed complete PDB lifecycle activities including cloning, refreshable PDB synchronization, unplug and plug migrations, relocation, resource allocation, and patch compatibility to simplify environment management and database consolidation.

Optimized AWS disaster recovery through cross-region snapshot replication, automated restore validation, storage scaling, and maintenance window planning for production Oracle workloads.

Optimized GoldenGate replication by tuning parallel Replicat processing, DDL replication, lag monitoring, conflict detection, and recovery checkpoints while maintaining transactional consistency across distributed financial databases.

Coordinated SAP Basis and Oracle maintenance activities ensuring database readiness during kernel upgrades, support package deployments, and production stabilization.

Executed proof of concept initiatives validating Oracle 23ai compatibility, upgrade readiness, operational behavior, and adoption pathways for future production implementations

Designed Data Guard Broker architecture with Fast-Start Failover, observer management, switchover planning, and disaster recovery validation to improve business continuity for mission-critical trading databases.

Automated PDB cloning, unplug/plug migrations, resource plan allocation, and patch validation to simplify database consolidation while improving environment provisioning efficiency.

Optimized high-volume OLTP workloads using AWR, ASH, ADDM, SQL Monitor, SQL Profiles, and execution plan analysis, reducing overnight settlement processing by 22% across production environments.

Standardized operating system maintenance by automating cron jobs, systemd services, package validation, and OS health assessments across enterprise database servers.

Standardized RMAN backup architecture, Recovery Catalog governance, Flashback policies, and recovery testing to strengthen operational resilience and meet enterprise recovery objectives.

Automated Oracle provisioning, health validation, quarterly patch deployment, and compliance reporting using Ansible, Python, Shell scripting, Jenkins, and Git across production database estates.

Administered Oracle Exadata storage, Smart Flash Cache, ASM rebalance operations, and capacity forecasting to sustain predictable performance for latency-sensitive financial workloads.

Tuned Oracle Enterprise Manager monitoring templates and alert thresholds to improve proactive incident detection across business-critical database services.

Validated Release Update deployments with OPatch while verifying Clusterware health, database integrity, and application connectivity before production release.

Governed database standards, release approvals, and operational documentation supporting SOX compliance and enterprise audit readiness.

Partnered with platform engineering and cybersecurity teams to align database architecture with evolving infrastructure and security initiatives.

Mentored Oracle DBAs on RAC engineering, Data Guard administration, and performance diagnostics while remaining accountable for complex production database operations.

Senior Oracle Database Administrator Mar 2016 – Oct 2021

Natera, Inc., Austin, TX

Transformed Oracle database platforms supporting genomic sequencing, laboratory information systems, clinical reporting, and patient data processing by designing resilient architectures that sustained rapidly growing diagnostic workloads while meeting stringent healthcare availability and compliance requirements.

Engineered Oracle RAC, ASM, and Active Data Guard environments to provide uninterrupted database services for laboratory operations, reporting platforms, and enterprise applications through optimized workload distribution, storage management, and disaster recovery planning.

Led Oracle 12c, 18c, and 19c upgrade initiatives by evaluating application dependencies, validating interoperability, executing phased migration strategies, and stabilizing production environments with minimal impact to regulated clinical operations.

Optimized middleware connection pools, transaction handling, and database interactions improving application throughput across clinical systems.

Implemented enterprise database security frameworks using Transparent Data Encryption, Oracle Wallet, Database Vault, Virtual Private Database, Unified Auditing, and Data Redaction to safeguard protected health information and satisfy HIPAA governance requirements.

Coordinated GoldenGate-based migration cutovers by validating replication health, transaction consistency, application synchronization, and rollback readiness during phased production modernization initiatives.

Optimized large genomic databases through AWR, ASH, SQL Monitor, SQL Profiles, partitioning strategies, Advanced Compression, and execution plan optimization, improving reporting responsiveness for laboratory and research users by 19%.

Designed scalable backup and recovery frameworks utilizing RMAN incremental merge backups, Recovery Catalog, Flashback technologies, block media recovery, and periodic disaster recovery validation to strengthen data resilience across mission-critical healthcare platforms.

Modernized Oracle database deployment standards by automating installation, configuration validation, environment provisioning, patch verification, and operational health assessments using Ansible, Python, and enterprise scripting frameworks.

Integrated Oracle databases with Oracle WebLogic, Oracle SOA Suite, Informatica PowerCenter, and Oracle Data Integrator to support secure movement of laboratory, operational, and enterprise data across interconnected clinical systems.

Administered Oracle Enterprise Manager monitoring policies and repository maintenance for proactive health visibility across production databases.

Executed Zero Downtime Migration planning and Oracle Data Pump activities supporting infrastructure modernization initiatives.

Coordinated database readiness with laboratory application owners, infrastructure teams, and cybersecurity stakeholders during enterprise release cycles.

Authored recovery procedures, operational runbooks, upgrade documentation, and database standards supporting long-term platform governance.

Enhanced database lifecycle management by introducing standardized maintenance practices, capacity forecasting, and performance reviews that improved operational consistency across expanding healthcare environments.

Oracle Database Administrator Aug 2010 – Feb 2016

NCB (National Commercial Bank), Jeddah, Saudi Arabia

Administered enterprise Oracle database environments supporting core banking, retail banking, commercial lending, treasury, digital banking, and regulatory reporting by maintaining stable database platforms that sustained high-volume financial transactions and daily banking operations.

Designed Oracle RAC, ASM, and Oracle Restart configurations for critical banking applications by optimizing storage allocation, listener architecture, service registration, and database availability across production and disaster recovery environments.

Executed Oracle 10g, 11gR2, and 12c database installations, lifecycle upgrades, PSU patching, and Grid Infrastructure maintenance while adhering to controlled banking release schedules and operational governance standards.

Configured RMAN backup strategies, Recovery Catalog, Flashback Database, Flashback Table, and recovery validation procedures to strengthen disaster recovery preparedness and ensure dependable restoration of business-critical financial systems.

Coordinated SAP Basis and Oracle maintenance activities ensuring database readiness during kernel upgrades, support package deployments, and production stabilization.

Tuned SQL execution plans, AWR reports, ASH analysis, TKPROF traces, and optimizer statistics to resolve transaction processing bottlenecks while improving database response during month-end and regulatory processing cycles.

Developed Oracle Scheduler programs and event-driven jobs supporting automated database health checks, archival processing, and operational housekeeping across core banking environments.

Implemented Transparent Data Encryption, Oracle Wallet, password policies, Unified Auditing, and Fine-Grained Auditing to strengthen database security and align sensitive financial information with enterprise compliance requirements.

Migrated databases using RMAN Duplicate, Oracle Data Pump, Transportable Tablespaces, and cross-platform validation while preserving application compatibility and maintaining transactional consistency throughout migration activities.

Automated recurring database maintenance, space monitoring, health verification, listener validation, and alert log analysis using Shell scripting and Oracle Scheduler to improve operational efficiency across production environments.

Managed Oracle Enterprise Manager agents and monitoring policies supporting proactive database administration.

Coordinated Control-M scheduling and maintenance windows for backup, reporting, and database administration activities.

Worked with application, middleware, and infrastructure teams to validate database readiness before production releases and business initiatives.

Produced operational procedures, recovery documentation, configuration standards, and audit evidence supporting internal governance reviews.

Contributed to continuous database optimization through capacity planning, storage forecasting, and preventive maintenance that improved long-term platform reliability.

Education

Bachelor of Science in Computer Science

Contact this candidate