Summary

• 5 years of experience as SQL Server DBA
• 4 years of experience working with SSIS, SSRS
• Experienced with SSRS,T-SQL, creating store procedure, trigger, functions
• Experienced in Installation, Migration, Upgrading SQL Server 2012/2008r2/2005
• Experienced in creating users account, security setting and setting of jobs
• Experienced in implementing Disaster Recovery and High Availability concepts using Native tools like Clustering, Log Shipping, Mirroring and Replication Snap Shot and Transactional

• Database: Server 2012/2008r2/2005/2000
• Operating System: Windows Server 2008/2003/2000
• Languages: SQL, T-SQL
• ETL Tools: SSIS/DTS, BCP
• Reporting Tool: SSRS SQL Server Reporting Services

Confidential

SQL DBA/SSIS

Responsibilities:

• Migrating large data from different location and load it in data warehouse using SSIS package.
• Identify and resolve database performance issues using profiler and DMV, DMFs options.
• Created store procedures and database maintenance plan.
• Data base backup and recovery and checking the proper functionality of the scheduled jobs.
• Usage of high availability for disaster recovery.

Confidential

SQL DBA / SSIS Developer

Queen Associates provides technology and business consulting services. The company provides technology consultation, implementation as well as business consulting services for businesses and organizations.

Responsibilities:

• Securing and Administering the SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting privileges to users and group account.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Worked as a team to maintain 100 percent up time to keep the environment running irrespective of any infrastructural changes in the environment.
• Performed backup and restore the data base manually as well as setting the jobs and Maintenance Plans.
• TSQL developer including creating of stored procedures, views, and triggers
• Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery. Used the DMVS, DMFS, SP Procs, Triggers and Functions for the instant analysis.
• Monitoring of database size and disk space in Production, Staging Development environments.
• Implement High Availability Solutions using Log shipping with SQL Server 2005 and 2008 R2/2012.
• Responsible for performance monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to Rebuild/Reorg indexes and update statistics.
• Used native tools like Data Base tuning advisor, Profiler, Performance Monitor and Activity Monitor, DBCC, DMV and DMF for performance tuning.
• Experienced in Extracting different data from different sources, Transform the data based on business requirement and load the Data to different location from sources Excel, CSV, Oracle, flat file, Text file, Teradata by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Multicast, Row count, Merge join, Lookup, Union all and other tools for analysis purpose using SSIS.
• Designed and developed SSIS packages using different tasks including control flow tasks, Transformations and dataflow tasks.
• Implementing ETL packages using SSIS 2012/2008/2005 services for integrating data from different sources using multiple transformations available in SSIS toolbox.

Confidential

SQL Database Administrator

The International Livestock Research Institute ILRI works to improve food security and reduce poverty in developing countries through research for better and more sustainable use of livestock

Responsibilities:

• Creating and securing user logins with appropriate roles.
• Created databases and specified automatic growth options.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing Disaster Recovery and High Availability concepts like Native Log Clustering, Log Shipping, Mirroring and Replication Snap Shot and Transactional
• Used native tools Database Tuning Advisor, Profiler and Activity Monitor.
• Experienced with Point-in-Time Recovery and Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Developed stored procedures, functions, triggers in T-SQL and batch scripts.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Involved in day-today database maintenance operations. Maintaining the backup-restore jobs.
• Created objects such as user-defined functions, tables, databases, indexes clustered and non-clustered , stored procedures, views, and triggers
• Scheduled agent jobs for database backup and windows task to clean up the file system. Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Used the DMV and DMF for the performance data collection and monitoring.
• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Used BULK INSERT to import the data from flat files using SSIS packages.
• Database Migrated development, testing and production environment From SQL server 2008 R2 into different locations Excel, Text file using SSIS packages.
• Report Development Administration using Reporting Services SSRS 2005 and 2008 R2. Generated Report using SSRS SQL Server Reporting Services
• Responsible for keeping system and databases up-to-date making necessary changes.

Confidential

SQL DBA/ SSRS, SSIS, SSAS Developer

• Flora Holland is an international co-operative organization which is established for growers of horticultural products. It operates as a matchmaker, intermediary, and knowledge center of horticultural business.
• Responsibilities: 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 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
• Create SSIS Packages to Extract, Transform and Load data into database.
• Export Import data from/to databases like Excel Pivot table , Access to/from SQL Server
• Use SSAS and SSRS to provide reports for business users for financial decision making.
• Launching the report builder for ad-hoc reports. Configuring the report viewing security.
• Responsible for deploying reports using Report Builder and Troubleshooting for any error occurring during execution
• Load data from flat files excel sheets, access database, and pad file into the target SQL Server 2005, 2008 database using SSIS packages.
• Experience use of T-SQL in stored procedures and SSIS packages.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Scheduled the Reports to run on weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Database Migrated development, testing and production environment From SQL server 2005 into different locations Excel, Text file.