We provide IT Staff Augmentation Services!

Sql Server Developer Resume

MarylanD

SUMMARY:

  • Microsoft certified professional with great analytical skills and 5+ years’ experience in database design and development on SQL Server.
  • Self - motivated and team player with a passion for technology accompanied by special interest and expertise in relational databases.

TECHNICAL SKILLS:

Database Technologies: SQL Server 2005/2008/R2/2012, T-SQL, SSRS, SSIS, SQL Server Profiler

Servers: Windows 2003 R2 /2008/2008 R2 / 2012

Languages: C++, Java, PHP

Platforms: Microsoft SQL Server Management Studio, Microsoft Visual Studio

Other Technologies: CSS, JavaScript, HTML, .NET Framework

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

SQL Server Developer

Responsibilities:

  • Worked with T- SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
  • Created drill down and drill through SQL server reports in 2008 R2, 2012 edition.
  • Created Ad-hoc reports as needed and carry out report projects as required.
  • Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.
  • For better Performance created indexes on regular intervals .
  • Created stored procedures for maintaining history data to load data on daily basis and create reports.
  • Responsible for the designing of advance SQL queries, Stored Procedure, cursor, triggers
  • Developed user documentation for all the projects.
  • Experience in improving performance of SQL server using tools like SQL Server Management Studio, SQL Server Profiler, and Database Engine Tuning Advisor.
  • Export & Import data from Flat file, Excel sheets and access database into the target SQL Server 2012 database using SSIS packages.

Environment: SSIS, SSRS, MS SQL Server 2012/2008R2, C#, Visual studio 2008, MS Office (Excel, Access…)

Confidential

SQL Server Developer

Responsibilities:

  • Involved in databases design requirements, and developments.
  • Maintained, update and monitor the existing database on a daily basis.
  • Created stored procedures, views, tables, and triggers
  • Troubleshoot all kinds of database related issues.
  • Assisted in data compilation, consolidation and conversion tasks when needed.
  • Coordinated with the management to discuss business needs and designed database solutions accordingly.
  • Rebuilt the indexes for better performance as needed.
  • Performed BULK INSERT, Imported and Exported data from different Data Sources using SSIS
  • Configured and maintained Report Manager and report server for SSRS
  • Developed reports using SQL Server Reporting Services and Utilizing complex SQL queries and stored procedures.
  • Wrote complex stored procedures to process customer’s requirement.
  • Implemented cursors and while loops to address some of the product requirements.
  • Implemented extensive error handling techniques into stored procedures
  • Monitored SQL server performance using profiler to boost performance
  • Worked very closely with Customers, End users and powered users to collect requirements, to train them or to resolve any business process related issues.

Environment: MS SQL Server 2008/R2, SSRS, SSIS, .Net, Visual studio 2008, MS Access, MS Excel

Confidential

Database Developer

Responsibilities:

  • Responsible in creating Stored Procedures, views, tables, and triggers
  • Maintain, update and monitor the existing database on daily basis.
  • Involved in databases design requirements, and developments.
  • Created SQL server reports against RDBMS.
  • Coordinated with the management to discuss business needs and designed database solutions accordingly.
  • Wrote complex views, stored procedures, Sub-queries, other SQL joins and statements for applications using T-SQL.
  • Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Excellent understanding of Relational Database Systems (RDBMS), Normalization
  • Extensively used SSIS Import/Export Wizard for performing the ETL operations
  • Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
  • Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform rollup and drill down operations in SSRS 2008/R2

Hire Now