Sql Server Developer Resume
4.00/5 (Submit Your Rating)
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