SUMMARY OF QUALIFICATIONS

• A resourceful Information Technology Professional with over 19 years of technical experience in the areas of database management, support, and maintenance, including 6 years of SQL Server DBMS experience. A professional who values professionalism, attention to detail and with a team-oriented approach. Experienced with the use of Windows 2008 SP1, Windows 2003 SP2, and Windows 2000. SQL Server 2008, SQL 2005 and SQL Server 2000, Oracle 8i, and Adabas SQL Gateway 11.0, Control-M Server along with ADABAS 8.2 z/OS platform . Also I possess a thorough understanding of SQL Server 2005. A solid track record combining experience and an openness to learning new technologies. Experienced with Installation, Managing maintaining of SQL Server 2000, 2005 2008 database structures via T-SQL, Management Studio Enterprise Manager . Also with manipulation of data exporting/importing within existing database tables via SSIS/DTS utilities . Also have working knowledge of Microsoft Suite Access, Excel PowerPoint along with Entire-X Broker services methodologies.
• Currently in training for Microsoft Certified IT Professional MCITP : Database Administrator SQL Server 2008.
• Honorable Discharge United States Marine Corps

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential

• Creation of SQL databases tables for replication purposes for agencies throughout the city.
• Perform adhoc T-SQL scripting against replicated SQL tables from the mainframe.
• Assist with the ongoing technical support of multiple agencies throughout the city.
• Perform ADABAS file modification requests.
• Expedite Natural module move requests as needed.
• Experience with the use of various ADABAS utilities such as Entire-X Broker services components.
• Experience with building ADABAS SQL Gateway Data Dictionary repositories.
• Experience with the support and utilization of Event Replicator Target Adapter and the propagation of ADABAS files to several SQL Server 2000/2008 database tables in support of different agencies throughout the city.
• Experience with the utilization of BMC Remedy change control system.
• Experience with database, table creation along with login/user administration via SQL Server 2008 Management Studio.

Database Administrator

Confidential

• Customized physical database structures and setup supporting utilities for production and development databases.
• Experienced with optimizing Oracle 8i 9i, SQL Server 2000, and ADABAS applications.
• Performed periodic exports/imports of specified ORACLE 8i schema tables.
• Monitored and maintained the production environment using multi-site data synchronization utilities RRDF .
• Conducted daily inspection of production and development databases and instances though automated reporting techniques.
• Experienced in the conversion and daily maintenance of ADABAS utilities and file structures.

Control-M/SQL Security Administrator

• Created and monitored SQL Server databases for Control-M utilization.
• Performed Control-M Server and Control-M Agent installations.
• Handled the documentation of critical batch processes for SQL AS400 jobs in Control-M environment.
• Monitored and provided effective user intervention for Production and Development Control-M environment.
• Created and Ordered jobs for processing in development and production environments.
• Administered users in Active Directory along with SQL triggers, stored procedures and DTS packages within SQL Server 2000 Enterprise Manager Interface.
• Experienced in Windows 2000 OS platform.
• Executed SQL scripts and provided documentation to the same.
• Utilized/maintained online control documentation of production changes/implementation.

Database Administrator

Confidential

• Provided daily ADABAS/Natural support for programmers and end users.
• Created and customized physical databases and setup supporting utilities for production and development databases.
• Experienced with optimizing ADABAS database components through the use of SYSAOS, Predict, ADABAS, and Natural.
• Experience in utilizing ACE 6.4.1.06, ACE6.5.1 CONNX 10.5 ADABAS SQL Gateway.
• Experienced w/ compiling/linking batch nucleus for Natural upgrades.
• Performed upgrades service packs, zaps to ADABAS, Natural, Predict to current versions as needed.
• Applied Service Packs and Patches to production and test/development databases as needed.

Database Administrator

Confidential

• Customized physical database structures and setup supporting utilities for production and development databases.
• Experienced with optimizing Oracle, SQL Server, and ADABAS databases.
• Managed user access to development and production SQL Server databases.
• Performed periodic exports/imports of specified ORACLE schema tables.
• Monitored and maintained the production environment using multi-site data synchronization utilities RRDF .
• Monitored and Maintained multi-site SQL Server installations via Enterprise Manager.
• Executed and verified completion of SQL scripts against production and test SQL database table structures.
• Performed daily backup/restore procedures of production and development SQL 2000 database schema tables as needed.
• Experienced in the conversion and daily maintenance of ADABAS file structures.
• Chairman's award recipient 2000 - Courage To Succeed Initiative