SUMMARY:

• 10 years IT experience with 6+ years of experience in Database Administration for very large and complex databases in multiple versions like SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL Server 2017.
• Expertise in Database Administration on Production Servers with server Installations and configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Migration of databases from SQL Server 2000 to SQL Server 2005, SQL Server 2008.
• Worked on SQL Server 2012, 2014, and 2016 migration from SQL Server .
• Having Experience on Data center servers and handling over 4.4 TB databases
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Very good hands on experience on Replication for Load balancing and data autonomy
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals, Query Store and AAG.
• Performance Monitor PERFMON used to resolve system hardware bottlenecks and DBCC Utilities for database consistency checks.
• Extensively used Query Store and system counters to monitor bottlenecks on the Disk I/O and throughputs.
• Planning/implementing Security: create Logins, setup permissions and assign server roles and database roles as required following security best practice and standards.
• Worked on linked server to setup Heterogeneous connections coming to SQL Server from ORACLE, TERADATA, MS Access, DB2 etc.…
• Handling Memory configurations for all SQL Server versions
• Create Database Maintenance Plans, SQL Agent Jobs, setup Alerts, and Operators.
• Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, Disaster Recovery Planning and High Availability.
• Highly experienced in Table partitioning for data archiving, performance improvements and data purge.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
• Troubleshoot day - to-day production database issues.
• Proficient in performance of SQL Server software new installation and upgrades.
• On call Production DBA for 24 x 7 in an OLTP Mission Critical Systems/Environment.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Used and highly proficient in third party tools such as red gate, EMC Networker, PRTG, Solarwinds and Idera.

PROFFESSIONAL EXPERIENCE:

Confidential

Snr. SQL Server DBA (Consultant)

Responsibilities:

• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Implemented solutions to ensure point in time recovery with minimal to no data loss.
• Performed side by side migration from SQL Server 2008R2 to SQL Server 2014 using suitable approach with minimal down time on prod server
• Migrated legacy databases with an upgrade from SQL 2005 and 2008R2 to SQL 2012, SQL 2014 and 2016 with Always-On configuration installed and maintained as a HA/DR solution
• Worked extensively in automating process like creating jobs, DB refreshes, and error reporting using Alerts, SQL Mail Agent
• Resolving requests related to database and system issues raised by user support
• Performed Table Partitioning on a very large table.
• Conducted root cause analysis of database incidents and problems.
• Frequent SSIS and SSAS updates reviews and deployment including index designs to enhance performance in warehouse servers
• Planned and executed upgrades such as Service Pack, Hot fixes etc.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Anchored System database migrations and maintenance on both physical and virtual machines.
• Installed and configured SSIS and SSAS and supported Developers in identifying deprecated codes and deprecated features, deployment storage management and other duties associated with SSIS and SSAS under the capacity of a SQL Server Production DBA.
• Performed daily tasks including backup and restore for DB Refreshes by using third party tool like EMC Networker, SQL Server Management Studio and T-SQL.
• Managed and executed maintenance jobs that ensure the stability and performance of the database servers.
• Monitored multiple servers for resource utilization (disk space, memory, CPU, etc.).
• Supported applications by troubleshooting, diagnosing, and resolving database issues.
• Enforced Microsoft standards and best practice across enterprise databases.
• Used third party tool to compare DBs from different environment and make deployments to updates the later
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Experience with rebuilding the indexes and statistics update at regular intervals for better performance
• Responsible for full index optimizations on prod servers by identifying aggressive indexes, unused indexes, and index hoarders that are consuming space on the servers.
• Created, Tested and deployed Table partitioning Solution to improve I/O access and for data purge.

Environment: SQL Server 2008R 2/2012/2014/2016 , 2017 Enterprise, IIS, NETFramework4.5, Windows server 2008R2/2012R2 Server, Log Shipping, FCI Clustering, EMC Networker, SCOM, PRTG, SolarWinds MS Outlook 2013, Windows 7/8.1, HP ITSM, ATLAS

Confidential

Contract SQL Server DBA

Responsibilities:

• Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in SOX audits.
• Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active Cluster Nodes.
• Involved in Analyzing and Upgrading SQL Server 2000 test and production servers to SQL Server 2008R2.
• Have experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack updates across enterprise production environment.
• Designed robust backup strategy and implemented comprehensive Backup plan using Native SQL and Lite Speed.
• Resolved and tweaked memory pressures caused during production release.
• Worked with customers on Application rollouts and server migrations.
• Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014.
• Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.
• Strong experience in mentoring team members and writing documentation.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Responsible for DB Refreshes from Production to QA/Staging/Development based on user requests or Application team needs including data cleansing
• Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 3.8 TB to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data warehouse by SQL Server 2005 and 2008R2 Integration Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows Server 2008R2.
• Experience in Batch processes, Import/Export, Backup, Database Monitoring tools and Application support.
• Configured and maintained SQL Server 2012 and 2014 Always-On for HA and DR as clients BC strategy

Environment: SQL Server 2008R2/2014, IIS, NETFramework4.5, Windows server 2008R2/2012R2 Server, EMC Networker, PRTG, SolarWinds, Redgate, MS Outlook 2013, Windows 7/8.1.

Confidential, Dallas, Texas

Assistant Network Engineer

Responsibilities:

• Configure and install various network devices and services (e.g. routers, switches, firewalls, load balancers, VPN, QoS
• Perform Network maintenance and system upgrades including service packs, patches, hotfixes and security configurations
• Monitor performance and ensure system availability and reliability using PRTG o Monitor system resource utilization, trending, and capacity planning
• Provide Level-2/3 support and troubleshooting to resolve issues
• Work within established configuration and change management policies to ensure awareness, approval and success of changes made to the network infrastructure
• Select and implement security tools, policies, and procedures in conjunction with the company’s security team
• Liaise with vendors and other IT personnel for problem resolution

Confidential

Desktop Support Admin/Network Engineer

Responsibilities:

• Developed & executed scripted changes requests in accordance with change control procedures.
• Provide tech support via phone, the internet, or in person at the office
• Diagnosed software/hardware problems, responding quickly, clearly, and resourcefully.
• Installed and Microsoft Windows Servers as well as Windows Desktop OS
• Configured and constantly maintain Windows Active Directory.
• Upgrade of Database from SQL Server 2000 and 2005 to SQL 2008R2.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate approvers (if applicable).
• Conducted research and collaborated with vendor if necessary for additional patches.
• Provided stopgap solutions if possible and acceptable by business and application team
• Set up new user hardware such as Desktops, laptops, iPhones, iPads, and other peripherals
• Installed printers in remote and on-site locations
• Responsible for preparing broken mobile devices for repair as well as issuing temporary devices for users
• Provide daily customer support to users by troubleshooting issues both on site and remotely for company’s other branches
• Microsoft Windows Server Administration Windows 20
• Microsoft Windows Desktop Administration /Support/Configuration Windows 95/XP/7
• AD Support/Administration for Windows 2003
• Maintain Microsoft Windows Cluster Solutions for current OS and previous OS
• RSA Remote Access and System Management for Hardware Failures
• Service Desk Incidents / Tickets, Request Support System, Change Controls for Mission Critical Server Support