Imperial PFS - Database Administrator
April 2007 - Present
- Administration of approximately 50 SQL servers in Server 2003/2008 environment
- Participated in upgrade of 25 production SQL servers from SQL 2000 to SQL 2005
- Developed and implemented enterprise-wide database backup and retention solution
- Development of ETL solutions to process data from external vendors
- Assist software developers with the creation of SQL stored procedures to support in-house software
- Design, create, and maintain databases
- Maintain database documentation and diagrams
Church of the Nazarene World Headquarters - Developer / Database Administrator
October 2004 - April 2007
- Adminisered SQL 2000/2005 and MySQL databases
- Converted several applications from Access 2000/2003 to Microsoft SQL Server
- Application development and maintenance using Java/JSP, PHP, VBA (Access 2003), and VB6
- Developed and implemented enterprise-wide database backup solution using Idera SQLsafe
- Developed and implemented database security and development policies
- Developed and implemented ETL process to support migration from AS/400 DB2 environment to Microsoft SQL Server environment
Publications / Articles
-
SQL Server 2008 Compression SQLServerCentral.com (Published Online) - April 22, 2010
-
SQL Server 2008 Mirroring Testing SQLServerCentral.com (Published Online) - December 12, 2008
Also published in: The Best of SQLServerCentral.com, Vol 7 - November 2009
Certifications
Education
|
