Sign in

Sql Server Windows

Frisco, Texas, United States
April 03, 2018

Contact this candidate





MOBILE: +1-650-***-****


Around 8 years of extensive experience in the IT industry with years of expertise in SPLUNK, LINUX/UNIX, PLSQL. Monitoring, Data Analytics performance tuning Troubleshooting and Maintenance of Data Base.

5+ years of experience as Splunk Developer performed activities including requirement analysis, design, and implementations of various client server-based applications using Splunk 5.x./ 6.x.

Expertise in Installation, Configuration, Migration, Trouble-Shooting and Maintenance of Splunk, Passionate about Machine data and operational Intelligence.

Creating accurate reports, Dashboards, Visualizations and Pivot tables for the business users.

Installing and using Splunk apps for UNIX and Linux (Splunk nix).

Extensive experience and actively involved in Requirements gathering, Analysis, Reviews.

Implemented workflow actions to drive troubleshooting across multiple event types in Splunk.

Experience on Splunk Enterprise Deployments and enabled continuous integration on as part of configuration (props.conf, Transforms.conf, Output.confg) management.

Experience with Splunk Searching and Reporting modules, Knowledge Objects, Administration, Add-On’s, Dashboards, Clustering and Forwarder Management.

Created and Managed Splunk DB connect Identities, Database Connections, Database Inputs, Outputs, lookups, access controls.

Expertise Splunk query language and Monitored Database Connection Health by using Splunk DB connect health dashboards.

Collecting detailed usage of Amazon Web servers.

Experience with Splunk technical implementation, planning, customization, integration with big data and statistical and analytical modeling.

Worked on log parsing, complex Splunk searches, including external table lookups.

Experience on use and understand rex, Sed, erex and IFX to extract the fields from the log files.

Experience on Splunk data flow, components, features and product capability.

Experience on Splunk search construction with ability to create well-structured search queries that minimize performance impact.

Installed Splunk DB Connect 2.0 in Single and distributed server environments and Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.

Created clustered and non-clustered indexes for increasing the performance, also monitored the indexes by troubleshooting any corrupt indexes by removing fragmentation from indexes.

Worked on the version control tools like GIT


Splunk Modules: Splunk 5.x/6.x, Splunk Cloud, Splunk DB Connect, Splunk Enterprise, Splunk on Splunk, Splunk IT Service Intelligence, Splunk Web Framework.

OS: Red Hat Linux 4.x/5.x/6.x, Unix (Sun Solaris,Aix,HP)

Windows 8.1/7/XP.

RDBMS: Oracle 12c/11g/10c, MS-SQL Server 2014/2012/ 2008R2, Sybase, DB2 MS Access.

Languages: C, LINUX Shell scripts, JAVA, Python, Pearl, SQL, Oracle.

Tools: Splunk, Java, SQL, T-SQL.

Web Tools and Languages: Java Script, JDBC, Servlets, Python, XML, HTML5.

Application Servers: Server 8.x./9.x/10.x, Apache Tomcat, JBoss 5.x/6.x, Oracle.



Splunk Consultant

Roles & Responsibilities:

Installation of Splunk Enterprise, Splunk forwarded, Splunk Indexer, Apps in multiple servers (Windows and Linux) with automation.

Install and maintain the Splunk adds-on including the DB Connect, Active Directory LDAP for work with directory and SQL database.

Configure the adds-on app SSO Integration for user authentication and Single Sign-on in Splunk Web.

Configure and Install Splunk Enterprise, Agent, and Apache Server for user and role authentication and SSO.

Manage Splunk configuration files like inputs, props, transforms, and lookups.

Upgrading the Splunk Enterprise to 6.2.3 and security patching.

Deploy, configure and maintain Splunk forwarder in different platforms.

Ensuring that the application website is up and available to the users.

Continuous monitoring of the alerts received through mails to check if all the application servers and web servers are up.

Create Splunk Search Processing Language (SPL) queries, Reports, Alerts and Dashboards.

Worked on various defects analysis and fixed them.

Problem record analysis and solution providing.

Field Extraction, Using Ifx, Rex Command and Regex in configuration files.

Creating Reports, Pivots, alerts, advance Splunk search and Visualization in Splunk enterprise.

Provide power, admin access for the users and restrict their permission on files.

Developed Splunk infrastructure and related solutions as per automation tool sets.

Installed, tested and deployed monitoring solutions with Splunk services.

Provided technical services to projects, user requests and data queries.

Implemented forwarder configuration, search heads and indexing.

Supported data source configurations and change management processes.

Analysed and monitored incident management and incident resolution problems.

Resolved configuration-based issues in coordination with infrastructure support teams.

Maintained and managed assigned systems, Splunk related issues and administrators.

Performed Splunk administration tasks such as installing, configuring, monitoring and tuning.

Active monitoring of Jobs through alert tools and responding with certain action w.r.t to logs, analyses the logs and escalate to high level teams on critical issues.

Worked on log parsing, complex Splunk searches, including external table lookups.

Configured and administered Tomcat JDBC, JMS and JNDI services.

Designing and maintaining production-quality Splunk dashboards.

Splunk configuration that involves different web application and batch, create Saved search and summary search, summary indexes.

Deployed applications on multiple WebLogic Servers and maintained Load balancing, High availability and Fail over functionality.

Involved in monitoring the ticketing tool and taking the ownership of the tickets.

Created Crontab scripts for timely running jobs.

Developed build scripts, UNIX shell scripts and auto deployment processes.

Provided 24/7 on-call Production Support.

Environment: Splunk 6.x, Tomcat 7.x, JBoss 7.x, BIGIP Load Balancers, SAML, Wily Introscope 6.0, Configured plug-ins for Apache HTTP server 2.4, RedHat Linux 6.x, JDBC, JDK1.7, J2EE, JSP, Servlets, XML, Oracle 11g, SVN, CVS.

Discover Financial Services, Riverwoods, IL SEP 2013- MAY 2015

Splunk Developer

Roles & Responsibilities:

Created Dashboards, Visualizations, Statistical reports, scheduled searches, alerts and worked on creating different other knowledge objects.

Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Universal and Heavy forwarder.

Provide Regular support guidance to Splunk project teams on complex solution and issue resolution.

Worked on installing Universal Forwarders and Heavy Forwarders to bring any kind of data fields in to Splunk.

Designing and maintaining production-quality Splunk dashboards.

Involved in admin activities and worked on inputs.conf, index.conf, props.conf and transform.conf to set up time zone and time stamp extractions, complex event transformations and whether any event breaking.

Integrate Service Now with Splunk to consume the alerts from Splunk and create service now tickets.

Splunk DB Connect 2.0 in search head cluster environments of Oracle, MySql.

Analyzing Oracle audit trails sent through syslog by using Oracle Audit Trail.

Supporting and maintaining a Splunk cluster infrastructure in AWS cloud environment.

By using AWS collect detailed billing data and in depth analysis of Amazon Web server.

Integrated Service Now with Splunk to generate the Incidents from Splunk.

Using Cisco Networks App includes dashboards, data models and logic for analyzing data from Cisco IOS, IOS XE, and NX-OS devices.

Environment: SPLUNK 5.x,SPLUNK 6.0, Linux, Windows Server 2012, 2008, SQL, Splunk Enterprise Security, ESX, Applications Development, Big Data Analysis, operations analysis.

Ecolab, St Paul, MN MAR 2011- JUN 2013

Splunk Admin

Roles & Responsibilities:

Installation, configuration and deployment of Splunk Forwarders, indexers, search heads and deployment server.

On boarding of new data into Splunk. Troubleshooting Splunk and optimizing performance.

Use Splunk Enterprise Security to configure correlation search, key indicators and risk scoring framework.

Configuration and deployment of Splunk forwarder, search heads, indexer and deployment server.

Work with Splunk GUI, command line interface and directly with configuration files.

Configured Splunk multisite indexer cluster for data replication.

Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.

Have Knowledge in various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries table etc. and difference between event stats and stats.

Experience in working with Splunk authentication and permissions and having significant experience in supporting large scale Splunk deployments.

American Greetings, Cleveland, OH NOV 2009- FEB 2011

PLSQL Developer

Roles &Responsibilities:

The Responsibilities included in understanding the Issue by having conversation with Business users and owners.

Developing packages, procedures, functions, and triggers for the application.

Coordinates/ facilitates transition (planning, sign-off, team meetings, and escalations).

Involvement in Production Change Management & Release Coordination.

Writing technical documents using the functional specifications

Identifying and tuning costly queries.

Writing PL/SQL stored procedures, functions, triggers to meet new features to be incorporated in the system to implements business rules.

Code review & Packaging DB Scripts.

Mentored junior programmers in Oracle database design and development

Trouble shooting for the end users requirement and Optimizing Queries

Created many triggers for audit purpose.

Using UNIX environment for performing the testing.

Performing the tests on the newly coded procedures and documenting the same.

Implemented reports in HTML pages.

Environment: Oracle 9i and10g, PL/SQL Developer, UNIX Shell Scripting.

Synergy Solutions Pvt LTD, India DEC 2008- OCT 2009

SQL DBA Developer

Role &Responsibilities:

Primary responsibilities include profiling, performance tuning & redesign, high availability server network and disaster recovery.

Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.

Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment

Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.

Extensively worked on SQL Server Integration Services (SSIS).

Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.

Solving the Bugs Reflected by the Testing team.

Rebuilding the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2003, SFTP, Microsoft Integration Services.


Bachelor of Technology from Jawaharlal Nehru Technological University (JNTU) Hyderabad, India.

Masters in Computational Science from Texas A&M University, Commerce,Texas.

Contact this candidate