SUMMARY

• Microsoft SQL Database Administrator and Developer with Over 10 years of experience in designing, analyzing, adapting, developing, implementing, testing, and maintaining database solutions through Business Intelligence usingSQLServer 2016/2014/2012/2008 R2/2008/2005,SQLServer Integration(SSIS) and Reporting Services (SSRS).
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in Database Administration of very large and complex databases inSQLServer 2016, 2014, 2012, 2008 R2, 2008 andSQLServer 2005/ 2000 including 24/7 Production support of the databases and round - the-clock database operations.
• Experience and deep knowledge with SQL Server Database Administering high availability and Disaster Recovery Strategies using Clustering, Standby/Replication, Database Mirroring, Log shipping.
• Experienced in Database Monitoring, Performance Tuning, Query Optimization and Security management
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating ComplexStored Procedures, Triggers, User-defined Functions, CTE's Views and Cursors.
• Strong experience in developingparameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008/2012 using data from a variety of sources.
• Experience in creating stored procedure for generating reports usingSQLServer Reporting Services (SSRS).
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficient in various Extracting, Transforming, and Loading (ETL) tasks, using different transformations like Slowly Changing Dimension, Lookup, Conditional Split, Derived Column to manage data.
• Well versed in Normalization/ De-Normalization for optimum performance in relational and dimensional database environmentsand maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Good knowledge of Data Marts, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modeling.
• Experience in building, provisioning and managing customSharePointsites, sub-sites and web parts.
• Experience in writing PowerShell script for installation and automation of certain tasks.
• Experience on Windows server environment (AD, DNS, DHCP, and ADFS) and creating virtual machines using Hyper-V.
• Experienced in Microsoft Dynamics GP installation, implementation, upgrades and providing support (AP, AR, Payroll, Sales, Inventory, Integration Manager and Smart List).
• Experience in Microsoft Dynamics CRM 2013 administration, creating workflows, forms, entities, dashboards, reports, user administration, E-mail router configuration and outlook plug in installation.
• Experience in Configure SAML-based claims authentication with ADFS.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2016/2014/2012/2008 /R2/2005, MS Access

Platforms: Windows 2003/2008/2012 server, Windows XP/Vista/7/8, Microsoft Azure

Tools: MS Visual Studio 2008/2010/2012 , SQLServer Business Intelligence Development Studio (BIDS), SSMS, SSRS, SSIS, SSAS, Crystal Report, SQL Query Analyzer, SQL Profiler, SQL Performance Monitor, Database Tuning Wizard, Import & Export, Red Gate, Idera, Apex SQL Tools, FogBugz

Software: Microsoft Office 2003/2007/2010/2013 , SharePoint, Microsoft Project 2005, Microsoft SQL Server, Microsoft Visio, Epi-Info, SPSS, Tableau, Peachtree, Microsoft Dynamic GP, MS CRM, Management Reporter, IIS Server, ADFS

Programming Languages: T-SQL, C++, Visual Basic, C#, HTML,CSS, JavaScript, AutoIT Script, PowerShell

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP, Active Directory, Hyper-V

PROFESSIONAL EXPERIENCE

Confidential, North Bethesda, MD

Sr. SQL Server Database Administrator

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, and application team.
• Automated and enhanced daily administrative tasks, including space management, backup & Recovery and performance monitoring.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Responsible forSQLserverlogical and physical database design, implementation, maintenance.
• Participated in all database deployments and solved all the critical issues during deployments which prevented the extended downtime of the sites.
• Installing Monthly Security Patches and Scheduling Regular Maintenance to ensure the health and security on the servers.
• Automated the daily routine tasks using PowerShell
• Analyzing Locks, Dead Locks, and handling the isolation Level and Concurrency Effects.
• Monitoring Databases and troubleshootingSQLServerperformance issues using Extended event,SQLServerProfiler, Trace and Index tuning wizard
• Prepared the auditing reports for the day-to-day as well as weekly/monthly purposes.
• Diagnose & troubleshoot issues, Conduct performance tuning for optimizations
• Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance ofSQLServerdatabases.
• Calculate and trend database sizes and plan appropriately for growth and communicate plans toserver administrators.
• Create complexSQLstored procedures, Triggers, Functions, Views, Indexes inSQLServer.
• Configured SSIS packages using Package configuration wizard to allow Packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Confidential, Rockville, MD

Sr. SQL Server Database Administrator

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Set up and monitor High-Availability(HA) and Disaster Recovery(DR) technologies including mirroring, log shipping, replication, failover clustering
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Optimize SQL queries for improved performance and availability.
• Develop, test & implement a robust database backup and recovery strategy. Recovering the databases from backup.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Migrating Disaster recovery databases into cloud - Microsoft AZURE.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Design, deploy and schedule reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
• Create SQL Server Agent jobs for monitoring performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Write scripts for operational automation of manual administrative tasks.
• Conduct root cause analysis for database incidents and problems.
• Perform database/infrastructure physical design; apply patches to databases as per application requirements.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Configured and Maintained Database mirroring and log shipping for Disaster Recovery
• Monitored physical and virtual servers using performance metrics and alerts.
• Managed and supported Microsoft Dynamics CRM - creating custom workflow activities, custom dashboards, views, forms, entities, relationships and JavaScript events.
• Managed and supported SharePoint sites - Created sites, built custom workflows, managed permission and content; setup document management and integrated with CRM.
• Configured SAML claims authentication with ADFS as an Identity Provider Security Token Service for the SharePoint and CRM web applications

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server instances
• Troubleshooting performance issues using DMV's, Profiler and Perfmon.
• Performing Index tuning, Query tuning and application tuning.
• Installed SQL Server patches, and deployed database code changes
• Migrated SQL servers and databases during Operating System upgrades
• Installing, Configuring and Troubleshooting AlwaysOn,and Monitoring and Troubleshooting Cluster servers.
• Monitoring and Troubleshooting Maintenance and Application jobs.
• Backup databases and perform database restore
• Configured Log shipping and mirroring
• Configured database maintenance jobs and alerts
• Created and deployed SSIS packages and SSRS reports
• Monitored and tuned databases to optimized database performance
• Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
• Designed and created databases, tables, views, store procedures and triggers.

Confidential - Baltimore, MD

Database Administrator

Responsibilities:

• Working on SharePoint Server and Managing PR Trucking system.
• Participated in the design and development of custom solutions inSharePoint2010 using Visual Studio andSharePoint designer.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Set up SQL Server configuration settings for better server management.
• Assisted and troubleshoot technical issues, and inquires for thePeachtreeAccounting computer program and ACCPAC

Confidential

IT Infrastructure / Database Administrator

Responsibilities:

• Installed, configured and managed SQL Server 2005 and 2008.
• Responsible for security management
• Generated Report using SQL Server Reporting Services (SSRS)
• Database monitoring, backup and restore of mission critical databases and system databases
• Performed database performance tuning, troubleshooting, day to day database maintenance tasks, Scheduled jobs and develop Maintenance Plans for database monitoring
• Troubleshoot performance problems and fine-tuning of databases.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Implemented and Scheduled Replication process for updating our parallel servers.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.