SQL Developer/Support Engineer Resume South Plainfield, NJ - Hire IT People

SUMMARY:

Experience in data warehouse development with complete Software Development Life Cycle.
Good understanding of SQL Server fundamentals.
Excellent communication skills and true team player with problem - solving capabilities.
Experience in designing databases with great sense of responsibility and commitment.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential, South Plainfield, NJ

SQL Developer/Support Engineer

Responsibilities:

Development & Administration on SQL Server 2008 R2, 2012 and 2014 environments: Installation, Upgrade, Migration, Configuration, SSIS, SSRS;
Extensive experience with advanced features of T-SQL, SSIS and SSRS;
Performed migration from SQL 2008 to SQL 2014;
Participated and design and implementation of Credit Application portal starting from design through development and release. Creating data model to support dynamic portal creation. Programmed functions and stored-procedures. Work closely with UI team on user experience and administrative interface;
Monitoring and troubleshooting daily data load;
Implementing SSIS packages to process load of over 35 Million records from major credit bureaus;
Creating ad-hoc reports.
Experience with database performance tuning, Query optimization. Analyzed log and traces and significantly improved application response time by changing database configuration parameters.
Experience in supporting very large and highly transactional databases and troubleshooting various performance bottle necks on different environment (production, stage and Test)
Design the schemes, permissions and tables for database as appropriate for its use;
Creating and monitoring all SQL Server agent jobs, check overlapping jobs and change run time as needed.
Worked closely with developers and business leaders.

Confidential, Staten Island, NY

SQL Developer/Support Engineer

Responsibilities:

Reviewing existing business procedures and improving query efficiency.
SQL Performance tuning prior to its inclusion in the development solution.
Troubleshooting performance problems and network related issues.
Implementing SSIS packages for B2B communications and internal data transformations.
Creating database tables, views, indexes, stored-procedures, triggers and cursors using T-SQL.
Developing SSRS reports for financial and transactional data analysis.

Confidential, Brooklyn, NY

SQL Developer

Responsibilities:

Designed and implemented SQL Server database in Microsoft Azure cloud.
Implemented SSIS packages to synchronize transaction data with PayPal data source.
Developed SSRS reports for daily, weekly and monthly reporting needs.
Optimized stored procedures and views for high number of daily visitors.
Gathered requirements for small data warehouse and data mart entities.

Confidential, Tbilisi, Georgia

Civil Engineer

Responsibilities:

Designed and prepared engineering designs, plans, drawings, specifications.
Timely delivered civil engineering design deliverables which met the customer's expectations.
Prepared draft agreements between the City and developers.