Todd Vlastnik
301 Rodman Rd.
Wilmington, DE 19809
 [Send email to request phone number] 64-2207
[Send email using form at bottom]


Summary	More than 10 years SQL Server experience with 7, 2000 and 2005.  Expert
knowledge of data warehousing, modeling and database design.  Vast experience
with integration and consolidation of data from diverse sources.  Thorough
knowledge of SQL Server Integration Services with 3+ years experience.  Extensive
ETL knowledge with an emphasis on automating the consolidation and integration of
data.  Basic knowledge of SQL Server Reporting and Analysis Services. 
Understanding of and experience with the full life cycle of software development.
Expert knowledge in designing reporting databases that are isolated from
production systems.  Extensive knowledge of replication and database mirroring. 
Working knowledge of Oracle administration.  Managed database and application
projects including the supervision and coordination of developers and other
database personnel.

Knowledge
•	Microsoft SQL Server 7, 2000 and 2005
•	SQL Server Integration Services
•	SQL Server Reporting Services
•	SQL Server Analysis Services
•	Data Warehousing
•	Data Modeling
•	Transact SQL
•	Replication
•	Database Mirroring
•	ETL
•	Oracle
•	Microsoft Transaction Server
•	Microsoft Visual InterDev 6
•	Microsoft Visual Basic 6
•	Microsoft Visual FoxPro 6
•	Microsoft Office Suite
•	Crystal Reports
•	IIS, HTML and ASP

Experience

2005-Current	Ajilon/DuPont	Wilmington, DE
SQL Server DBA / Database Architect
•	Manage many instances of SQL Server in production and development environments
including installation and configuration.
•	Perform DBA duties including backups, maintenance, user access and security,
testing and moving of user procedures from development to production.  These
tasks are based on company defined business rules.
•	Use AWE to dynamically allocate memory to specific instances of SQL Server.
•	Develop disaster recovery plans and documentation.
•	Monitor performance, utilization and overall health of all databases and
instances of SQL Server to ensure optimal operating performance for applications
and users based on defined business rules.
•	Performance tuning, including indexing and modification of procedures for
optimal performance.
•	Maintain databases for Global applications including an Internet Legal
collaboration application, Business Ethics Survey application and Business
Objects.
•	Designed, implemented and maintain a reporting database to include data from a
Global Internet legal collaboration application.  Import unstructured log files
and extract specific data into tables that are   integrated into existing data
designed for reporting.
•	Designed, developed and maintain a data warehouse from Legal Matter
Management, Patent, Trademarkand billing applications used globally to provide
comprehensive consolidated reports.  Data is integrated from Lotus Notes, Oracle
and SQL Server through direct extracts and FTP pickups using Integration 
Services.
•	Designed and manage a global employee database along with participating in the
planning and implementation of data gathering from 28 HR systems in many
countries world wide.  Import and integrate supporting employee data.  Developed
complex stored procedures to accurately consolidate employee data.
•	Develop procedures for reporting and generate ad hoc reports as need by
users.
•	Coordinate with Oracle DBA on integration of data into Data Warehouse.
•	Coordinate with Crystal Reports / Business Objects person on report requests
and provide database design/data knowledge required for reporting.


2004-2005	Call767	Dominica, West Indies
IT Manager / SQL Server DBA
•	Manage personnel and activities within IT department.
•	Coordination and implementation of IT projects including reporting, scripting
and infrastructure.
•	Interface with internal and external clients to asses needs.  Ensure all
deliverables meet time and quality requirements
•	Management of SQL Server development, maintenance, installation, backups and
recovery.
•	Perform DBA duties on production and development SQL Servers.
•	Monitor SQL Server performance and make necessary changes to tables, indexes
and stored procedures to receive the best server performance while maintaining
quality data access through front end applications.
•	Use Replication extensively between sites to provide internal and external
access to information.
•	Create, update and maintain stored procedures for incoming and outgoing data
manipulation.
•	Design and Develop reporting applications to fulfill internal and external
client request.




1998-2004	TCIM Services Inc.	       Wilmington, DE/Tucson, AZ
SQL Server DBA / Senior Developer
•	Performed DBA and Web Master Duties, including performance analysis and
monitoring of database changes to tables, stored procedures and views.  Evaluated
the potential effect that each would have on existing systems. 
•	Extensive use of Transact SQL for many different applications including data
gathering, data manipulation, importing and exporting of data, custom replication
and DTS processes.  Also provided ad hoc query information on a daily basis for
internal uses.
•	Ongoing development of feature requests and upgrades to applications including
an agent softphone,  reporting and data warehousing processes.
•	Designed and maintained a browser based Integrated Telephony application for
call center agents.
•	Extensive knowledge of Genesys CTI and scripting used in developing front end
applications.
•	Knowledge of Avaya CMS including report generation and data exports.
•	Designed and maintained a browser-based reporting application.
•	Designed and developed GUI’s for technologically inexperienced end users.
•	Designed and developed components in Visual Basic that run under Microsoft
Transaction Server.
•	Developed data synchronization processes using Visual Basic, SQL Server and
Informix.
•	Created application training documents and conducted training of other
developers as well as end users.