PROFESSIONAL EXPERIENCE AND KNOWLEDGE

• Seventeen years of professional experience in programming, database design, administration, and data analysis.
• For the past nine working as the sole database administrator for CDA and FHFC.
• Professional work experience in database design, administration, and programming with SQL Server 7/2000/2005/2008/2012.
• Officially certified as MCDBA (Microsoft Certified Database Administrator) in SQL Server 2000 and 2005.
• Professional work experience in database design, administration, and programming with Oracle 8i/9i/10g.
• Comprehensive work experience in database and server planning, design, installation, and upgrading.
• Ongoing work experience in database administration, monitoring and optimization.
• Extensive work experience in SQL Server programming and SQL Server Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).
• Broad work experience in reviewing programmer scripts, providing advice, and execution of scripts in production environments.
• Experienced in managing and supporting third - party software.
• Designed company database design standards, database dictionary, database server recovery scripts and third-party software support documents.
• Programmed window-based and web applications, with Visual Basic .NET and ASP.NET, using SQL Server and Oracle as backend databases.

EMPLOYMENT HISTORY

Database Administrator

Confidential

Responsibilities:

• Monitor, administer and optimize databases and database servers for the CDA 911 Emergency System
• Check database server service status, disk space availability, and database mirroring/AlwaysOn HA status
• Check SQL Server Agent jobs, backup jobs, and verify database and log backups
• Check SQL Server Logs, Error Logs and Windows Event Logs
• Monitor database server and database activity and performance
• Report and work to solve database related issues with Motorola agents
• Participate in system and database upgrade testing, implementation, and post-upgrade
• Generate Worst Performing Query Report for CDA databases
• Research and optimize long running queries to improve database performance
• Design database objects and work on Business intelligence projects
• Design views, stored procedures and functions in OLTP databases and Data Warehouse
• Compose procedures and set up SQL jobs to export tables from OLTP databases and perform updates to the Data Warehouse
• Design and edit numerous reports in the SQL Server Reporting Service, schedule automatic delivery, and configure security
• Work with Motorola agents to solve the Report Discrepancy Issue in the Data Warehouse
• Generate various ad-hoc reports by querying from databases
• Compose Data Dictionary for the Data Warehouse
• Document 594 tables, 612 views, 170 procedures and 75 functions
• Detail information for each database object to column-level about partitions, structures, keys, relationships, indexes and dependencies
• Study and document the ETL process and related SSIS packages and procedures for the Data Warehouse
• Record the Source Table information from OLTP databases for tables in the Data Warehouse
• Perform database comparison and update Data Dictionary after system upgrade
• Design Uniform Database in Access Database for CDA customers

Database Administrator

Confidential

Responsibilities:

• Planning, designing, maintenance, securing, upgrading and administration of all databases on the FHFC network
• Install, configure, safeguard, and administer database server and SQL Server instances.
• Upgraded SQL Server Instances from SQL Server 2000 to SQL Server 2005 and then from SQL Server 2005 to SQL Server 2008 R2.
• Configure and manage database server security and user administration.
• Manage and administer SQL Server logins, users, roles and securities.
• Configure SQL Server Agent and automating administrative tasks.
• Set up Maintenance Plans to check, optimize, and back up databases regularly
• Monitor database server activity, performance, and user activity.
• Monitor, manage and optimize SQL Server performance.
• Configure and manage Database Mail.
• Generate scripts for SQL Server databases, users, logins and passwords.
• Develop, implement and maintain backup and recovery plans for databases, database servers and related hardware/software.
• Restore databases and synchronize users.
• Generate various ad-hoc reports by querying from databases.
• Investigate and resolve database and related hardware/software problems.
• Programming for SQL Server databases and Business intelligence projects
• Work with programmers to design database tables, indexes, views, functions, and stored procedures.
• Implement data encryption for PII information.
• Configure, monitor and administer Reporting Service data sources, reports, user access and security.
• Design and edit various reports with SQL Server Reporting Service.
• Use SQL Server Integration Service to import/export/migrate/transform data between multiple data sources
• Convert an Oracle 10g database to SQL Server 2005
• Work with programmers on Data Warehouse databases and SQL Server Analysis Service projects.
• Work with programmers on different projects through backend databases.
• Set up development / testing environments, review programmer scripts, and execute scripts in production environments
• Set up development and testing environments for programmers and refresh databases as needed.
• Review programmer scripts to ensure they conform to the company standards.
• Provide advice and suggestions to programmers about their scripts.
• Execute scripts in production instances per implementation plans.
• Install, upgrade and support third-party software
• Install and configure third-party software, including server side, client side, and backend databases.
• Provide support for third-party software and work with customer support when issues arise.
• Research, plan, coordinate and carry out third-party software upgrade plans.
• Set up testing environments for software upgrades, and coordinate user testing.
• Perform software upgrades in production environments and support.
• Compose documentation about SQL Server database and third-party software
• Compose FHFC database design standards.
• Compose Data Dictionary for SQL Server databases.
• Compose backup and recovery scripts for databases and related hardware/software.
• Compose documents about database server configuration and usage.
• Compose documents about code review processes, templates, and logs.
• Compose documents about installing, managing and upgrading third-party software.

Computer Programmer Analyst

Confidential

Responsibilities:

• Designed / maintained a large web-based Crime Evidence Management System: with user front-end in Visual Basic, middle-tier in Java and database in Oracle.
• Designed / maintained a windows-based crime evidence reporting application: using Visual Basic .NET and XML.
• Designed window-based DNA data downloader and uploader applications, to download and upload data between networks: using Visual Basic .NET and SQL Server.
• Designed a web-based DNA Offender Search application: using ASP.NET and SQL Server.
• Designed a web-based crime reporting application: using ASP.NET and Oracle.
• Designed / administered databases in Oracle, SQL Server and Access.
• Upgraded databases from Oracle 8i to Oracle 9i, and then to Oracle 10g.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.

IT System Specialist

Confidential

Responsibilities:

• Miscellaneous programming projects as assigned: using Visual Basic and classic ASP.
• Designed a Visual Basic application to export multiple documents from an image server into multi-page TIFF files.
• Developed Visual Basic and ASP web applications to display a State pay plan.
• Developed backend databases in SQL Server and Access.
• Monitored and administered SQL Server on the network.
• Upgraded Visual Basic projects to Visual Basic .NET.

Database Administrator

Confidential

Responsibilities:

• Planned, designed, developed, secured and administered: all databases on the PSC network.
• Migrated SQL Server data and objects across multiple locations and servers.
• Upgraded SQL Server 7 to SQL Server 2000 platforms.
• Daily monitoring of SQL Server and administrative tasks.
• Developed back-end databases in SQL Server or Access to support web applications.
• Designed database-driven Visual Basic and Access applications.
• Developed web applications with ASP, VB Script and HTML.
• Solved database-related problems and provided end-user support / training.

Programmer / Database Analyst

Confidential

Responsibilities:

• Coordinated the implementation of a web-based disease reporting system, with backend database in SQL Server.
• Designed a Visual Basic application to import and convert historical disease data, from a DOS system to SQL Server.
• Constructed numerous database-driven Visual Basic applications that interact with SQL Server and/or Access.
• Developed numerous data analysis programs, utilizing Microsoft Access as the primary user interface and database component.
• Performed statistical analyses of Florida’s disease data and compiled Florida’s Annual Disease Book.