Robert Cantor Email & Phone Number

Las Vegas, NV, US

• Provide DBA services with a focus on migrating several SQL Server 2012 production instances to SQL Server 2017 with Availability Groups hosted by Amazon Elastic Compute Cloud.
• Migrate legacy systems including SSIS, SSRS and complex T-SQL code. I planned and executed the migration. I configured the SQL Server instances, migrated, and upgraded the database, set up the automated backup.
• Additionally, I refactored and optimized legacy code.

• Senior Production DBA in a 24/7/365 international 300+ instance multi-terabyte production environment primarily supporting the Relativity EDiscovery platform.
• SQL Server production support, installations, upgrades, database migrations, database backups, high availability, and disaster recovery preparedness.
• Instance and database optimizations including Index and statistics maintenance and optimization.

Buena Park, California, US

In my role as a Senior Production/Operations support DBA in a 24/7 international multi instance multi-terabyte production environment I introduced Advanced Query optimization as well as index analysis and best practice. I also introduced advanced coding concepts such as user defined table types and table view partition elimination.

La Crescenta, California, US

SQL Server Developer DBA for this midsized B2C

Atlanta, Georgia, US

Projects Include:Disney/ABC Television Group Route 66 project - A multi-platform Data Driven Work Flow web app for the marketing department.Fox Entertainment Group FoxFast platform - An enterprise level multi portal internet platform.

London, GB

Software Engineer specializing in MS SQL Server 2008 development, optimization and troubleshooting and T-SQL coding. Apply advanced optimization techniques using SQL Server profiler and DMVs. Innovate VLT/VLDB query performance solutions at this worldwide leader in gaming solutions.

Pasadena, CA, US

SQL Server Production DBA/Domain Admin for this international Bank. 24/7 Data Base support in a multi-instance, 7+ terabyte international environment. I built complex SSIS packages, Maintenance plans/backups, Perfmon and SQL Profiler traces/troubleshooting

Beverly Hills, California, US

SQL Server Ad Hoc development, T-Sql scripting and optimization

Working to build my client and contact base. I just wrapped up supporting the rollout of a B2B web application coding T-SQL Stored Procs and SQL Server SSIS/SSRS

Itasca, IL, US

SQL Server 2000/2008 T-SQL and ETL development in support of a Data Warehouse multi server/multi terabyte environment.

US

MS Access table design and input form development. This contract ended 1/09.

• Sql Server Data Warehouse development for IMS’ client, VF Corp.
• Database schema design using T-sql.
• Developed SSIS scripting and packages to load (ETL) a high availability Datamart for a Cognos reporting app.

Lead Sql Server database developer/DBA for an internet publisher. Responsible for performance tuning, maintenance plans and resolving deadlocks on the database servers. Responsible for writing complex T-Sql ETL including XML Xquery.

Built a full data cycle Sql Server/MS Access/MS Excel OLAP/OLTP reporting application for a major boutique hedge fund.

Built an OLTP/OLAP MS Access/Sql Server 2005 application for a midsize specialty manufacturer using T-Sql, Jet Sql and VBA.

Lead Sql Server developer/DBA for an internet retailer. Responsible for granting user access, performance tuning, database maintenance plans and resolving database deadlocks. I wrote complex triggers to transfer data from the web database to the backend database. I wrote all the reporting objects including stored procedures, user defined functions.

Enhanced an existing MS Access application and took over development responsibility for an instance of Sql Server 2000 used for department wide reporting using T-Sql. For Compuware's

West Coast Applications Developer for an international law firm. Participated in an international rollout of MS Office 2002. Programming/customizing the MS Office suite with VBA/VB 6/Sql Server 2000/C# scripting. I wrote desktop applications with a Sql Server back end. Duties also included conducting technical interviews for employment candidates.

I started as a contractor in 2/02, full-time employee in 1/03. Created a multi user sales/compensation MS Access/Sql Server OLAP reporting/data mining applications mining data from a proprietary business control applications using T-Sql. Duties also included training, heavy user contact, building ad hoc Excel VBA apps and acting as technical support to two.

As a Contract Programmer for these two regional IT Contractors I worked consecutive projects BP-ARCOI created MS Access ETL Database Applications to migrate legacy data (Sybase, DB2) to a custom (MAXIMO/Oracle) business flow application. Duties include writing technical and end user documentation. Tycom Industries I developed an intranet web based.

Universal City, CA, US

Developed a distributed Access application to track the Universal Studios' analysts responsible for department specific orphan applications.

Participated in a programming team to convert an Access '95 application to Access '97/Y2K compliance standards.

Created VBA automated Excel '97 templates.Law Firm/MS Office Conversion Experience

MS Word '97 custom application development for a boutique Law Firm.

Created MS Office '95 Word and Excel templates for a nationally know market research firm and migrated the templates from MS

MS Word '95 custom application development for in-house legal department.

MS Word '95 custom application development for a boutique Law Firm.Law Firm Conversion specialist - Bryan Cave, Latham & Watkins and several smaller projects.

Various CBT Providers

Technology

Education record

Tisch School Of Art

Communication

Education record

Education record

Education record