SUMMARY

• Over 8 years of experience in MS SQL Server 2014/ 2012/2008 R2/2008/2005 database administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Experience with Database compression thereby reducing the database size to 80%
• Proficient with SQL Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools, Query Analyzer, SQL Server Agent, SQL Profiler, SQL Sentry for performance monitoring.
• Supporting production environment in 24/7 by acting as an on-call in rotational basis, also worked collaboratively with off-shore team to support the environment.
• Experience in Tuning SQL queries & improving the performance of the Database and performed database Consistency Checks Using DBCC Utilities
• Hands on experience about SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Troubleshooting ETL issues in SQL Server Integration Services.
• Experience in implementing and managing transactional, merge and snapshot Replication models
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Maintain database objects including tables, view, Stored procedures, functions based on the customer requirements
• Experience in Extracting, Transforming and loading of data from sources like Excel, XML, Text File, Flat file, Oracle into MS SQL Server using SQL Server Integration Services (SSIS).
• Strong experience with ETL tools components like Mapping, Transformations, Expressions, look-ups and Aggregations.
• Experience in creating deployment scripts and deploying the SSIS Packages/SSAS Cubes to Development Server and Production Server
• Set up SQL Server Databases in a lab environment and duplicate the functionality of the SQL Server in Development, Test/Acceptance and Production environment.
• Experience in regular maintenance activities like index rebuild, query tuning, statistics update, log file monitoring, temp DB monitoring, deadlock resolutions, and blocking contention issues.
• Worked closely with developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Good knowledge in preparing and updating disaster recovery documentation and Implemented and documented proactive monitoring scripts for production and non-production databases.
• Possess excellent communication skills, analytical, problem-solving skills and experience of working with multinational and cross-cultural teams.

TECHNICAL SKILLS

Databases: MS Access, SQL server 2005, 2008, 2008 R2, 2012 and 2014

Database Tools: SQL Server Management Studio, Business Intelligence Studio, Enterprise Manager, Profiler, Query Analyzer, DTS, Import & Export, Replication, Log- Shipping, SSIS, SSRS, SSAS, Mirroring

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012

Backup Tools: SQL Native, Litespeed, SQL Safe, Net backup tool

Ticketing Tools: BMC Remedy, CASD and Synergy Tool

Operating Systems: Windows NT, 2003, 2008 R2, 2012, 2012 R2

Language: T- SQL, SQL, PL-SQL & SQL

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. SQL Server DBA

Responsibilities:

• Managed and administrated the SQL Server 2014/2012/2008 R2/2008 production and Non-production servers.
• Administered and maintained production/Development servers with more than 1 TB of database size with complex structures.
• Created jobs to monitor SQL Server Blockings. This job gives detail information on the Performance of the server.
• Installed couple of SQL Server 2012/2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2008R2 to SQL server 2012
• Involved in Troubleshooting ETL issues in SQL Server Integration Services
• Performed daily loads in SAP without touching other parts of the database by using table partitions
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Created SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of user.
• Configured SQL Litespeed and native Database Backups in DEV/QA/Analysis and Production environments along with Litespeed/Net Backup setup.
• Involved in Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Involved in Exporting and Importing data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: SQL Server 2000, SQL server 2005, SQL server 2008, SQL server 2008 R2, SQL Server 2012, SQL Server 2014, SSIS, SSRS,SSAS & Windows 2003, 2008 R2, 2012& 2012 R2, Oracle 10g/11g.

Confidential, Reading, PA

Sr. SQL Server DBA\Developer

Responsibilities:

• Involved in the process of Upgradation/Migration SQL Server by upgrading database engine and transferring metadata to new server using side-by-side up gradation.
• Maintained database objects including tables, view, Stored procedures, functions based on the customer requirements
• Performed daily tasks including backup and restore by using SQL Server Management Studio.
• Used to work on Checking of Backup logs, Event logs, Sql server logs, Agent logs and Job history.
• Monitored SQL server performance using profiler to find performance and Deadlocks.
• Involved in Recovering the databases from Backup in Disasters, and also having Good knowledge on rebuilding master database.
• Troubleshooted transaction logs and tempdb when full.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Designed and developed SSIS Packages to loop through different sources like Text files, MS Access, MS Excel files, cleanse the data, Created new calculation as per requirement and then loaded into SQL Server.
• Developed SSIS packages in both Project deployment model and package deployment model.
• Exported data to flat files on timely basis.
• Involved in finding out Poorly Performing Queries by tracing server activity and get recommendations through Database Tuning Advisor to perform necessary actions.
• Maintained the Database Consistency with DBCC commands at regular intervals.
• Replicated the data between various servers.
• Made data available to all the resources using the Log shipping.

Environment: SQL server 2005, SSIS, SSRS,SSAS & Windows 2003, 2008 R2, 2012& 2012 R2, Oracle 10g

Confidential, Columbus, OH

SQL Server DBA\ Developer

Responsibilities:

• Installed and maintained SQL Server database systems. Maintaining of databases includes like successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
• Supported various application database issues like blockings, log file issues, data file issues, connection issues, performance issues etc.
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Migrated application code and objects from development/test environments to production.
• Worked with development and systems teams to perform application and database tuning.
• Maintained database objects including tables, view, stored procedures, functions based on the customer requirements solution.
• Administered SQL Server database backup & recovery methods, database tuning using Oracle Enterprise Manager, data transport techniques, and troubleshooting all manner of database issues.
• Worked with SQL Server Configuration Manager to configure SQL Server services and configure network connectivity.
• Checked Database Health by using DBCC Commands and DMVs
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
• Involved developing and implementing jobs for SQL server, and involved in various production releases for all the groups
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Performed Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: SQL Server 2000, SQL server 2005, SQL Server 2008, Oracle& Windows 2003

Confidential, Westlake Village, CA

SQL Server DBA

Responsibilities:

• Was responsible for SQL Server database administration
• Managed development, validation, and production of MS SQL Server 2005 and 2008 database servers
• Managed database backups and ensured that Disaster Recovery and Data Retention protocols adhered to corporate policies
• Managed security at all levels of MS SQL Server, implements and maintained high availability features of MS SQL Server
• Managed and maintained shared MS SQL Server database instances
• Conducted production database performance monitoring and capacity planning
• Architected MS SQL server solutions and technology upgrades
• Provided technical expertise related to ongoing maintenance and support of MS SQL Server
• Monitored and optimized data storage for database systems and works with development teams on data sizing
• Resolved Windows platform issues related to SQL Server; and utilized SQL Server Integration Services
• Used Stored procedures, DBCC and System Stored procedures, T-SQL, Triggers and other database objects
• Created and maintained MS SQL Clustering, replication and log shipping
• Was responsible for performance tuning, backup/recovery, query optimization, security and disaster recovery
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Worked on multiple products and platforms and converted Access databases to SQL Server databases

Environment: MS SQL server 2000, SQL server 2005, Windows 2003

Confidential

SQL Server Database Administrator

Responsibilities:

• Involved in installation and configuration of SQL Server 2000 on Window 2003.
• Maintained the Production and Test Database Environment.
• Created Security, Roles and Permissions to users.
• SQL Server optimization, DBCCs, debugging scripts and automating DBA tasks.
• Managed the Data Migration from SQL Server 2000 to SQL Server 2005.
• Analyzed data requirements and participated in design reviews.
• Mentored in knowledge sharing on database activities.
• Documented business rules and logic.
• Automated administrative tasks knowledge transfer of database.
• Involved in creating cubes using Analysis Manager.
• Migrated all the test environment objects into Production database and maintained high availability of the database.
• Involved in Performance Tuning and Query Optimization.
• Monitored the event logs and server error logs for troubleshooting.
• Identified the bottlenecks and troubleshooting them for optimal performance.

Environment: SQL Server 2000, SQL server 2005, Windows 2003