Pointsmith Work Values

Daily Duties at Pointsmith:

Wrote/scripted/deployed Stored Procedures and T-SQL code in support of client applications. Wrote/built/deployed C# Assemblies for Encryption, Secure FTP, and Directory operations for SQL Server. Designed, wrote scripts for, and architected an upgrade of 43 databases from SQL Server 2000, 2003, 2005, and 2008 to 2012. Some issues encountered were DDL intermixed with the DML, Linked server references hard coded (And named after servers), schema's owned by users no longer with the company, inconsistent naming/coding, dead code which would no longer compile due to the referenced objects not existing any longer, double hop to get 2000 Databases to 2012 through 2008 R2, inconsistent collation, and cross database chaining. Created 2012 Visual Studio DacPac Projects from all databases, added references, removed dead code, made buildable, and integrated with TFS source Control.

What they like about Pointsmith:

Working in an organization that is technologically advanced, creative, and innovative is critical in your assessment of hiring companies. Less important to you are stability of the organization, the length of time an organization has been in business, and the business' plans for the future. You prefer a fast-moving company that will take risks to achieve its goals and objectives. The length of time the company has been in business is irrelevant. Maintaining status quo is unnecessary. You thrive on change, uncertainty and the upside of potential business risks, especially those associated with innovation. Stability for the long haul is not nearly as important as is working in an atmosphere that is charged with a sense of urgency and constant change.

Tags

Senior, Solution, SQL, warehouse, SSIS, SSRS, SSAS, Architect, TFS, PODS, C Sharp, Sharepoint, Integration, Team Foundation Server, Program Manager, Project Manager, IT Manager, Visual Basic, VB Script, VBA

Skills

See Resume, www.LinkedIn.Com, Everything Microsoft: SQL (Admin / Developer / Architect): SSIS / ETL / DTS (Admin / Developer / Architect / SSIS Packages): SSRS (Admin / Developer / Architect): SSAS (Admin / Developer / Architect): TFS Admin: SharePoint Admin: SharePoint Developer, Office Developer \ VB Script Developer \ .NET Developer \ C# Developer \ oper. I've worked many years across all of these fields in operations as well. Technology Architecture • Infrastructure Design • Communications • Needs Analysis, Client Relations • Procedure Development • Process Improvement • IT Strategy • Special Projects • Requirement Identification • Project Management • Strategic Planning • Technical Support • Disaster Recovery • Report Generation, Network Management • Team Leadership/Motivation • Database Development • Database Management • Database Optimization • Database Architecture • Mirroring • Indexes • Triggers • Log shipping • Production databases • Database servers, Network Management • Team Leadership/Motivation • Database Development • Database Management • Database Optimization • Database Architecture • Mirroring • Indexes • Triggers • Log shipping • Production databases • Database servers, Instances • Production servers • Database backup • PODS • PipeLine Open Data Source • Maintenance Plans • Alerts • Database Maintenance • Schemas • Replication • Enterprise Database Environments, Security (Server Logins • Database Logins • Active Directory • Server Logins) • Production Environment • Staging Environment

These are some of the questions we asked our climbers about their experiences with Pointsmith: