Tim Harkin Email & Phone Number

Wilton, Connecticut, United States

Norwalk, Ct, Us

Hamilton, Bermuda, Bm

Work with business analysts and other architects to develop a data warehouse model using ERWin (versions 7.3 and 8.2). Managed the master model and several sub-models to support different development efforts. Create database schemas for various development teams. Implement source control for databases. Changed database warehouse release process to use source control for all deployments.Performance tune data warehouse ETL and reporting queries.Work with ETL developers to use SQL best practices, and reviewed their SQL codeImplemented partitioning and piecemeal backup and restore for the data warehouse environmentImplemented Change Data Capture on source systems

Responsible for disaster recovery and high availability of the database environmentArchitect new data platform to accommodate the expanding needs of the business Reduced deadlocks in main application database from 75-100 a week to 3Set up replication for reporting purposesRemove unused indexes and addition of new ones to enhance query performanceRefactor stored procedures to improve performanceCreate new SSRS reports and migrated existing ones from OLTP Database to Data WarehouseSet up log shipping for disaster recovery

• Responsible for maintaining uptime and reliability of over 60 SQL servers hosting in-house and third party applications. Strategies included clustering, replication, and log shipping. Duties included server build and implementation, disaster recovery planning and testing.• Design and implementation of ETL processes using SQL Server Integration Services. • Build and deployment of BI solutions using SQL Server Analysis Services. • Work with developer teams to troubleshoot performance issues using SQL profiler, Perfmon, Idera’s SQL Diagnostic Manager, and other tools. • Provide database analysis and consultation to software projects. • Migrated and upgrade databases from SQL 2000 to SQL 2005 and SQL 2008. • Management of all production changes.• Systems Administration tasks include maintenance of IIS, JBoss, Citrix, Confluence, Jira, McAfee ePO, Gigaspaces and Datasynapes infrastructures.

Us

• Day-to-day management of entire systems staff, including mentoring of junior level staff.• Project management for all systems projects, including defining of project requirements, scope, deliverables and schedules. • Coordination of systems activities with other business groups. • Planned all technology aspects of new office build out and moving of entire company. • Senior level expertise with SQL 2000. Built SQL Server 2003 Cluster for third-party financial applications and in-house applications. Managed production, DR, and development SQL environments, with a total of 25 databases. Created physical data models for SQL servers. • Monitored database performance using Windows Performance Monitor and SQL Profiler. • Developed and tuned queries in conjunction with Developers. • Set up all backup and restore procedures, including log shipping and replication for DR purposes. • Performed database re-organization and re-indexing. • Bulk-loaded data using BCP and other tools. • Managed DTS packages. Migrated databases and DTS packages from development to production environments. • Wrote customized scripts for managing and monitoring databases.

• Responsible for the stable operation of Citrix MetaFrame environment (XP or 1.8) at all client sites. Supported server farms with up to 11 servers.• SQL 2000 Database Administration: Maintained databases for support of internal help desk ticketing system and reporting tools, using query and stored procedure programming for SQL Server RDBMS. Created data reports for ASP web site. Supported client application to maintain student records.• Active Directory and Windows 2000: Designed and supported Windows 2000 Active Directory implementations for client schools, including NT to Active Directory migrations. Supported networks of up to 6,000 users. Established Group Policies to manage security, application availability, and desktop environment. Wrote scripts for administrative purposes using batch files and VBScript. Did troubleshooting of network services such as DNS, DHCP, WINS, and IIS.

Us

• SQL 2000 Database Administration: Planned and installed hardware, performed database maintenance including backup and restore, moved and replicated databases. Optimized database applications using SQL Profiler and Query Analyzer, and implemented appropriate indices. Administered 6 servers hosting 20 databases, up to 40 GB in size. Wrote T-SQL programs for database administration and maintenance.• Upgraded Network from Windows NT to Windows 2000: Planned and implemented network upgrade, including domain controllers and other network services (WINS, DNS).. • Network Administration: Installed, did troubleshooting, and maintained network infrastructure. Infrastructure consisted of Cisco 6500 and 5500 series core switches, Nortel Baystack 450 access switches, and Cisco 2600 and 3600 series routers. Implemented extension of corporate network for 2 remote sites to integrate them with existing network. • Market Data Administration: Provided user support and vendor coordination for market data services including Bloomberg, Reuters, Instinet, Bridge, Telerate, NewsEdge, FactSet, and First Call. Responsibilities included software installation, user support, billing and account maintenance, and troubleshooting service interruptions. Coordinated transfer of all market data services for Kynikos Associates, a hedge fund co-located with ZBI, pertaining to their move into their own space.• Checkpoint Firewall-1 Administration: Upgraded existing firewall, including configuration of new hardware, transfer of rule base, and maintenance. Added rules to firewall based on company needs

Be, Engineering

Ms, Civil Engineer