SQL Developer Resume Drexel Hill, PA - Hire IT People

PROFESSIONAL SUMMARY:

Full of enthusiasm, drive and creativity SQL Server Developer with experience in analysis, design, coding, implementation and support is looking for a challenging position as SQL Server developer that will allow my current technical skills evolve in a direction that would actively support the success of a company.
A dedicated learner in evaluating and applying new technologies in order to enhance content and functionality as well as a valuable contributor to a team.
Experience in designing and creating databases, tables, views, stored procedures, functions and triggers.
Database modeling concepts and normalizing data by using techniques for keeping its integrity and fast data retrieval purposes.
Create, modify and maintain indexes to boost system performance.
Performance Tuning and Query Optimization by analyzing query execution plan.
Use SQL Server profiler to trace troubled queries.
Passion for technology and a competitive, results - focused nature.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

Released Health Report for the Business on daily basis that indicated the performance of multiple government and commercial applications.
Compiled and distributed the excel spreadsheet report to job owners on daily basis that indicated automated jobs completion status.
As a job owner monitored automated scheduled job on three terminal servers using Syncovery and Windows Task Scheduler applications.
Analyzed (SQL,VB scripts), traced down the root cause and implemented the solution to recover jobs that failed.
Per service request followed up with the audit user to fully understand the objective and implement the SQL code in a way that satisfy the user request.
Led the small project of searching through the servers and filling excel spreadsheets in an organized way with job related data and associated emails through distribution system to facilitate a quick allocation and efficiently address the issue.
Maintained and released Backlog Service Request report of monitoring active status for incidents and service requests as well as team performance.
Went through the stream of emails on daily basis and identified those that stated the downtime for applications and servers that effected the company performance and kept track of it to be further deployed in the Health Report.

SQL DEVELOPER

Confidential, Drexel Hill, PA

Responsibilities:

Assisted in designing and creating the new database for the business, connecting tables using PK, FK and other constraints for data integrity purposes.
Accurately located indexes on tables in care of system performance.
Created number of user defined functions, stored procedures, views and triggers defined by business rules.
Applied Incremental Load approach for sync purposes while implementing the load from source data into destination on repeating basis.
Integrated data from Excel files into SQL table destinations by completing tasks such as data reading, data conversions, validation of data existence at the destination and data insertion at final stage using SSIS.
Extracted joined data through T-SQL scripts, transformed based on business requirements by passing expressions into components such as Derived, Conditional Split and others, loaded the data into separate Excel, Flat files as results of its transformations.
Improved performance of SQL server queries by analyzing execution plan and optimizing queries, rebuilding and reorganizing the indexes.
Performed database backup.
Developed stored procedures, queries and views necessary to support SSRS reports.
Designed and developed different type of reports including: Drill through reports, Drill down reports, Parameterized reports based on business requirement using SSRS.