SUMMARY

• Over Ten Years of IT experience which includes over six years of experience in System Analysis and Design, Development, Support & DBA of MS SQL Servers 2008, 2005 and 2000 on Windows 2003/NT 4.0 in Production, QA and Development Environments.
• Extensive Experience in MS SQL Server 2008/2005 and 2000 Database Administration including Planning, Installation, Deployment/Implementation and configuration
• Experience in Migration of MS SQL Server 2000 to MS SQL Server 2005 and Server 2005 to MS SQL Server 2008.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• Extensive experience in Installation, Configuration and Upgrading of MS SQL Server (Including SSIS and SSRS), Client Software and related products for Production, Development and Test Environment.
• Hands - on experience in Planning, Designing and Developing databases, data warehouses, data marts and OLAP servers.
• Actively participated in gathering business requirements and system specifications from users.
• Developed full scale Entity Relationship model for all MS SQL backend application
• Have an extensive experience with normalized and de-normalized databases.
• Star and Snowflake Schema modeling.
• Worked on SSIS and SSRS extensively.
• Excellent in DTS and SSIS package development and implementation.
• Designed Maintenance plans. Scheduled and monitored all maintenance activities including database consistency check, index de fragmentation and Updating stats.
• Extensive Knowledge with FTP, SFTP, Telnet, uploading, software development life cycle.
• Extensive experience in space allocation, database migrations and database security.
• Extensive experience in writing Complex Stored procedures as well analyzing and debugging existing complex stored procedures.
• Extensive experience in multiple instances on single server, share memory, design and implementation.
• Expertise in MS SQL Server databases backup/restore, Disaster recovery strategies of VLDB databases using VERITAS Net backup and Tivoli.
• Successfully led, executed and maintained projects with multiple databases.
• Extensive experience in Capacity planning, Performance Tuning and troubleshooting.
• Experience in using Native Tools for Performance Monitoring and Tuning of MS SQL Server 2000/2005/2008
• Planning and Implementing the Replication of MS SQL Server Databases successfully Configured Transactional replication using MS SQL Server 2000/2005/2008
• Experience on Maintaining the Large Databases on Production Environment, Cleansing, and Performance Tuning.
• Experience on SQL CLR with C# and .net programming.
• Proficiency in other RDBMS like Oracle and MS Access and languages like PL/SQL, VB, VB.net, and C++. Java
• 24 X 7 Production Database On Call Support.
• Working knowledge of Teradata.
• Strong Communication and Time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.
• Expertise in Data processing using SSIS, T-SQL and BCP.

TECHNICAL SKILLS

Languages: T-SQL, ASP.NET, VB6.0, VB.NET, C#.NET, ASP, JavaScript, VBScript, XML, COBOL, JCL, DB2, VSAM

Databases: MS SQL Server 2008, 2005, 2000, Oracle and MS-Access

Operating Systems: Windows Server 2008, 2003, 2000, Advanced Server, Windows NT 4.0/3.51, Windows 3.x and Windows 9.x

Other Tools: MS OLAP, Crystal Reports, ERWIN 3.0, DTS, SSIS, ETL, Performance Manager, IIS, Visual Interdev 6.0, MS OFFICE 2000 and Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, GA

Database Administrator\Developer

Responsibilities:

• Installing, configuring and administering Microsoft SQL Servers.
• Support multiple SQL Server / 2008 databases in both clustered and non-clustered environments with replication/SSIS. Troubleshoot issues within a clustered server configuration.
• Involved in various stages like development, system Analysis and design
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Database Migration from M SQL 2000 to MS SQL 2008.
• Worked on Teradata to pull the data from transactional DB.
• Worked on critical enhancements and bugs on PATS application.
• Redesign the DB to accommodate critical bugs and enhancements.
• Integrated permits division (Premisys ID) with PATS.
• Worked on migration of Crystal Reports server from Crystal Reports XI to Crystal Reports 2008 to Crystal Reports 2011.
• Experience on SQL CLR with C# and .net programming.
• Performance Tuning: Analyze, tuning and optimizing SQL Server Applications by using performance monitor and profiler. Assist the SQL Developers to normalize the database and optimize Queries.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers
• Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
• Worked on SVN (Source control software) and migrated all the DB scripts for versioning.
• Security Implementation. Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
• Designed and implemented Data Warehouse and data marts for the reporting.
• Designed, developed and implemented several SSIS packages (ETL) to copy the data from transactional DB to the DW.
• Develop reports using SQL Server Reporting Services (SSRS) and utilizing complex SQL queries and stored procedures.
• Configuring, Monitoring and Troubleshooting DB mirroring Replication, Log shipping.
• Migration and Disaster Recovery plans and Implementation.
• Planning and implementation of database backup/restore Strategies.
• Performance Monitoring of MS SQL Server 2005/2000 using various tools like SSMS, Performance Analysis, Spotlight, BMC - Proactivenet, SQL Sentry, Redgate and Idera.
• Identified and resolved SQL Server Database locks and hardware-related issues, using Dynamic Management Views & Functions, Server-Side Tracing/Wait-States and database engine and my own strong set of scripts, DMVs, etc., where necessary, to resolve Performance slow-downs due to locking, blocking and other index related issues.
• Reconfigure/improvements for SQL Server environments, architecture and processes. Experience in performing large scale SQL Server version upgrades.
• Designed Daily Database Report which is embedded with HTML and send out an email notification with the information every day on the activities and state of the database like data file size and the data file % full, log file size and the log % full, free space on all the drives on the server (virtual\physical), errors\exceptions in past 24 hours.
• Analyzing the server performance metrics of the server from various tools like VMware and Performance monitor.

Environment: SQL Server 2008/2005/2000 , WINDOWS 2008/2003, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS\SVN.

Confidential, Washington DC

MS SQL Server Database Administrator\Developer

Responsibilities:

• Installing, configuring and administering Microsoft SQL Servers.
• Involved in various stages like development, system Analysis and design
• Planning, Designing and Developing databases, data warehouses, data marts and OLAP servers. Optimization, clustering, fault tolerance etc.
• Enhancing the existing databases and database modeling.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Actively involved in the data aggregation, data auditing and generating the reports for clients.
• Worked extensively on huge enterprise level data warehouse and data mart.
• Designed and developed SSIS Packages (ETL) to transform the data from transactional database to enterprise data warehouse and from data warehouse to data mart.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Configured Audit at each level of the SSIS package for reporting any errors during the execution process of the package/code and for historical tracking of the errors occurred in the SSIS execution process.
• Designed SSIS Packages to import the data from external sources and different file formats to load in to SQL Server using ftp and sftp.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Involved in migrating from SQL Server 2005 to SQL Server 2008.
• Installed, Configured, Designed and created reports using SSRS.
• Performance Tuning: Analyze, tuning and optimizing SQL Server Applications by using performance monitor and profiler. Assist the SQL Developers in SQL tuning.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost. Analyzed different scripts to find the bottlenecks in SQL code
• Worked on database maintenance, planning and scheduling maintenance jobs such as database consistency check, index de fragmentation and Updating stats.
• Worked in a large team using Microsoft Visual studio 2008 Team System for Database Professionals with TFS for version control and greater co-ordination.
• Planned and managed backup and recovery strategies.
• Security Implementation. Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Configured Database Mail and Operator for agent job alerts on Success/Fail/Complete.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Scheduling Transaction Log Backup and Full backups for disaster recovery and physical space management.
• Involved in Log Shipping
• Refreshing dev and staging servers with production data by restoration of databases for constant synchronization of dev and staging servers with production servers.
• Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
• Providing 24x7 On-Call support for production applications.

Environment: SQL Server 2008/2005/2000 , WINDOWS 2008/2003, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS.

Confidential, Bethesda, MD

Database Administrator\Developer

Responsibilities:

• Installing, configuring and administering Microsoft SQL Servers.
• Involved in various stages like development, system Analysis, design.
• Planning, Designing and Developing databases, data warehouses and OLAP servers. Optimization, clustering, fault tolerance etc.
• Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
• Enhancing the existing databases and database modeling.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Support for ongoing huge databases.
• Scheduled and monitored all maintenance activities including database consistency check, index de fragmentation and Updating stats.
• Involved in migrating from SQL Server 2005 to SQL Server 2008.
• Extensively used SSIS to Export/Import data from existing database to live database and Vice-versa.
• Created SSIS packages to transfer objects from development server to production.
• Used SSRS extensively to create reports.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Setup and maintained Linked Servers.
• Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Testing of applications for performance, data Integrity.
• Actively involved in Transforming Operational Data and planning Data Warehouse design.
• Involved in Managing a Data Warehouse or Data Mart.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Managing the use of disk space, memory and connections. Running DBCC.
• Worked in a large team using Microsoft Visual studio 2005\2008 Team System for Database Professionals with TFS for version control and greater co-ordination.
• Providing 24x7 on-call technical support.

Environment: SQL Server 2008/2005/ 2000 , Oracle 10g,Toad for Oracle, WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS.

Confidential, Alexandria, VA

Database Administrator\Developer

Responsibilities:

• Involved in various stages like development, system Analysis and design.
• Actively participated and interacted with users, team members, leads and technical manager of concerned system to fully understand the business rule and requirements of the changes that need to be made compatible with existing system.
• Analyzed different tables from all customer line, figured out the natural keys for each table if it had any, and came up with the business rule to whether insert only new records or insert all records or merge duplicate records. These tables were assigned as per clients.
• Created several SSIS packages to import Flat files (CSV) into data tables.These packages were scheduled in regular time interval.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost. Analyzed different scripts to find the bottlenecks in SQL code
• Wrote several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules. Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Wrote scripts to check for duplicate records and delete/modify them on this staging table depending on the business rule.
• Worked in a large team using Microsoft Visual studio 2005 Team System for Database Professionals with TFS for version control and greater co-ordination.
• Regularly monitored the system for bottlenecks of H/W (CPU, RAM, Disk IO and networking) and Software version, Maintained database and Backup/recovery. Defined Database Maintenance Plan which was scheduled as job and made them run automatically.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked extensively on SSRS and Crystal Reports to create reports.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Actively involved in migrating from SQL Server 2005 to SQL Server 2008.
• Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. used on IPN supported machines. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDFs, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Testing of applications for performance, data Integrity.
• Actively involved in migrating from SQL Server 2000 to SQL Server 2005.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Managing the use of disk space, memory and connections. Running DBCC.

Environment: SQL Server 2008/2005/ 2000 , WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS

Confidential, Richfield, OH

Database Administrator/Developer

Responsibilities:

• Involved in various stages like development, system Analysis, design.
• Worked on Microsoft Visual studio 2005 Team System for Database Professionals with TFS for version control and greater co-ordination.
• Enhancing the existing databases and database modeling.
• Extensively used DTS and SSIS (ETL).
• Created SSIS packages to transfer objects from development server to production.
• Worked extensively on SSRS to create reports.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Testing of applications for performance, data Integrity.
• Actively involved in Transforming Operational Data and planning Data Warehouse design.
• Involved in Managing a Data Warehouse or Data Mart.
• Actively involved in migrating from SQL Serer 2000 to SQL Server 2005.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Managing the use of disk space, memory and connections. Running DBCC.

Environment: SQL Server 2005/ 2000, WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2005 with TFS