SUMMARY OF QUALIFICATIONS

• A resourceful Information Technology Professional with technical experience in the areas of database management, support, and maintenance including 6 years of SQL Server 2000/2005 experience . I currently have a working knowledge of Windows 2008 SP1, Windows 2003 SP2. 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 . I possess a strong familiarity with SQL Server 2000, 2005 and 2008 installations/upgrades, database security procedures via Active Directory , DTS/SSIS package creation/administration as well as backup/recovery procedures through the use of Management Studio and Enterprise Manager and T-SQL. I am a great communicator with exceptional work ethic, with strong attention-to-detail. I also work extremely well with others.
• Currently training for Microsoft Certification MCITP SQL Server 2012 .
• Honorable Discharge Confidential

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

• Proficient with database, table, index and stored procedure creation and maintenance via SSMS and SQL.
• Perform SQL scripting, compilation and optimization procedures against SQL tables.
• Creation and administration of DTS/SSIS packages via SSMS Export Wizard interface.
• Perform ADABAS file modification requests.
• Expedite Natural module move requests as needed.
• Creation of various middleware utilities such as Entire-X Broker server components.
• Creation of ADABAS SQL Gateway Data Dictionary repositories.
• Installed and configured Event Replicator Target Adapter 2.7 and the propagation of ADABAS files to several SQL Server 2000/2008 database tables in support of different agencies throughout the city.
• Proficient with BMC Remedy change control system.
• Performed SQL Server 2005, 2008 DBMS installation procedures.
• Knowledgeable with Report Builder and Report Manager Utilities via SSRS.
• User ID creation and administration via Active Directory.

Confidential

Database Administrator

• Proficient with database, table, index and stored procedure creation and maintenance via SSMS and SQL.
• Provided daily production database support Backups, Restores, Log file inspections of SQL Server 2005 2000 database structures.
• Customized physical database structures and setup supporting utilities for production and development databases.
• 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.
• Participated in ADABAS file conversion protocols and daily maintenance of ADABAS utilities and file structures.

Confidential

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.
• Created login/user IDs along with password administration via Active Directory.
• Executed SQL scripts and provided documentation to the same.
• Utilized/maintained online control documentation of production changes/implementation.

Confidential

Database Administrator

• Provided daily ADABAS/Natural support for programmers and end users.
• Created and customized physical databases and setup supporting utilities for production and development databases.
• Optimization and maintenance of ADABAS database components through the use of SYSAOS, Predict, ADABAS, and Natural.
• Installation and administration of ACE 6.4.1.06, ACE6.5.1 CONNX 10.5 ADABAS SQL Gateway.
• Conducted compiling/linking of 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.

Confidential

Database Administrator

• Provided daily production database support Backups, Restores, Log file inspections of SQL Server database structures.
• Customized physical database structures and setup supporting utilities for production and development 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 Confidential.
• 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.
• Participated in Confidential file conversion protocols and daily maintenance of Confidential utilities and file structures.
• Chairman's award recipient 2000 - Courage To Succeed Initiative