NetApp Storage Architect
Resume:
Mitchell Sojdehei
*********@*****.***
Senior NetApp Solutions Architect & NetApp Certified (NCDA) & NetApp/Microsoft Solutions Architect. Non-Disruptive Upgrades (NDU), NetApp VMWare, NetApp Oracle, NetApp SqlServer, NetApp Cluster-Mode, 7-Mode, NetApp Exchange, NetApp CIFS, NFS, ISCSI, FCP implementation.
Mr. Sojdehei is a NetApp Solutions Architect with over 15 years of NetApp Certified Database and Storage experience. As Storage Architect, he did storage design with volume layout including writing NetApp Snapshot/FlexClone/SnapMirror, CIFS, CIFS Security, NAS(NFS) Security scripts using some of the latest NetApp SnapManager suite of tools. As Oracle DBA he managed databases over 500 TB including replication monitoring, and scheduled jobs monitoring. He offers 17 years of Oracle RAC with ASM, RMAN, and Data guard experience. Mitchell offers experience with Microsoft SqlServer, and Golden Gate Oracle’s latest replication tool in addition to expert level experience in database exports, table space management, and extents management. He has heavy experience in performance tuning, upgrading database software, completing database replication, data backup and recovery procedures as well as heavy involvement with physical and logical design of databases. Mitchell has the ability to manage, architect, configure, install, and maintain multiple and hybrid databases. As DBA manager he is well versed with all aspects of management life cycle and responsibilities. His experience includes Non Disruptive Uprades (NDU), NetApp/Sqlserver, NetApp/Exchange, NetApp/CIFS, and NetApp/Sharepoint Architecture and Implementation. NetApp Virtual Console, NetApp/VMWare, NetApp Cluster Mode. As a Senior Oracle and NetApp Architect, Mr. Sojdehei has participated in numerous escalations and Root Cause Analysis Findings while at IBM. Also, participated in EMC Architure Solutions Projects, and EMC/VmWare, and EMC to NetApp Migration projects. Thorough experience with setup of Brocade, Broadcom, Qlogic, Emulex , and Cisco UCS Switches
connecting to NetApp Storage.
Summary of Qualifications:
NetApp Non Disruptive Upgrade.
NetApp Custer Mode.
NetApp 7-Mode.
NetApp Disaster Recovery Planning.
Oracle Disaster Recovery Planning.
NetApp Data Storage performance tuning.
NetApp SnapManager for Oracle tuning.(SMO)
NetApp SnapManager for SAP tuning.(SMSAP)
NetApp Operations Manager tuning. (NetApp OnCommand product line)
NetApp Virtualial Console. NetApp/VSphere, NetApp/VirtualPC, NetApp/Citrix.
NetApp Database Storage tuning.
NetApp SAN expertise.
NetApp LUN Design Layout and Architecture expertise.
NetApp Virtualization expertise.
NetApp V-Series expertise.
NetApp SnapManager for SQL Server(SMSQL)
NetApp SnapManager for Exchange(SME)
NetApp SnapManager for Share-point (SM-sharepoint)
NetApp SnapManager for Virtual Infrastructure(SMVI)
NetApp AutoSupport, PerfStat, PerfViewer and escalations engineer expertise.
NetApp OSSV – Open Source SnapVault Expertise.
EMC Clariion, Symmetrix Solution.
EMC Solutions Architectrue and Planning
EMC to NetApp Migrations.
Oracle Golden Gate.
Oracle 10g RAC on SAN design expertise.
Veritas SAN expertise.
SAN and NAS Design Layout expertise.
SAP on NetApp appliance.
SAP Oracle BRTools implementation and production support.
Veritas LUN Storage Layout and Architecture.
Oracle 11g data migration.
Oracle 11g Golden Gate.
Oracle 10g Replication and monitoring.
Oracle 10g and 11g ASM and RAC installation and implementation.
Oracle 10g Data Warehousing, Data Modeling and in all aspect of Database Management Systems.
Oracle 10g RAC ASM and RMAN Installation, implementation and planning.
Oracle 10g and 11g RAC Database Development, Database Administration and Production Support.
Database Architect / Senior Production and Development ORACLE and SQL Server Database Administrator SQL Server to Oracle data migration.
Sybase to Oracle data migration.
Oracle 10g, 11g RAC (Real Applications Cluster) support.
Oracle RMAN (Recovery Manager).
Oracle Performance and Tuning/Tracing/debugging (Stats pack Utility or AWR Report)
Oracle RMAN Backup and Recovery.
Oracle RAC (including Interconnects), Grid technologies, Data guard, and Data Streams.
Oracle Change Data Capture and Oracle Streams experience.
Partitioning (Oracle Partitioning and Quest Partition Magic)
Business Objects (Crystal Reports).
Setup of FireWire based shared storage on red hat Linux for Oracle RAC 10g.
Setup storage on Suse Linux for Oracle RAC 10g.
Programmer (Java, J2EE, C/C++, SQL; T-SQL, PL/SQL, Perl, Korn, Bash, DOS, CMD Shell Scripting, Tcl/Tk).
Oracle SAP, Oracle PeopleSoft, Oracle Siebel database installation and support.
DB2 UDB Database Administration.
OLAP, Data Warehousing, Data Mining design, implementation, and support.
Oracle BPEL – Business Process Execution Language for e-business process integration .
Content DB Management through BPEL using Oracle.
Application Server(Web-Sphere, Web-Logic, IIS)
UNIX (Solaris, AIX, HP-UX, Linux) and WINDOWS system administration, including clustered systems.
Rational ClearCase.
7 years experience in Healthcare Industry
8 years experience Telecom Industry
Experience facilitating large-scale data migration, script conversion, technical innovations, staff development, negotiation and coordination with many diverse people
Technical Summary:
Current Skills
Current SkillsExp.
Including
Oracle DBA
Oracle DBA19 years
(7.3.x, 8.0.x, 8.1.x, 9.x, 10g, 10g RAC, 11g, 11g RAC)
NetApp Storage Architect
NetApp Storage Architect18 years
NetApp 7.xx, 8.xx, GX, Cluster mode
NetApp software
15 years
Operations Manager, SMO, SMSQL, SME, SMVI, VSC, SMOSS, SMSAP
Oracle Golden Gate
Oracle Golden Gate8 years
Oracke. SqlServer, DB2
DB2
DB25 Years
IBM AIX
Sybase
Sybase5 years
(version 8, 9, 10)
SQL Server DBA
SQL Server DBA8 years
(T-SQL Scripting, Replication 64 bit windows 2003 Server)
T-SQL Scripting
T-SQL Scripting7 years
(SQL Server T-SQL scripting)
UNIX System Administration
UNIX System Administration12 years
(RHEL, CentOS, AIX, Solaris, HP-UX)
Windows System Administration
Windows System Administration10 years
SQL Programming
SQL Programming12 years
(incl. Optimization, Profiling and Trace Analysis)
PL/SQL Programming
PL/SQL Programming10 years
C /C++ Programming
C /C++ Programming10 years
(incl. Oracle OCI, OTL)
Java/J2EE
Java/J2EE7 years
(WebSphere managed and container j2EE Programming)
PERL Programming
PERL Programming10 years
(incl. Oracle binding, programming)
Business Objects
Business Objects 5 years
(Crystal Reports)
KORN Shell Programming
KORN Shell Programming10 years
BASH Shell Programming
BASH Shell Programming10 years
DOS / CMD Shell Programming
DOS / CMD Shell Programming10 years
HTML Programming
HTML Programming10 years
ETL tools (Informatica, Data Stage)
ETL tools (Informatica, Data Stage)10 years
Technical Documentation
Technical Documentation 8 years
TCP/IP Networking
TCP/IP Networking11 years
PC Hardware
PC Hardware10 years
Work Experience:
IBM Global Services, NetApp Certified Architect(NCDA), Unitek and CDW April 2010 to present
Involved in Pre/Post Sales. Implementations included Non-Disruptive Upgrades, installs and provisioning NetApp 8.x.x-7Mode, and NetApp Cluster-Mode(64bit). Implemented NetApp Snapshot, SnapMirror, FlexClone, FlexShare, SnapVault, SnapMirror, Syc-Mirror.Worked at NetApp Univesity(Unitek) as Instructor and Implementation Architect on SMSQL, SMO, SMSAP, SMVI, VSC, SME, SMOSS. While at IBM worked on projects at IBM clients as Oracle and NetApp Architect at Amgen, Genentech, and Hertz. While at NetApp worked on projects at: PayPal, Yahoo, Ebay, Cisco, AMD, Agilent, BlueCoat, Bunge, Genentech, Apple, Finisar, Formfactor, Saber, and Globe Intl amongst others. Expert level NetApp data storage architect using SnapManager for Oracle, SMSAP, SAP, SqlServer, Virtualization, and Operations Manager(DFM). Worked with NetApp customers for all oracle 10g and 11g migrations from Solaris to Linux to windows to Oracle VM. Worked with IBM customers for all Oracle 10g migrations from AIX to Oracle 11g Linux VM. Design and implementation of new product databases on Network Appliance Storage(IBM N-series). Design and implement NetApp Volume/LUN Layout and Storage Architecture.(IBM N-series). Design and implement Veritas LUN Layout over NetApp Storage Architecture.(IBM N-series). Used Database Server monitoring and capacity management (Quest Spot-light, Net-IQ) on NetApp Storage. Reverse engineering of DB2 database and convesion of schema to Oracle on NetApp Storage. Creation and maintenance of Oracle 10g with Golden Gate and Oracle 11g RAC databases on NetApp Storage. Implementation of Oracle 10g database on IBM AIX, Solaris, and Linux on NetApp Storage. Design and implemented Oracle 10g to manage business process integration on NetApp Storage. Design and implemented SAP Oracle 10g BRTools on NetApp Storage Appliance. Design and implemented Oracle 10g Veritas Cluster and wrote shell scripts for NetApp backup/recovery. Managed DB content using Oracle 10g Grid Control NetApp Plug-in and SnapManager for Oracle. Oracle and PL/SQL script tuning for NetApp Storage.
Key Accomplishments:
While at IBM worked on an assignment at Amgen implementing Non-Disruptive Upgrades on NetApp OS, and implemented Oracle Veritas cluster on NetApp Storage. While at IBM worked on an assignment at Hertz implementing Oracle Golden Gate. Trained Oracle DBA team on Oracle on NetApp cloning and fast restore technologies. Rapidly supported NetApp Data Storage for distributed 24/7 transaction and reporting system spread over multiple data centers, multiple UNIX-type OSes, multiple versions of Oracle (including 10g RAC on Solaris 10), and multiple products, covering a diverse family of technical problems from hardware issues to performance tuning. On NetApp Data Storage, developed new product database and participated in all aspects of the entire development cycle, including developer support, testing and implementation. On NetApp Data Storage, performed complex, remote conversion of production database from Oracle 10g to 11g, including hand-scripted recreation of most database objects , encryption of a subset of the data via TDE, scripted Netapp backup and recovery, and verification of new database after conversion.
Southwest Airlines, Dallas Texas Aug 2009 to May 2010
Senior NetApp Database Architect:
Worked on Non-Disruptive Upgrades(NDU) of NetApp OS, and worked on migration of Solaris9 Oracle 10g to Linux RedHat Oracle 11g. Worked on tuning and performance enhancements of two 4 node 4TB production databases. Worked on Daily DBA tasks involving management of all production, QA, Dev databases of over 38 TB in size. Developed scripts for RMAN backups. Developed GridCntrl jobs to run RMAN backups in place of cron. Worked on setup of Oracle RAC srvctl and CRS, voting disk. Worked on setup of DataGuardBroker to automate fast failover. Worked on setup of DataBuardBroker using GridCntrol to monitor DG performance. Worked with the Linux Admin to fine tune OS settings per recommendations on Oracle Metalink for Oracle 11g RAC. Worked extensively on debugging using Oracle Metrics and Policies threshold settings. Worked extensively on debugging Oracle RAC OCR environments and in conjunction with Oracle Golden gate.
Key Accomplishments:
While at Southwest Airlines worked on Oracle RAC on NetApp Storage. While at Southwest Airlines worked on implementing Oracle RAC/ASM/R-MAN with Golde Gate. Trained Oracle DBA team on Oracle on NetApp cloning and fast restore technologies. Rapidly learned to support NetApp Data Storage for distributed 24/7 transaction and reporting system spread over multiple data centers, multiple UNIX-type OSes, multiple versions of Oracle (including 10g RAC on Solaris 10), and multiple products, covering a diverse family of technical problems from hardware issues to performance tuning. On NetApp Data Storage, developed new product database and participated in all aspects of the entire development cycle, including developer support, testing and implementation. On NetApp Data Storage, performed complex, remote conversion of production database from Oracle 10g to 11g, including hand-scripted recreation of most database objects, and Netapp backup/recovery snapshots/Fleclones/SnapMirror.
Southernwine & Spirits, FL Feb 2009 to Aug 2009
Senior NetApp Database Solutions Architect (Oracle-SAP):
Worked on tuning and performance enhancements for a 7TB SAP production database. Worked on Non-disruptive upgrades of NetApp OS, and worked on migration of Oracle 1og RAC from Solaris9 and solaris 10 and AIX to Linux Red Hat VM Oracle 11g for development and QA test environments on NetApp Storage. Worked extensively with the Storage Architect designing and architecting Oracle 11g Virtualization environment on NetApp Storage. Setup and tested Oracle 11g VM on NetApp Storage. Used SAP OSS Notes to verify Oracle settings per SAP recommendations for NetApp storage. Worked on Daily DBA tasks involving management of all production, QA, Dev databases of over 28 TB in size. Developed scripts for RMAN backup using cron. Developed GridCntrl jobs to run RMAN backups in place of cron. Worked on setup of DataGuardBroker to automate fast failover. Worked on setup of DataBuardBroker using GridCntrol to monitor DG performance. Worked extensively with the SAP team on performance tuning, index builds, and SAP recommendations . Worked with both NetApp and IBM DS5300 storage team to fine tune LUNs and file system layouts related to SAP and Oracle. Worked with the AIX and Solaris Admins to fine tune OS settings per recommendations on Oracle Metalink and SAP OSS notes. Worked on Oracle Streams – Capture – Replicaiton – Propegate to replicate specific tables, tablespaces and whole database. Worked on Oracle Golden Gate to replicate data across heterogenous databases (from Oracle to SqlServer, MySQL). Worked extensively on debugging using Oracle Metrics and Policies threshold settings. Worked extensively on debugging Oracle RAC OCR environments and in conjunction with Oracle Streams usage.
Network Appliance – Sunnyvale, CA Oct 2005 – Feb 2009
Senior NetApp Storage Architect / Database Storage Solutions Architect:
Implemented NetApp Snapshot, SnapMirror, FlexClone, FlexShare, SnapVault for Oracle. While at NetApp worked on projects at: Yahoo, Google, Ebay, Cisco, AMD, Agilent, BlueCoat, Bunge, Genentech, Apple, Finisar, Formfactor, Saber, and Globe Intl amongst others. Expert NetApp data storage architect using SnapManager for Oracle, SMSAP, SAP, SqlServer, Virtualization, and Operations Manager(DFM). Worked with NetApp customers for all oracle 10g and 11g migrations from Solarisxx to Linux Oracle VM. Worked with NetApp customers for all Oracle 10g migrations from AIX to Oracle 11g Linux VM. Design and implementation of new product databases on Network Appliance Storage. Design and implement NetApp Volume/LUN Layout and Storage Architecture. Design and implement Veritas LUN Layout over NetApp Storage Architecture. Have gained experience using Data Warehousing Tools i.e. Informatica 6.1, Business Object, Erwin. Reverse engineering of SQL Server database and conversion of schema to Oracle on NetApp Storage. Used Database Server monitoring and capacity management (Quest Spot-light, Net-IQ) on NetApp Storage. Reverse engineering of DB2 database and convesion of schema to Oracle on NetApp Storage. Creation and maintenance of Oracle 10g with Golden Gate and Oracle 11g RAC databases on NetApp Storage. Implementation of Oracle 10g database on IBM AIX on NetApp Storage. Design and implemented Oracle 10g to manage business process integration on NetApp Storage. Design and implemented SAP Oracle 10g BRTools on NetApp Storage Appliance. Design and implemented Oracle 10g RAC and SMO and SMSAP suite of NetApp products. Managed DB content using Oracle 10g Process Management on NetApp Storage. Oracle and PL/SQL script tuning for NetApp Storage. Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases. Utilized Oracle Streams Applied Load Balancing with N-way Replication within managed databases. Utilized Oracle Streams for information dissemination by using Hub and Spoke Replication. Utilized Oracle Streams for Table Replication with Synchronous Capture. Utilized Oracle Streams Message Queuing and Advanced Queuing with IBM Web Sphere. Initial build script development and maintenance for Oracle Business Suite on NetApp Storage. Creation and maintenance of test schema on NetApp Storage. Conversion of text file (initial load) data (including use of Pervasive Data Junction tool). Oracle 10g import/export and migration to Oracle 10g enterprise. Implementation into production database on NetApp Storage. Database migration Oracle 8.1.7.4 to 10.2.0.1, including (manual) scripting for conversion of all database objects on NetApp Storage. Reverse engineering of all database objects on NetApp Storage. Schema comparisons via TOAD on NetApp Storage. Optimization of long-running processes by parallel processing on NetApp Storage. Support of Oracle database servers v9.2.x, 10.x, 10g RAC on NetApp Storage. Troubleshooting and 2nd-level support for database application issues on NetApp Storage. SQL Server 64 bit on Windows 2003 Server support and issue management on NetApp Storage. Remote administration of Unix OS: HP-UX, Solaris, Suse Linux with NetApp Storage. Backup and recovery via RMAN scripts and troubleshooting on NetApp Storage using SMO. Monitoring of Oracle database; automated error notification on NetApp Storage using NetApp Operations Manager. SQL statement analysis, tuning, and storage on NetApp FAZ30XX and FAZ60XX. Storage analysis and allocation on NetApp Storage devices. Online index rebuilds and storage recovery best practices on NetApp Storage.
Key Accomplishments:
While at NetApp worked on an assignment at Genentech implementing Oracle RAC on NetApp Storage. While at NetApp worked on an assignment at Gilead Sciences implementing Oracle RAC/ASM/R-MAN with Change Data Capture and Oracle Streams. Trained Oracle DBA team on Oracle on NetApp cloning and fast restore technologies. Rapidly learned to support NetApp Data Storage for distributed 24/7 transaction and reporting system spread over multiple data centers, multiple UNIX-type OSes, multiple versions of Oracle (including 10g RAC on Solaris 10), and multiple products, covering a diverse family of technical problems from hardware issues to performance tuning. On NetApp Data Storage, developed new product database and participated in all aspects of the entire development cycle, including developer support, testing and implementation. On NetApp Data Storage, performed complex, remote conversion of production database from Oracle 8i to 10g, including hand-scripted recreation of most database objects.
IIS-Software, Inc. (McKesson Health Care Systems – Dallas, Texas) Dec 2004 to Oct 2005
(Dimensional Fund Advisors – Santa Monica, California)
DBA Manager/ Senior DBA:
Design and implementation of new product databases. Worked on migration of Solaris 9 Oracle 9i to Linux Suse oracle 10g RAC. Have gained experience using Data Warehousing Tools i.e. Informatica 6.1, Business Object, Erwin. Reverse engineering of SQL Server database and conversion of schema to Oracle. Used Database Server monitoring and capacity management (Quest Spot-light, Net-IQ). Reverse engineering of DB2 database and convesion of schema to Oracle. Creation and maintenance of DB2 database. Implementation of DB2 database on IBM AIX. Design and implemented Oracle BPEL to manage business process integration. Managed DB content using Oracle BPEL Process Management. SQL Server T-SQL script conversion to Oracle PL/SQL script. Initial build script development and maintenance. Creation and maintenance of test schema. Conversion of text file (initial load) data (including use of Pervasive Data Junction tool). SQL Server data migration to Oracle 10g enterprise. Implementation into production database. Database migration Oracle 8.1.7.4 to 10.2.0.1, including (manual) scripting for conversion of all database objects. Reverse engineering of all database objects. Schema comparisons via TOAD. Optimization of long-running processes by parallel processing. Support of Oracle database servers v9.2.x, 10.x, 10g RAC. Troubleshooting and 2nd-level support for database application issues, including.SQL Server 64 bit on Windows 2003 Server support and issue management. Remote administration of Unix OS: HP-UX, Solaris, Suse Linux, Red hat Linux. Backup and recovery via RMAN scripts and troubleshooting. Monitoring of Oracle database; automated error notification. Implementation of Oracle Transparent Data Encryption (TDE). SQL statement analysis and tuning. Storage analysis and allocation. Online index rebuilds and storage recovery.
Key Accomplishments:
Rapidly learned to support extremely complicated distributed 24/7 transaction and reporting system spread over multiple data centers, multiple UNIX-type OSes, multiple versions of Oracle (including 10g RAC on Solaris 10), and multiple products, covering a diverse family of technical problems from hardware issues to performance tuning. Developed new product database and participated in all aspects of the entire development cycle, including developer support, testing and implementation. Performed complex, remote conversion of production database from Oracle 8i to 10g, including hand-scripted recreation of most database objects , encryption of a subset of the data via TDE, and verification of new database after conversion.
IIS-Software ( Precision Software, Inc. - Dallas, Texas) Nov 2003 to Dec 2004
Senior DBA / DBA Manager:
Helped build and support a local software team to reduce cost, time to market, and significantly increase quality of releases, and upgrade of SQL Server databases. Data Warehousing Skills Design, Implementation & Data Modeling using ETL Tools Version Informatica 6.2, Business Object 5.5, ERWin. Standardized database software releases and install procedures and wrote automation to install releases off-hours. Developed database software release installation standards for both SQL Server and Oracle databases based on company guidelines on naming conventions and past experience with releases. Developed three standardized levels of release for Sybase install automation including hand installs, SQL controlled installs and fully automated installs, documentation, templates and examples for each, to cover every install requirement. Fully automated install program (Perl) is platform independent, schedulable, network aware and Oracle aware, and can be adapted to run almost any processes including RPC processes. Thorough documentation set, including online documentation provided in the program, MS Word documentation and HTML documentation suitable for intranet use. Supported development, project management and business analyst teams in addition to supporting high-volume call center, production database, archives database (data warehouse), training and multiple test environments. Subject matter expert for SQL Server and Oracle, database installs, database logical and physical structure, storage allocation. Application development support to programmers on all aspects of SQL Server and Oracle database programming. Responsible for all software release installs to test, training and production databases for both SQL Server and Oracle. Responsible for maintenance and improvement of production, archive Oracle database. Responsible for data refreshes for production, development and training databases. Responsible for storage usage of all databases, including rearrangements of the database logical structure and tables when needed. Completely rebuilt Oracle database system twice, to upgrade Oracle binaries, implement new, higher performing hardware, rearrange and rework logical structure for better performance, implement clustering and failover high-availability via Oracle Fail Safe, implement large SAN. Troubleshooting application errors and performance issues, including process simulation, to isolate and identify issues; implement solutions to both short and long-term issues; continued refinement of solutions. Automated many common tasks including: Backups, exports and imports, archiving old records and verification of such processes. Periodic trimming of Oracle system log files and removal of old redo log archives. Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics (performance tuning). Gathering of both database and operating system metrics relevant to performance monitoring and tuning. Stress testing of new database installations. Patch sets to Oracle database binaries that lacked installation programs. Responsible for Oracle and SQL Server database security and patching, Oracle database capacity analysis and planning. Wrote and delivered technical presentations on Oracle and SQL Server database operation (to colleagues). Documentation of Oracle and SQL Server database operations and training of backup personnel. Added duties of two development DBA’s to regular production DBA tasks. Exposure-level use of Oracle Designer; Design and Data Modeling (typically, I write scripts by hand).
Key Accomplishments:
Improved success rate of deployed tasks per test failure by more than 150% as part of development team. Improved overall productivity of the development lifecycle by over 40% as part of development team. Deployment of over 15 high-demand timesaving software changes as part of development team. Deployment of more than 150 releases in all. Drastically reduced unscheduled downtime and improved performance. Automated backups, software release installs, performance tuning and database metrics gathering. Improved backup processes resulting in one-minute (downtime) cold backups. Rebuilt, reorganized and simplified databases, enhancing development, maintenance and performance. Improved database replication practices resulting in on-demand, one-hour refresh. Documented most critical procedures and trained backup staff to run them.
Contact this candidate