Summary

• Over 6 years of professional experience in SQL Server 2000/2005/2008/2012 database development, support, upgrade and administration.
• Strong experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
• Strong experience in Enterprise Backup and Administration solution implemented using Idera.
• Strong experience in replicating the data from Oracle to SQL Server using Attunity Oracle CDC for SSIS
• Highly experienced in Database Maintenance plans, scheduling of jobs and alerts and Notifications using Database Mail.
• Excellent with database backup and recovery activities through Import/Export wizard, backup/restore, SSIS packages, bulk copy/insert, generating scripts.
• Expert in providing high availability support for SQL Server: Failover clustering, database mirroring, log shipping, replication.
• Excellent T-SQL and database programming skills, constructed procedures, triggers, functions, tables, views, indexes, relational database models and data integrity.
• Strong in monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
• Hands on experience in system security, managing user logins, granting access roles and creating services account.
• Strong experience in SQL database design, architecture, data modeling conceptual, logical and physical using Erwin.
• Expert in MS SQL Server 2005/2008 with Business Intelligence, SSIS Integration Service , SSAS Analysis Service , SSRS Reporting Service , building project to extract data from various data sources, flat file, create cubes in SSAS and generating reports through SSRS.
• Strong experience in supporting data center move.
• Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experienced in generating reports using SQL Server reporting services and deploying them on various application on to the web servers.
• Excellent communication skills, self-managing and teamwork spirits in multicultural environment
• Experience in installing, configuring ,managing and troubleshooting Microsoft Team Foundation Server

Skill set:

MS SQL Server 2000/2005/2008/2012, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Idera, Microsoft Management Studio, Import/Export Wizard, Attunity Oracle CDC for SSIS, Visual Studio 2005, Windows 2003 Advanced Server, Windows Enterprise 2003, Windows 2003 Server Enterprise, Microsoft Visio 2005, Web Services, Web Services, Unix, Visual Studio .Net, , SQL Server, XML, ASP , IIS 6.0, Erwin, Windows NT4.0/XP/Vista/07

Professional Experience

confidential

SQL Server DBA

• Installed, configured and upgraded SQL server software.
• Planned, implemented and maintained backup, recovery and restore strategies.
• Created, scheduled maintained database maintenances strategies.
• Planned implemented high availability disaster recovery strategies.
• Provided troubleshooting and solved issues that affect database and its availability.
• Performed data migrations, transfers using utilities like Data Transformation Services DTS , and SSIS, Bulk Copy Program BCP and Bulk Insert.
• Performed Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and PerfMon.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error Handling and Event Handling.
• Performed data profiling using SSIS and streamlined the data according to formatting guidelines.
• Wrote T-SQL, created the stored procedures, triggers, tables to handle complex business rules, history data and audit analysis.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Used SQL Profiler to optimize T-SQL code. Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check.
• Troubleshoot databases and custom application issues
• Eased administrative work through automatic script, performing daily/weekly backups
• Granted access for operational and developmental application system databases. Managed user access. Created and managed new security accounts Designed, implemented, and maintained very complex and large databases with all database respect to access methods, security management, device allocation, database organization, documentation, and statistical methods
• delivers source control, work item tracking, Team Foundation Build, a team project portal Web site, reporting, and project management capabilities on Microsoft Team Foundation Server
• Imported exported data to from SQL server using Integration Service Management Studio.
• Created and audited users ID, their roles and assigned appropriate permission. Created, modified maintained database objects including tables, views indexes.
• Worked with programmers in new database applications test or major changes to existing applications.
• Provided 24 7 production support

confidential

SQL Server DBA

• Created logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Monitored and tuned databases to meet the performance and availability requirements
• Created maintenance plans, scheduled jobs and packages
• Migrated the databases and managed the database location files and size
• Used third party tool IBM's Tivoli Storage Manager for database backups and restorations
• Creating Clustered Indexes and Non-Clustered Indexes to increase the performance of database queries.
• Performed Defragmentation and rebuilding of indexes periodically on the production tables
• Secured the SQL Server by creating user logins and Windows logins with appropriate roles, dropping and locking the logins, creation of groups, granting the privileges to users and Groups.
• Promoted database objects from development environment to testing and from test environment to production.
• Assisted with various ad hoc query requests
• Worked on clustering for Users on a High available environment
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases

confidential

SQL Server DBA

• Designed and modeled database using ERD at the conceptual, logical, and physical levels based on business requirement.
• Designed and created various Database objects such as tables, functions, stored procedures, triggers as per business requirements
• Designing of OLAP database using Star and Snowflake Schema for the purpose of building and maintaining Date warehouse and Data Mart solutions
• Data migration from SQL 2000 and 2005 to 2008 of SQL server
• Installed, configured, administered and secured SQL server by way of Creating logins and assigning server as well as database roles as per business needs with business confidential information in mind
• Optimized SQL server database performance using SQL Profiler, DETA, and Activity Monitor in SSMS as well as wrote T-Sql query to display Execution plan
• Created jobs to automate repetitive tasks using SQL Server Agent
• Involved in creation of custom tailored backup/restore and disaster recovery plans for production servers
• Involved in implementation of database replication between SQL server databases as well as other dissimilar databases
• Implemented Dynamic ETL solution capable of error handling for processing of data created in operational software using various SSIS tools
• Developed reports that are of tabular and Matrix form as well as parameterized with drill through or drill down capacity using SSRS tools by using SSAS cube as a source
• Interacted with relevant Client for gathering of functional requirements to get accurate and pertinent information as it relates to project at hand

confidential

SQL Server DBA

• Designed and modeled database using ERD at the conceptual, logical, and physical levels based on business requirement.
• Designing of OLAP database using Star and Snowflake Schema for the purpose of building and maintaining Date warehouse and Data Mart solutions
• Data migration from earlier versions to latest versions of SQL server
• Installed, configured, administered and secured SQL server by way of Creating logins and assigning server as well as database roles as per business needs with business confidential information in mind
• Optimized SQL server database performance using SQL Profiler, DETA, and Activity Monitor in SSMS
• Created jobs to automate repetitive tasks using SQL Server Agent
• Involved in creation of custom tailored backup/restore and disaster recovery plans for production servers
• Involved in implementation of database replication between SQL server databases as well as other dissimilar databases
• Implemented ETL solution for data created in operational software using SSIS tools into Data Warehouse and Data Mart solutions
• Involved in Front-End application development to be used for input of data from Lab equipments using VB
• Developed reports that are of tabular and Matrix form as well as parameterized with drill through or drill down capacity using SSRS tools by using SSAS cube as a source
• Interacted with various organization personnel for design of business unit specific solutions in the form of frontend application development, user training along with development of proper user manual to aid developed application usage