Administrator, Architect & Developer

In addition to being a Microsoft SQL Server DBA (database administrator), architect, and developer, Dr. Bisconti is an X-DBA (database x-administrator), architect, and developer in the following databases:

4th Dimension, ADABAS, Adabas D, Alpha Five, Apache Cassandra, Apache Derby, Aster Data, Altibase, BlackRay, CA-Datacom, Clarion, Clustrix, CSQL, CUBRID, Daffodil database, DataEase, Database Management Library, Dataphor, DB2, DB2/2, dBase, Derby aka Java DB, Empress Embedded Database, EXASolution, EnterpriseDB, eXtremeDB, FileMaker Pro, Firebird, Foxpro, Greenplum, GroveSite, H2, Helix database, HSQLDB, IBM DB2, IBM Lotus Approach, IBM DB2 Express-C, IDMS, IMS, Infobright, Informix, Ingress, InterBase, InterSystems Caché, GT.M, Linter, MariaDB, MaxDB, MemSQL, Microsoft Access, Microsoft Jet Database Engine (part of Microsoft Access), Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Visual FoxPro, Mimer SQL, mizanSQL, MonetDB, MongoDB, mSQL, MySQL, Netezza, NexusDB, NonStop SQL, Openbase, OpenLink Virtuoso (Open Source Edition), OpenLink Virtuoso Universal Server, Base, Oracle, Oracle Rdb for OpenVMS, Panorama, Paradox, Quattro Pro, Pervasive PSQL, Polyhedra, PostgreSQL, Postgres Plus Advanced Server, Progress, Progress Software, RDM Embedded, RDM Server, The SAS system, SAND CDBMS, SAP HANA, SAP Sybase Adaptive Server Enterprise, SAP Sybase IQ, SQL Anywhere (formerly known as Sybase Adaptive Server Anywhere and Watcom SQL), ScimoreDB, SmallSQL, solidDB, SQLBase, SQLite, Sybase, Sybase Advantage Database Server, Teradata, TimesTen, txtSQL, UDB, Unisys RDMS 2200, UniData, UniVerse, Vectorwise, Vertica, VMDS

Last Contract Technologies

This  was a cloud-computing project that utilized multiple technologies, including  AWS (Amazon Web Services), including RDS and EC2, Hadoop, Hive, Pig, Redshift,  SQL Server, MySQL, MySQL Workbench, and SSIS.   SQL Server and MySQL databases and SSIS were hosted in the AWS cloud and  the following tasks were completed:

  • Upgraded SQL Server 2008 to SQL Server 2008 R2 then applied SP3.
  • Created SQL Server and MySQL logical and physical models.
  • Created SQL Server and MySQL databases on both local and cloud servers.
  • Created SSIS packages to load SQL Server databases on both local and cloud servers.
  • Created and compiled SQL Server digital, educational library.
  • Created and compiled MySQL digital, educational library.
  • Designed SQL Server to SSIS to MySQL architecture.
  • Installed SQL Server 2008 and 2008 R2 on both local and cloud servers.
  • Installed MySQL and MySQL Workbench on both local and cloud servers.
  • Installed SSIS, SSAS, and SSRS.
  • Developed  accelerated, table generation tools.
  • Performed troubleshooting of numerous system components, including SSIS packages.
  • Used Embarcadero to translate diverse RDBMS DDL database generation SQL scripts.
  • Used Visual Studio 2008 to create SSIS packages.