Senior Systems Engineer, Data Architecture
Plano, Texas, Us
-Designed, built, and documented the enterprise SQL environment, consisting of 5 multi instance/ multi node SQL 2005 clusters, 5 multi instance/multi-node SQL 2008/R2 clusters, 4 multi instance/multi node SQL 2012 clusters, 3 multi instance/ multi node SQL 2000 clusters, 6 SSIS 2005 batch servers, 6 SSRS 2005 servers, 6 SSRS 2008 servers, 6 SSRS 2008R2 servers, and 4 SSRS 2012 servers..-Wrote, tested, and implemented the enterprise SQL business continuity plan, achieving the first, fastest complete system restoration in the company during an actual datacenter outage.-Supported and administered all SQL databases in the store, enterprise, and dot com environments, numbering over 100,000 databases, over 500 terra bytes of storage, and 1,000,000 SQL Server Agent jobs.-Developed, documented, and deployed code that performed automated upgrades of all stores databases from SQL 7 to SQL 2008 on over 1000 servers.-Designed, built, and supported over 5,000 integration packages utilizing DTS, SSIS 2005/2008, and Informatica for systems integration and ETL processes.-Provided technical direction for the JCP SQL data architecture team in regards to infrastructure architecture, best practice development, performance tuning, and change management.-Assisted on install of MS Systems Center 2012(SCOM, SCCM, and SCVMM) for the JCP stores team, installed, audited, and developed the ruleset and health monitors for the SQL and clustered server environments. -Assisted application development teams in T-SQL coding, mentoring developers in best business practices for database and stored procedure design, as well as performing code reviews of new/upgrading applications. -Performed training for new team members and application teams on enterprise database environments, proper use of ANSI SQL in application code, and best practices of database interaction for applications utilizing dot net, java, COBOL, and c# methodologies.