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
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)
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
SSIS,SSRS,SQL Server Management Studio, Business Intelligence Development Studio ,Commvault 10, SVN version control, Erwin,SQL Profiler, SQL Query Tuning Wizard
SQL Server 2014
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
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.
Companies Worked For:
Verizon Communications Inc
iQm Soft Pvt Ltd, Hyderabad, Andhra Pradesh
George Mason University
Job Titles Held:
SQL Server Architect/Developer
SQL Server Database Architect/Developer
SQL Database Developer/ Analyst
Master of Science : Information Systems Management Bachelor's degree (B.E) : Computer Science Engineering
Create a job alert for [job role title] at [location].