PROFESSIONAL SUMMARY:

• Over 9 Years of IT experience in Development, Management, Support & DBA of MS SQL Servers 2016,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.
• Migrating databases from Sybase to SQL server
• 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 2012
• Monitor and provide support to the application during the testing and production environments.
• Extensive Experience in MS SQL Server 2016,2012, 2008 and 2005 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:

• Operating Systems: Windows XP/ 2012/12008/2003/ NT/98, DOS
• Databases: MS SQL Server 2016,2012, 2008,2005, 2000, MS - Access, Sybase
• 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, Idera SQL Safe, Evault, Red Gate, ignite

PROFESSIONAL EXPERIENCE:

Confidential , Los Angeles, CA

SQL Server DBA

Responsibilities:

• Migrating databases from Sybase to SQL server 2012
• Upgraded data base servers from SQL Server 2000 to SQL Server 2012.
• 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.
• 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/applications.
• 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
• 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 2012/2008/2005, SSIS,SSRS,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.
• Legacy database migration (MySQL --> MSSQL)
• Maintenance, conversion and improvement of all existing jobs in SQL Agent
• 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.
• 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.
• 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 SSIS 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 2012/2008, Idera SQL Safe, Red Gate, SSIS, Windows 2012/2008

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 SSIS to Export/Import data
• Design and normalize the databases and created different objects like tables, views, Stored Procedures on MS SQL server.
• 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 2012/2008/2005, SSIS,SSRS,Idera SQL Safe, Evault, Red Gate, ignite