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 2012, 2008 R2/2005 and 2000 Database Administration including Planning, Installation, Deployment/Implementation and configuration on Windows and UNIX plat forms.
• Experience in Migration of MS SQL Server 2000 to MS SQL Server 2005 and Server 2005 to MS SQL Server 2008 R2.
• 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.
• 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.
• Developed full scale Entity Relationship model for all MS SQL backend application
• Have an extensive experience in Transact-SQL (DDL, DML, and DCL) and with normalized and de-normalized databases.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Experience with tools like SQL Server management studio and SQL Server 2005/2008.
• Experience with Star and Snowflake Schema modeling.
• Proficient in developing Parameterized, Ad-Hoc Reporting, Linked Reports, Drill down and Drill through reports.
• Create/Edit/Maintain/implement ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access, Excel, DB2, MYSQL and ORACLE.
• Worked on development of SSRS and SSAS extensively.
• Working knowledge of Informatica.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Hands-on experience on deployment of SSIS and SSRS.
• Experience in configuring Agent Jobs, Sending Alerts using SQL Mail.
• 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.
• Expertise in Data processing using SSIS, T-SQL and BCP.
• 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 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.
• 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.
• Ability to adapt quickly to changing environments.
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs

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, Atlanta, GA

Database Administrator

Responsibilities:

• Installing, configuring and administering Microsoft SQL Servers.
• Support multiple SQL Server / 2008 R2/2012 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 MS SQL 2000 to MS SQL 2008 and from MS SQL 2008 to MS SQL 2012.
• Worked on critical enhancements and bugs in 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.
• Performance Tuning: Analyzing, tuning and optimizing SQL Server Applications by using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Assist the SQL Developers to normalize the database and optimize Queries.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.
• 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.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, CSV files, Oracle and DB2
• 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 2012/ 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, Informatica.

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.
• Worked Extensively on VBA.
• 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

Confidential, Memphis, TN

Database Administrator

Responsibilities:

• Installing, configuring and administering Microsoft SQL Servers.
• Planning, Designing and Developing databases, data warehouses and OLAP servers. Optimization, clustering, fault tolerance etc., Planning, designing, implementing and administering MS Windows NT based networks and multi-domain models.
• Providing 24x7 on-call technical support.
• Active member for Database and Analytics team involved in development of a warranty product. The warranty product is part of the service solution available for manufacturing organizations to manage product service / warranty.
• Managing SQL Servers in development and production.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers.
• 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.
• Backup and Recovery: Designing Backup/Restore Strategy.
• Perform recovery of the database. Import tables schema as requested.
• Actively involved in migrating from SQL Serer 2000 to SQL Server 2005.
• Written SSIS packages for business needs.
• Creating tables, views, indexes, stored procedures, triggers and constraints.
• Suggested different plans for Replication.
• Performance Tuning: Analyze, tuning and optimizing for SQL Server Applications by using performance monitor. Assist the SQL Developers in SQL tuning. a) Data loading job which was taking more than 36 hours, reduced to 2 hours. (b) sql statement was tuned which was taking more than 5 hours to 30 seconds. (c) sql statement was tuned which was taking 1.30 hours with high CPU to 4 seconds.
• 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.
• 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.
• Written visual basic scripts to monitor the application and for sending mails in case of any discrepancy.
• Data transfers between various servers using BCP and DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Designing DTS packages for the data transfer from the customer feedback to databases for various purposes.
• Involved in writing stored procedures for different tasks.
• Fine- Tuning the Server to achieve Best Performance.

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

Confidential, Austin, TX

SQL Server Developer/DBA

Responsibilities:

• 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 day-to-day administration tasks like space and log management.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• 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.

Environment: MS SQL Server 2000, Windows 2003 Server, Windows NT 4.0, Erwin, MS Access, Toad, Excel, ASP.Net.