SUMMARY:

• Database administrator (DBA) with extensive experience designing, coding, testing and supporting next - generation database solutions in HIVE, Oracle and SQL Server environments. Proficient in an assortment of technologies, including Hadoop, Oracle, MS SQL Server, 2008,2012, 2016, SharePoint, JDBC, Sqoop, Pig, Oozie, Hue, mongodb, Windows and Linux
• Hadoop Administration
• Oracle Database Administration
• SQL Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• Windows Administration ( )
• Linux System Administration
• SQL Server 2017 on Linux, windows and Docker
• Python and R programing
• Big Data Queries and Interpretation
• Data Mining and Visualization Tools
• Business Intelligence (BI)

PROFESSIONAL EXPERIENCE:

Confidential

Hadoop Administrator

Responsibilities:

• Deploy and manage Hadoop Cluster using cloudera Manager
• Deploy and configure Cloudera Hadoop cluster in both AWS and Azure
• Manage, configure and administer Hadoop Cluster using HUE
• Hands on experience in installing, configuring, and using Hadoop ecosystem components like Hadoop HDFS, Yarn, MapReduce, HBase, Oozie, Hive, Sqoop, Pig, Flume, Storm, Kafka, Ranger and Knox, sentry,Hue
• Experience in integrating Hadoop Kerberos authentication infrastructure with Active directory
• Experience in managing and reviewing Hadoop log files, and UI for job analysis
• Experience in Ingesting data using Flume and managing KAFKA Cluster
• Writing Linux shell scripting for administration and troubleshooting
• Experience ingesting data from Confidential SQL and MySQL using SQOOP
• Experience in writing HIVE and PIG scripts
• Deep experience hortonworks and Amabri

Confidential

Sr. SQL Server Database Administrator

Responsibilities:

• Administrated SQL Server Databases for ASP.Net Application and SharePoint 2007/2010/2013 including planning, designing, developing and maintaining the databases
• Installed and administered SQL Server cluster Active/Passive on Confidential Windows Server 2012 on SAN environment
• Configured SQL Server 2017 on Linux for active directory authentication
• Troubleshooted performance problems, fine-tuning of databases and index Analysis, long running queries using DMV, Dynamic Management Function, SQL Profiler, performances monitor, wait statistics and third party tools
• Troubleshooted Memory, CPU, IO related issue using Wait statistics, DMV and Perf monitor
• Use SQL Server Extended events to troubleshoot various SQL Server issue, performance issue, connectivity issue, index fragmentation and abnormal database size growth
• Installed and configure SQL Server 20 and SQL Server 2016/17 in Development, test and Production servers
• Installed, configured and Managed SQL Server 2012/2016 Always-On environment
• Configure and manage SQL Server Failover clustering in Development, staging and production environment and monitor Databases in the cluster for security and performance issue
• Worked extensively on always on Clustering and server consolidation. Troubleshooting production issues and raising high availability
• Installed, configured and managed SQL Server on Linux for Always on cluster on public cloud and on premise
• Configured SQL Server 2016 always on windows with or without Active Directory
• Developed, deployed and administered SQL Server SSIS package in SQL Server 2008, SQL Server 2012 and SQL Server 2016
• Developed, deployed and administered SQL Server Reporting Server for SharePoint integration and standalone reports
• Install SQL Server SP and security updates on development, staging and production SQL Server environment
• Monitored Backup jobs for any issue and perform periodic restore to verify the backup files
• Configured and managed disaster recovery site and perform quarterly simulation of production failure

Confidential, Seattle

Database Administrator

Responsibilities:

• Designed, implemented and Administered SQL Server Transactional Replication between servers and databases
• Performed database administration activities including; installation, configuration, space management, database backup and recovery
• Configured and managed access for SQL server to various users group
• Performed routine server maintenance and implement infrastructure changes
• Maintained and monitored system for effective performance and troubleshoot performance issue
• Wrote deployment scripts using SQLCMD and windows scripting language for various deployment

Confidential, Washington

System Engineer,

Responsibilities:

• Database administration for SQL Server 2000/2005 including database backup/restores, log shipping
• Administration, managing, troubleshooting and tuning SQL Server reporting and Integration services
• Monitor and optimize system performance using index tuning, disk optimization, query optimizations, and other methods of Confidential SQL server
• Troubleshoots and resolves problems related to the ASP.NET Websites, network and server environment
• Administered NLB clusters, set up websites, analyzed and resolved issues
• Performed installation, configuring, and administration of the systems on test, and production servers including SQL Server Failover clustering, log shipping and replication