SEARCH

SQL Server Architect/Developer Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SQL SERVER ARCHITECT/DEVELOPER
Career Overview
SQL Architect and developer with 9 years of experience in Software Development Life Cycle (SDLC), Database Design, ER Modelling, SQL Query Performance Tuning, T-SQL and Database Administration in Manufacturing, Financial, Healthcare and Education industries
Qualifications
  • Expertise in SQL Query Performance Tuning, appropriate indexing
  • Experienced in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS and custom scripts
  • Implemented executive reports using SQL Server Reporting Services(SSRS)
  • Implemented Stored Procedures, Triggers, Cursors, Views, UDF's, CTE's, Table Variables, Dynamic SQL, SQL Injection
  • Experience in Backup/Restore activities. Planned and implemented Full , Differential and Transactional Log backups jobs using SQL Server Agent and third party tools
  • Planned and implemented SQL Server Snapshot, Transactional and Merge replications SQL Server 2014/2012/2008 R2/2005
  • Oracle 9i/10g
  • Mysql 5.2
  • Programming Skills

  • T-SQL,C#.NET,JavaScript,HTML,PL/SQL
  • Tools

  • SSIS,SSRS,SQL Server Management Studio, Business Intelligence Development Studio ,Commvault 10, SVN version control, Erwin,SQL Profiler, SQL Query Tuning Wizard
Technical Skills
SkillsExperienceTotal YearsLast Used
SQL Server 2014Master92016
Accomplishments
  • Certifications:.
Work Experience
SQL Server Architect/Developer
May 2015 to CurrentVerizon Communications Inc － Reston, VA
  • Perform SQL Query performance optimizations by analyzing the stats, Query Execution Plans and SQL Profiler.
  • In some cases re-writing the code Design databases for the logical requirements received from Business Analysts.
  • Analyze different business entities for creating the process flow Analyze legacy systems and transform the legacy design to migrate into new databases as needed Develop Stored Procedures, Triggers, Cursors, Views, UDF's, CTE's, Table Variables, Dynamic SQL (T-SQL) Create SSIS Packages for loading data from sources like (Excel, CSV, Oracle, flat file) Participate in internal meetings for reviewing the project updates and future requirements Analyzed and Designed SSRS reports for executive dashboards, ad-hoc reports Schedule Backups (Full, Differential and Log) as needed for new databases Resolved issues related to blocking, deadlocks, connectivity issues Perform data refreshes from Production to Development/Testing environments as and when needed Mock point in time database restores for checking the accuracy of backups taken.
March 2013 to May 2015Deloitte － McLean, VA
SQL Server Database Architect/Developer
February 2010 to March 2013Bio-Rad
  • Analyze legacy systems and transform the legacy design to migrate into new databases as needed Design databases for the logical requirements received from Business Analysts and analyzing the existing systems SQL Query Performance Tuning using Execution Plans, DMVs and SQL Profiler Develop Stored Procedures, Triggers, Cursors, Views, UDF's, Dynamic SQL (T-SQL) Schedule Backups (Full, Differential and Log) Create SSIS Packages for loading data from sources like (Excel, CSV, Oracle, flat file) Resolve tentative SQL issues caused by the bulk loads as per the new design Migrate users after restoring the backup Prepare database checklist for Pre-Deployment and Post-Deployment procedures Create, Backup and Restore databases and perform mock deployments Mock database point in time restores for ensuring backup validity Participate in internal meetings for reviewing the requirements Created ETL packages using SSIS for loading data Interact with various teams for coordinating an issue Work on technical requirement documents to close the open issues Company: Knowledge Matrix, Hyderabad, Andhra Pradesh.
SQL Database Developer/ Analyst
January 2008 to February 2010iQm Soft Pvt Ltd, Hyderabad, Andhra Pradesh
  • Installed SQL Server 2005 on Development, Test and Pre-Production environments Designed databases as per the logical wireframes provided Created Technical Design documents and updated them as and when needed as per the modifications Implemented SQL Server objects (Tables, Views, Triggers, Cursors, Indexes, Stored Procedures, Functions) Worked with Application developers and resolved issues from database end Project: Online Assessment Engine Role: SQL Developer Responsibilities: Created Tables, Stored Procedures, Views for a module Created Exceptions to handle errors and give meaningful output to the user Wrote queries to handle large result sets Have done basic testing on the work done.
Education and Training
Master of Science : Information Systems ManagementGeorge Mason UniversityInformation Systems Management
Bachelor's degree (B.E) : Computer Science EngineeringAnna UniversityComputer Science Engineering
Certifications
Microsoft Certified Solutions Associate - SQL Server 2012 (MCSA)
Skills
C#.NET, ad, Backup, basic, Business Intelligence, communication skills, version control, DBA, Databases, Database, Database Architect, Designing, ERP, Erwin, ETL, Fertilizers, Finance, HTML, indexing, Inventory, JavaScript, meetings, Microsoft Certified, Excel, MySQL, Mysql 5.2, OLE, Oracle 9, Oracle, DB, Developer, PL/SQL, performance analysis, Programming, Reporting, requirement, Sales, scripts, Microsoft SQL Server, SQL, SQL Server, Statistics, Tables, T-SQL
Additional Information
  • Awards 2014 - Applause award for the work done at Deloitte
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Verizon Communications Inc
  • Deloitte
  • Bio-Rad
  • iQm Soft Pvt Ltd, Hyderabad, Andhra Pradesh

School Attended

  • George Mason University
  • Anna University

Job Titles Held:

  • SQL Server Architect/Developer
  • SQL Server Database Architect/Developer
  • SQL Database Developer/ Analyst

Degrees

  • Master of Science : Information Systems Management
    Bachelor's degree (B.E) : Computer Science Engineering

Similar Resumes

View All
SQL-Server-Developer-resume-sample

SQL Server Developer

Pinnacle Health System Healthcare

Palatine, Illinois