SUMMARY

• Total experience of 9+ years in the IT industry.
• 7 Years of relevant experience as a MS - SQL Server Database Administrator.
• Experienced in SQL Server database administration & Configuration.
• Hands on Experience in installing, configuring, managing and troubleshooting SQL Server, 2008, 2008R2,2012 and SQL Server 2016.
• Experienced in providing Production support for Database and Applications.
• Outstanding knowledge of high availability/DR SQL Server solutions, including Log shipping, Mirroring and Replication.
• Performing Back-ups, Restores, Scheduling and Maintenance planning.
• Having Good knowledge on clustering.
• Assigning SQL server roles and granting permissions to the users.
• Knowledge to manage Logins across the servers.
• Having Experience in DataCenter Migration.
• Experience in Migrating Database from Legacy environments like, SQL Server 7, SQL 2000 & SQL Server 2005 to higher versions like 2008 and 2012.
• Administration storage management (Eextent, Pages & Data file).
• Experienced in Performance Tuning of SQL Server Databases Using Explain Plan, AWR.
• Work with the application development teams in fine tuning of Queries.
• Strong RDBMS concepts and experience in creating, maintaining stored procedures
• Good experience in creating SQL server data objects like tables, Views, Procedures and functions.
• Experience in writing and tuning SQL and PL/SQL stored procedures.
• Experience in requirement analysis, coding and testing various modules of SDLC.
• Involved in all phases of the project (Documentation, Designing, unit testing and defect fixing)
• Monitoring and resolving Blocking/deadlock issues.
• Developing successful Backup strategies based on recovery model.
• Strong Windows skills, Experience with SS Management Studio, Light Speed andSCOM
• Experience with data management and data processing flowcharting techniques.
• Systemanalysis,design,developmentimplementationandReverseEngineering&optimization.
• Experience in supporting Production Servers and Applications 24x7.
• Exhibits strong teamwork and individual drive - highly motivated, articulate and eager to learn.
• Experience in Development of User Interfaces and User Enhancements, including Analysis, Design and Development of Web based E-commerce, B2B, Client-Server, Migration, integration and Distributed Applications.
• Experience in designing or creating entity relationship diagrams and implementing database objects based on an ERD.
• Work with system administrators and use data dictionary software packages to ensure data integrity and security.
• Experience with Active directory and SQLSecurityAdministration.
• Experiences in design, development, coding and testing of ETL and DW technologies like SQL Server, SSIS/SSRS, and Teradata
• Having knowledge in Importing SSIS packages and deploying the packages in to prod environments.
• Extensive knowledge of creating SSIS Packages for data extraction, transformation, and loading (ETL) solutions for data warehousing.
• Having Knowledge on SSRS design.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.Knowledge in T-SQL & Powershell Programming.
• Good Communication and Interpersonal skills.
• SQL Server 2012 certified and ITIL V3 foundation process certified.

TECHNICAL SKILLS

Database: MS SQL SERVER / / 2014 & 2016.

Database Tools: SQL Server Management Studio, SQL Profiler & DTA.

Operating System: Windows server 2003/2008/2012 and XP.

Ticketing Tools: Advent Net Manage Engine, CA-SPSD, Remedy, HPSM, SNOW & Jira.

Monitoring Tools: Tivoli, HPOV.

Languages: .Net 2.0 (C# With ASP.Net)

Web Servers: IIS, Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Lowell - AR

Sr. SQL Server DBA

Responsibilities:

• Performing ETL process (SSIS packages auditing).
• Creating SSIS packages using proper control and data flow elements improving the performance of the package run time and unit test the developed packages as an ETL developer.
• Work on ETL process using Microsoft SQL Server Integration Services (SSIS) process to provide the data quality, data cleansing, business rule transformations, and data loading, support the data loads and transformations using SSIS for the iterative conversion project.
• Involved in migration from SQL Server 2008R2 to Oracle databases using SSIS on CSS Conversion Project.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Data migration from WWR legacy to the CSS Impact to support the day-to-day operation of WWR's business model.
• Develop complex Stored Procedures, Tables and useful Functions, temporary tables, Views, in SQL Server as per the requirement.
• Upgraded or migrated SSIS packages from older 2005 version to 2013 version in Microsoft Visual Studio in Migration Project.
• Developing the Data Flow in SSIS with all the required sources (Stored procedures, tables, Excel sheets etc.), transformation, and suitable destinations as required as per the document.
• Migration involved migrating scripts developed with PowerShell alsoDeveloped packages using variables, expressions, functions, stored procedures, parameters and also defining queries, writing complex queries in SQL involving tables, Open queries, Joins.
• Deployed packages, scripts, tables, stored procedures from lower to higher environments in SQL servers.
• Worked with all almost all the transformations and control flow components in SSIS like SCD, Pivots, FTP, Lookups, OLE DB sources, OLE DB Command, ODBC sources, Script Task (using VB Script), For each Loop Containers, Sequence containers etc., along with few other users designed transformations Regular Expressions.
• Worked on creating Fact, Dimensions Tables with required transformations, Stored procedure sources and moving to different locations using FTP task.
• Created SSIS package using Script Component using C# and VB.NET.
• Involved in designing, developing, debugging and testing of SSIS packages.
• Worked on creating and executing complex T-Sql queries using SQL Server Management studio for back end data validation testing.
• Worked on PL-SQL queries to check and validate data if all the requirements have met.
• Worked on child and parent packages.
• Performed software reverse engineering to disassemble and debug unknown code.
• Create PowerPivot models and PowerPivot reports, stored them onto SharePoint, and deploy models into SQL Server SSAS instance.
• Followed business enhancements for migration during the project with Project
• Developed Packages to Load data fromMSSQL server to Oracle Destinations and in the flow created new SSIS packages according to the requirement for the fields.
• Troubleshooting the issues on the SSIS packages.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server
• Experience with SSRS design.
• To analyze long running slow queries and tune the same to optimize application and system Performance
• Involved in SQL Server Technologies like Log Shipping, Replication.
• Worked on disk space alerts, Job failure alerts.
• Daily Log checking for errors on Production Server.
• Rebuilding the indexes at regular intervals for better performance.
• Work closely with other team in other region to deliver the service.
• Monitoring SQL server performance using profiler to find performance and deadlocks.

Confidential, Charlotte - NC.

Sr. SQL Server DBA.

Responsibilities:

• Installation, configuration and maintenance of MS SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Monitoring the Scheduled jobs.
• Performing BCP in and BCP out on different environments.
• Strong RDBMS concepts and experience in creating, maintaining stored procedures
• Good experience in creating SQL server data objects like tables, Views, Procedures, functions and triggers.
• Experience in writing and tuning SQL and PL/SQL stored procedures.
• Involved in all phases of the project (Documentation, Designing, unit testing and defect fixing)
• Performing Database refresh between Production, Test and Dev Environments.
• Implementation of Database maintenance plan
• Good experience in resolving blockings and Deadlock Issues by using SQL commands.
• Managing Security (Creating users, logins and roles, granting permissions).
• Performing ETL process (SSIS packages auditing).
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server
• Experience with SSRS design.
• To analyze long running slow queries and tune the same to optimize application and system Performance
• Involved in SQL Server Technologies like Log Shipping, Replication.
• Worked on disk space alerts, Job failure alerts.
• Daily Log checking for errors on Production Server.
• Rebuilding the indexes at regular intervals for better performance.
• Dealing with performance issues on production servers.
• Moving objects from QA to Production databases.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. (Reindexing, Backup and Restoration)
• Work closely with other team in other region to deliver the service.
• Monitoring SQL server performance using profiler to find performance and deadlocks.

Confidential, Houston - TX.

Sr. SQL Server DBA.

Responsibilities:

• Administering SQL Server Production Database.
• SQL Server 2012 & 2014 Installations, configuration and SQL cluster Installation.
• Experience as a MSSQL Administrator on large scale software development project.
• Involved in Datacenter Migration, one of the biggest datacenter in the world (WWT), with 1278 SQL Servers across the globe.
• Having hands on knowledge in migrating Database from SQL Server 7, SQL Server 2000 and SQL 2005 databases to SQL 2005,SQL 2008 etc.,
• Responsible for helping design, model, and architecture of Data Warehousing, Data Governance, and Business Intelligence solutions for the client.
• Involved in the compliance project, where my role was to applying latest Service Packs to all the servers under baker environment and make it compliant to baker Standard.
• Involved in day-to-day operations:
• Backup and Restoration of System and User databases.
• Experience in Deploying and troubleshooting SSIS packages.
• Creating Dashboard Reports to support end users using SSAS.Knowledge in T-SQL & Powershell Programming.
• Monitoring SQL Server Jobs and Troubleshooting on failure.
• Troubleshooting SQL Server production issues.
• Monitoring database growth, managing Databases, data files, log files.
• Performance Tuning of SQL Server Databases.
• Managing SQL Server security and logins.
• Experience with Active directory adding individual User ID’s to Active directory groups.
• Performed ETL to support data loads and transformations using DTS Packages and SSIS.
• Dealing with performance issues on production servers.
• To analyze long running and slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. (Reindexing, Backup and Restoration)
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Systemanalysis,design,developmentimplementationandReverseEngineeringandoptimization.
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping etc.,
• Database & application tuning and performance monitoring.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24/7 supports when required.

Confidential, Irvine - CA

Sr. SQL Server DBA

Responsibilities:

• Administering SQL Server Production Database.
• SQL Server 2012 Installations, configuration and SQL cluster Installation.
• Experience as a MSSQL Administrator on large scale software development project.
• Maintaining the servers - applying latest Service Packs with cumulative updates.
• Migration of databases from SQL Server 2000, 2005 to SQL Server 2008 server.
• Backup and Restoration of System and User databases.
• Administration storage management( Eextent,Pages & Data file)
• Migrated SQL Server 2005 databases to SQL Server 2008R2 databases including DTS to SSIS packages.
• Loaded the data into another data sources like SQL Server using SSIS.
• Experience in Deploying and troubleshooting SSIS packages.
• Experience with SQL Server reporting services (SSRS), generating Adhoc reports based on the client requirement.
• Deployment utilizing Parallel Data Warehouse (PDW) which has a massively parallel processing (MPP) architecture for big data processing.
• Substantial knowledge throughout Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2012/2008R2/2008.
• Monitoring SQL Server Jobs and Troubleshooting on failure.
• Troubleshooting SQL Server production issues.
• Monitoring database growth, managing Databases, data files, log files.
• Performance Tuning of SQL Server Databases Using Explain Plan, AWR.
• Managing SQL Server security and logins.
• Experience with Active directory adding individual User ID’s to Active directory groups.
• Rebuilding the indexes at regular intervals for better performance.
• Dealing with performance issues on production servers.
• Moving objects from QA to Production databases.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. (Reindexing, Backup and Restoration)
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Systemanalysis,design,developmentimplementationandReverseEngineeringandoptimization.
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping etc.,
• Database & application tuning and performance monitoring.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24/7 supports when required.

Confidential, NY

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server.
• Applying latest Service packs and cumulative updates.
• Creating automated reports as per customer requirements.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Creating linked servers and SQL Server network aliases.
• Configuring TCP ports as per application requirements.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Work with the application development teams for fine tuning of queries.
• Migration of databases from one Server to Other Server.
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping etc.
• Analyze data requirements, application and processing architectures, data dictionaries, and database schemas.
• Monitoring the Disk spaces on all the servers.
• Creating SQL Users and providing required permissions.
• Creating maintenance jobs on the production Servers.
• Analyzing, Identifying and Resolving performance issues of the server.

Confidential

SQL Server DBA

Responsibilities:

• Setting up new SQL Servers 2005 and configuring the required users.
• Configured Log Shipping, Database mirroring and troubleshoot issues by continuous
• Monitoring Transaction Log Update’s.
• Administered SQL Server by Creating User Logins with appropriate roles and permissions and monitoring the user accounts, creation of groups, granting the privileges to
• Users and groups. SQL Authentication etc.,
• Experience in writing and tuning SQL and PL/SQL stored procedures.
• Experienced in debugging the stored procedures, and modifying them as per the business needs.
• Worked heavily with relationship database model, schemas and entity relationship diagrams.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary;
• Creating backup strategies and scheduling them for execution.
• Resolving various performance issues and running DBCC, DMV commands.
• Indexing, Import/export data, backup restore database, managing servers.