Darryl D. Dan www.linkedin.com/in/ darryl-d-dan
[email protected] | Beaverton, OR | C: (503) 407-5728 SUMMARY
Process Automation – Utilized the use of T-SQL and PowerShell to automate administrative tasks. Automated the process process of collecting and storing database database space information centrally for storage forecasting. Automated the process for determining and and alerting (if necessary) when a database object had changed. Performance Tuning – Worked with developers and system analyst to ensure the database performance is optimal. Worked with the teams to isolate the areas that that can be improved. Security and Compliance – Ensured the databases were within security and patch compliance. Primary contact for for the SOX audit compliance. Technical Skills Operating Systems – Windows NT, 2000, 2003, 2008, and 2012, Clustering o SQL Server – 6.5, 7.0, 2000, 2005, 2008/R2, 2012, and 2014, Cluster o
EDUCATION Portland State University - Portland, OR Fall 2014 – Present Pursuing Bachelor of Science in Business Administration – Supply and Logistics Management (anticipated graduation: March 2017) Washington State University - Pullman, WA Fall 1980 – Summer 1985 Bachelor of Science in Science in Business Administration - emphasis in Management Information Systems, Minor in Computer Science
PROFESSIONAL EXPERIENCE INTEL CORPORATION – Hillsboro, OR Database Engineer – SQL Server
1999 – 2016 2006 - 2016
Performed process automation for collecting the SAP Data Services and Information Steward application database database information for weekly review. Worked with the Basis Engineers, System Analyst and development team to monitor the database growth with the use of automated T-SQL and PowerShell PowerShell scripts. Utilized T-SQL script to refresh the Solution Manager objects after the application pre-production databases were “refreshed” from production data. Utilized T-SQL and PowerShell scripts in the process of collecting database database SAN space utilization and for forecasting purposes. Worked with the System Analyst for the eMDM application on performance concerns. Worked closely with the Analyst to review the query execution plan to determine the initial area of improvement. improvement. Worked with the the Analyst to ensure the indexes indexes optimized for the objects.
As the representative for the group for the Rapid Response Security team, I would create the project plan to implement security remediation activities for the SAP database environment. During the Sarbanes-Oxley audit, I represented the organization and provided the technical expertise to resolve any audit issues. For any audit concerns, I provided the technical reports for management and provided the execution plan to resolve the audit concerns. o Technical summary – Windows 2003R2, Windows Server 2008R2, Windows Server 2012, Windows Clustering, SQL Server 2005, SQL Server 2008/R2, SQL Server 2012, and SQL Server 2014
System Engineer/Database Engineer – Middleware Application group
Determined the initial database configuration configuration build to be used by the group. Utilized the SAP database BKM information to help stabilize the database environments. Worked with the System Analyst, System Engineers, and development team to work on application performance performance benchmarks. Worked with the System Engineers Engineers to determine performance issues to isolate areas of improvement for the vi rtual server configuration. Technical summary – Windows Server 2008R2, SQL Server 2008R2 o
System Engineer/Technical Project Lead
Provided the OS, application and database support for several Intel internal materials applications. Worked with the developers on the coordination coordination of patching, and release management for the application. Performed the other administrative functions functions for the support of the application (i.e. backup, restores, etc.). Technical summary – Windows Server 2003R2, Windows Clustering, SQL Server 2005 o 2001 - 2004
Provided the primary database support for the internal application for materials forecasting. Created the early SQL Server security models that provided more security for the application. Created the T-SQL and batch files to be able to back up the production database and restore the backup file to the non-production environments. Wrote a couple of stored procedures that used in production. production. As the developer teams became comfortable with my skills, I was assigned some stored procedures that became part of the application. o Technical summary – Windows Server 2003, SQL Server 2000, Windows Clustering
Systems Engineer
2004 - 2006
Provided the technical expertise in the coordination coordination of data center migration. Worked with the project manager and system engineers to coordinate the movement of critical application to Folsom CA, and less critical application to another Hillsboro OR data center.
Database Administrator/Developer
2013 - 2014
1999 - 2001
Provided the OS, basic application and database support for an internal data warehouse application within Intel. Created scripts that would would determine if there were any database orphan accounts and provide the code to remove the orphan accounts from the database. o Technical summary – Windows NT 4.0, SQL Server 6.5 and 7.0
