We provide IT Staff Augmentation Services!

Consultant - Engineering Resume

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

DBA

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.

Hire Now