Sql Server System

ROBERT RUBINBERG

**** ******

Skokie, Illinois **076

Mobile: 847-***-****

Email: ***********@*****.***

SUMMARY

Information technology professional with over 25 years of experience in the analysis, design, development, architecture, testing and implementation of complex systems. Expertise in design, architecture and development of client/server and Service based systems. Over ten years in database architecture, implementation and operations. Strong consulting and communication skills. Desires a challenging technical role implementing vision, technology and leading teams to solve business problems. Enjoys learning new technologies and sharing with others to benefit the team.

WORK EXPERIENCE

ABLE CONSULTING, LLC, Skokie, IL 2012 – Present

Major clients are listed; other clients were small companies for short term engagements.

Database management Specialist, Environmental Services Company

Maintained a three node database cluster that had 10 database instances running across the three nodes. Documented all processes running on the database cluster and provided technical assistance in keeping the cluster active and running. Performed performance review and updates to the elements of the cluster to ensure optimal performance.

Data Architect, Surety Insurance Company

Re-architect the data structure of an existing to support additional data requirements being driven by software development. This includes supporting major enhancements, creating a logging mechanism and ensuring database performance. Created and implemented a conversion strategy from a legacy system into the newly developed system which included data mapping, cleansing and physical data movement

Principal Consultant/Senior DBA, Subscription Management Company

Provided database consulting services for companies in the mid to large size range. Key areas included data warehouse design and management, performance tuning and database monitoring. This warehouse was in innovative way to use data from numerous disparate platforms ranging from AS/400 to MySQL to other SQL Server platforms. The Warehouse gave the client innovative ways to apply their data for their customers generating a new stream of SAAS revenue for the company.

Worked on design of multiple database model used to keep primary active while alternate loaded data in background.

Refined indexes to make ad hoc reporting work in a reasonable amount of time in the MS SQL 2008 environment.

Helped to institute testing standards and testing environments for better control of release procedures in an environment where little organized testing existed.

Implemented Red Gate SQL Monitor for better database monitoring and control of database issues. Used the findings from the SQL Monitor to improve performance on queries by huge margins.

Worked with SSIS packages under MS SQL 2012, as part of the ETL process.

Assisted in the implementation of standards for the development, DBA and testing arenas.

360FACILITY, LLC, Evanston, IL 2000 – 2012

Director/Owner/DB Architect/Database Operations

Co-founder of 360Facility, LLC a provider of work order management software for the property management and service provider industries. Designed and coded original system, performed database analysis and implementation of system. Robert also set the overall technical directions and standards for the company. Robert continued on as developer, DBA, Data Architect, Director of Operations, and Director of the Company, helping to manage the day to day running of the company. Eventually, Robert specialized in day to day and long term management of over 600 individual databases running on the MS SQL Server 2008 platform. Robert managed the update from SQL Server 2005 to 2008 as well. The system leveraged both private cloud based and dedicated servers to achieve optimal performance for the SAAS client base.

Robert led a design team to design the initial and subsequent data architecture releases. Robert also worked on the stored procedures, functions, triggers and functions that were the backbone of the internal system.

Responsible for managing production databases, establishing appropriate software and hardware and procedures to minimize downtime, and maximize throughput.

Managed all master data elements across DB servers to provide a central management point for all clients, with no chance of cross access from one client to another.

Planned for future operational capacity changes in a fast growing company, also managed the transition to a new service host, minimizing downtime and impact to client base.

Primary responsibility for acquiring, maintaining and upgrading all hardware for company from portable computers to servers, as well as network and infrastructure elements.

Managed outside providers for setup and maintenance of infrastructure, including build out and wiring of network, specialized server configurations, and outside internet service providers.

RRI and ZY SOLUTIONS, Skokie, IL 1998 - 2000

Senior Consultant

Create project plans, analyze business problems and apply technology to solve the issues. Projects included:

Merchandise reward redemption program that allowed the sale of a merchandise voucher as a gift, and allowed for the online redemption of the voucher.

Airline reservation system data analysis system. Allowed the business users to look at data in alternative ways to look for trends in the business and find ways to maximize profits against the trends.

GRAPHICAL TECHNOLOGIES CORPORATION, Chicago, IL 1995 to 1998

Senior Consultant

Create project plans, analyze, design and implement software solutions and troubleshoot existing applications for various client companies. Projects/accomplishments include the following:

Designed project plan and architected an Active X subsystem of a CD-ROM system for a major publishing company. Wrote back-end code, set up data to make it accessible to the system. Was responsible for guiding the system testing and for the system implementation.

Improved VB and C++ coding and made credit card validation system more efficient for an oil company’s point of sale system. Redesigned the system process; utilized Active X to offload processing from a Visual Basic front-end, with the realized goal of making the process an Active X object

Responsible for finding and correcting a problem with a complex system utility which loads code into telecommunication devices for a telecommunications hardware manufacturer. Troubleshot, tested and fixed problem and ran through field beta tests.

Additionally, assisted in adding new features to a configuration tool. Currently rewriting this tool using Visual Basic 5.0/6.0, using Active X through Visual Basic as well as Access database and C++.

Designed and ran system test on a tracking system for a manufacturer of retreaded tires. Tested multiple formats and configurations.

COMPUTER SCIENCES CORPORATION, Oak Brook, Illinois, January 1988 to 1995

Senior Consultant

Staff Consultant

Associate Consultant

Planned, designed, coded, implemented and tested systems for clients in a variety of industries with a variety of technologies. Selected projects/accomplishments include the following:

Planned project, wrote C++ dynamic link library (DLL) for a system to control telephones from desktops for a telecommunications client.

Functioned as a Technical Team Leader in another project for the same client. Wrote project plan for integration and integrated a help desk system with a new billing system.

Designed and developed reporting subsystem of a warehouse control system for a shoe distributor. Also assisted in the design and development of complete warehouse control system.

Developed a truck distribution/rating system for the Department of Transportation to interface with the AS/400. Designed data interfaces between AS/400 and PC’s. Also responsible for screen design.

EDUCATION

Bradley University, Peoria, Illinois

Bachelor of Science, Computer Science, minor in Mathematics, 1987

INTERESTS

Boy Scout Leader, Camping, Bicycling, Sailing, Tae Kwon Do, Running

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate