SUMMARY

• 12 years of experience in Database Administration, Development and Design and extensive experience with SQL Server 2014/2012/2008/2008 r2/2005/2000 in retail and banking/Insurance sector.
• 1 Year Experience In MONGO DB Developer and Administration.
• Designed, implemented, and managed mission critical high availability SQL Server solutions: Log shipping, Replication, database Mirroring, SQL Server Clustering and Always On.
• Proficient in database maintenance methods and procedures including Backup/Recovery, performance tuning, normalizing/de - normalizing databases.
• 24 x 7 Support, Monitoring, Maintenance and Administration of production, Staging, QA and dev SQL environments and familiar with change request process.
• Experienced in supporting Very Large OLTP Databases of size 7 TB and troubleshooting the performance bottle necks.
• Hands on experience in database migration and up gradation.
• Datacentre DB migration, Database Migration(In place/Side By Side)
• SQL Server Diagnostics and identification of slowness.
• SQL Query Performance tuning, indexing, Table level Compression, Table partitioning.
• Automation of SQL Server Health using TSQL, Windows PowerShell.
• SQL Server capacity planning and choosing right licensing strategy.
• Maintenance plan setup: backups (full, differential, transactional, file group, file).
• DB maintenance, index maintenance, DBCC CHECKDB, etc.
• TSQL development: triggers, CTEs, views, stored procedures
• ETL processing: Data load and transformation, deploying large scale ETL Packages.
• SharePoint DB and Application Administration and service application configuration.
• Automation of Adding DB to Always On availability group and backup refresh to Staging/QA/Dev.
• Extensive experience on supporting, Tuning Applying maintenance plan, migrating on SAP ERP Databases.
• Security, Auditing, Encryption
• Experienced in SSRS Load balancing, Implemented large scale SSRS reports.
• Creation and Implementation of SSIS package to extract data from various sources.
• Worked in SaaS environment.
• Expertise in working in Azure/AWS cloud.
• Configuration and Administration of SharePoint Server 2013.
• Installations, Upgrades, Service Pack, Cumulative Updates, Migrations, Patching.
• Experienced in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
• Implemented TDE for highly secured SharePoint database through automated process.
• Managing TFS databases and moving/upgrading TFS databases.
• Reviewing legacy SSIS packages and update periodically.
• Maintaining SOX AUDITED DBs, producing SOX.
• Planning and recommend capacity planning by analysing the table and database growth.
• Trouble shoots highly resource intensive queries by reviewing TSQL.
• Identify Deadlock/blocking on time and take proactive recommendation/action.
• Expertise in using third party monitoring tool Fog light/ appdynamics for monitoring SQL severs.
• Extensively use Execution plans, Engine Tuning Advisor and other query optimization practices.
• SQL 2014, SQL 2012, SQL 2008 R2, SQL 2008, SQL 2005, SQL 2000.

TECHNICAL SKILLS

Cloud: Microsoft Azure

Scripting: PowerShell, C#,VB.

Databases: SQL Server 2016/ 2014/2012/2008/2008 R2/2005/2000 MS Access 2000, Oracle 11g.

OS: Windows Server 2012 R2 (server core), 2012, 2008R2, 2008, 2003

Reporting Tools: SSRS (Reporting Services), Tableau

BI Tools: SQL Server BI Development Studio (BIDS), SharePoint, MS Visual Studio 2008/2005, DATAZEN.

Miscellaneous: Storage I/O performance testing tools, VMWare, Hyper-V, Redgate, Autosys, Litespeed Backup Tools.

Monitoring Tools: FogLight, AppDynamics, M360.

Change Management Tools: Service Now,BMC Remedy.

PROFESSIONAL EXPERIENCE

Confidential, Los Angles, California

SQL Server DBA

Responsibilities:

• Working as L3 Level support engineer for mission critical large scale databases.
• Setup, Installation, upgrade & migration of Existing system to SQL Server 2014/2012 from SQL Server 2005/2008
• Setup for disaster recovery, fail over strategy, High Availability of system using MS Clustering, Database Mirroring, SQL Always On, Replication.
• Support for (24 x 7) and problem solving using available resources & making recommendation like DTA, DMV, SQL Trace, Perf-Mon, SQL Server Monitoring & third party tools
• Co-ordination, co-operation, guidance and direction to group of DBA
• Reporting to the Management about the project status and its schedules from time-to-time.
• Meeting/Conferences among technical groups and delegation of responsibilities to our junior members.
• Immediate solution to customer service for existing problems.
• Training to the staff members to keep pace with the improved technology
• Smoothly handling the project under critical time based on priority, when unwanted events happened
• Involve in study, design, development and enterprise database architecture of the existing and new system
• Involve in infrastructure design for its scalability of the system using MS Clustering, Database Mirroring, SQL Always On, Replication, load balancing
• Setup, Installation, upgrade & migration from SQL Server older release to MSSQL Server current release. Migration of SQL Server 2005 and finally 2005 to 2008, to keep the latest products & features advantages and technical support from vendors.
• Database Maintenance and Troubleshooting
• Error log monitoring for MSSQL Servers/ Replication Servers.
• Database and Replication monitoring for optimal response and higher throughput using remote distributor
• Database Backup & Recovery of databases
• Performance & Tuning of SQL Servers/ Replication Servers, Databases, systems, Networking configuration (optimal) and query optimization using SQL Query Analyzer/SSMS.
• Configure, setup the log shipping/ Database Mirroring/Replication/ Clustering/ Disaster recovery in Lynda system.
• Involve in Design, develop and maintain logical/physical database model for new and existing system. Involve in Software Development Life Cycle for the existing and new systems.
• Involve in Database Source Code and versioning Control using Microsoft Visual Source Safe/TFS .
• Managed the off shore project & its team to design, develop, QA/test and launch the project in alpha stage

Confidential

Consultant SQL Database Administrator

Responsibilities:

• Installing, building, configuring, managing, upgrading, patching and trouble-shooting MicrosoftSQLServer 2008 /20012 & MS-SQLexpress 2008/2012 databases.
• Large scale DB data center migration on multi subnet windows cluster and bring them in Always on.
• Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.
• Migration of database from SQL 2005 to SQL 2015 and implement always on.
• Supporting applying patches, service packs, security fixes, routinesDBAtask, periodic refreshes in Microsoft DB environments.
• Support dealing with functional, developers and end users.
• Ensuring high availability in a mission-critical production environment in a 24x7 support environment (on-call, night-shift).
• Migrating, MSSQLinstances to new hardware and environments.
• Scheduling jobs, alerting for databases blocking, deadlocks CPU usage etc.
• Extensively working on administering 4 node SQLserver 2012/2008 cluster.
• Suggesting Disk Capacity, Processors and Memory based on the Capacity planning.
• Load Balancing & Scaling outSQLServer using SQL server transactional/Peer-to-peer replication.
• Perform Purge & Achieve procedures related to MS-SQLDatabase tables, Application and Customizations based on Purge & Archive Policy.
• Developing Database Backup Scripts and automate this process.
• Designed Disaster Recovery (DR) sites usingsqldatabase mirroring technologies and successfully conducting DR exercises / drills as part of recovery best practices.
• Implementing and monitoring MicrosoftSQLServer Application, Database, Data integrity, and overall security of the systems
• Creating and Implementing SSIS on SSIScatalog to extract data from various flat sources.
• Perform Customized Application source code deployment & version control.
• Maintain database Performance by following Tuning Methodologies
• Conform and abide by Change Control Procedures for applying changes/new additions to the Database, Applying patches, Application and any Software components on Test, Development and Production Instances.
• Reports problems to authorized vendors and follows-up.
• Perform Purge & Archive procedures related to MicrosoftSQLServer Database, Application and Customizations based on Purge & Archive Policy
• Carries out ad-hoc queries on the database requested by users and development staff.
• Ensures synchronization of database between HO and DR sites.
• Share point 2013 service application creation for the business intelligent application with SSRS and PowerPivot.
• Subject Matter Expert on all issues related to the Microsoft Technical Stack.
• Raising tickets Microsoft Support and using Microsoft support to resolve the bottlenecks in the database environments.

Confidential

Senior SQL Database Administrator and Middleware Administrator

Responsibilities:

• Planning, installing, configuring, and supporting SQL Server 2005, 2008 R2 and 2012 Clustering on Windows 2003 R2, 2008R2 and 2012.
• Implementing high availability with Always on Availability Groups and failover clustering.
• Implementing database Replication Snapshot, Merge and Transactional in 2005 & 2008 R2 environment and troubleshooting and fixing of replication synchronization, latency issues.
• Implementation of Mirroring, log shipping and replication and its support.
• Applying cumulative patches & Hot fixes. Installation & up-gradation of SQL server 2008R2 and 2012.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Configured instant Deadlock and Blocking Alerts using WMI in mailbox via Database mail.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Going through the clients’ requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Created and scheduled maintenances for disaster recovery method.
• Created and implemented silent installation tool for SQL Server for various clients.
• Migration of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP, DTS, SSIS and SQL server migration assistance utility.
• Identifying and tuning TQL queries and stored procedures that heavily using CPU and IO resources.
• Experienced in using tools like SQL Profiler, Windows Performance Monitoring utility and performance counters for monitoring and Tuning MS SQL Server Performance, Idera Diagnostic manager.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Installation, configuring and maintenance of SSRS2012, SSRS2008R2.Created automated tool for uploading and setting data source for newly releasing SSRS reports.
• Moving Report Server Database from one server to another.
• Created and Implemented live monitor of the performance of server through SSRS reports.
• SSAS analysis service implementation on 2005 and 2012 and works with development team for client business analysis.SSAS instance installation, deployment, creation of cubes and performance tuning of cubes MDX query.
• Manage Change and incident tickets by following ITIL.

Confidential

Consultant Senior SQL Database Administrator

Responsibilities:

• Working with DBA (Bank of America Corporation) Support Team that provides 24x7 production support for mission critical database environments.
• Experience in planning, installing, configuring, and supporting SQL Server 2008 R2 & 2005 Clustering on Windows 2008 R2 & 2003 Cluster environments
• Experienced in handling large database of size 5TB.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues
• Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
• Collaborate with developers, network administrators, system administrators to implement secure, reliable database environments. Datacenter Operation and Server Consolidation.
• To handle process user requests received through telephone and emails.
• Upgrade/Migration from SQL Server 2000, 2005 to SQL Server 2008 R2 using any suitable approach (in place or side by side).
• Running of performance monitor, SQL profiler, or querying server to identify performance problems on servers experiencing bottlenecks.
• Planning, administration, and implementing Replication between the servers.
• Hands on experience in configuring Database Mirroring and Ensuring High Availability to the databases by testing the failover
• Scheduling SQL server maintenance job through AUTOSYS.Manage Change and incident tickets by following ITIL.
• Analyze long running queries and tune the same to optimize application and system performance.
• SQL server & Database architecture and database maintenance, Creation of new databases and assign permission as per the user requirement, Decommission of instances and databases
• Handing disk space and SQL server critical issues, alert setup in SQL server for monitoring SQL server performance related issues.
• Applying cumulative patches & Hot fixes. Installation & up-gradation of SQL server 2005 and 2008.
• Backing up Transaction log file and database shrinking
• Experience in import & export, detach/attach, copy wizard & script databases
• Data compressions, online indexing, have hands on experience in Log Shipping High Availability Solution.
• Refresh databases to Development, QA, and UAT from Production for bug fixing and new Releases. Identify and fine tune database and query issues to ensure optimal performance and uptime.
• Deploy database scripts, SSIS packages, SSAS cubes, and reports to Production.
• Resolve database related issues and requests from the Development teams and Helpdesk.
• Configure third party tool Fog light for receiving SQL server alerts.Implementaion of Litespped backup tool.

Confidential, Edison, NJ

SQL Database Administrator

Responsibilities:

• Up gradation of Database from SQL Server 2000 to 2005 and SQL Server 2008 R2 Enterprise Edition.
• Database recoveries as per requirements. Conducted root cause and analysis for database incidents and problems.
• Installed and monitored database mirroring and log shipping in SQL Server 2005 and 2008.
• Implemented MS SQL Cluster (Active/Passive) Multi Node Cluster. Apply service pack or patch SQL Server 2008 in a clustered environment.
• Implementation of Peer-To Peer Transactional Replication in SQL Server 2008 and 2005 and its trouble shooting.
• Administer SQL Server Cluster, Replication Monitor, Consolidate and Migrate Database from server to another, Restore Database in the production environment.
• Test and apply new software and maintenance patches, including patch management services, complete security audits on a routine basis.
• Troubleshooting Performance Issues related to High CPU Usage, Memory, Disk, Blocking, and Deadlocking etc and provide recommendations observed to application team.
• Managing Index Fragmentation, Statistics, DBCC Consistency Checks through automated jobs on production servers.
• Expertise in using performance analysis tool such as, PAL, RML, SQL Nexus, APEX SQL Doc Etc, Idera SQL Diagnosis ManagerV6.6.Scanned the data pages, Indexes and checked the storage space used by each table.
• Developing and implementing DBA maintenance plan. Daily monitoring of MS SQL Server activity, error logs, NT event logs, space usage and security
• Managing database object permissions, user accounts and passwords.
• Configured database mail services for setting up alerts.
• Documenting MS SQL Server logical and physical design. Managing Transaction log files, User management, Backup and recovery methods using Enterprise Manager and Query Analyzer, SQL network configuration ( using Server / Client Network utilities), Database performance tuning, Trouble shooting database issues, SQL and T/SQL knowledge, Working with storage and other support teams to configure and manage data stores.
• Worked on Storage (SAN, RAID), VERITAS Net backup and work withDBAteamforproduction on call support rotation. Resolve Database related trouble tickets assigned to theDBAgroup.
• Assist Database Administrator in staff training, maintaining user controls, and installing new database applications. Monitor relational database to optimize database performance, resource use and physical implementation of database
• Advanced IIS 6 and .NET server administration and troubleshooting experience.

Confidential

SQL Database Administrator

Responsibilities:

• Responsible for installation, configuration, and maintenance of MS SQL 2000/2005/2008/2008 R2 Server in various environments.
• Responsible for Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Wrote stored procedures, checking the code for efficiency.
• Responsible for routine Backups and Restoration.
• Administration and Production support for various applications in all environments.
• Configuring, implement Merge replication in SQL server 2000 and Peer-to-Peer replication on SQL server 2005 and its trouble shooting.
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and
• Implementing these procedures.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the
• Logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Monitoring MS SQL Server performance and managing the use of disk space, memory and connections.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data.
• Sources, creating packages for different data loading operations for application.
• Running DBCC consistency checks, fixing data corruption on application databases.
• Monitor and tune SQL scripts. Creating upgrade scripts for Production database and supporting it.
• Auditing stored procedures for optimization and improving performance.
• Designed database maintenance plans, profiler and execution plans for stored procedure development and indexes for optimizing performance.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Worked to establish connectivity between VB applications and MS SQL Server by using ODBC.

Confidential

System Administrator

Responsibilities:

• Developed stored procedures and triggers.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Logical and Physical design of database for projects on basis of user requirements using Erwin
• Reporting on a weekly basis to the project manager.
• Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Moved the entire phase from the Staging to the Production.