Database Administrator

• Nov 2021 - Present

ETL Developer

• Jul 2020 - Nov 2021

Design and build time-saving and manpower-saving solutions. Initiate solutions, build and maintain components as determined by customers• Use Agile methodology to maintain a consistent and productive workflow. • Work with BAs and developers to analyze the data needs of a project and produce an effective database system to meet those needs.• Setup DBs and develop ETLs to automate internal processes.• Testing and QA of these automated processes. • Analyze existing databases and processes, and recommend and implement appropriate optimizations.• Create documentation about the databases, operational manuals, and supporting documentation• Provide periodic status on the progress of development. Show less

Consultant

• Jan 2009 - Present

Provide services for hardware and software solutions. Initiate solutions, build and maintain components as necessary • Design and build database systems to increase workflow and productivity. • Build front-end interfaces to access online databases. • Assist users by troubleshooting hardware and software difficulties. Provide services for hardware and software solutions. Initiate solutions, build and maintain components as necessary • Design and build database systems to increase workflow and productivity. • Build front-end interfaces to access online databases. • Assist users by troubleshooting hardware and software difficulties.

Solutions Specialist

• Feb 2019 - Jul 2020

Design and build data management solutions using Digital Clay. Initiate solutions, build and maintain components as determined by customers; provide live, online and video training • Worked with customers to refine and design custom solutions. • Built DB to best handle customer specifications. • Designed and built interface to access online database. • Created series of video tutorials to create basic solution • Taught live and online sessions for platform • Provided support to existing customers Show less

Licensed Realtor

• Mar 2018 - Feb 2019

Realtor at Center Properties (סנטר נכסים) Realtor at Center Properties (סנטר נכסים)

Web developer / DBA

• Jan 2017 - Jan 2018

Maintain DB and website for cellphone plan store. Initiate solutions, build and maintain components as determined by management • Troubleshoot and improve database to increase workflow and productivity. • Built front-end interfaces to access online databases. • Updated DB and website to pass PCI compliance Maintain DB and website for cellphone plan store. Initiate solutions, build and maintain components as determined by management • Troubleshoot and improve database to increase workflow and productivity. • Built front-end interfaces to access online databases. • Updated DB and website to pass PCI compliance

System and Database Administrator

• Jul 2013 - Dec 2015

Provide IT support for third-party logistics and trucking firm. Support internal and remote users and maintain commercial and proprietary software • Maintain SQL (MS / DB2) databases to ensure proper function and data integrity. • Create and customize (Crystal) reports to retrieve data from SQL databases. • Build, test, and troubleshoot customer EDI integrations. • Manage firewall and internal network; assist customers with running their equipment inside our firewall. • Installed racks, data and other ports, and wireless access points. • Installed wiring for hardline and wireless networking. Show less

IT

• Oct 2012 - Jun 2013

Provide IT support for third-party logistics and trucking firm. Support internal and remote users and maintain commercial and proprietary software • Maintain SQL (MS / DB2) databases to ensure proper function and data integrity. • Create and customize (Crystal) reports to retrieve data from SQL databases. • Build, test, and troubleshoot customer EDI integrations. • Manage firewall and internal network; assist customers with running their equipment inside our firewall. • Installed racks, data and other ports, and wireless access points. • Installed wiring for hardline and wireless networking. Show less

Consultant

• Jun 2012 - Jul 2012

Provide engineering, design, support and installation services to the wireless industry. Installed wiring and other hardware components • Install conduit and wiring for hardline and wireless networking and audio-visual connectivity. • Install racks, data and other ports, and wireless access points. • Install and configure network and AV hardware. Provide engineering, design, support and installation services to the wireless industry. Installed wiring and other hardware components • Install conduit and wiring for hardline and wireless networking and audio-visual connectivity. • Install racks, data and other ports, and wireless access points. • Install and configure network and AV hardware.

Consultant

• Jun 2003 - Jan 2009

Provided services for hardware and software solutions. Initiated, built, and maintained components as necessary • Designed and built database systems to increase workflow and productivity. • Built front-end interfaces to access online databases. • Assisted users by troubleshooting hardware and software difficulties. Provided services for hardware and software solutions. Initiated, built, and maintained components as necessary • Designed and built database systems to increase workflow and productivity. • Built front-end interfaces to access online databases. • Assisted users by troubleshooting hardware and software difficulties.

Consultant - Database Manager

• Oct 2002 - May 2003

Database manager, AT&T. Modified and maintained existing relational databases during conversion to new process. • Updated electronic copy based on hardcopy provided by customer. • Modified and verified page layout based on customer specifications. • Created and updated variable types used by front-end application. Database manager, AT&T. Modified and maintained existing relational databases during conversion to new process. • Updated electronic copy based on hardcopy provided by customer. • Modified and verified page layout based on customer specifications. • Created and updated variable types used by front-end application.

Web Developer, Site Administrator

• Oct 2001 - Apr 2002

Enhanced website to meet new corporate objectives. Designed new tools to facilitate both content management and corporate communications with clients and prospective customers. • Created content-driven (PHP) pages at county, city, and property levels which incorporated new database functionality, facilitating content management. • Incorporated MapQuest mapping functionality into property pages, based on database query results, allowing visitors and potential customers to view property locations and surrounding areas. • Helped design and implement tracking tool (URL parameters) to allow third-party software (NetTracker) to track website activity, with a focus on visitors who navigated to the websites from HTML emails. • Rebuilt existing pages to meet shifting corporate standards and to streamline site for users by writing HTML templates and Javascript. • Evaluated and selected new software so as to maintain best-of-breed, externally-hosted site within budgetary and personnel constraints. Show less

Web Developer

• Apr 2000 - Jan 2001

Developed and maintained commercial websites. Worked with graphic artist to turn page layouts and navigational elements into valid HTML and Javascript. Wrote ColdFusion templates for database-driven sites, including www.Dallek.com and www.planetostomy.com. • Developed back-end utilities allowing internal customers to update and maintain database content. • Automated content creation for thousands of repetitive entries into static pages by writing emacs macros, completing redeployment of www.topps.com’s online card service ahead of schedule and under budget. • Original Javascript prepopulated forms, validated input, and organized workflow expediting ordering and delivery systems. • Produced HTML code for www.pretesting.com, integrating corporate content into new page layouts. Updated www.comprehensivenet.com to accommodate new content areas and navigation elements. Show less

Website Administrator

• Aug 1999 - Apr 2000

Oversaw quality, accuracy and consistency of two e-commerce sites and associated e-stores. Reviewed all copy for accuracy by checking online product descriptions against manufacturer’s specifications. Oversaw HTML coding to ensure the accuracy and professional appearance of the site. Interacted with web administrators of associated e-commerce sites and portals, such as the Yahoo Store, to provide accurate copy and shared information. • Created online showcases to advertise special offers and product packages. • Developed database upload files to interface with Yahoo’s data import utility. • Maintained hardware and software for TheCameraClub.com, including WindowsNT Server and Windows 95/98. Show less

Consultant (at Lucent Technologies, Murray Hill, NJ)

• Sep 1998 - Apr 1999

Systems Support Engineer, Lucent Technologies. Lead engineer providing systems support for Macintosh and for PCs on the Appleshare network; member of the Y2K conversion staff. • Delivered training to technical writers and engineers producing SGML-based documentation and online help. • Validated SGML volumes and files converted from FrameMaker and other legacy systems to Lucent’s SGML formats. Systems Support Engineer, Lucent Technologies. Lead engineer providing systems support for Macintosh and for PCs on the Appleshare network; member of the Y2K conversion staff. • Delivered training to technical writers and engineers producing SGML-based documentation and online help. • Validated SGML volumes and files converted from FrameMaker and other legacy systems to Lucent’s SGML formats.

Technical Support Engineer

• Sep 1996 - Jan 1998

Supported third-party vendors integrating Voxware SDK. Member of Voxware's in-house support team for Macintosh and PC developers using C/C++ to integrate proprietary codec. • Provided telephone support and basic help desk assistance to end users of Voxware's telephony and voice data applications. • Provided software quality assurance (QA) for in-house developers and programmers. QA involved writing programs in C/C++ to test SDK updates. Supported third-party vendors integrating Voxware SDK. Member of Voxware's in-house support team for Macintosh and PC developers using C/C++ to integrate proprietary codec. • Provided telephone support and basic help desk assistance to end users of Voxware's telephony and voice data applications. • Provided software quality assurance (QA) for in-house developers and programmers. QA involved writing programs in C/C++ to test SDK updates.