SUMMARY

• 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.
• Very good experience with SQL servers working in VM environment.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Worked on SQL AZURE database
• Strong experience in mentoring team members and writing documentation.
• Hands on experience with Always On.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012

Operating Systems: Windows 2000 Advanced Server/Professional Windows server 2003/2008/2008 R2/2012

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

Data modeling Tools: Erwin, Red gate, Lite Speed, Idera.

Programming Languages: C, C++, SQL, TSQL.

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R 2/2008/2005/2000 databases in Production, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Experience working on always on environment.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Maintained Production and Test Database Environment in SQL server 2012/2008R 2/2008/2005. Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: MS SQL Server 2005/2008/2008 R2/2012, Windows 2008 server NT, IIS Server 6.0, SSIS, Reporting Services.

Confidential, Foster city, CA

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• 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.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services. monitored and managed DB2 threads and locking issues.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Managing the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential, Maine

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential

SQL server developer/DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports.
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Involved in planning, designing, configuring and implementing SAN fabric.
• Worked on monitoring and tuning of SQL scripts using UNIX. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/dbRoles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Unix, Perl, Business Objects, T -SQL, ERWIN Data Modeler, SAN, DTS, SSAS, SSRS, SSIS, Crystal Reports

Confidential

SQL Server developer

Responsibilities:

• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• I migrated many DTS packages to SSIS packages.
• I Used many transformations like Data Conversion, Derived Column, Conditional split, Multicast, Sort, Merge, Union All, Fuzzy Lookup, Fuzzy Grouping and also used For loop, For each Loop, Sequence container and Execute SQL task etc.. I have hands on experience with BIDS.
• I have good experience in SSRS reporting and also generated different kinds of reports like Tabular Reports, Matrix Reports, Parameterized Reports, Ad-hoc Reports, Drill down Reports, Drill through Reports, Sub reports, List & Chart reports as well as interactive reports according to business requirements in time restricted environment.
• I created and executed the stored procedures and complex queries for reports.

Environment: SQL Server 2000 Enterprise Edition/ SQL Server 2005,.Net, VB, Crystal reports, T-SQL & Windows 2K platform.