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.