Dean Schindell Email and Phone Number

My responsibilities involve providing database support for a large, multi-team development environment. The development databases are about 12Tb; the production database is 90Tb, with the largest table growing by 2 billion rows/day. The database software is Greenplum 6.22.2 (based on PostgreSQL 9.4.26).My responsibilities include:• writing and tuning SQL Queries• maintaining stored procedures• performing some DBA tasks (copying databases, granting permissions)• writing… Show more My responsibilities involve providing database support for a large, multi-team development environment. The development databases are about 12Tb; the production database is 90Tb, with the largest table growing by 2 billion rows/day. The database software is Greenplum 6.22.2 (based on PostgreSQL 9.4.26).My responsibilities include:• writing and tuning SQL Queries• maintaining stored procedures• performing some DBA tasks (copying databases, granting permissions)• writing patches to fix errors in data. Show less

I continued to support the software I supported with BC Tel, Telus, and NewMetrics.

I was contracted to maintain databases in a multi-server environment with multiple databases per instance, based in the cloud. I developed procedures for creating databases for new clients, including secure user IDs and passwords. I developed a scheduled nightly maintenance job that maintained index health and ran backups for all user databases in an instance, including databases that were created after the job was created. I also maintained client-side application code as required.

I wrote an application to convert COBOL MACRO files (flat file definitions) to a SQL Server database.

I was responsible for analyzing, writing, and supporting reports in a Jasper Reports and Oracle environment.

PowerBuilder (PB) and Microsoft SQL Server (MSSS).Continued to support the software suite first supported at TELUS.The typical installation of this software supported 200 to 300 users managing 2,000 employees, across the continental USA, with overseas users. I created several new, complex areas of functionality.For the latest client, I wrote an automated assignment module that assigned work shifts for all employees in various offices. It took into account holidays… Show more PowerBuilder (PB) and Microsoft SQL Server (MSSS).Continued to support the software suite first supported at TELUS.The typical installation of this software supported 200 to 300 users managing 2,000 employees, across the continental USA, with overseas users. I created several new, complex areas of functionality.For the latest client, I wrote an automated assignment module that assigned work shifts for all employees in various offices. It took into account holidays, vacation, training, preferences, labour code and rules, and union rules, among other constraints.I also wrote a reporting module that was quite configurable, allowing users to define reports and the lines that made up the reports. Lines were either of a predefined type, or a calculation of other lines using either real-time data or warehouse data. At run time, users could select several criteria, including the office(s) included, the start and end dates, the days to be included (business days, calendar days, holidays, etc.), and the grouping method (daily, weekly or monthly). The reporting module was written using stored functions within MSSS to retrieve and build the underlying data, and PB to provide the cosmetic layout.As the last major component, I re-wrote the most used module. I moved the complex business rules to stored procedures so that they could be called by multiple front-ends to support a conversion to .NET. My design goals were flexibility and performance, with each business rule having a severity level (that is, error, warning or information) for each module. For performance, I used temporary tables so that the client could validate several changes in one procedure call.My responsibilities included communicating with clients, writing business and technical specifications, estimating timelines, designing and implementing new areas of the data model, and developing and maintaining software. I acted as technical lead for the PB software and the database structure. Show less

PowerBuilder 10.5, MS SQL Server 2005I was responsible for writing the ABIO application in a team environment. From January, 2009 to November, 2009, I was the Database Administrator for the development databases. All members of the team worked remotely. Half of the team members (project manager, tester, project lead, help desk, business analyst) were in Victoria BC, while the other half (four developers) were in the Vancouver, BC area.This application is rather small, with… Show more PowerBuilder 10.5, MS SQL Server 2005I was responsible for writing the ABIO application in a team environment. From January, 2009 to November, 2009, I was the Database Administrator for the development databases. All members of the team worked remotely. Half of the team members (project manager, tester, project lead, help desk, business analyst) were in Victoria BC, while the other half (four developers) were in the Vancouver, BC area.This application is rather small, with only 85 database tables. A large portion of the application is the report portion, with about 250 reports. The application manages accounting, personnel and equipment for a large, Alberta based company.As a PowerBuilder developer, I was initially responsible for converting a large number of the 250 reports from the original FoxPro application to PowerBuilder and SQL Server. During these conversions, I had to convert underlying SQL statements and any processing code to the new environment, taking advantage of the functionality offered by SQL Server and the inherent differences in the two technologies.I was later responsible for writing numerous batch jobs and conversion routines to convert data to new, normalized tables, and fix various foreign key violations. I also wrote various database reports to identify and solve locking problems the team encountered just after first implementing the new application.As the Database Administrator, I was responsible for identifying and defining all foreign keys, and to write reports that identified foreign key violations. I was also responsible for identifying and creating indexes to support these foreign keys. I redefined the data model to match the current database schema. I identified and defined check constraints, and fixed data to adhere to these constraints. I then rewrote all scheduled jobs, like nightly backups and weekly maintenance (reorganizing indexes, integrity checks, deleting old backup and log files). Show less

PowerBuilder 9.0, Oracle 8i, Oracle 9iResponsible for maintaining the Genus Resources application in a team environment. Implemented several small specifications and fixed several bugs.This application is very large, with 900 database tables, 25 PBLs and 8000 objects, with several distinct business modules within the application.The team consisted of a project manager, project lead, technical analyst, two business analysts, four employee developers, two contract… Show more PowerBuilder 9.0, Oracle 8i, Oracle 9iResponsible for maintaining the Genus Resources application in a team environment. Implemented several small specifications and fixed several bugs.This application is very large, with 900 database tables, 25 PBLs and 8000 objects, with several distinct business modules within the application.The team consisted of a project manager, project lead, technical analyst, two business analysts, four employee developers, two contract developers, two DBAs and two help desk staff. Show less

Java J2EE 1.4, MySQL 5.0, Tomcat 5.5, Eclipse 3.1.2, DbForms 2.6Responsible for developing a web application for entering and maintaining research information. Developed the custom tags and servlets used in this application. Developed utilities such as a session manager, login user manager and page navigation manager. Worked remotely in home office.This project was small, with only two members and a small MySQL database with a minimum number of tables.This project was… Show more Java J2EE 1.4, MySQL 5.0, Tomcat 5.5, Eclipse 3.1.2, DbForms 2.6Responsible for developing a web application for entering and maintaining research information. Developed the custom tags and servlets used in this application. Developed utilities such as a session manager, login user manager and page navigation manager. Worked remotely in home office.This project was small, with only two members and a small MySQL database with a minimum number of tables.This project was a pilot project, to help the Borealis Centre migrate to the Internet to offer its services and information. Show less

PowerBuilder 6.5, Informix 7.2Coordinated and secured long term relationship between TELUS Communications and NewMetrics Corp., a supplier of Call Centre Management software. Moved direct support of software in-house and developed close working relationship with NewMetrics for second tier support.This software suite included 300 database tables, 60 stored procedures and 12 PowerBuilder modules. It managed the workflow of a group of call centres, from analyzing in-coming call… Show more PowerBuilder 6.5, Informix 7.2Coordinated and secured long term relationship between TELUS Communications and NewMetrics Corp., a supplier of Call Centre Management software. Moved direct support of software in-house and developed close working relationship with NewMetrics for second tier support.This software suite included 300 database tables, 60 stored procedures and 12 PowerBuilder modules. It managed the workflow of a group of call centres, from analyzing in-coming call volumes to managing day-to-day activities of operators and agents. There were 3,000 agents (employees that the software managed) and 200 users. The users were spread over British Columbia and Alberta.I stabilized software suite by restructuring the code of several key modules. I found and fixed several obscure bugs that affected the reliability of the data. I improved the reliability of the software by implementing object-orientation to the source code and centralizing code.I continued development of the software suite by adding and improving complex functionality such as allowing employees to be loaned between offices, supporting long term vacation planning and improving ad hoc forecasting of staffing requirements.My responsibilities included consultations with users to analyze business needs, writing business and technical specifications, estimating timelines, managing two consultants, schema design, writing code and designing the database schema and administering some aspects of the database. Show less

PowerBuilder 5.0, Informix 7.2, IBM DB2, SQA Team Test 5.1Developed and maintained software for the E-File project, a large project staffed by several developers and testers. This application enabled Board staff to electronically view documents and other information about a claim.I was initially responsible for testing the application. I introduced SQA TeamTest at the Board, and set up an automated testing environment. I mentored four other testers on the application, and… Show more PowerBuilder 5.0, Informix 7.2, IBM DB2, SQA Team Test 5.1Developed and maintained software for the E-File project, a large project staffed by several developers and testers. This application enabled Board staff to electronically view documents and other information about a claim.I was initially responsible for testing the application. I introduced SQA TeamTest at the Board, and set up an automated testing environment. I mentored four other testers on the application, and administered the database server component.Developed and maintained two major modules in the application. Responsibilities included communicating with business users, writing technical specifications and developing and maintaining software. Show less

Involved with several projects which typically included four to six developers and was typically six months to one year in duration. Developed software, wrote business and technical specifications, maintained applications, supervised contractors.