We provide IT Staff Augmentation Services!

Database Architect Resume

Scottsdale, AZ

Summary:

A highly-motivated IT consultant with a passion for SQL Server, functioning as SQL Server Data Architect with more than 10 years of database encounter with experience using Microsoft SQL Server 2008 through 2012. Extensive knowledge of industry best practices in data movement design, Integration using Scribe and migration methods, techniques. Expert Knowledge in SQL Server 2008/12, SSIS, SSRS,SSAS and Datamodelling

SKILL SET:

Technical:

Databases: MS SQL Server (05/08/12)

DB Tools, System Center 2012, Data Protection Manager 2012, Red Gate Tools

Monitoring Tools : PRTG, RedGate-SQLMonitor, Idera-SQL diagnostic Manager

Programming Languages, C++, C#.Net

Web Tools & Technologies, .NET 4.0, Scribe Integration Tool

ERP : Microsoft CRM Dynamics

Scripting Languages, JavaScript and PowerShell Script

Configuration Management, Altassian JIRA, SVN and TFS

Reports : Microsoft SQL Server Reporting Services, MS SSIS.

Tools, Remedy, Rally Dev

Experience:

Confidential, Scottsdale, AZ

Project Overview:

Role : Database Architect

Environment : MS SQL Server 2008, Scribe Insight, CRM Dynamics 2011 & 2013

Synopsis : CRM Dynamics 2011 is back office Property management system which provides the operational functions for Leasing, Construction & Account department in Confidential . It is a customizable role based system for users with different activity authorization. The users of this system will be able to view information based on their roles and perform operations.

Deliverables,

  • Functioning as Database Architect; carrying out tasks related to database design, Maintenance activity & implementation.
  • Heavily employed Microsoft database tools including SQL Server 2000-2012 Relational Engine, Integration Services and Computer Associate’s ERwin data modeling tools and experience with Analysis Services.
  • Data integration across platforms using scribe.
  • Ensure high-availability and data security by implementing SQL Server Failover Clustering, rigorous backup and recovery plans, SAN mirroring to disaster recovery sites.
  • Worked on moving transactional data from production OLTP database to another database for reporting purposes is a common way to prevent OLAP-type transactions from interfering with primary production database.
  • Perform regular maintenance including index optimization, consistency checks, and data file and Transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail.
  • Worked and resolved issues around too any indexes on frequently updated (inclusive of inserts, updates and deletes) tables incur extra index maintenance overhead. Generally, OLTP database designs should keep the number of indexes to a functional minimum, again due to the high volumes of similar transactions combined with the cost of index maintenance.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default & Black box Traces to analyze other issues on the server.

Confidential, Phoenix, AZ

Project Overview:

Role : Database Architect/SQL DBA

Environment : MS SQL Server 2008, SSRS, SSIS, Microsoft C#.Net, Asp.net

Synopsis : Confidential is back office order management software which provides the operational functions for Sales Orders, Vendor Bills, Invoice Generation and Tracking. It is a customizable role based system for users with different activity authorization. The users of this system will be able to view information based on their roles and perform operations as per access permissions. Confidential also provides various KPIs and reports to the users of the application.

Confidential is the web-based order booking application which allows its customers of Confidential to request quotes and book shipments. The customers can book LTL shipments.

Deliverables,

  • Functioning as SQL Architect; carrying out tasks related to database design, Maintenance activity & implementation.
  • Develop & Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default & Black box Traces to analyze other issues on the server.
  • Migrated standalone database to a SQL Failover Clustered environment.
  • Perform regular maintenance including index optimization, consistency checks, and data file and Transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail;
  • Worked and resolved issues around too any indexes on frequently updated (inclusive of inserts, updates and deletes) tables incur extra index maintenance overhead. Generally, OLTP database designs should keep the number of indexes to a functional minimum, again due to the high volumes of similar transactions combined with the cost of index maintenance.

Confidential

Project Overview:

Title, eRTIS Application.

Role : Data Analyst.

Environment : MS SQL Server 2005/2008, Asp.Net, SSRS, SSIS

Synopsis : The project dealt with refinery related analyzer data of the British Petroleum products. The application was used by the Site Engineer to take security and safety action based on the analyzer data fetched from the refinery sites.

Deliverables :

  • Functioning as SQL Server DBA; involved in the planning, analysis, design & implementation of databases & be a primary resource for new application implementation. Provided appropriate consulting, interfacing, and training for users.
  • Collaborate with developers, network administrators, system administrators to implement secure, reliable database environments.
  • Ensure high availability in a mission-critical, secure production environment including backups, disaster recovery, and real-time system monitoring.
  • Implementing Quality Management System procedures; conducting with unit testing & deployment.
  • Maintain thorough and rigorous documentation related to database server configuration, operation, and database change management

Confidential

Senior Software Engineer

Project Overview:

Title, Columbus Web portal

Environment : C#, Asp.net and SQL Server

Synopsis : The project aimed at developing an application that provided assistance in sales related activities of the HP products. It was mainly used by the Sales Representative to claim the compensation of the complex and meta deals.

Deliverables :

  • Facilitating as Software Engineer, responsible for design and coding of the application using design patterns.
  • 200 hand-programmed stored procedures, with parameters, RETURN values, complex multi-table JOINs, and cursors when necessary.
  • All tables indexed and tuned, then de-normalized when necessary to improve performance.
  • Performance tested and optimized using SQL Profiler, Index Tuning Wizard and Query Analyzer.
  • Carrying out unit and user acceptance testing with debugging functions.
  • Perform regular maintenance including index rebuilds, reorganization and statistics updates.
  • Visiting client place - Germany for a period of 5 months for business requirement analysis and design discussion.

Confidential

Project Overview:

Title : CopathPlus v2.4

Environment : C# (Win forms) and SQL Server

Synopsis : The project was based on designing a an industry-recognized anatomic pathology information system designed for the unique workflow requirements of the anatomic pathology department.

Deliverables :

  • Designing, coding and testing of application.
  • Maintain thorough and rigorous documentation related to database server configuration, operation, and database change management
  • Data imported and manipulated with DTS and BCP as needed.

Hire Now