Summary

Around 7 years of IT experience working as a SQL server Database Administrator, having hands on experience in Installation, Configuration, Backup and Recovery, Migration, Upgrades, Replication, Database Security, Memory Management, Log Shipping, Mirroring, Performance monitoring and Tuning, Implementation and Testing of Relational Database Management systems for Business solutions.

• 7 years of Production Support Database Administration using Microsoft SQL Server 2000,2005,2008, R2 and 2012 .
• Experience in Installation, configuration and maintenance of SQL Server 2000, 2005 and 2008, 2012.
• Assist with database design and architecture as needed.
• Extensive experience working in a Data Architect capacity and possess skills ranging from business intelligence/data warehousing to production support.
• Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints.
• Experience in managing big volume of data 2TB databases .
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in query optimization performance tuning, SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures in SQL server 2000, 2005 and 2008.
• Experience in SQL server 2000, 2005 and 2008 Replication
• Experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load with SSIS and SSRS.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Created complex DTS and SSIS Packages for Data Migration and Transformation.
• Experience in MS SQL Server upgrades from SQL server 2000 to MS SQL Server 2005 and from 2005 to MS SQL server 2008.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Review of physical and logical database design Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.
• 24 7 on-call production database support and maintenance including remote database support.

Technical Skills:

Responsibilities:

• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Monitored mission critical SQL Servers using SQL Sentry to address different issues such as blocks, deadlocks, Memory, CPU and escalate the issues appropriately based on the severity.
• Backup databases from production servers and restoring them to testing environments to help application developers in their code rollouts and testing.
• Created scripts to sync all the SQL logins to appropriate Users after restoring the databases to test environments.
• Creating logins and assigning proper roles to the SQL Server logins users.
• Created scripts to monitor database log tempdb files growth and alert DBA group when necessary.
• Scheduled SQL Server agent jobs to send out Backup information reports of all the databases in production servers to DBA group.
• Created Indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Create and Maintained SSIS packages to extract data from flat files and export to SQL Server Objects
• Generated reports using SSRS that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Environment: SQL Server 2005/2008/R2/2012, RedGate toolbelt, SQLSafe, SQL Sentry, SSIS, SSRS, Sharepoint.

Confidential

SQL DBA/Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• Performed data migration from SQL Server 2005 to SQL Server 2008 R2.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Data migration import export BCP from Text to SQL server.
• Good understanding and experience in SQL Server 2008 features like Change Data Capture CDC , Transparent Data Encryption TDE and Policy based Management.
• Prepared and documented Backup Restore Plans.
• Created clustered and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan. Eliminated key-lookups, table scan and converted index scan to index seek
• Backing up databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio BIDS and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Environment: SQL Server 2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential

MS SQL DBA Deveoper

Responsibilities:

• Responsible for Logical Physical Database Design.
• Responsible for creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/ Check Constraints.
• Responsible for the Development and Debugging of Stored Procedures, User Defined Functions, Triggers and Queries.
• Designed Scripts for Reorganizing and Rebuilding Indexes and for updating statistics.
• Managed databases in clustered/non-clustered environments.
• Used Visual Source Safe Source Control to transfer the stored procedures and scripts to production servers.
• Creation and management of Transactional/Snapshot Replication.
• Prepared scripts for SQL Lite Speed Backups.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Used DBCC commands to check physical and logical consistency of the databases.
• Backup and recovery of System and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Responsible for Query optimization and Performance tuning using Database Tuning Advisor, Profiler and Query Execution plans.
• Used NT Performance monitor to monitor CPU Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Creation, Development and Maintenance of SSIS Packages.
• Used Red Gate compare tool to compare the Databases with the snapshots.
• Generated monthly and yearly Reports using SSRS 2005.
• Provide 24 X 7 dedicated support to all Production, QA Development MS SQL Server Environments.
• Monitor Server Level Blocks/deadlocks Maintain all the OLTP Servers with Maximum Database Availability, Reliability Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime Maximum Reliability.
• Review/test/apply all database changes to all environments including QA, Development and Production Servers.
• Installed SQL Server 2008 and Applied Service Packs to all the SQL 2005 Servers.
• Performed Migration from SQL Server 2000/2005 to SQL Server 2008 CRM Applications .
• Performed SQL Server 2005 installation and Upgrade in Test, Development, QA Production servers.
• Fine tuning the Database Settings as well as the Server Settings.

Environment: SQL Server 2008/2005/2000, .net, BizTalk Server, Share point server, Microsoft Dynamics CRM, Great Plains, SSIS, SSRS, Advanced Windows 2003 Server, RedGate and Team Foundation Server.

Confidential

SQL DBA Developer

Responsibilities:

• Designed and created use case, class and sequence diagrams using UML.
• Expertise in all the installation and configuration issues of Microsoft SQL Server and Integrating Services and Reporting Services.
• Expertise in Server Management issues like administration, Backup/Restore, Space Management auto growth/shrink, file groups , Attach/Detach.
• Worked on performance issues like server wide performance issue, database wide performance and stored procedure tuning issue.
• Worked on replication configurations and troubleshooting replication like replication agent's failure, and performance issue.
• Troubleshoot data corruption issue Server down situation understand the DBCC checkDB output, planning of disaster recovery.
• Troubleshooting all type of memory related issues like: out of memory error and issues related to basic connectivity and full text search.
• Troubleshooting of upgrades issues like SQL Server 2005 to SQL Server 2008, Edition upgrades and hot fix upgrades.
• Worked on advisory cases like providing knowledge to customers who are not sophisticated on installations and configuration setups of database services and reporting services and also helped customers in setting up upgraded services packs and hot fixes.
• Created Complex SSIS Packages ETL Applications, using BIDS and troubleshoot couple of Execution and development issues.
• Created Complex SSRS Reports using the Business intelligence development tools and troubleshoot the performance and subscription issues in it.
• Troubleshooting issues with the reporting services website on different ports.
• Trouble shooting IIS and reporting services errors like HTTP:401 etc .
• Environment: Windows Server 2000, SQL Server 2008, UML, SSIS, SSRS.

Confidential

MS SQL DBA

Responsibilities:

• Upgraded migrated SQL 2000 to SQL 2005.
• Developed scripts for migration and validate the completeness.
• Converted over 200 DTS Packages SQL 2000 into SSIS Packages SQL 2005 .
• Responsible for creating Cluster/Non-Cluster Index, Stored Procedures, Unique/Check Constraints, Views, and Triggers, Rules.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Performed database performance monitoring and tuning using System Monitor, Event Log Viewer, SQL Profiler, SQL Query Analyzer, Stored procedures etc. Monitored and resolved Deadlock, blocking.

• Worked closely with development team and testing team to the gather required information at the time of upgrade.
• Monitored SQL Server's relational engine and Windows using Spotlight.
• Resolved deadlock issues, long-running queries and blocking locks and using Spotlight.
• Migrated data from MS Access, DB2 data source to SQL Server Data warehouse with ETL solutions using SSIS packages.
• Identified various data sources and established the connections using SSIS and constructed data source view based on the required reports.
• Created an Integration Services package to extract data from a flat file using MS SQL Server Integration Services SSIS .
• Analyzed hardware requirements and gave suggestions on RAID level configuration for data files and log files.
• Configured and Monitored Database Mirroring for one of the Business Development Scenario.
• Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers with Updatable Subscriptions.
• Configured securities and access to product databases in SQL Server 2005, SQL Server 2000.
• Optimized existing queries to minimize locking in the database Server, remove negative search arguments and creating appropriate indexes.
• Create new databases, tables, and fields for data entry, performing database capacity planning.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• Generated the daily, weekly, and monthly report.
• Environment: SQL Server 2005,SQL Server 2000, Spotlight, DTS, SSIS, SQL Profiler, SSMS, Windows Server 2003,MS Access 2003, SQL Query Analyzer, Lite Speed Backup, VB.

Confidential

Role: Jr. SQL Server Database Administrator.

Responsibilities:

• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Responsible for Performance and tuning of SQL servers and application issues related to migration.
• 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 SQL queries to check the databases.
• Involved in designing use cases and test cases.
• Involved in test case review and test case execution.
• Involved in defect tracking and functionality testing
• Responsible for routine Backups and Restoration.
• Administration and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures.
• Responsible for drafting documentation for end user usage and develop training material.
• Actively involved in trouble shooting, customization before and after upgrade in various projects.
• Tuned Performance of database and stored procedures
• Implementing and maintaining database security policies
• Implemented Mirroring, Log shipping and replication in SQL server 2005.
• Troubleshooting SQL server 2005 replication and clustering issues.
• Worked with T- SQL for implementing stored procedures, triggers, Cursors etc.
• Running DBCC consistency checks, fixing data corruption on application databases.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Developed Web forms for the application using ASP.NET 2.0
• Maintaining QA and Production SQL Servers.
• Creating and maintaining SSIS packages.
• Setup SQL Jobs, Operators, Alerts and Mail Profile
• Working with Third Party tools like Red Gate, Quest tools
• Developed various business reports using Reporting Services
• Environment: MS SQL Server 2000/2005,T-SQL,SSIS,SSRS,ReportBuilder SQL Profiler, Replication, Logshipping, Mirroring, Clustering ,Windows XP/2000 and Windows 2003/2005 Server.