SUMMARY

• 10+ years of IT experience, which includes Administration, System Analysis, Design, Development, Testing, Security and Support in Microsoft Database Technologies with various Industry verticals like GIS, Education, food, financing, insurance and Health care.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, 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/2005/2000 databases.
• Involved in configuring the reporting services (SSRS) and creating the reports in SQL server 2008/2005.
• Experience with Database Backup, Recovery and Disaster recovery procedures.
• Experience with SQL Server 2005 Database Mirroring, Migration, Upgrading.
• Experience in using Data modelling tools like SQL Diagrams, ERWIN and Visio.
• 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, Windows Perfmon and DTS, SSIS, SSRS for Monitoring, Developing and Tuning MS SQL Server applications.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• 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
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail and custom extended procedures like XP SMTP MAIL.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Worked with Third Party Backup solutions like SQL Litespeed for MS SQL Server.
• Developed backup and recovery strategies for SQL Server databases.
• Documented disaster recovery plans and participated disaster recovery drills.
• Experience in working with Reporting tools like Business Objects, Crystal Reports, and Microsoft Reporting services (SSRS).
• Experience in monitoring the disk usage and the memory usage of the servers
• Excellent team player with good communication skills.
• Ability to adapt new technologies
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003 Advanced Server, Windows Exchange Server 2003 Windows NT 4.0/3.5, Windows9.x, Windows XP.

RDBMS: MS SQL Server 2008,2005, 2000, 7.0, MS Access 2000, 2003Oracle 9i,10g,11g

Languages: C, C++, T-SQL.

Web Technologies: HTML, DHTML, XML, Java Script and VB Script

Version Control Tools: Visual Source Safe, Rational Clear Case

Reporting Tools: Crystal Reports 8,9,10, SSRS 2005/2000.

Modeling Tool: ERWIN 3.5/4.0, Visio 2002

Other Tools: Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, Toad, Red Gate

PROFESSIONAL EXPERIENCE

Confidential, Ohio

SQL Server DBA

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created objects and program units using functions, stored procedures, triggers and exceptions in T-SQL
• Participated in database modelling (logical and physical) using Erwin data modeller.
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Implementing Backups and Restoring when necessary.
• Used BCP utility to publish table output to text files
• Created reports from database onto excel spread sheet using DTS.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Checks, Update Database Statistics and Re-indexing.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Automated databases maintenance plan using the DTS packages.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee’s requirement and generating records between front-end and back end.
• Created Users and Roles, and managed security and permission of database

Environment: SQL Server 2000, Visual Basic 6, Windows NT server, Erwin 3.5.2

Confidential, Ohio

SQL Server DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforcing entity referential integrity.
• Involved in Implementation of database design and administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Performed installation and upgrading MS SQL Server 6.5 to SQL Server 7.0.
• Daily monitor the systems and check the performance of systems.
• Generates the report into Excel Spreadsheet form from SQL server6.5/7.0.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: SQL Server 2000 Oracle 8i/9i, Windows NT, C++, HTML, T-SQL, PL/SQL, SQL Loader

Confidential, Chicago

SQL Server Developer

Responsibilities:

• Create and maintain various databases for Production, Development and Testing environments using SQL Server 2008/2005/2000
• Involved in a 24/ 7 production support on SQL Server 2008/2005/2000 .
• Created, scheduled and managed all the database maintenance plans using SSIS packages in all the SQL servers across 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 2005/2000 to SQL server 2008.
• Maintained the database security in all the servers.
• Involved in creating and maintaining transactional replication using an external tool called XoSoft.
• 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.
• Using the replication tool XoSoft maintained all the production and stage servers in a maximum availability.
• Involved in maintaining reporting services in SQL server 2005 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).
• Worked with a terabyte database applications.
• 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.
• Worked with various application teams in order to create the applications on the SQL server.
• 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 developers 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 50GB to 1 tera byte, 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.
• Since I was in SQL Support, I got an opportunity to see almost all the possible ways Microsoft SQL Server and its products could be implemented according to the needs of our customers.

Environment: SQL Server 2008/2005/2000 Enterprise Edition, SQL Server Reporting Services 2000/2005/2008 , Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Windows 2008 Enterprise Edition, IIS 5.0/6.0/7.0.

Confidential, MD

SQL Server Developer

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 2000 to SQL server 2005.
• Worked on and maintained an 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 2000 to SQL server 2005.
• 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.
• 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 2005 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 2000 to SQL server 2005
• Maintained the database security in all the servers of the company.
• Maintained all the databases in all the servers in sync in order to avoid any kind of errors.
• 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.
• Automated various Database maintenance plans used the DTS packages and SSIS in SQL server.
• 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 2000/2005 Enterprise Edition, SQL Server Reporting Services 2000/2005, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Idera Diagnostic Manager.

Confidential, Washington, D.C.

Database developer

Responsibilities:

• Digitized livelihood zone, woreda and PA maps (using Arc view software for mapping and excel for population data)
• Ensured that appropriate systems for data collection, storage, retrieval and analysis are set up
• Compiled Population data by woreda and livelihood zone by P A, Crop production data by woreda and season, Market price data by woreda and month, Baseline household economy results by livelihood zone, Key parameter results by woreda and livelihood zone.
• Set up a system for preparing woreda specific materials for each seasonal assessment
• Set-up and maintain the software required to complete the outcome analysis by woreda and livelihood zone and livelihood zone within woreda.
• Developed training materials and provide training in data storage, retrieval and analysis
• Developed database/spreadsheet training materials.
• Maintained a digital library of project outputs, including
• Supported rapid dissemination of project outputs, e.g. by tailoring materials for posting on the DPPA website.