Eric Welsh Email & Phone Number

Rancho Cordova, Ca, Us

Durham, North Carolina, Us

Serve as Sr. Data Architect ,Sr. DBA and technical SME between consulting, information technology, and implementation divisions of business, ensuring that database products and software installations are implemented efficiently and effectively while adhering to strict SDLC methodologies. Supervise and perform quality code review of database administrators.Develop policies and procedures for implementing and maintaining SQL Server applications. Implement and maintain database systems utilizing SQL Server 2000-2012 on 32 and 64-bit Windows platforms. Responsible for database design, performance tuning and optimization, capacity planning, backup and recovery for over 100+ database servers, 800+ databases in 15+Tb in size. Responsible for ongoing database security, disaster recovery, system upgrades, partitioning, data replication, log shipping, service broker management, database mirroring, physical/logical designing of SAN, server and database, data-modeling, OLAP RDBMS and Cube architecture, and all aspects of T-SQL programming. Architect, develop and maintained SOX and HIPAA-compliant based applications. Built a disaster recovery platform that asynchronously pulls all SQL server backups (native, LiteSpeed and encrypted) from entire enterprise in to a service based platform that consumes, manages and queues the backups, to run a series of validation checks that confirms the backups are valid, restorable, and functional. Architect and implement SMART maintenance routines that manage multi-Tb databases (i.e. index fragmentation, statistics review, partition management, logical and physical file management). Re-architected existing legacy data models with a physical and logical schema design that is conducive to current business needs including considering space consumption, performance and scalability. Conducts performance tuning MSSQL objects using advanced indexing code structure strategies that coincide with coding best practices

Clackamas, Or, Us

Responsible for the installation, programming, configuration, and administration of MS SQL Server databases, including system tuning, performance monitoring, database maintenance, report development, responses to custom user requests and assisting with user support. Maintained backup/restore policies with database disaster recover policies and deployment, security administration, performance optimization, SQL Server system design and architecture, locking mechanisms, log shipping transactions, internal data structures and data replication.Database Architectural Design:Responsible for the data warehouse, in-house ASP.NET, VB.NET applications and DTS ETL tool repository databases. Built all phases of data warehouse projects from hardware setup configuration and rollout to database architecture, ETL data cleaning, and object/security administration. Interfaced with data sources such as AS/400 DB2, SQL, Flat File, MS-Access, and Excel. Responsible for all phases of the presentation process MicroStrategy MSTR V.8 to build the various projects using SDLC. Full working knowledge of metadata architecture, data modeling, report design using HTML, OLAP, Report Services development including custom FreeSQL reports. Built a customized web interface that effectively utilized dynamic subscriptions. Configured MSTR Narrowcast delivery system to build schedules, subscriptions and reporting event triggers to control report deliveries. Network:AS/400 Administration, aside from interfacing with the AS/400 for data retrieval performed administrative duties on the AS/400, from creating user accounts, setting security levels, creating and modifying Ad Hoc queries within the main frame and developed thin client applications. Performed network duties such as configuring LAN/WAN interface for server workstations, routers, manageable switches, printers, faxes, Inter-tel PBX Digital phone system.

Network Administrator responsible for the implementation and repair of 35 remote national servers and over 2000 desktops. Delegated resources and maintained administration of LAN/WAN. Aided in the administration of SQL Server. Responsible for the creation and editing of tables, views, writing procedures and DTS packages in order to roll out custom data feeds. Provided internal/external technical support to assist with troubleshooting and diagnosis for all contracted clients. Tested and corrected “The Meyers Group” software for bugs. Wrote 250 custom VBA database applications for clients. Managed and implemented SQL 7.0 and SQL 2000 servers. Assisted in the creation and manipulation of data warehouse rollouts.