It Infrastructure Oracle Database

Shamim Ahmad Khan

*** ********** ** *********, **-92025 +1-858-***-**** *******@*****.***

PROJECT LEADER

Seasoned project leader and Oracle Database specialist with professional experience in IT Infrastructure, Oracle Database, and Data Warehouse solutions. Clientele spans state and local governments, insurance, mortgage, and technology companies. Possess extensive expertise in administering IT Infrastructure, Oracle Production, and Development Databases. Adept in leading various enterprise-wide projects, such as data center relocations and data conversions from non-Oracle to Oracle databases. Skilled in strategic planning, with experience in setting long-term goals, analyzing business needs, and implementing innovative solutions that align with organizational objectives. Expertise includes planning, identifying stakeholders, organizing bi-weekly meetings, tracking project resources and progress, and identifying bottlenecks to ensure timely project execution. Collaborative leader skilled in migrating and supporting databases on Oracle Cloud, AWS Cloud, and Azure Cloud."

TECHNICAL SKILLS

Databases: Oracle databases 19c/12c/11g/10g/9i/8i, MS*access and progress database, 10/11g/12c/19c Grid control, RAC ASM Storage management, Agile database.

Applications: ORACLE Applications (Financials, Distribution, Manufacturing, Projects, and e-Business Suite 11i (11.5.3,11.5.5,11.5.6,11.5.7, 11.5.8,11.5.9) and latest release12.0 and 12.1.1, 12.2.2, 11.0.3 & 10.7 SC &10.7NCA, 10g Application server, ZDRLA, Cohesity backup solution, Service Now, Splunk, Peoplesoft. OBIEE, Informatica, EPM. ODI.

Operating Systems: UNIX Sun Solaris 2.x, & 7, 8, 10 and 11, AIX (4.x), VAX VMS 5.2, Compaq Tru 64 Version 5.1, MS-WINDOWS NT 4.0 Enterprise edition, MS-WINDOWS 98/95/2000/XP, Linux, HP-UX, AWS Cloud, Azure Cloud, and Oracle Cloud.

Languages: SQL, PL/SQL, UNIX Shell Scripts. C, C++, FORTRAN, Pascal

Tools: ZDRLA, SQL*PLUS, SQL*FORMS, SQL*DBA, SQL*LOADER, ER win 3.5.2, SQL Navigator, SVRMGR, SQL* Net V2, SQL Lab, DEVELOPER-2000 (Forms 6i, 4.5, Reports 3i, 2.5), Visual Basic 5.0 and Visio, 9iAS, Apache Server, OAS 3.2., Jira. Confluence.

PROFESSIONAL EXPERIENCE

Qualcomm Incorporated, San Diego July 2022 – Dec 2024

IT Engineer, Senior Staff

Led the X9M Exadata-engineered machine configuration for the ZDRLA appliance, implementing a robust backup solution.

Database Installation: Coordinated the installation of Oracle Databases on Oracle Solaris Servers for OBIEE, Fusion Middleware, and Oracle E-Business Suite (versions 12.1 to 12.2.10).

Cell Disk Recovery: Managed the recovery of cell disks on X8M Exadata Servers as Oracle ZDRLA appliances, configuring new Exadata cells and ASM. Monitored system performance using metrics and Enterprise Manager, including disk replacements between cells.

Oracle Linux Management: Worked extensively with Oracle Linux on ZDRLA appliances, ensuring system integrity and performance.

Database Upgrade: Oversaw the successful database upgrade from 11i to 19c and Oracle applications from 12.1 to 12.2.10.

Backup Solution Transition: Directed the project to migrate from NetBackup to Cohesity for enhanced backup solutions.

Security Patching: CPU Security patching for databases and applications (version 12.2) to ensure compliance and security integrity.

Cross-functional collaboration: Coordinated with consultants across databases, applications, and middleware teams to achieve project objectives effectively.

Documentation and Training: Developed documentation and trained consultants on Cohesity backup tools to streamline operations.

Cloud Monitoring Upgrade: Upgraded Oracle Cloud Enterprise Manager from version 13.4 to 13.5, enhancing database monitoring capabilities.

Audit Collaboration: Worked with auditors to provide necessary audit data, addressing issues such as user access violations, financial responsibilities, backup failures, and racer certification.

Database Backup Replication: Designed and managed the replication of database backups between ZDRLA appliances and implemented unidirectional and bidirectional replication strategies.

AWS Database Management: Created and managed Oracle databases on AWS Cloud for ModelN applications, including EC2 and RDS instances, overseeing backup, snapshot creation, and restoration processes.

Performance Optimization: Improved database performance through advanced monitoring and analytics using Oracle Enterprise Manager (OEM).

Peraton(Split merge from HPE/HP) San Diego – Client: County of San Diego May 2012 – June 2022

Database Manager/Team Lead

Led the acquisition of Exadata X8M/X6 machines and 25 Oracle Solaris servers to support Oracle Databases for PeopleSoft, OBIEE, and Oracle E-Business Suite.

Exadata Installation and Configuration: Installed and configured Exadata servers, ASM, and database instances. Performed performance testing (CALIBRATE) and monitoring through Oracle Enterprise Manager.

Team Leadership: Led a DBA team for 9+ years, setting operational standards, monitoring databases, and proactively addressing performance issues.

Database Management: Managed Oracle 10g/11g/12c/19c RAC/ASM/Data Guard environments, with strong troubleshooting and performance tuning skills.

GoldenGate Expertise: Oversaw installing, configuring, and tuning Oracle GoldenGate for Oracle-to-Oracle environments.

OBIEE Support: Managed OBIEE 11g/12c/19c databases, including data movement, performance tuning, and migration from OBIEE 11g to 12c on Exadata.

Security and Compliance: Implemented database security, including Oracle Database Vault, VPDs, and Advanced Security Options to control database access and secure sensitive data.

Backup and Recovery: Performed database backup, recovery, and migration, including tuning RMAN backups and managing database refreshes.

Cloud and Migration: Migrated databases to Azure, created Data Guard environments, and utilized Oracle Cloud FastConnect for data uploads.

SQL Server Management: Installed, upgraded, and managed SQL Server 2008/2012, with experience in clustering, backup, SSRS, SSIS, and tuning.

Project Leadership: Led major projects such as data center relocations (LA to Texas), including planning, stakeholder management, and automation using Orchestrator for switchover and failover.

Disaster Recovery: Managed disaster recovery with Oracle 11gR2 RAC databases using Data Guard broker for switchover/failover and flashback for DR testing.

Technology Evaluation: Provided technology evaluations and recommendations to improve database management and operations for the County of San Diego.

ADDITIONAL RELEVANT EXPERIENCE AVAILABLE ON REQUEST:

Sponsorship: "willing to be sponsored for a TS/SCI Polygraph

PAPERS / SEMINARS

Computer Assisted Gender Recognition System, Department of Computer Science, AMU, Aligarh, 1989.

Natural and Human Resource Database Management Information System, National Institute of Science, Technology and Development Studies, New Delhi, 1993.

Natural Resource and Database Management Systems, National Institute of Science, Technology and Development Studies, New Delhi, 1993.

Y2K Contingencies, Jeddah King Fahd Hospital Jeddah, 1999.

E-Commerce Opportunities and Challenges, Jeddah, 2000

Is Your File Management a Stone Age System? Oracle Open World Sept 8-11, 2003

EDUCATION

MCA (Master of Computer Science and Applications) AMU, Aligarh, India

M.Sc. (Physics) AMU, Aligarh, India

B.Sc. (Physics, Mathematics, Chemistry) Gorakhpur University, Gorakhpur, India

TECHNICAL TRAINING

Certificate in Database Administrator (D.B.A.) by Oracle Corporation, Jeddah, Saudi Arabia, 1994

Certificate in Oracle Purchasing by Oracle Corporation, Jeddah, Saudi Arabia, 1998.

Certificate in Introduction to Human Resources by Oracle Corporation, Jeddah, Saudi Arabia, 1998.

Certificate in Human Resources Management System Setup by Oracle Corporation, Jeddah, Saudi Arabia, 1998.

Certificate in Payroll Setup by Oracle Corporation, Jeddah, Saudi Arabia, 1998.

Certificate in Human Resources System Administration by Oracle Corporation, Jeddah, Saudi Arabia, 1998.

Training at Informatics New Delhi, June 2000 on Oracle E-Commerce includes:

Introduction to SQL/ PL/SQL

Essential Components of Oracle 8i (Basic/Advanced)

Oracle Application Server: Administration

Oracle Application Server: Staying Secure on the internet

Oracle: WebDB: Build Web Sites and Components

Java Programming

OAS: Develop Web-Based Application with Java

Develop Database Application with Java

E-Commence based classroom project

Certificate training in Database Administrator (D.B.A.) for 10g –RMAN with Saisoft, Irvine, CA, USA

Certificate training for project management with Saisoft, Irvine, CA, USA

Certificate training VMware infrastructure with Saisoft, Irvine, CA, USA

ITIL V3 Certification, EXin USA

Training in Audit Vault, Oracle Corporation, USA

Training in Multitenant database, Oracle Corporation, USA

10g OCA and OCP Certified, Oracle Corporation, USA

11g OCP Certified, Oracle Corporation, USA

Oracle Cloud Infrastructure Developer 2020 Certified Associate Earned on: 06-Jul-2020

Oracle Autonomous Database Cloud 2019 Certified Specialist Earned on: 15-May-2020

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Earned on: 02-May-2020

Contact this candidate