SUMMARY

• 4+ years of IT industry experience in Microsoft Sql Server Database Administration and development with good knowledge of Windows and Database security
• Experienced in installing, configuring, managing, monitoring, maintenance and troubleshooting SQL Server 2008/2012/2014/2016
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management
• Experience in Database Upgrade from MS SQL server 2012/2008
• 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
• Worked closely with application teams, developers, testing team and helped in impact analysis and problem resolution
• Planning and implementation of High availability and Disaster Recovery for SQL Server databases, including Windows 2008/2012 Clustering, Log shipping, Replication (Snapshot, Merge & Transactional), Database Mirroring and Database Snapshot
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Dynamic Management Views (DMV’s)
• Experience in using different Transformation tools like DTS Packages, SSIS and, BCP and BULK INSERT
• Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans and Database Mail Configuration
• Checking Database Health by using DBCC Commands and DMVS
• Experience with SQL Server and T - SQL in constructing triggers, joins, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Implemented Data partitioning, database mirroring, database snapshot, try-cache blocks, online indexing, DMV's, Mail Setup, Jobs, and Alerts
• Designed and developed the custom Error logging, Data Archiving process, Error Reporting, Kingsway log processing solution for the Integration framework
• Create SSIS packages to extract, validate and load data into Data warehouse
• Experienced working with SSDT on SQL server Integration Services (SSIS) and SQL server Reporting Services (SSRS)
• Worked with Perland UNIX shell scripts and Worked with releasing scripts live and tested
• Extensive experience in controlling the user privileges, monitoring the security and audit issues as per enterprise standards
• Hands on experience in cleaning and scrubbing of data with Lookup and Fuzzy Lookup, Logging, Error handling by using Event Handler, and Custom transformations
• Writing shell scripts for system maintenance and automation of server
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail
• Testing backups to ensure we can meet the business Recovery Time Objects (RTO).
• Optimized SQL queries for improved performance and availability
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load
• Migrated On-Premise databases to Azure SQL Server
• Experience in Policy Based Management, Resource Governor, performance data collector, and Transparent Data Encryption
• Setup automated jobs for different purposes including backup, monitoring database health check, disk space, backup verification, and moving databases from environment to environment including creating test environment

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, C concepts, XML, PL/SQL and visual studio

Database: MS SQL Server 2014, 2012, 2008R2, 2008, Oracle 9i/10g/11gR2/ 12c

Tools: SQL Server Management Studio, SSIS, SSRSSQLserver Query Analyzer,SQLserver mail service, DBCC, DTS, BCP,SQLserver profiler, Event Viewer, and Index Tuning Wizard,SQLServer Agent, SSRS Log Shipping, T-SQL, SQL Server Enterprise Manager

Operating System: Windows Server 2012, 2008, 2008 R2 Windows XP, UNIX, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Sr. SQL Database Administrator & Developer

Responsibilities:

• Involved as an MS SQL Server 2008R2/2012/2014 Administrator and responsible for installation, configuration, tuning and provided 24 X 7 dedicated support to all Production servers
• Migrated two servers with more than 60 databases from SQL Server 2008 to SQL Server 2012
• Extracted data using SQL Server Integration Services (SSIS) from different data sources
• Performed monitoring of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Created and configured an OLTPreplication database for disaster recovery purpose
• Implement data models, database designs, data access and table maintenance codes
• Expertise in performance tuning, optimization, data integrity and statistics by using SQL profiler and DB engine tuning advisor
• Fine-tuned and Monitored SQL Servers in Web based and Transaction intensive environments
• Implemented Active/Passive, Active/Active SQL Server Cluster servers
• Configured and maintained database mirroring for high availability
• Excellent backend skills in creating and managing SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Defaults, user defined data types and functions
• Created and implemented (DTS Packages & bcp scripts) replication between SQL Server and Sybase
• Experience in data Migration from ORACLE to SQL Server
• Extensively worked on Dynamic Management Views (DMV’s)
• Expertise in design, development and implementation of Client/Server Application using Microsoft Visual Basic .Net, Microsoft Visual C# .NET and Microsoft Visual Studio .NET
• Performed DBCC utilities and fixed data corruption in User databases
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS)
• Managing security by creating Groups, Logins, users with proper authentication and grant appropriate permission on Server level, Database level as well as Object level
• 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
• Import & Export data from Oracle, Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP

Confidential

SQL Server Database Administrator

Responsibilities:

• Responsible for installation and maintenance of all the SQL Server 2008/2012 servers with the design, document, development, enhancement and support of MS SQL Server databases
• Migrated more than 100 databases and around 14 servers from SQL Server 2008 to 2012 and upgraded 3 servers from SQL Server 2005 to 2008
• Created and maintained databases tables, Indexes, Views and used Stored Procedures, DTS packages, BCP for updating Servers
• Building reports using SQL Server Reporting Services in SQL 2008
• Performed all aspect of database administration, including backup, recovery and Replication for SQL 2008
• Strong working experience in Database High Availability - AlwaysOn, Database Mirroring, Log Shipping and Clustering
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS)
• Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries
• Extensive experience in controlling the user privileges, monitoring the security and audit issues as per enterprise standards
• Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process
• Working with Kingsway software components for SSIS to integrate, convert, download, upload, and pull different pieces of information from MS CRM System servers
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008
• Worked in Active/Active Cluster environment as a High availability solution
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics modifications
• Experience in data Migration from ORACLE to SQL Server
• Expert in debugging an application using the debugging tools provided by the Visual Studio.Net IDE
• Created complex stored Procedures, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Create SSIS packages to extract, validate and load data into Data warehouse
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Worked SQL Server Agent Jobs for scheduling jobs related to .Net applications and SSIS Packages
• Migrated On-Premise databases to Azure SQL Server
• Worked with Perland UNIX shell scripts and Worked with releasing scripts live and tested
• Set up Microsoft Azure Linux environment and deployed MongoDB and also created MongoDB cluster environment in MongoDB ATLAS environment
• Provided server requirements for CRM2016 On Premise and Worked on business/functional and technical requirements
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs

Confidential

SQL Database Administrator & Developer

Responsibilities:

• Involved as an MS SQL Server 2008/2005 Administrator and responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases
• Developing Reports in SQL Server Reporting Services on MS SQL 2005/2000 platform
• Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
• Implemented data models and database designs, data access and table maintenance codes
• Involved in Failover clustering for Active/Active and Active/Passive SQL Server 64-bit environment
• Experience in providing logging, error handling by using event handler, and custom logging for SSIS packages
• Enforce database integrity using primary keys and foreign keys
• Writing shell scripts for system maintenance and automation of server developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS
• Creating/Modifying/Locking Logins and Users in SybaseDatabase
• Controlled user access rights, and managed data security
• Maintained multiple instances SQL Servers with maximum availability
• Set up Microsoft Azure Linux environment and deployed MongoDB and also created MongoDB cluster environment in MongoDB ATLAS environment
• Analyzed potential problems (Response delay, locking, server downtime, etc.) to avoid and optimize
• Designed and developed the custom Error logging, Data Archiving process, Error Reporting, Kingsway log processing solution for the Integration framework
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS)
• Worked SQL Server Agent Jobs for scheduling jobs related to .Net applications and SSIS Packages
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS
• Experience in data Migration from ORACLE to SQL Server
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation
• Created proactive scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, dB size and service status monitoring