SUMMARY:

• Over 9 years 10 Months of experience in SQL Database Administration, System Analysis, Design & Support of MS SQL Servers in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Servers.
• Experience in upgrading SQL Server versions.
• Good experience with SQL Server online Indexing and Recoveries features.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience in Data Migration Management.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de - fragmentation, re-indexing and update the index statistics.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Experience in migrating packages from DTS to SSIS.
• Good experience with Integration Services, Analysis Services, Reporting Services, and SQL Server Clustering.
• Experience in Team Management (SQL & Oracle Teams) and ITIL process.
• Good understanding of Hadoop/Hbase architecture.
• Hadoop/Hbase standalone/Pseudomode installation and configuration
• Hadoop/Hbase High Availability Installation and configuration
• Monitoring and Troubleshooting Hadoop/Hbase cluster environment.
• Performing Sanity, Regression and SI testing for Hadoop/Hbase Application
• Installation and Configuring Cloudera and Horton works Hadoop servers
• Performed administrative tasks on Hadoop Clusters using Cloudera/HortonWorks

TECHNICAL SKILLS:

Languages: C, C++, Java, SQL.

Operating Systems: Windows Server 2000/2003/2008/2008 R2/2012

Operating Systems: RHEL 6.4, 6.6, 7(basics)

SQL Server: 2000, 2005, 2008, 2008 R2, 2012 & 2014

Hadoop: Hadoop 1.x, 2.x

Hbase: Hbase0.98, Hbase 1.0.1

Oracle: Oracle 11gR2, RAC, ASM, RMAN (Only )

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Hadoop 1.x, Hadoop 2.x, Hbase 0.98, Hbase1.0.1, Linux6.4

Consultant - Engineering

Tools: Jira, Bug zilla

Responsibilities:

• Installation, Configuration and Troubleshooting Hadoop standalone/pseudo mode servers
• Performing Sanity, Regression and SI Testing for Hadoop/Hbase application
• Setting up and Configuring Hadoop/Hbase clusters
• Monitoring and Troubleshooting Hadoop/Hbase clusters
• Scaling up data nodes from 4 to 8 Nodes
• Monitoring & Troubleshooting MapReduce jobs
• Backup & Recovery of NameNode,Hmaster & Data Node servers
• High Availability Installation/Configuration and Testing for NameNode,Hmaster,Zookeeper,JournalNode
• Assisting Team members on Hadoop & Hbase Technologies

Confidential

Technology: SQL Server 2008 R2, SQL server 2012 & SQL server2014

Consultant - Engineering

Tools: Jira, Bug zilla

Responsibilities:

• Supporting Production, Development and Testing Environments
• Capacity Planning & build sql server & Databases for Production, Development & Test environments
• Performing Database Testing
• Installation, configuration and troubleshooting of 2012
• Monitoring and Troubleshooting Maintenance and Application jobs.
• Troubleshooting security issues.
• Performing Sanity, Smoke, Regression and SI Database Testing for applications
• Testing on Performance of the databases for the applications
• Comparing schema & Data on databases/sql servers
• Preparing and Executing Test cases/scenarios for DB testing
• Helping QA team in database bug fixing.
• Performing testing on Stored Procedures and T-SQL queries.
• Configuring and Monitoring Resource governor
• Configuring and Monitoring SQL Server & Database Audit.
• Grant privileges to users to access systems and databases.
• Establishing connectivity to databases and monitoring system performance
• Using Enterprise Manager and Query Analyzer to optimize the data flow
• Troubleshooting performance issues using DMV’s, Profiler and Perfmon.
• Performing Index tuning, Query tuning and application tuning.
• Writing T-SQL queries for Archival processes, Fine tuning procedures.
• Troubleshooting CPU, Memory& IO issues.

Confidential

Technology: SQL server 2000, 2005, 2008, 2008 R2, 2012

Database Consultant/Team lead

Tools: BMC Remedy v7, Lotus 6.5.

Responsibilities:

• Supporting Production, Development and Testing Environments for 18 Clients.
• Maintaining team and satisfying the business requirements of the clients.
• Installation, configuration and troubleshooting of SQL Server
• Configuring high availability solutions (Log shipping, Database Mirroring, Replication) and monitoring them.
• Installing, Configuring and Troubleshooting AlwaysOn
• Monitoring and Troubleshooting Cluster servers (Active/Active, Active/Passive).
• Monitoring and Troubleshooting Maintenance and Application jobs.
• Running imports/export utilities, off-line backup, on-line backup various SQL server Applications utilities.
• Working on DTS, Import and Export utility, BCP Utility and replication tool.
• Troubleshooting security issues.
• Grant privileges to users to access systems and databases.
• Establishing connectivity to databases and monitoring system performance
• Using Enterprise Manager and Query Analyzer to optimize the data flow
• Setting up standby server, DR servers and monitoring them.
• Troubleshooting performance issues using DMV’s, Profiler and Perfmon.
• Performing Index tuning, Query tuning and application tuning.
• Performance Monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance.
• On call for the production database.

Confidential

Technology: SQL Server 2000, 2005, 2008

Tools: SCOM Console, Remedy

Responsibilities:

• Data Manipulation using Remedy Tickets
• Production On-Call Support
• Release Deployments
• Job Monitoring and Troubleshooting
• Emergency Bridge Management
• Resolving Disk Space Alerts
• Storage Requests
• Changes in schema of articles involved in Replication through Release
• Data File Addition/Shrinking
• DBCC Commands
• Performance Monitor, Perfmon
• Liaison with Microsoft
• SQL Profilers usage for Troubleshooting Issues
• Performance Tuning
• Database Archival
• Hot Fix and Service Packs installation specific to SQL Server/Oracle
• SQL /Oracle Cluster monitoring and troubleshooting
• Pre and Post work for Rebooting Servers
• Replication Implementation and Troubleshooting
• Log Shipping Implementation and Troubleshooting
• Oracle Startup and Shutdown every weekend
• SBO Support / Archiving (Oracle)
• OTS Monthly Refresh (Oracle)

Confidential

Technology: SQL Server 2005, 2000

DBA

Responsibilities:

• Backup client databases and perform database restore from SQL Server.
• Troubleshooting any SQL related issues in Client Servers.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends.
• Creating users and giving appropriate permissions.
• Maintenance of Log shipping.
• Ensuring right privileges are given based on role and group.
• Complete Documentation about the database
• Recovering the databases from backup in disasters

Confidential

Technology: SQL Server 2005, 2000

DBA

Responsibilities:

• Installing SQL databases
• Providing access to databases, as needed.
• Creation of user database, users and assigning roles to the users
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Make sure daily, weekly database backups are archived on File servers, as per the Maintenance plan.
• Recover databases in case of any crashes.
• Ensuring high availability of the database exploiting the concepts of replication and log shipping.