PROFESSIONAL SUMMARY:

• Over 9 Years of IT experience in Development, Management, Support & DBA of MS SQL Servers 2012,2008, 2005,2000 in Production, QA and Development Environments.
• Thorough Domain knowledge in Health care, Marketing, Financial Domains and Web Applications
• Database and Log Backups and restores, backup strategies, scheduling backups.
• Deploying database objects from dev to sys and prod environments.
• Planning and Implementing the Replication of MS SQL Server
• Monitor and provide support to the application during the testing and production environments.
• Creating Maintenance plans to automate daily maintenance activities
• Hands on experience in Database Support, Data analysis and fixing.
• Played a key role in business requirements analysis, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• Experience in using DTS to Export/Import data
• Good Knowledge of SSIS, SSRS, OLTP, OLAP, Data mining.
• Scheduled and monitored all maintenance activities including database consistency check
• Good Knowledge in HTML, XML, VB Script, ASP, IIS, software development life cycle.
• Experience in Installation, Configuration and Upgrading of MS SQL Server, Client Software and related products for Production, Development and Test Environment.
• Experience in writing stored procedures as well analyzing and debugging existing complex stored procedures.
• Extensive Experience in MS SQL Server 2012, 2008, 2005 and 2000 Database Administration including Planning, Installation, Deployment / Implementation and configuration.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Experience in Creating jobs, alerts, log to monitor the database errors
• Experience in Full, Differential and Transaction Log Backup strategies
• Experience in Backups, Clustering, Capacity planning, Performance Tuning and troubleshooting.
• ·Experience in using SQL Bulk Copy Program, Native Tools for Performance Monitoring and Tuning of MS SQL Server 2000.
• 24 X 7 Production Database On Call Support.
• Excellent time management, interpersonal and communication skills and a very proactive team player.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/ NT/98, DOS

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

Languages: T-SQL, VB6.0, .Net, VBScript, XML

Test Strategies: Functional, Regression Testing

Process Methodologies: ISO 9001:2000, CMM, CMMi

Other Tools: Informatica 7.1 Red Gate

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Managing SQL Servers in development and production and QA environment.
• Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Automation of data exports/imports using SSIS.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained production database, along with supporting development and testing environment.
• Troubleshoot production database server, user administration, configure SQL Server, creating databases for development and testing environments, capacity planning, performance tuning and database monitoring.
• Migrated from Sybase ASE 11.9 to SQL Server 2012 using SQL Server Migration Assistant(SSMA)
• Have worked on Log shipping to create Stand-by Server.
• Database and Log Backups and restores, backup strategies, scheduling backups.
• Remote configuration, fine tuning of database objects and server
• Job Monitoring and making sure all jobs ran successfully every night.
• Managed MS SQL Servers in Virtual Environments using VMWARE.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers.
• Perform recovery of the database. Import tables schema as requested.
• Actively involved in migrating from SQL Server 2000 to SQL Server 2012.
• Creating tables, views, indexes, stored procedures, triggers and constraints.
• Monitoring and fixing replication issues.
• 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.
• Used import\export wizard to import and export data.
• Designing SSIS packages for the data transfer from the customer feedback to databases for various purposes.
• Deployed Functions, Triggers, Stored Procedures, Databases, and views

Environment: SQL Server 2008/2012, Windows 2000 NT, Idera SQL Safe, Red Gate, SSIS, Windows 2012/2008

Confidential, Madison, WI

SQL Server DBA

Responsibilities:

• Responsible for maintaining production databases, supporting development and QA environment.
• Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.
• Full, Differential and Transaction Log Backup strategies.
• Configured log shipping as part of recovery strategy.
• Created and maintained technical documentation.
• Created jobs, alerts, log to monitor the database errors.
• Involved in various stages like development, Testing and Support.
• Deployed Functions, Triggers, Stored Procedures, Databases, and views
• Enhancing the existing databases and database modeling.
• Support for ongoing databases.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Used SSIS to Export/Import data
• Design and normalize the databases and created different objects like tables, views, Stored Procedures on MS SQL server.
• Production Code Deployment and handling concurrent user requests.
• Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• 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.
• Performing regular consistency checks for database consistency using DBCC commands and re-index/index-defrag tables on a scheduled basis
• Monitoring and fixing replication issues.
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Managing the use of disk space, memory and connections. Running DBCC.

Environment: SQL Server 2012/2008/2005, Windows 2008, 2008/2005, SSIS, SSRS, Idera SQL Safe, Evault, Red Gate, ignite

Confidential, IL

SQL Server DBA

Responsibilities:

• Upgraded data base servers from SQL Server 2005 to SQL Server 2008.
• Responsible for maintaining production database, supporting development and testing environment.
• Involved in Data analysis and fixing.
• Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.
• Full, Differential and Transaction Log Backup strategies.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Configured log shipping as part of recovery strategy.
• Created and maintained technical documentation.Generated and maintained test data and databases for the testing environment.
• Created jobs, alerts, log to monitor the database errors.
• Involved in various stages like development, Testing and Support.
• Created Functions, Triggers, Stored Procedures, Databases, and views
• Enhancing the existing databases and database modeling.
• Support for ongoing databases.
• Used SSIS to Export/Import data
• Design and normalize the databases and created different objects like tables, views, Stored Procedures on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• 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.
• Performing regular consistency checks for database consistency using DBCC commands and re-index/index-defrag tables on a scheduled basis
• 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 offshore (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 2008/2005, Idera SQL Safe, Evault, Red Gate, ignite

Confidential

SQL Server DBA

Responsibilities:

• Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained production database, along with supporting development and testing environment.
• Troubleshoot production database server, user administration, configure SQL Server, creating databases for development and testing environments, capacity planning, performance tuning and database monitoring.
• Have worked on Log shipping to create Stand-by Server.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Job Monitoring and making sure all jobs ran successfully every night
• Responsible for Drops i.e. moving from development to QA and then to Production
• Planned the complete Backing up of Database and Restored the Database.
• Provided day-to-day administration tasks like space and log management.
• Production Code Deployment and handling concurrent user requests.
• Remote configuration, fine tuning of database objects and server
• Job Monitoring and making sure all jobs ran successfully every night.
• Moved the entire phase from the Staging to the Production and reviewed existing databases and documented the suggestions for improving performance of the database.
• Managing SQL Servers in development and production.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers.
• Perform recovery of the database. Import tables schema as requested.
• Actively involved in migrating from SQL Server 2000 to SQL Server 2005.
• Creating tables, views, indexes, stored procedures, triggers and constraints.
• Suggested different plans for Replication.
• Involved in Data analysis and fixing
• 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.
• Designing DTS packages for the data transfer from the customer feedback to databases for various purposes.
• Responsible for creating user groups and assigning permissions.
• Involved in writing stored procedures for different tasks.
• Upgraded data base servers from SQL Server 2000 to SQL Server 2005

Environment: SQL Server 2000/2005, Idera SQL Safe, Red Gate, DTS, SSIS, Windows 2000 NT

Confidential

SQL Server DBA

Responsibilities:

• Creating and managing database objects such as tables, views, indexes, and maintaining referential integrity
• Deploying/Migrating databases across server environments like Development, UAT, and Production
• Job Monitoring and making sure all jobs ran successfully every night
• Performing regular consistency checks for database consistency using DBCC commands and re-index/index-defrag tables on a scheduled basis
• Administering and automating Backup and recovery process for standalone DB server environments
• Involved in Data analysis and fixing.
• Production Code Deployment and handling concurrent user requests.
• Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Designed, implemented, and administrated databases in SQL Server 2000
• Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
• Performed daily administration, monitoring, and documentation of SQL Servers
• Responsible for tuning data, indexes, and queries
• Created alerts and notifications for system errors, insufficient resources, fatal database errors
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Configured securities and accesses to production databases and database servers
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
• Managed the integration of data and monitored exceptions of highlight data from customers

Environment: SQL Server 2000, T-SQL, SQL Profiler and Windows 2000 Server