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.