PROFESSIONAL SUMMARY:

• 10 Years of IT experience in Development, Management, Support DBA of MS SQL Servers 2012, 2008,2005 in Production, QA and Development Environments.
• Thorough Domain knowledge in Health care, Health Insurance , Marketing, Financial Domains and Web Applications
• Database and Log Backups and restores, backup strategies, scheduling backups.
• Promoting database objects to dev to sys and prod environments.
• Planning and Implementing the Replication of MS SQL Server Databases successfully Configured Transactional replication using MS SQL Server 2005
• Monitor and provide support to the application during the testing and production environments.
• Extensive Experience in MS SQL Server 2008, 2005 and 2000 Database Administration including Planning, Installation, Deployment / Implementation and configuration .
• 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 Full, Differential and Transaction Log Backup strategies
• Experience in using SSIS to Export/Import data
• Good Knowledge of SSAS, 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.
• Experience in data integration and data migration.
• Experience in Creating jobs, alerts, log to monitor the database errors
• 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.
• Proficiency in other RDBMS like Oracle and MS Access and languages like PL/SQL, VB
• 24 X 7 Production Database On Call Support.
• Excellent time management, interpersonal and communication skills and a very proactive team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Legacy database migration MySQL --> MSSQL
• Maintenance, conversion and improvement of all existing jobs in SQL Agent
• Automation of data exports/imports.
• 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.
• Planned the complete Backing up of Database and Restored the Database.
• 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.
• 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:

• Upgraded data base servers from SQL Server 2005 to SQL Server 2008.
• Responsible for maintaining production, testing and training databases, supporting development and testing environment
• Responsible from implementation and maintenance for transactional replication.
• Responsible for database promotions from dev and sys environments to production environments.
• Involved in Data analysis and fixing.
• Write database scripts to automate the batch works in DTS.
• Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.
• Full, Differential and Transaction Log Backup strategies.
• 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 DTS and 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
• 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:

• 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.
• 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

• 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/2005, T-SQL, SQL Profiler and Windows 2000 Server

Confidential

SQL Server DBA

Responsibilities:

• Installing MS SQL Server, configuration and doing performance tuning, capacity planning, query optimization
• Job Monitoring and making sure all jobs ran successfully every night
• Proper use of Indexes to enhance the performance of individual queries and the Stored Procedures
• Responsible for Drops i.e. moving from development to QA and then to Production
• Writing migration scripts and taking care of efficiency
• Performing various DDL changes in order to improve performance of database
• Writing stored procedures
• Involved in Data analysis and fixing.
• Monitoring the database assigned for development work
• Expertise in handling system and data issues and fixing the same

• 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.
• Provided day-to-day administration tasks like space and log management.
• Involved in fine tuning of the database, troubleshooting, and memory management.
• Maintained databases with DBCC Rebuilding Indexes, Integrity Checks
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.

Environment: SQL Server 2000, SSIS Windows 2000 Server, T-SQL

Confidential

Database support Admin

Responsibilities:

• Performing administrative tasks like installation and configuration of databases, creating logins, usernames and assigning permissions
• Involved in Data analysis and fixing.
• Using front-end applications Visual Basic 6.0 to access the database
• Creating database objects like triggers to enforce data integrity
• Involved in various stages like development, Testing and Support.
• Developing Database objects and applications using T-SQL.
• Writing Stored Procedures and Triggers.
• Enhancing the existing databases and database modeling.
• Support for ongoing databases.
• Involved in Data analysis and fixing.
• Performing the backups and running the database consistency checks.
• Involved in study of Data Flow requirements and implementation issues to enable smooth sharing of information across the application
• Application design and development using SQL, PL/SQL stored procedures and setup the scheduled feed programs and batch jobs.
• Day to day Database administration
• Support the Web application and database administration
• Development team support and resolving the problem from clients
• Developed various stored procedures using T-SQL.

Environment:

SQL server 2000, VB.Net 1.1, XML, HTML and Windows 2000 Server