SUMMARY

• 7+ years in - depth experience in managing multiple MSSQLServer servers wif very large OLTP Databases in development, testing/QA and production environments.
• Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
• Experience wifSQLServer Installation, Configuration, Migration, SSIS, SSRS and administration, apply periodic Service packs and hot fixes (cumulative updates) and complimentary third party tools.
• Solid experience and noledge ofSQLServer High Availability solutions - Replication, Clustering, Mirroring, and Log Shipping.
• Experience in Cassandra data modeling along wif managing and scheduling of the data backup and restore operations.
• Design and Implement Database Schema, Import data and build stored procedures on SQL Azure.
• Experience in implementing High availability solutions like Always on, Replication models (Snapshot and Transactional), Log shipping, dynamic management views, clustering and mirroring on physical and virtual machine
• Experience in Creating and Maintaining enterprise databases, Backup & Recovery.
• Expertise in implementation of security models; Database autantication modes, creation of users, configuring permissions and assigning roles to users.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQLand also expert in tuning Complex Queries.
• Expertise in troubleshootingSQLissues by usingSQLTools, execution plans, Trace, statistics, index tuning wizard.
• Experience in Cassandra stress tool for benchmarking Cassandra Cluster.
• Good Knowledge in Cassandra cluster topology and Virtual nodes.
• Experience in installing multi-data center and multi-rack Cassandra cluster.
• Expert in design and development ofSQLServer Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts usingSQLServer Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports usingSQLServer Reporting Services (SSRS) based on client requirement.
• Strong Database Administration experience wif MSSQLServer 2005, 2008, 2008 R2 and 2012, MS Access 2003, 2007, and 2010 including Scripting and Job Automation.
• Experienced in Batch processes, SSIS, DTS, BCP (bulk copy), Bulk Insert, Import, Export, Database Monitoring tools and Application support.
• Experience in using Performance Monitor,SQLProfiler and optimizing the queries, tracing long running queries and deadlocks.
• Strong Technical background wif excellent problem solving and communication skills. Strong time management skills and excellent team player wif reputation of integrity and an ability to work on multiple technologies.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008R2, 2008, 2005

Databases: Microsoft SQL Server 2012, 2008, 2005, 2000

Programming Languages: T-SQL, SQL, PL/SQL, Power Shell, Python,HTML, C/C++, XML

Database / ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), DTS, Query Analyzer, SQL Profiler, TOAD

Reporting Tools: SQL Server Reporting Services (SSRS) and Report Builder

Third Party Tools: SQL Lite speed, IDERA, SCOM, VMware, TSRM, SQL Sentry, ERwin Data Modeler and SQL Compare, ITSM Ticketing System, BMC Remedy Ticketing Tool, Orion, Amazon Web services(AWS).

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

SQL DBA

Responsibilities:

• DBAforSQLServer Environment wif over 100 Production Servers and 120 Development/ Test Servers and more than 7000 Databases.
• Install and configureSQLServer 2008R2/2012. Troubleshooting Performance issues and database issues.
• SQLServer 2014 installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
• Virtualization of SQL Servers from P2V (Physical to Virtual) Environment.
• Migrating Databases fromSQLServer 2005/2008 toSQLServer 2012/2014.
• Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively usedSQLnative tools like Index tuning wizard, Database tuning advisor (DTA),SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting.
• Daily routineDBAtasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Install and configure latest Service Packs/Hot Fixes onSQL2008R2, 2012 and 2014 servers.
• Create documentation for steps that need to be taken while upgrading theSQLserver 2008/2012 to SQLserver 2014.
• Data backup/ recovery rollback planning and implementation.
• User's access to database objects was restricted by configuring security features like Autantication and Authorization.
• Worked wif CQL3 to execute queries on the data persisting in the Cassandra cluster.
• Involved in the process of designing Cassandra Architecture including data modeling.
• Installed and configured Cassandra cluster and CQL on the cluster.
• Installed 2 and 3 nodes Windows Server 2012 R2 Clusters in Virtual environment and implemented SQL Server 2014 Always On high availability.
• Experience in troubleshooting performance using 2012 Show plan enhancement.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters wif System Monitor.
• Used BMC remedy ticketing tool to provide support for application users and vendors.
• Perform Backup and Restore operations during off-hours for the Development team.
• Troubleshooting space issues like transaction log full, data file full, clearing the drive space
• Database maintenance, management and performance monitoring using third party tools including IDERA and SCOM.
• Reporting and resolving seriousSCOMalerts.
• Performed the database full and differential backup' for large size databases
• CreatingSQLServer Logins and assigning Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Extensively worked on snapshot replication. Used to create the tables manually and tan use the snapshot replication for dumping the data.
• Created Audit Reports.
• Setup configurations after the SQL Server installations are completed.
• Configured Server Memory for maximum Performance and effective utilization.
• Created Maintenance Plans for scheduling the full, diff and T-Log Backup's.
• Participated on 24 X 7 on call support. Familiar wif change management process.
• Used TrueCrypt encryption software to store production password data.
• Automate maintenance plan jobs inSQLServer agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
• Used Encryption and decryption techniques to backup and restore the sensitive data on the production databases.
• Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups wif recovery procedures.
• Designed and implemented SSIS package to migrate data from multiple data sources.
• Worked on SQL Server 2014 and 2012 Always On Availability Groups.
• Co-ordinate wif application team and other vendors to obtaining solutions when needed.
• Worked and generated reports usingSQLServer Reporting Services (SSRS)
• Worked on PowerShell scripts for daily monitoring and security audits.
• Developed reports using SQL and PowerShell.

Environment: SQL Server 2014, SCOM, IDERA SQL DM, BMC Remedy Ticketing Tool, SSAS, SSRS, SQL Queries, DTA, Triggers, Power Shell, SSIS.

Confidential, Edden Praire, MN

SQL DBA

Responsibilities:

• Responsible forSQLserver logical and physical database design, implementation, maintenance.
• Automate maintenance plan jobs inSQLServer agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
• SQLServer 2014 installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
• Database maintenance, management and performance monitoring using third party tools including IDERA, REDGATE and Spotlight.
• Extensively usedSQLnative tools like Index tuning wizard, Database tuning advisor (DTA),SQLprofiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting.
• Analyzing Locks, Dead Locks using both Spotlight and DMVs and DMFs, and handling the isolation Level and Concurrency Effects.
• Experience in Normalization, Database design, Performance Analysis and Production Support.
• Build Data Sync job on Windows Azure to synchronize schools data from SQL 2012 databases to SQL Azure.
• Create Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server.
• Assessment of existing on-premise workloads and providing an architectural roadmap for moving workloads to Microsoft Azure migration in both P2V and V2V scenarios.
• Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and DynamicSQLqueries.
• CreatingSQLServer Logins and assigning Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups wif recovery procedures.
• Designed and implemented SSIS package to migrate data from multiple data sources.
• Worked and generated reports usingSQLServer Reporting Services (SSRS)
• Used SSAS (SQLServer Analysis Services) to design, implement and manage data warehouses OLAP cubes and reporting solutions.
• Use Power Shell to configure user accounts and give necessary privileges forSQLlogins.

Environment: SQL Server 2014, SSAS, SSRS, SQL Queries, DTA, Triggers, SSIS, OLAP Cubes.

Confidential, PA

SQL DBA

Responsibilities:

• Responsible forSQLserver logical and physical database design, implementation, and maintenance.
• Install, configureSQLServer 2005/2008/2008 R2/2012 and apply periodic service packs and hot fixes (cumulative updates) for Dev, Staging and Prod environments.
• Develop TSQL scripts to create database objects and perform DML and DDL tasks.
• Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and DynamicSQLqueries.
• Migration of databases fromSQLServer 2008R2 toSQLServer 2012.
• Configured SMTP Server for Database Mail setup and received Alerts.
• Actively involved in planning the Disaster Recovery (DR) and responsible in understanding the requirements and coordinating Business Continuity (BC) planning activities.
• Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
• Implement database refresh using SSIS packages and automated backup/restore jobs.
• Auditing of database for logins, users and database activities and resolving orphan users.
• Configured SMTP Server for Database Mail setup and received Alerts.
• Configuration and Administration of SharePoint Server 2007/2010/2013 farms.
• Executed POCs to check feasibility of moving various workloads in Azure.
• Create, manage SQL Server AZURE Databases.
• Responsible for implementing Windows Azure and SQL Azure information factory and cloud based reporting and faxing solutions.
• Data Migration to and from various sources usingSQLServer Integration Services (SSIS).
• Develop reports usingSQLServer Reporting Services (SSRS).
• Auditing of database for users transaction, login and database action and removing orphan users.
• Upgrading and downgradingSQLserver instances.
• Scheduling and automating maintenance plans usingSQLServer job agent.
• Set up and manage transactional log shipping,SQLserver Mirroring (Synchronous/ Asynchronous), Fail over clustering and Transactional replication in multiple environments as part of disaster recovery plan and load balancing strategy.
• Experience in mentoring wif team members, documentation and 24/7 on call production support.

Environment: SQL Server 2005/2008/2008 R2/2012, SQL server Mirroring, SSRS, SSIS, SharePoint Server 2007/2010/2013 farms, TSQL Scripts.

Confidential, Jersey City, NJ

SQL DBA

Responsibilities:

• Maintaining moreSQLServers as production and other environments.
• Providing Primary On-Call Support as a productionDBAon rotation basis.
• Changed generic service accounts to specific service accounts on prod and non-prod servers.
• Configure Database Mail and Maintenance scripts on all environments.
• Trouble shoots replication issues on production.
• Installing and configuringSQLServer 2008 on production as standalone and cluster servers.
• Apply service packs and hot fixes on production servers.
• Trouble shoots the long running jobs on production.
• Migrating database fromSQL andSQL .
• Refresh databases from Prod to other environments.
• Configure and Support Always- On, Mirroring, Replication, Log shipping and Clustering
• RebuiltSQLServer 2008 andSQLServer 2005 servers
• Worked on year end Disaster recovery test and built DR database servers.
• Write TSQL andSQLscripts, SSIS and developingSQLServer Reports on SSRSTuning theSQLServer and databases on production.

Environment: TSQL and SQL Scripts, SQL Server 2008 and SQL Server 2005 servers, SSRS, SSIS.

Confidential

SQL DBA

Responsibilities:

• Maintaining the file server, application and Print Server.
• SQLServer 2005 Database Administration.
• Managed the migration ofSQLServer 2000 databases toSQLServer 2005
• Deployed and AdministratedSQL2005/2000 Enterprise servers on production environment.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1.5Terabytes.
• Developed, implement and monitor a large-scale and time-sensitive production loading processes
• Develop and implement replication, archiving and backup and recovery strategies
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Worked on Client/Server tools likeSQLServer Management Studio to administerSQLServer.
• Evaluated data storage considerations to store databases and transaction logs.
• Created databases usingSQLServer Management Studio, Database Wizard and TransactSQL Statements.
• Expertise in trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by usingSQLServer 2005 tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Implemented Snapshot replication.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Used Log shipping for synchronization of database.
• Involved in generating various reports using theSQLServer Reporting Services.

Environment: SQL Server 2000/2005, VLDB, SSIS packages, DMV’s, DDL Triggers, SQL Server Reporting Services, Data Extraction.

Confidential

SQL Server DBA

Responsibilities:

• Performed Desktop and Phone Support as needed.
• Responsible for Logical & Physical database designing, implementing and Data Modeling.
• Involved in upgrading fromSQLServer 7 toSQLServer 2000 and fromSQLServer 2000 toSQL Server 2005.
• Worked on database user administration and granted required privileges to users.
• Tuned Stored Procedures andSQLQueries.
• Performed performance analysis using CPU, me/O and memory counters using performance monitors.
• Experienced wif converting Access database to the MSSQLServer environment.
• Configured and maintained the Transactional replication between the production environments.
• Scheduled database maintenance tasks to improve the database performance.
• Experienced in database backup and restore operations.
• Involved in maintaining database wif maximum database availability, resolve any database issues.
• Created the BCP scripts file to export the data from text files toSQLServers.
• Administered the Windows NT 4.0 Servers and local area networks.
• Worked wif tuning and configuration of production and development database servers.
• Created the stored procedures, views and scripts for application development.
• Experienced wif DBCC commands, to check physical and logical consistency of the databases

Environment: SQL Server 2000/2005/2007, BCP Scripts, DBCC Commands, BCP Scripts.