SUMMARY OF QUALIFICATIONS

• A resourceful Information Technology Professional with over 16 years of technical experience in the areas of database management, support, and maintenance. A professional who values professionalism, attention to detail and 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. 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 along with corresponding indexes via T-SQL, Management Studio Enterprise Manager . Also with manipulation of data exporting/importing within existing data tables. Also have working knowledge of Microsoft Suite Access, Excel PowerPoint along with Entire-X Broker services methodologies.
• Honorable Discharge United States Marine Corps
• Currently in training for Microsoft Certified IT Professional MCITP : Database Administrator SQL Server

PROFESSIONAL EXPERIENCE

Database Administrator

• 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 upgrade of Entire-X Target Adapter and the propagation of ADABAS files to several SQL Server 2000 servers in support of different agencies throughout the city.
• Experience with the utilization of BMC Remedy change control system.
• Experienced with Java Eclipse programming language.

Database Administrator

• 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 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

• Closely monitored daily ORACLE backups for integrity on each production/test server as well as the TIVOLI server.
• 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 AOS, PREDICT 4.5.1, ADABAS 7.4.4, and Natural 4.1.4.
• Experience in utilizing ACE 6.4.1.06, ACE6.5.1 CONNX 10.5 ADABAS SQL Gateway.
• Performed periodic exports/imports of specified Oracle schema tables.
• 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

• 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.