DBA/Lead Resume

SUMMARY:

8+ years’ experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012
Experience in Hadoop ecosystem - HDFS, YARN,Sqoop, Pig, Spark and Hive for data analysis, using GRUNT shell
ESB- Enterprise Service Bus. Monitoring and Administration of Middleware connecting core business systems
Experience in Disaster Recovery Planning, Execution and Testing at remote site
Experience in using SQL Server Tools like Import/Export Wizard, SQL Profiler and SQL Query Analyzer .
Configured and implemented High availability (Always-On) SQL Server solutions, including Replication Models (Snapshot/Transactional/merge)
CYBER SECURITY modelling and installations, firewalls, proxy servers and DMZ

PROFESSIONAL EXPERIENCE:

Confidential

DBA/Lead

Performed major migration of 10 major databases, logins and objects from server-(completed July 2015)
Configured and installed SharePoint 2013 farm and its component applications and databases(December 2016)
Configured and testing ESB security and proxy server settings including use of demilitarized zoning( DMZ )
Experience in building Pig scripts to extract, transform and load different file formats- JSON, TXT, XML data onto HDFS, and Hive for data processing.
Used SQL Indexes for improving query performance, lower storage and maintenance cost
Experience in optimization tools such as SQL Profiler, cyber security configurations, windows Performance Monitor, using virus scans and Datacenter controls
Wrote Map Reduce jobs using Pig Latin , Sqoop
Team lead in maintenance configuring , architecture and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances
Configured Application Databases and designed , modelled database, tested functionality of data for point of sale application
Experience in Hadoop ecosystem- HDFS, YARN, Pig , Spark and Hive for data analysis
Enterprise service bus (ESB) messaging of both test and production environment
Analyzed data using Hive queries and running Pig scripts to study customer behavior.
Project manager in installing Always On solution for high availability
Configured Data Warehouse for Purchasing department , for immediate user/transaction and storage of large data
Server security by assigning logins, server and database roles and server permissions, hardening of database server
Participated in Disaster prevention and Recovery Strategies and supported High availability components.

Confidential

Database Administrator -MS SQL

Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans
Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server
Migrated SQL databases and also performed upgrades and updates of SQL server
T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments
Secured the database environment using various security measures e.g. encryption, user lists
Created Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications
Involved in automation of administrative tasks like creating job s, schedules, alerts using SQL
Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail
Extraction, Transformation and Loading (ETL Tools) data using DTS/ SSIS Import/Export utility

Confidential

Junior Database Administrator

Install SQL server in Cluster and upgrade SQL server from SQL 2000 to SQL 2005
Set up log shipping and management strategy and Capacity planning
Proactively monitor, tune and improve Database Performance
Strong ability to Identify/ troubleshoot problems and resolve real-time database issues
Conduct performance tuning for applications, using DMV, SQL profiler, DTA etc.
Perform database Backup and Recovery of production databases
Automate DBA activities to help ensure the high availability of the server
Implemented stored procedures, triggers and views to implement business rules
Automate DBA activities to help ensure the high availability of the server

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship