We provide IT Staff Augmentation Services!

Sql Developer Resume

Minneapolis, MN

SUMMARY:

  • Experience in Installation, upgrade, and configuration of SQL Server and databases, Backup & Recovery.
  • Experience in Capacity planning, Disaster Recovery, troubleshooting, backup restore procedures.
  • Experience in Creating Views, Triggers, Indexes, Stored Procedures and User - Defined Functions.
  • Extensive knowledge in Tuning SQL queries & improving the performance of the Database..
  • Experience in Database Mirroring and implementing Log Shipping
  • Performing Data Partitioning in SQL 2008/ 2005/2012.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS
  • Experience with tools like Microsoft Reporting Services (SSRS).
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Overall database design with logical modeling and physical modeling, such as creating Normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
  • Experience in Implementing SQL Server change control process.
  • Experience in providing good Production support for 24x7.
  • Easily adapt to new technologies at greater pace and fulfill the project goals and objectives.

TECHNICAL SKILLS:

Operating Systems: Windows 7, XP, Vista, 2003, 2000, 98, 95.

Databases: MS SQL Server 2012/2008/2005.

Programming: T-SQL, SQL, C++, JavaScript, HTML,powershell

SQL Server Tools: Mng Studio, Business Intelligence Development Studio, visual studio 2005

Application Packages: Photoshop, Image Composer, Access, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

SQL DEVELOPER

RESPONSIBILITIES:

  • Responsible for Database developer.
  • Monitoring of DB size and disk space in Production.
  • Responsible for migration of Database SQL Server 2008 to SQL 2012 using SSIS.
  • Responsible for upgrading SQL server and to 2012
  • Designed and create the databases, tables, views, stored procedure and triggers.

Environment: Windows 2003 Server, SQL Server 2008/2005/2012 , T-SQL, Erwin 4.1, JavaScript,HTML/DHTML, XML, powershell,.NET

Confidential . Durham, NC

SQL Server DBA

RESPONSIBILITIES:

  • Responsible for Database support.
  • Monitoring of DB size and disk space in Production, Staging & Development environments.
  • Participate in gathering User Requirements and System Specifications.
  • Design physical development databases using Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
  • Write Stored Procedures & User Defined Functions.
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
  • Configured Database mail, linked servers in SQL server 2008 and 2012.
  • Good Knowledge of using SSRS (SQL Server Reporting Services).
  • Installed and configured SQL Server Cluster server in SQL Server 2008 and 2012.
  • Performed Production support and on Call duties.

Environment: Windows 2003 Server, SQL Server 2008/2005/2012 , T-SQL, Erwin 4.1, JavaScript,HTML/DHTML, XML, powershell,.NET

Confidential

SQL DBA

RESPONSIBILITIES:

  • Installation and configuration of SQL server
  • Setup active/passive failover cluster in SQL server
  • Perform backup and restored the databases
  • Designed and create the databases,tables,views,stored procedure and triggers
  • Performing data migration from Text to SQL server
  • Performing data partitioning in SQL 2008
  • Maintaining database consistency and integrity
  • Used T-SQL to create various queries

Environment: Windows 2003 Server, SQL Server 2008/2005/,T-SQL, Erwin 4.1, JavaScript, HTML/DHTML, XML, Microsoft office.

Confidential, Raleigh, NC

SQL DEVELOPER

RESPONSIBILITIES:

  • Responsible for sql developing
  • Installation and configuration of SQL server
  • Perform backup and restored the databases
  • Designed and create the databases,tables,views,stored procedure and triggers
  • Performing data migration from Text to SQL server
  • Performing data partitioning in SQL 2008
  • Maintaining database consistency and integrity
  • Used T-SQL to create various queries

Environment: Windows 2003 Server, SQL Server 2008/2005/,T-SQL, Erwin 4.1, JavaScript, HTML/DHTML, XML, Microsoft office.

Hire Now