SUMMARY

• Around 9 years of experience as MS SQL Database Administrator and SSIS Developer. Responsibilities include Database design, development, SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports.
• Excellent experience working on different versions of SQL server like 2000, 2005, 2008, 2008R2 and 2012.
• Expert in the areas of MS SQL Server installation, Configuration, Server upgrade, Performance tuning, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.
• Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance. Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.
• Involved in Installing and configuring AWS.
• Involved in AWS Migration.
• Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement.
• Maintain Data reliability to proactively avoid Data corruption and unexpected performance issues by implementing Maintenance plans and performing Database Consistency Checks that ensures data integrity and consistency.
• Understand and implement organizational standards across all servers in all environments and follow processes in performing day to day administrative tasks. Have monitoring jobs in place that helps audit the activities on the servers and databases.
• Ability to Build and maintain complex SQL queries for data extract. Strong experience working with stored procedures, database tuning methodologies, extraction, transformation and query methodologies.
• Used multiple transformations in SQL Server Integration Services to meet the business requirements by collecting data from various sources.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Verifying the status of Disk spaces of the servers and Log spaces of Databases and taking appropriate action if required.
• Proficient using DMVs, Wait - States & Performance Monitor Counters to quickly find the Root Cause of performance slow-downs.
• Improving query optimization performance using profiler, execution plan, Database Tuning Advisor.
• Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. Maintain the records of the same and follow up.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2008 R2/2012, AWS

Tools: SQL Server Management Studio, Business Intelligence Development Studio, Query Editor, Configuration Manager, SAC, IBM Tivoli, PROFILER, SQLCMD, PERFMON, Confidential Service Now, Tracker, GAM Tracker, Remedy, DBSpy, USD

Reporting: Microsoft SQL Server Reporting Services

ETL Tools: Microsoft Data Transformation services, SQL Server Integration Services

Programming Skills: T-SQL, Java, C, HTML, Java Script

Operating Systems: Win 2000/ 2003/ 2008/ 2008 R2/ 2012

Scheduling Tool: Windows scheduler, SQL Server Agent

PROFESSIONAL EXPERIENCE

Confidential, GA

Senior DBA/SSIS Developer

Responsibilities:

• Provide SQL Server database Administration and monitoring support across production, development and staging environments
• Install and configure SQL server 2012. Analyze results of upgrade advisor and perform database upgrades from /2012
• Perform cleansing of data loaded from legacy systems using data conversion scripts and produce clean formatted data which can be loaded into production system
• Proficient using DMVs, Wait-States & Performance Monitor Counters to quickly find the Root Cause of performance slow-downs
• Installed and configured clustering i.e. active/active and active/passive
• Automation of frequent refresh requests are taken care of by creating SQL jobs that copy the backup from production, backup roles and users from development database, perform refresh and reapply the roles and users on to development
• Manage disk space on SQL servers by shrinking data and log files. Determine and forecast the growth of the databases and increase disk space as required
• Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis
• Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution
• Ensure daily and weekly Database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Maintaining the Security of the Database, assigning responsibilities as part of Security
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc
• Deploy SSIS packages on to production server and configure configuration files
• Ensure standard backup policies are implemented across all servers depending upon the application criticality. Make sure we have backup cleanup tasks are in place
• Plan, test and apply SQL patches on SQL servers to make sure we are up to date
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Involved in Installing and configuring Amazon RDS and EC2
• Involved in AWS Migration
• Experience in creating Tabled Reports, Matrix Reports using SQL Server Reporting Services 2008
• Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS)
• Understand changes required and attend Change Control Board meetings to explain the changes to happen on the DB and justify the changes required
• Gather service account information and document the same for all locations

Environment: Windows Server 2000, Windows Server 2003, Windows Server 2008, Windows Server 2012, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, AWS, Confidential Service Now, MS Outlook, MS Word, MS Excel, MS PowerPoint

Confidential, OH

Senior DBA/SSIS Developer

Responsibilities:

• Provide Production, Staging and Integration SQL Server database Administration support with databases as large as 700 GB
• Installed and configured two node clustering i.e. active/active and active/passive
• Extract data from external systems, transform data and load them into the existing databases using SSIS packages
• Implement backup plans, monitor and maintain Backup and Recovery on servers
• Perform daily, weekly and monthly Database Maintenance tasks
• Database design and optimization of databases for better performance
• Managing SQL Server security by creating roles and security groups
• Monitor and resolve blocking issues in coordination with application team
• Proactively check the SQL Error log and take appropriate action to avoid downtime
• Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance
• Configuring and maintaining Disaster recovery techniques such as mirroring, log shipping and clusters
• Monitoring SQL Server performance by finding deadlocks and blocking
• Import/Export data as per user request using import export wizard
• Deploying/Migrating DTS and SSIS packages. Help troubleshoot issues with packages
• Perform database refresh and fix orphaned users on the refreshed database
• Support Disaster recovery project planning, testing and implementation
• Worked on Migrating data from SQL server R2 and SQL server 2008R2 to 2012
• Provided secondary DBA support for Oracle databases

Environment: Windows Server 2000, Windows Server 2003, Windows Server 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, Oracle 10g, Remedy ticketing tool, MS Outlook, MS Word, MS Excel, MS PowerPoint

Confidential

Consultant

Responsibilities:

• Maintain SQL Server Production databases and ensure high availability
• Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created
• Manage space on database servers by proactively forecasting the DB growth
• Back databases before change implementation and ensure rollback capability
• Perform ETL operations with the help of SSIS packages for the initial setup of DBs
• Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up
• Create roles and grant permissions to users upon proper approval from business
• Ensure the change process is followed religiously and suggest changes required
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Performing Database maintenance activities like Backups, Restoring etc
• Performing SQL server daily health check and preparing a report
• Verifying the Databases backups are happening and moved secured location.
• Performed daily tasks including Check for Failed Processes, Analyze Errors and Validate disk space
• Used multiple transformations in SQL Server Integration Services to meet the business requirements by collecting data from various sources
• Deploying and Scheduling SSIS Packages
• Provided secondary DBA support for Oracle databases

Environment: Windows Server 2000, Windows Server 2003, Windows Server 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, Oracle 10g, MS Outlook, MS Word, MS Excel, MS PowerPoint, Tracker tool

Confidential

Consultant

Responsibilities:

• Support SQL Server 2000, 2005 SQL Server Administration and Maintenance
• Installation and Configuration of MS SQL Server instances
• Database creation and implementation of code on database servers
• Plan and implement robust Backup and Restore strategies
• Configuring SQL mail, scheduling tasks and managing alerts
• Co-ordinate with onsite DBAs and ensure smooth running of the system
• Worked on security management and linked servers creation
• Provided support for DTS/SSIS package migration and implementation
• Monitoring SQL Server performance using System Monitor and SQL profiler
• Preparation of Knowledge sharing documents on SQL Server
• Automated DB maintenance tasks by developing scripts for providing consolidated reports over mail for daily full and transactional log backups across all production servers. Generic job failure reports of the important application related jobs
• Handle ad-hoc user requests like granting permissions, database refresh from production to development environments and identify slow running queries
• Developed SSIS packages for maintenance plan tasks
• Manage data, transactional log file growth and implement file management policies
• Ensure weekly index rebuild and update statistics jobs run fine on production systems
• Capacity planning for new and existing SQL servers to manage database files
• Prepare knowledge sharing technical documents on SQL server DBA activities

Environment: Windows Server 2000, Windows Server 2003, SQL Server 2000, SQL Server 2005, MS Outlook, MS Word, MS Excel, MS PowerPoint, Crystal Reports, Remedy ticketing tool

Confidential

Software Engineer

Responsibilities:

• Installed, configured, administered and secured SQL Server 2005 on Server and Clients
• Backup and restore databases on different environments
• Performs and monitors daily database operations and set-up backup schedules
• Grant permissions to different teams depending upon their role
• Verifying the status of Disk spaces of the servers and Log spaces of Databases and taking appropriate action if required
• As a part of the DBA team providing 24x7 production support to the clients
• Perform Database Administrative tasks on Development environment
• Create views, indexes, functions, stored procedures and scripts
• Write test cases and test the code on the development environment. The test cases are then signed off by respective teams
• Database and Code Implementation on production environment. Once production implementation is completed provide maintenance and support for the databases
• Backup client databases and perform database restore and run consistency checks from SQL Server and application
• Work with network team to resolve and network issues occurring during business hours
• Reviewing SQL Server and SQL Server Agent Error Logs

Environment: Windows Server 2000, Windows Server 2003, SQL Server 2000, SQL Server 2005, MS Outlook, MS Word, MS Excel, MS PowerPoint, Crystal Reports, Global application management ticket tracking tool