EXPERIENCE SUMMARY:

• IT Professional with Over 9 years of Administrative Experience in MS SQL Server 2014/ 2012 / 2008 R2 / 2008 / 2005 systems in OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2014, 2012, 2008R2, 2008, 2005 and associated database tools, updating with latest service packs, hot fixes and security patches.
• 3+ years' experience with Windows Server 2008/2008R2/2012/2012 R2
• Hands on experience on SQL Server Cluster and Always on High availability in SQL Server 2012
• Extensively worked on Active - Active and Active-Passive Clustering.
• Extensively used the native tools like an index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the database manually and by scheduling the jobs and Maintenance Plans.
• Experienced in customizing of Skins in SAP CRM
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for user's transaction, login and database action and removing orphan users.
• Strong experience in mentoring to team members, documentation and 24/7 on call production support.
• Implement and manage SQL Azure database for cloud server
• SQL Server new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in handling the Change Data Capture (CDC) with different retention time.
• Experience in SQL Upgrades SQL 2008 to 2012 and Building SQL Clustering.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Extracted data from internal data warehouse system to SSRS.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, MongoDB, Oracle

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager. Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSAS

Programming Languages: SQL, T-SQL, XML, PL/SQL.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 4.0, Linux, Novell Netware, MS-DOS.

WORK EXPERIENCE

Confidential, New York City, NY

Senior SQL Server DBA

Responsibilities:

• Migration of SQL Server 2008 to 2012/2014, SQL Server 2005 to 2008 in clustered and non-clustered environment.
• Administering and Maintaining SQL Server 2014, 2012, 2008, 2005 on Development, QA and Production environments.
• Implemented, and administered Windows Server 2012 R2/2008/2003 Servers in the Environment.
• Experience working as a Mentor to employees within the DBA group and other groups within IT, offering guidance and sharing business and technical knowledge.
• Analysing problem and Handling Tickets of SAP ISU CS / CRM
• Experience working with 24 x 7 on call environments.
• Customized the Tableau landing page with site listing as icons and descriptions
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau.
• Installed, Configured and Maintained Active/Passive and Active/Active clusters to provide High Availability for SQL Server 2012 Always on.
• Migrated databases to cloud environment on Microsoft Azure with MongoDB
• Installed and Configured Transactional and Snapshot replication to replicate data to OLTP and Data Warehousing.
• Creating, Maintaining Database Maintenance Plans and experience performing load and stress testing for large databases.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Configured Database Mirroring to maintain High Availability at database level.
• Implemented, scheduled and supervised backup and recovery tasks.
• Involved in Creating tables, indexes and designing constraints.
• Experience scripting Disaster Recovery Plan, testing, analyzing and continuously updating it with documentation.
• Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.
• Expert in implementing business logic and procedure in the backend using complex stored procedures and functions.
• Installed SQL Server hot fixes and patches

Environment: Microsoft Windows Server 2012/2008/2008 R2/2003 32/64 bit, Microsoft SQL Server 2014/2012/2008/2005/2012 Always on and Visual Studio 2008/2005, Reporting Services, Integration Services

SQL Server DBA/ Developer

Confidential, Greensboro, NC

• Maintained a stable process of database refresh from production to internal environments.
• Installed Configured and Maintained deployments for SQL 2008,2008r2 and 2012r2
• Responsible for Setup, configuration, maintenance of SQL Servers and their Mirroring.
• Ensured the integrity and security and auditing the SQL Servers.
• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments.
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Configuring log shipping and replication
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Worked on Virtual Servers.
• Involved in CDC (change data capture) and CT (change tracking) process.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configuration of Log shipping and Replication
• Experience with PowerShell Scripting
• Configuration of Mirroring (Synchronous &Asynchronous)
• Created Linked Servers between SQL Server 2008 and OLE DB data sources.
• Creating and scheduling maintenance plans which include Database Backups database maintenance checks like shrink database, re-organizing and rebuilding of Indexes

Environment: Windows 2003/2008/2012 server, Unix, Linux, MS SQL Server 2005/2008 R2, 2012,MS Access, T-SQL, Oracle 11g, MS Excel, Virtual Machines, Performance analyzer and SQL developer

Confidential, NYC, NY

SQL Server DBA

• Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Good experience in analyzing the execution plan and index management for better Query Optimization.
• Good experience in identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Proactively identify missing indexes and create them as necessary after testing to improve query performance.
• Use of SCOM, Redgate Database tools set solution to improve the performance of the SQL Server.
• Work with developers to implement best practices while programming database objects. Worked with them to optimize database before releasing it to into production.
• Involved in General Database Administration, Query Performance tuning.
• Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.
• Created databases, logins, roles and granted appropriate permissions.
• Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Supported 24*7 production support and solved all kinds of critical problems.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Setup Log Shipping and Mirroring for day one critical database as a High Availability Solution.
• Setup Replication (both Transactional and Merge replication) for multiple point of presence for Stock Trading Firm business data.
• Setup, implement, and maintain Access Control as per industry standards in database management.
• Created Database Maintenance Plan for the Performance of SQL Server 2012 which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Environment: T-SQL, SQL Server 2005/2008R2/2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate, Spotlight, SCOM.

Confidential

Associate Technical Architect (SQL Server DBA)

Environment: Windows 2003, Windows 2008, MS SQL Server 2000, 2008 R2, 2012 Clustered environment

• Installation / Administration and Configuration of SQL Server 2008 R2 in clustered environments and proficient in SQL Database Administration
• Upgrading databases with new code drops/maintenance releases
• Installation of IIS6.0/7.0 on windows server 2003/ 2008
• Troubleshooting application & environment level issues
• Install and configure application and databases on SIT, V&P, UAT, DM, DR and PROD environments
• Involved in design and implementing Disaster Recovery (DR) procedures through HA techniques for CBFO (Component Based Failover)
• Managing the users with required levels of privileges of access
• Pro-active database monitoring and maintaining the backups and perform optimization
• Migrating databases and its objects between multiple servers across development and production platforms
• Managing detailed cutover/ go-live plans and act accordingly
• Production Support 24/7 as a part of 4th Line support
• Monitoring constantly growth of databases and transaction logs, change of server configuration, database settings
• Experience in performance Monitoring and Tuning, DMVs/DMFs, System Monitor(Perfmon), DBCC Utilities, Database Tuning Advisor Tuning Wizard, and SQL Profiler
• Tested and implemented Log shipping solution for MS SQL server 2008 R2 databases
• Experience in database backup and recovery, security and Data Transformation services(DTS)
• Performance analysis of Volume and Performance testing (V&P) results

Confidential

SQL Server DBA

Environment: Windows 2003, MS SQL Server 2008, Load Runner 9.5

• Monitoring and analyzing the performance of the various servers and troubleshooting based on the client requirements
• Backup databases and perform database restore and run consistency checks from SQL Server and application
• Monitor the status of maintenance jobs schedule to run daily and on weekends
• Rebuilding the indexes at regular intervals for better performance
• Monitored and modified performance using execution plans and Index tuning
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Regular checking of the database consistency using DBCC commands to minimize complexity
• Checking the OS Event Logs, SQL Server Logs, and Security Logs to identify the occurrence of any unusual events
• Verifying all scheduled jobs have run successfully
• Monitoring the DB server disk space
• Periodically monitoring the performance using both System Monitor and Profiler
• Monitor and identify blocking issues using Enterprise Manager/Management Studio
• Verifying the Backups and backup file size on weekly basis