SUMMARY:

• Having11+ 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
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts
• Extensive experience in implementing HADR solutions likeAOAG,Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
• Implemented In - place and Side by SideMigration of MS SQL SERVER2005 to 2008 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)
• Worked on Data Integrity, Performance Tuning, Query Optimization
• Providing on call support 24/7 on rotational basis for production database on mission critical systems
• 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 2000 to 2005 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
• 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: 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: Lumira,HANA

WORK EXPERIENCE:

Confidential

SR. SQL Server DBA

Responsibilities:

• Expert in performing installation, configuration (32bit/64bit), optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments.
• Experience in Migrating from SQL server and and by using In-Place upgrade process as well as side-by-side upgrade process and documented complete Upgrade Process.
• Implemented and supported different High Availability & Disaster Recovery scenarios like Always-On Availability Groups(AAG), Clustering (Active/Passive), Replication models (Transactional, Snapshot), Log Shipping (Native and Custom) and Data base Mirroring.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Created effective Backup and Recovery plans by Transactional Log and Full Database Backups and utilized to recover data in 'Point in time' in case of disaster of server based on ERT(Estimated Recovery Time), RTO(Recovery Time Objective), and RPO(Recovery Point Objective) Policies.
• Handled with both the Planned Failover and the Unplanned Failover
• Backed up Production servers set to outside local (DR site)
• Backed up SQL Servers to Local (Live site)
• Ensured the systems are functioning optimally and that users are able to upload
• Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014
• Technical Analysis, Code Review, Implementation, 24*7 production support
• Worked on performance monitoring and health checks for SQL Servers
• Executed SQL Server Integration Services packages using SQL Server 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 large SQL Cube and ETL
• Exposure to supporting ETL based applications

Environment: MS SQL Server 2014/2012/2008 , Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.

Confidential

SR. SQL Server DBA

Responsibilities:

• Installed and maintained of SQL Server 2014, 2012 and 2008R2 on Test, Development and Production Environments, Active Directory Administration
• Build High availability, Disaster Recovery and Human T-SQL error plans to meet business requirement.
• Implemented Disaster Recovery Planning (Using Asynchronous (High-Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation
• Created Windows Authentication Logins and SQL Server Authenticated Logins
• Created database roles and application roles for security concern
• Provided explicit permissions to specific tables to users in databases
• Tuned stored procedures and T-SQL for performance using indexes
• 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)
• Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014
• Technical Analysis, Code Review, Implementation, 24*7 production support
• Worked on performance monitoring and health checks for SQL Servers
• Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration

Environment: MS SQL Server 2014/2012/2008 , Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.

Confidential

Sr.SQL Server DBA

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.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Involved in Performance tuning, query-inventory, analysis and optimization.
• Created and managed database users, login Ids and security.
• Performed Data transfer (Import & Export) using DTS packages.
• Responsible for performing complete back-up and restoration, database maintenance
• Service pack updates on server and client.
• Created crystal reports and hosting it in the web for the users.

Environment: Windows 2012, SQL Server 2012,Crystal Reports.

Confidential

SQL Server DBA

Responsibilities:

• Installed MS SQL Server 2008, Performed Database Design and created User Databases
• Excellent knowledge in Recovering Databases in emergency/data file missing/log space full
• Scheduled backups and performed restore operations for system test data depending on developers' requirement
• Created maintenance plan and SQL server 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 MS SQL Servers 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: MS SQL Server 2008, 2008R2 and 2012, Windows 2008R2 Advanced Server

Confidential

SQL Server DBA

Responsibilities:

• Administrated and supported on large number of SQL Server 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-scale SQL Server databases
• Implemented Log shipping on a few databases for off site 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-SQL and database engines
• Developed all the required stored procedures, user defined functions, and triggers using T-SQL
• Maintained documents and implement Disaster recovery models
• Built scheduled-jobs to migrate data from flat files to database

Environment: SQL Server 2008R2, Windows 2003 Advanced Server,SQL Profiler.

Confidential, Tulsa, OK

Jr.SQL Server DBA

Responsibilities:

• Administration and support on large number of SQL Server instances in multiple data centers including Production, Validation, QA, Staging, Test and Development Environment.
• Installed MS SQL Server Performed Database Design and created User Databases
• Worked mostly on Windows servers
• Centralized the environment by fixing the issues with their necessary maintenance plans and service accounts.
• Worked with Application System Managers directly and provide suggestions under database side
• Involved in Planning/Implementation/Support for database migration from SQL Server 2005 to SQl Server 2008R2
• 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 and Implemented Active/Passive and Active/Active clustering for large size databases
• Performed Monitoring with SQL Profiler and Windows System Monitor
• Moved System databases to different drives for data security and availability
• Available production support for 24*7 whenever required

Environment: SQL Server 2005/2008 R2, T-SQL, EXCEL, Power point, Windows 2008 Server, Visual Source Sate 6.0, 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 performances using 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: SQL Server 2000/2005 Enterprise Manager, SQL Query Analyzer, SQL Profiler, SSIS, MS ACCESS, Crystal Reports.