Imagem de perfil de johntmn
Bandeira de United States Minneapolis, United States
Membro desde 21 de março de 2007
0 Recomendações


On-line Offline
## BIO National Real Estate Company July 2006 – Present ** Duties:  Sr. DBA and .NET Developer** for the REO line of business web sites.  This included daily management of the suite of web sites in production as well as migration of the suite from an outside vendor to the internal network.  Duties also include development of T-SQL, VB6, VB.NET, ASP.NET code and the migration of that code from the development environment through the production deployment. National Marketing Company July 2005 – June 2006 ** Duties:  Production Support DBA** for all of Shared SQL Servers.  This included daily management of 60+ SQL Servers and over 4000 databases.  Duties included code migration from QA to PROD, performance tuning, security management, production troubleshooting backup/restore and other duties as requested.  This position also included work on the SQL Server 2005 certification into the production environment.  This certification included determining the correct instillation and configuration as well as upgrading and testing of existing applications that were being moved to SQL 2005. National Retail Company June 2002 – July 2005 ** Duties:**  **Data Management Lead and  Sr. DBA** for companies web site replacement project.  Duties included the daily management of an 8-person development team that wrote a wide variety of interfaces to various enterprise data sources.  This required sorting through multiple logged defects and change requests, daily prioritization and management of each developer’s code from DEV to QA to PROD environments, as well as through multiple build cycles.  This work also included a great deal of triage on each issue – dealing with the QA Leads and the Business SME’s as needed.  Weekly code reviews and actual coding was required on certain issues.  Technologies included J2EE, Oracle PL/SQL, Microsoft SQL Server 2000, PERL scripts, and Korn Shell Scripts.  **Duties:**  **DBA and Developer** of a custom reporting tool against i2’s retail planning applications that support improved and more balanced inventory levels across the supply chain as well as improved customer satisfaction and loyalty due to improved in-stock reliability.  This project involved reporting across several modules from i2 Technologies, as well as the common data management data warehouse (CDM).  The project was completed using Microsoft Access, VBA, Oracle PL/SQL stored procedures, SQL Server 2000, DTS, and Korn Shell Scripts on UNIX for data importing.   Other duties on this project included requirements gathering from business users and the completion of technical specifications for multiple data feeds and interfaces that supported reporting.  Other duties included coordination of code build versions through DEV/QA/PROD that had dependencies upon other data fees and batch processing limitations.  This required an extensive effort to performance tune many interfaces to comply with batch window requirements. National A/P Auditing Firm June 1995 â€“ June 2002 **Duties:**  **Functioned as Data Architect and Sr. Developer** for all new development initiatives.  This included managing the project through the SDLC, system design as well as the data model design and included a significant amount of coding in each project. ## Area of Expertise MS SQL Server 4.21 – 2005 IBM UniData Informix Visual Schema Generator Oracle 7.2 - 9i MS SQL DTS**  **MS SSIS**        **Microsoft Visual Basic 3.0 – VB.NET Microsoft InterDev 1.0 – 6.0 Microsoft Visual Studio 6.0, .NET Active Server Pages, ASP.NET JavaScript VBScript HTML/DHTML XML Maestro / Batch Processing Microsoft Transaction Server COM, COM+ Internet Information Server 3.0 – 6.0 Microsoft Office Microsoft Visio  
0 comentários
  • N/ATrabalhos concluídos
  • N/ANo Orçamento
  • N/APontualmente
  • N/ATaxa de Recontratação


Comentários recentes

Sem comentários.


  • Conectado com o Facebook
  • Freelancer Preferencial
  • Pagamento Verificado
  • Telefone Verificado
  • Identidade Verificada
  • E-mail Verificado

Procurar Freelancers Similares