SUMMARY

• Ten plus years of IT experience in SQL Server Administration, Development, Design, Working experience of MS SQL Servers in Production, QA, Development environments.
• Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
• Experience in Replication, Mirroring and Log Shipping.
• Experience in Database Backup, Recovery procedures.
• Installing SQL servers, applying patches, resolving errors.
• Experience in Reporting tools like Microsoft Reporting services.
• Flexible and versatile to adapt to any new environment and work on multiple projects.
• Experience in creating Ad hoc reports and tuning of reports.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts and SQL Mail Agent.
• Experience in working with managing SQL scripts and changes that are going to production.
• Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Good understanding of capacity planning.
• Extensive knowledge of Relational Database Management Systems.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging stored procedures and triggers.
• Creation of users, configuring permissions and assigning roles to users.
• Experience in Deploying SSRS reports and SSIS.
• Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Operating Systems: Windows 2012/2008/2003/2000 , Windows XP, Windows NT 4.0 Server/Workstation, Windows 98/95, Windows 2000 Advance Server.

Languages: T-SQL, SQL Plus, VB Scripts and ASP.

RDBMS: MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Oracle, MS-Access

Front End: MS Visual Basic

Internet Technologies: ASP, HTML

Version Control Tools: Visual Source Safe

Certification: Microsoft Certified specialist in SQL server 2008 Administration.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Database Administrator

Responsibilities:

• Installation of SQL server 2008 and applying latest patches on SQL server.
• Backups, Linked server, Log Shipping, Replication and Mirroring.
• Deployed stored procedures, views, triggers and user-defined functions using T-SQL.
• Migration of SQL servers using side by side and in place technology.
• Used monitor all subscription jobs and sends email alerts to the reporting team.
• Deployed and monitored SSIS Packages.
• Tuned Stored Procedures and SQL Queries and created indexes on tables.
• Created SQL Server jobs for SSIS packages and scheduled them and monitored them.
• Worked on tickets as per priority.
• Interaction with Client to resolve any errors encountered.
• Getting the requirements from new application and implementing it.
• Supported change request on weekends.
• Worked with Application team to resolve any issues faced by them.
• Attended calls to rectify priority issues with different types of teams in the calls.

Environment: SQL Server 2012/2008/2005 , SQL Server Reporting Services, SSIS, Windows Server 2003/2008/2012 , Windows 7/8, MS Office, Excel.

Confidential

Database Administrator

Responsibilities:

• Installation of SQL server 2008 and applying latest patches on SQL server.
• Backups, Linked server, Log Shipping, Replication and Mirroring.
• Migration of SQL servers using side by side and in place technology.
• Created Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Optimized queries to get sale of Policies done by each agent with different permutation and combinations.
• Creating, maintaining, Upgrading, Migration of SQL servers.
• Deployed the SSIS packages on different servers.
• Optimized Query Performance and Reliability.
• Created new tables and databases, normalized and indexed all the tables.
• Written stored procedures for front end and helped the front end application developers with their queries.
• Cleaned and corrected data.
• Worked on DTS packages.
• Sent reports to the clients.
• Tuned Stored Procedures and SQL Queries and created some indexes on tables.
• Resolved tickets as per priority.

Environment: Windows 7,VSS, MS SQL Server 2000,2005,2008,T-SQL, MS Excel, MS Word, MS Access.

Confidential

Database Administrator

Responsibilities:

• Creating, maintaining, Upgrading, Migration of SQL servers.
• Backups, Linked server, Log Shipping, Replication.
• Installation of SQL server and apply latest patches.
• Migration of SQL servers using side by side and in place technology.
• Designed databases and tables.
• Created proper indexes for some tables for better performance of the queries.
• Created Visio diagrams for some data bases.
• Exported data from flat files to SQL server using BCP and Export\Import tool.
• Created Maintenance job for the server.
• Wrote complex SQL queries for data retrieval.
• Designed new data bases for Reporting purpose.
• Created stored procedures, tables, triggers, and views for databases.
• Maintained and Made changes to application in VB 6 and ASP files used for uploading data.
• Documented the guidelines for SQL programming.
• Created a report to notify the status of all report subscriptions.
• Worked on PL\SQL writing queries.

Environment: Windows Server 2003,Oracle PL\SQL, MS SQL Server 2000\2005, VSS, T-SQL, MS Excel,, MS Word, VB 6.0 and ASP.