SUMMARY:

• 4+ years of IT experience, which includes Administration, System Analysis, Design, Development, Testing, Security and Support in Microsoft Database Technologies with various Industry verticals like financing, Insurance and Health care.
• Experience in MS SQL  Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, and Database Consistency Checks using DBCC commands.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional. 
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL  Server 2008,2012 databases.
• Involved in configuring the reporting services (SSRS) and creating the reports in SQL  server 2012. 
• Experience with Database Backup, Recovery and Disaster recovery procedures. 
• Experience with SQL  Server 2008r2,2012 Database Mirroring, Migration, Upgrading. 
• Data migration using ETL tools like DTS services/SQL   Server Integration Services (SSIS) across different databases like Oracle, MS access & flat files. 
• Experience in using Microsoft's in built tools like SQL  Profiler, DTS, SSIS, and SSRS for Monitoring, Developing and Tuning MS SQL  Server applications. 
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T - SQL, SQL  Scripts and Batch files. 
• Creation and maintenance of Databases, creating Roles and managing user permissions. 
• Good experience in resolving blocking and Dead lock Issues by using SQL  commands. 
• Experience in Installing and configuring SQL  Server Active/Active and Active/Passive clusters. 
• Expert in Configuring, Managing and optimizing transactional replication in OLTP environments.
• Good knowledge in using various RAID technologies 
• Experience in using DTS Import/Export utility, BCP and DTS Packages. 
• Worked with Popular monitoring solutions such as SQL  Diagnostic Manager, Quest Spotlight 
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database. 
• Developed backup and recovery strategies for SQL  Server databases. 
• Documented disaster recovery plans and participated disaster recovery drills. 
• Experience in monitoring the disk usage and the memory usage of the servers.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008,Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Web Technologies: XML, HTML, VBScript

GUI Tools: Visual Studio (VB), Visual Studio2005/2003

Languages: VB 6.0, VB.Net, T-SQL, .Net Technologies VB. NET, ASP.NET

Web Server: Internet Information Server

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access, Oracle 9i.10g, 11g

Version Tool: Visual Source Safe

Reporting Tools: Business Objects, Crystal Reports, OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Lite speed, Erwin, DB Moto.

PROFESSIONAL EXPERIENCE:

Confidential, IA  

SQL DBA

Responsibilities:

• Create and maintain various databases for Production, Development and Testing environments using SQL  Server 2012/2008r2/2008. 
• Created, scheduled and managed all the database maintenance plans using SSIS packages in all the SQL  serversacross the environment. 
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as Database backup, replication verification, database integrity verification and indexing updates.
• Used SSRS for creating various reports in the company in a daily basis on DEV and the production databases.
• Involved in migrating the databases from SQL  server 2008/2008r2 to SQL  server 2012. 
• Maintained the database security in all the servers. 
• Maintained SQL  servers in an Active / Passive cluster environment.
• Implemented and maintained all the production servers using an external tool for monitoring called Fog light. 
• Involved in maintaining reporting services in SQL  server 2012/2008 in one of the production servers. 
• Perform daily backups and developed recovery procedures .
• Created logical and physical databases for various applications.
• Involved in creating scheduled full and transactional log backups in all the test and Development environments. 
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization (space, Performance and capacity). 
• Involved in creating and deploying the SSIS packages in SQL  server which are developed by the application which will load data in to SQL  server in a regular intervals of time. 
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes. 
• Involved in monitoring the servers in a regular basis in order to check if there are any blocks that are Occurring during the processes. 
• Worked closely with various application teams and respective developer  during the time of releases. 
• Involved in documenting various activities performed as a DBA . 
• Attending meetings regarding current database performance.
• Involved in using the Red Gate comparison tool in order to list out the irregularities between certain Environments. 
• Setup profiler traces for slow running queries and tune them accordingly. 
• Size of databases varied from 500GB to 1 Terabyte, each server contained around 15 to 30 databases in all The 40 servers and other 16 DR servers and worked as a DBA  in a team of 3. 
• Implemented various ways to implement high availability and scalability for SSRS.    Environment: SQL  Server 2012/2008 Enterprise Edition, SQL  Server Reporting Services 2012/2008, Windows Server 2008 Enterprise Edition.

Confidential ­,Dallas,TX

SQL DBA

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles. 
• Involved in the SQL  Server migration from SQL  Server 2005 to SQL  server 2008.
• Worked on and maintained Active / passive clustered environment. 
• Maintained all the databases and monitored the performance in a regular basis.
• Assisted and supported the development team in the process of installing new patches and changes in the Databases in SQL  server. 
• Automated various daily backups in all the servers. 
• Managed various issues like the Orphan user and transfer of logins etc., during the process of migration of SQL  server 2005 to SQL  server 2008.
• Created logical and physical databases for the development and testing servers as per the end-user Specification. 
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. 
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes. 
• Implemented and Troubleshooted log shipping and database mirroring for high availability of critical Databases. 
• Created all the scripts for the migration for all the databases of both QA and the Production servers. 
• Supported the production server 24/7 during the process of major installs and releases. 
• Automated various jobs that would re index the databases on a regular basis in order to increase the performance of SQL  server. 
• Responsible for Query optimization and Performance tuning. 
• Maintained all the instances of SQL  servers in maximum Availability .
• Implemented the latest technologies in SQL  server 2008 such as reporting services in all the servers. 
• Involved in monitoring the proper usage of the disk space on the physical drives of the server as a part of Disk management.
• Involved in transferring and recreating all the jobs and logins in the process of migration of SQL server from SQL  server 2005 to SQL  server 2008.
• Involved in configuring the reporting services and creating the reports in SQL  server 2005. 
• Setup profiler traces for slow running queries & analyze load file through query tuning wizard.
• Configured the IIS in all the servers during the process of configuring the reporting services.
• Size of the databases varied from 70 to 200 GBS databases, each server contained about 50 to 60 databases in all the 15 servers in both QA and production and worked as a DBA  in a team of 4    Environment: SQL  Server 2005/2008/2012 Enterprise Edition, SQL  Server Reporting Services 2008, Windows 2003/2008 Enterprise Edition.

Confidential

JR SQL DBA/Developer

Responsibilities:

• Installed SQL  Server 2005/2008 Servers and applied hotfixes and service packs for Production and Development environments. 
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server Databases. 
• Developed scripts for tables, stored procedures, DTS tasks, and prepared comprehensive commenting of all Codes. Maintained technical documentation for operational support. 
• Used joins and other complex queries to view the results that meet the business decision. 
• Actively monitored performances of queries on SQL  server using SQL  Profiler and optimized it by creating Appropriate indexes using Index Tuning Wizard.
• Created Database Maintenance Planner for the Performance of SQL  Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing. 
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Created Jobs, Alerts and scheduled DTS Packages as per the application team's requirements. 
• Created stored procedures and create dynamic SQL  Queries to adopt dynamic environment. 
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from Being displayed. 
• Performance monitoring and trouble-shooting at the server and database level.    Environment: MS SQL  Server 2005/ 2008, Windows NT/2003 Servers