MS SQL Server Architect Resume

Posted in Information Technology Resume Examples
Terry Higuchi
803 Queens Lane
Lynchburg, VA 24502
(222) 575-6947
Email : [email]

Career Goal
Dynamic and multi-skilled MS SQL Server Architect seeking to exploit my deftness in consultation services for database designing and development for MS SQL Server
Technical Skills
Quick and excellent in managing permissions with::

  • SQL Mail Agent
  • Performance Monitor and Profiler

Functional knowledge of ETL tools::

  • SSIS
  • DTS
  • Bulk Insert

Strong technical acumen of replication models::

  • Snapshot
  • Merge
  • Transactional

Cognitively expert in data processing tasks::

  • Data compressions
  • Data partitioning
  • CDC
  • Updating statistics

Adept in reporting applications::

  • SSRS
  • SSAS

Extensive technical knowledge of SQL Server functions::

  • Assemblies and interactions
  • XML data types
  • Data columns
  • Scalar valued functions

Familiarity with performance tuning of databases::

  • Windows performance monitor
  • SQL profiler

Extreme abilities to::

  • Data migration tasks and conduct consistency checks
  • Handle server mapping and objects creation tasks
  • Prepare complex ETLs and evaluate database performance
Relevant Experience
MS SQL Server Architect
Talent Merchants Inc
January 2012 – Present
Lynchburg, VA
  • Installed, configured and migration versions of SQL server.
  • Suggested latest upgrades for database applications and prepared backup plans.
  • Created complex queries with stored procedures and views.
  • Developed and administered cluster active on SAN storage systems.
  • Participated in tuning and optimization of stored procedures and database queries.
  • Prepared users and user groups and managed access permissions.
  • Updated and configured replication methodologies including snapshot.
  • Formulated and executed schema objects including indexes and views.
MS SQL Server Architect
Diverse Lynx Llc
November 2010 – January 2012
Denver, CO
  • Provided assistance for tuning queries and running scripts.
  • Formulated and executed database backup and recovery processes.
  • Created database tables, triggers, business rules and stored procedures.
  • Designed and developed SQL server databases for various online retailers.
  • Prepared database architecture components such as intranets and data warehouses.
  • Participated in integration of enterprise needs and application of database functions.
  • Maintained detailed documentation of data flow diagrams and data structure plans.
  • Installed, configured and maintained SQL database servers.
Educational Background
Master’s Degree in Computer Science
Wichita State University
August 2008 – May 2010
Wichita, KS
Professional Certification
MCTS – SQL Server, Business Intelligence Development and Maintenance July 2010

Create your own professional looking resume for free using our resume builder!