PROFESSIONAL SUMMARY:

Microsoft Certified SQL Server DBA with 5 years of Database Developer and IT experience with an In-depth understanding of SQL Server administration, design, development and implementation of different environments Production, Test and Development using SQL Server 2012,2008/R2 and 2005 on Operating Systems Windows Server 2003/8/R2, Windows Vista, Windows 7/8 and VMware as well. High level of energy, integrity and work ethics with an exceptional ability to deliver outstanding bottom line results which improves productivity, automating and maintaining applications and database operations

Work History:

Confidential

SQL Server Database Developer

• Transformed data from various data sources using OLEDB connection by creating SSIS packages and schedule them as per requirement.
• Monitor performance of SQL server 2005/2008/R2 and SQL server 2012 databases
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Updated the technical requirements documents as per given requirement and created data mapping document for data transformation.
• Migrated the entire database objects from one Server to another Server
• Created and managed database objects, store procedures, triggers, views and functions
• Created and monitored automated scheduling Jobs and Alerting using SQL Server Agent
• Maintained stored procedures, triggers, views and indexes using T-SQL
• Scheduled jobs for backups and set notifications for job failures and disk issues
• Created reports SSRS using Cascading parameters and Drill-Through Reports, Sub reports, Parameterized Reports, Report Models and ad hoc reports.
• Extensively use in ETL tools for data extraction, cleansing, integration and loading from different data sources using SQL Server Integration Services SSIS .
• Experienced in creating disk backup, tail log backup, file and file group backup for various purposes
• Followed proper backup retention policy, keep copy of databases backup in remote location in case of disaster
• Implemented Database Maintenance Plan for Database Integrity checks, Reorganize and Rebuild Index and update statistics
• Configured and administered SQL Server security by creating and monitoring User and Group Logins with appropriate roles

Confidential

SQL Server Database Developer

• Managed users, roles, and profiles Objects in Active Directory
• Created SSIS package to export and import data from SQL Server to Access, text and EXCEL files.
• Used various SSIS tasks such as conditional split, derived column on the data retrieved, performed data validation checks during staging, and then loaded the data into the data warehouse.
• Imported and Exported data from Excel, SQL server and text files
• Created new SQL Server Instance, Installation configuration, Managing server and security, move or copy database to multiple location
• Created reports to retrieve data using stored procedures that accept parameters depending upon the client requirements.
• Created reports to retrieve data using stored procedures that accept parameters depending upon the client requirements.
• Experience in Maintaining server level and database level security best practices by creating users, configuring permissions and assigning different roles to users
• Created, maintained, updated and troubleshooting of SSIS packages
• Administrated, updated, troubleshooting and development of SSRS
• Created Database Backup scheduling jobs for production and development environment
• Assisted SQL developers to optimize SQL queries and Stored Procedures
• Managed database elements, including creation, alter, delete and copy of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints
• Transformed data from different data sources like Oracle, Flat files, and SQL databases to SQL Server using OLEDB connection providers by creating various SSIS packages.

Confidential

SQL Server Database Administrator/Developer

• Worked with Database team to maintain data integrity, performance, and administration of all SQL Servers and their associated databases
• Used ETL Transformations to copy columns and load data from data sources Oracle, DB2, Flat files to destination databases.
• Created logins and Maintained user permissions appropriately
• Active Directory to reset passwords account group memberships and permissions settings
• Used DBCC to Check the physical consistence of the database Health
• Created and modified tables, Indexes Cluster/Non-Cluster , Constraints Unique/Check , Views for the users according to their roles
• Imported data from multiple sources files to SQL Server Database
• Backing up entire users database and scheduling backup process
• Good understanding in performance tuning, Backup and Recovery Process and tools.
• Helped the front-end application developers with their queries
• Designed InfoPath form and customized pages and list/libraries using SharePoint Designer
• Created various OOTB web parts including Content Query Web parts, List View Web part and Custom Web parts
• Customized out of the box SharePoint sites and List Permissions for various Business needs

Environment

Microsoft SQL Server 2012/2008-R2/2005, Windows server 2008/2003, Transact-SQL, SQL Profiler, Performance Monitor, SSIS, SSRS, SharePoint 2010,Visual Studio, SharePoint Designer 2010, InfoPath 2010, MS Access, Microsoft Excel, MS Visio, SAN, VMware