SUMMARY

• Having 10+ Years of Database Administration and Development experience on MS SQL SERVER 2014/2012/2008 R 2/2008/2005/2000 in OLTP and OLAP environments
• Experience in installing MS SQL SERVER 2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packs and also AWS, Azure environments.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts and other RDBMS (Oracle 10g, 11g and 12c)
• Extensive experience in implementing HADR solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
• Implemented In - place and Side by SideMigration of MS SQL SERVER R2 and 2008R2 to 2012
• Knowledge in writing T-SQL (DDL, DML, and DCL) statements
• Migrated DTS 2000 packages to SSIS packages in 2005 using MigrationWizard
• Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Implemented and deployedAzureofferings including both the IaaS and PaaS offering.
• Worked on Data Integrity, Performance Tuning, Query Optimization
• Providing on call support 24/7 on rotational basis for production database on mission critical systems
• Implemented and provisionedAWSservices combining hands on experience with services like EC2, Cloud Front, Cloud Formation templates and monitoring services like Cloud Watch etc.
• Knowledge inSparkStreaming andSparkSQL
• Hands on implementation experience with a strong background in AzurePlatform Microsoft SharePoint and Microsoft Dynamics development, infrastructure, governance and content management
• Implementing CR (Change Request) and CA (Change Amendments) requested by users
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources
• Performed SQL Upgrades. SQL and building SQL Clustering
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects
• Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis
• Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics
• Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values
• Experience in Fog light and CIS Tools
• Experience in CRQ and BDA Tools
• Worked on third party tools like BCP Remedy Tool, Lite Speed, Fog light and Red gate
• Experience in creating SQL SERVER Reports using SSRS 2005/2008 and worked on Hyper-V and VMware environments
• Implemented change management
• 24*7 Production support experience.
• Performing Root Causal Analysis(RCA) of incidents and adhering to SLA standards

TECHNICAL SKILLS

Operating System: Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX

RDBMS: MS SQL SERVER 2005/2008/2008 R2/2012/2014, MS Access

Languages: Transact-SQL, SQL and Visual Basic

Database Tools: Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli

ETL Tools: SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools: SSAS 2005/2008/2008 R2/2012

Reporting Tools: SSRS 2005/2008/2012 , Crystal Reports, BO-Universe, WebIntelligence, MS Excel.

SAP: Business Objects Lumira, HANA

Others: AWS, Windows Azure, ER-Win v 4.0, Visio 5.0, PL/SQL, Visual Source Safe, Net Backup, Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, Toad, SQL*Plus.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server DBA Lead

Responsibilities:

• Regularly monitored and identified blocking issues. Worked on a procedure that continuously run on all PROD servers and notifies DBA team if any blocking, long running quires/transactions.
• Check Performance counters on all production servers and verify that all counters are within the normal range. Designed SSRS metrics report to review the counters for every one hour.
• Throughout the day, periodically monitored performance using System Monitor and DMV.
• Checked the fragmentation and rebuild/ reorganize the indexes.
• Checked all the Stats Update / nightly checkalloc / Index Rebuild jobs are completed without any issue.
• Research- Trying to best practice of the implementation and looking for all the possibility of moving SQL Servers into Azure cloud.
• Worked with the other teams to make sure that all servers are at health condition and to balance the infrastructure.
• Approach regarding (CR/IR/SR - Change Request/ Incident / Service)
• Found I/O errors, blocked by, CPU wait stats, and session.
• Created documentation for Databases (Dev / Stag / QA / PROD)
• Troubleshooted and resolved database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Architected cloud roadmap for SharePoint Server and development on the Azure
• Worked on Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Tested Private Cloud and bringing upAzurecloud stack in Lab.
• Detected by troubleshooting SQL Server related CPU, Memory, I/O, disk space and other resource contention.
• Involved with other teams in Migrating the SQL server .
• Effectively communicate the differences betweenAzureand on-site technologies and the benefits of each type of deployment.
• Scheduled lot of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.

Confidential, Edison, NJ

Team Lead/SQLServerDBA/BI Developer

Responsibilities:

• Installed and maintained ofSQLServer 2014, 2012 on Test, Development and Production Environments, Active Directory Administration
• Build High availability, Disaster Recovery and Human T-SQLerror plans to meet business requirement.
• Implemented Disaster Recovery Planning (Using Asynchronous (High-Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation
• Monitored as a lead for 4 members team
• Installed and configuredSparkecosystem components (SparkSQL,SparkStreaming, MLlib or GraphX)
• Assisted in migration of existing data center into the AWS environment.
• Created Windows Authentication Logins andSQLServer Authenticated Logins
• Created database roles and application roles for security concern
• Provided explicit permissions to specific tables to users in databases
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor.
• Installed the application on AWS EC2 AMI, Red hat, Ubuntu Instances.
• Implemented AWS solutions using E2C, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.
• AzureAutomation (cloud and on-premises) solution development for Microsoft POC engagements
• Tuned stored procedures and T-SQLfor performance using indexes
• AzureBackup and Backup Server configuration and POC
• AzureSite Recovery (ASR) configuration and POC
• Prepared databases for Mirroring and Configured the principal Server
• Handled with both the Planned Failover and the Unplanned Failover
• Backed up Mission Critical Production servers set to outside local (DR site)
• Backed upSQLServers to Local (Live site)
• Ensured the systems are functioning optimally and that users are able to upload
• MigratedSQLServer 2012 toSQLServer2014
• Technical Analysis, Code Review, Implementation, 24*7 production support
• Worked on performance monitoring and health checks forSQLServers
• ExecutedSQLServer Integration Services packages usingSQLServer Agent Job for building high performance data integration
• Monitored, scheduled SSIS and changed SSIS Workflows & Configurations
• Experienced with optimizing and performance tuning the queries for a largeSQLCube and ETL
• Exposure to supporting ETL based applications

Environment: MSSQLServer 2014/2012, Windows Server 2012, T-SQL, MS Access, BIDS 2014, Azure, AWS.

Confidential, Ann Arbor, MI

Sr. SQLServerDBA

Responsibilities:

• Provided database design support for new system development; set SQL standards for object names and usage.
• Developed complex T-SQL code for data retrieval.
• Responsible for backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for data retrieval by extensive use of joins normalization and views.
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• AzureAutomation (cloud and on-premises) solution development for Microsoft POC engagements
• Managed servers on the Amazon Web Services (AWS) platform instances using Puppet, Chef Configuration management.
• Effectively use Profiler to find performance issues and deadlocks. I am familiar and comfortable with perfmon. Have resolved blocking and long running queries through Activity Monitor and Profiler.
• Performed configuration, deployment and support of cloud services including Amazon Web Services (AWS)
• Catching and Reporting errors using exception handling
• Integration and automation withAzureAutomation
• Involved in DevelopingOLAPmodels like facts, measures and dimensions.
• Created SSIS packages from scratch to transfer data from source to destination using all required transformations applied.
• Performed configuration, deployment and support of cloud services including Amazon Web Services (AWS)
• Managed Oracle Databases on Windows and Linux platforms.
• Integrated AzureBackup& AzureSite Recovery (ASR)
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Data migration between databases using both Oracle11g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Monitoring the performance of the scheduled jobs and alerts
• Involved in Performance tuning, query-inventory, analysis and optimization.
• Created and managed database users, login Ids and security.
• Performed Data transfer (Import & Export) using SSIS packages.
• Responsible for performing complete back-up and restoration, database maintenance Service pack updates on server and client.

Environment: Windows 2012, SQL Server 2012, SSIS, SSRS, T-SQL, Excel, Oracle 11g, Azure, AWS

Confidential, Pensacola, FL

SQLServer DBA

Responsibilities:

• Installed SQLServer 2008 R2, Performed Database Design and created User Databases
• Excellent knowledge in Recovering Databases in emergency/data file missing/log space
• Scheduled backups and performed restore operations for system test data depending on developers' requirement
• Created maintenance plan andSQLserver jobs and scheduling them, setting emails alerts on failure.
• Set up Peer to Peer Transactional Replication (international) along the datacenters in Europe, Asia and America.
• Synched all the databases participating in PTP replication prior to setup.
• Acquired Replication Accounts (including login names and permissions)
• Configured Distributor on all Nodes and Publisher and tested live transaction flow
• Configured Transaction replication (domestic) for reporting purpose
• Created SSIS Packages to upload test data from Text files.
• Used DBCC checks and fixed data corruption in Application database
• Administered MSSQLServers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Environment: Windows 2008R/2008 MS-SQLServer2008R2/2008, SSIS, SSAS, SSRS

Confidential, Deerfield, IL

SQL Server DBA

Responsibilities:

• Administrated and supported on large number ofSQLServer instances in multiple data centers including Production, Test and Development Environment.
• Supported 24*7 for production systems
• Managed logins and user accounts, including assigning database object permissions and ancillary privileges
• Migrated databases and configured database Recovery if necessary
• Performed backups and restores on large-scaleSQLServer databases
• Implemented Log shipping on a few databases for offsite reporting purpose
• Moved the Log Shipping secondary databases to different drive due to disk space issue
• Provided explicit permissions to specify tables to users in databases
• Moved the Log Shipping secondary databases to different drive due to disk space issue.
• Performed redirected restores of databases to Test, QA and development system
• Supported and Clearing the database logs everyday
• Performed monitoring and tuning T-SQLand database engines
• Developed all the required stored procedures, user defined functions, and triggers
• Maintained documents and implement Disaster recovery models
• Built scheduled-jobs to migrate data from flat files to database

Environment: SQLServer 2008 R2, Windows 2003 Advanced Server, SQLProfiler, T-SQL.

Confidential, Tulsa, OK

Jr. SQL Server DBA

Responsibilities:

• Administration and support on large number ofSQLServer instances in multiple data centers including Production, QA, Staging, Test and Development Environment.
• Installed MSSQLServer Performed Database Design and created User Databases
• Worked mostly on Windows servers
• Centralized the environment by fixing the issues with their necessary maintenance plans
• Worked with Application System Managers directly and provide suggestions under database side
• Involved in Planning/Implementation/Support for database migration fromSQLServer 2005 toSQL Server 2008 R2
• Implemented Mirroring for critical operational databases to provide no data loss
• Successful in implementing and setting up the replication (Snapshot /Transactional /Merge /Peer-Peer)
• Implemented Log shipping by placing the secondary database in Read-only mode.
• Configured Active/Passive and Active/Active clustering for large size databases
• Performed Monitoring withSQLProfiler and Windows System Monitor
• Moved System databases to different drives for data security and availability
• Available production support for 24*7 whenever required

Environment: SQLServer 2005/2008 R2, T-SQL, EXCEL, Power point, Windows 2008 Server, ITSM, Foglight, Scom, Net App Snap manager, DB Monitoring Software Imperva

Confidential

SQL Server Developer/DBA

Responsibilities:

• Developed backup restore scripts for MS SQL Server as needed.
• Upgraded to latest version from MS SQL server .
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, Triggers and Constraints.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements using Indexes and Stored Procedures.
• Responsible for Disaster recovery and database maintenance plan.
• Designed and implemented data access stored procedures and automating tasks.
• Performed Job scheduling and alerts.
• Optimized queries and performancesusing varies MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• Created many complex Stored Procedures and used them in Crystal Reports directly to generate reports on the fly.
• Created crystal reports and hosting it in the web for the users.

Environment: SQLServer 2000/2005 Enterprise Manager,Query Analyzer,SQLProfiler, SSIS