Cross platform migration to Engineered Systems - Oracle superclusters/Exadata, Dataguard, Real Application Testing, Enterprise Manager 13c. TDE, security vulnerability. Exadata auto disk man-agement; Expansion of storage by adding new storage cells; GDPR; network encryption; ASR; shell scripting; cell management; cellcli/dcli; WriteBack Flash Cache; multiple deployments; exachk

Oracle Database Exadata Cloud Service.Oracle Connection Manager.Oracle Database Appliance.

Environment: X3-2, X4-2, X5-2, ZFS, EM12cR5, RAC one nodeImplementation of Exadata Best Practices. Exadata critical issue evaluation. Exadata Vulnerability scan analysis and mitigation. Assessed and resolved vulnerabilities against various components of Exadata including Infiniband switches, ILOM’s, Host Databases, listeners, OS etc.Designed and Implemented Dataguard Physical standby RAC on Exadata, using a second network for Log shipping.Integration of EM12c and Oracle Database Instances with edirectory as External LDAP.RMAN backup and Restore with various compression types on ZFS appliance.

Data Center Migration, Data IntegrationCapacity Planning, ForecastingOracle Exadata Full Rack Implementation, Extended Exadata x2-2 from a half rack to a full rack, Implemented Best Practices for Database consolidation on Exadata, Implementation of Instance Caging, Database Resource Management (DBRM), IO Resource Management (IORM), High Availability (HA) Testing of Exadata, Deployment and Configuration of Enterprise Manager 12c for managing Exadata (Advanced Reporting and Proactive monitoring using SNMP traps; Exadata Dashboard), Configuration of ASR, Exachck, Designed and Implemented High Availability solutions according to Oracle's Maximum Availability Architecture (MAA)Active Dataguard, working knowledge of Golden Gate Integrated Extract. Created and configured ASM disk groups on Exadata, Administered Exadata Storage servers (metrics and alerts) using CellCLI, Advance Performance Tuning, Configured the Database File System (DBFS) for GG Trail files, OSWatcher.

Lead efforts to build environment for new projects from scratch. Experience in Exadata environments, Logical Dataguard in a RAC cluster, active DG on Exadata. Setup and configured DBFS. Exadata implementation, implementing Maximum Availability Architecture. Experienced with installation, setup, configuration and customization of Oracle Grid control. Experienced with implementing Oracle Advanced Compression, IORM, upgrading Exadata software.Oracle Exadata x2-8 Implementation, DBRM & IORM, EM 12c implementation for the Enterprise

Database installation and Administration in Real Application Cluster environment. Used RMAN for Hot backups with Veritas Net Backup as MML. Transportable Tablespace Backup as an archiving solution for the warehouse. Extensive work experience with OEM Grid Control and Database Control. Performance tuning with the help of Extended SQL trace using event 10046, Oracle statspack reports, session events/ waits, ASH and AWR reports. Install Oracle software, patches, upgrades, disk layouts and database creation for new projects. Assisted the team in setting up 10gR2 RAC on RH Linux, ASM, and Netbackup. Encryption of PSI data using DBMS_OBFUSCATION tool kit. 24 X 7 on call support. Evaluated new features in 11g. Disaster recovery tests. Data Center Consolidation (DCC). Performed database migration.

Responsible for supporting Sprint’s Financial Dataware House from physical as well as environmental database perspective. Oracle Parallel Server environment, Replication; Worked with DA’s to design and implement DDL for production changes. Implemented shell scripts to monitor database activities in OPS environment. Helped developers to tune their code for performance optimization of their SQL queries. 24X7 On-call support, Oracle upgrade in OPS environment. Data Migration from and to an OPS environment.