Sql Server Service
Resume:
Bishnu Thapa
**********@*****.***
Work Authorization: US Citizen
Summary:
Strongly skilled and years of experience in IT industry. System Software Engineer with strong experience managing server infrastructures, database, Patched release, Technical support, Lab support, QA and data-center operations across Linux and windows platforms. Effectively plan, install, configure and optimize IT infrastructures to achieve high availability and performance.
Highlights of IT Skills:
Technical Prod support Database Patched Release
Security patch update Systems Installation,Configuration & Upgrading
. System Infrastructure & Support. Data Center Lab Support
Quality Assurance & Product Support (QA) for Enterprise Cloud Services
•Providing technical solutions for enterprise cloud component deployed WebLogic & Toolchains for Enterprise Cloud service cloud release and Managed the virtual Private cloud in productions environment both public sector/commercial.
•Managing server, VM ware, Storage and Data center in Enterprise Cloud Service.
•Experienced in Unix / Linux /Weblogic/Apache web Server, windows and Sql database in productions environment.
•Worked with web logic, apache and Sasu server production issues and Performed design and code reviews.
•Setup infrastructure for Enterprise cloud service.
•Exprianced in Virtual private cloud Oracle Database Management and Monitoring Tools.
•Provide support in application server (Oracle WebLogic Server),Apaches and Tomkcats for Enterprise Cloud service.
•Installed oracle software and Supported to the lab student for Lab work.
•Worked on administration tasks such as Data and Ability to deliver comprehensive BI through MS solutions including MS Excel, CSV, SAS, Text and excel.
•APIs for all CRUD operations (Create, Retrieve, Update, Delete).Created scripts for creating API user, token, server management, developed the test cases for API and conducted testing.
•Tested software and hardware features for the Helion Managed Private Cloud
•Adopt at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression testing.
•Performed Smoke Testing Basic Validation and Run the smoke tests specified for enterprise service release.
•Experienced in creating, reporting, and managing software defects to software developers.
•Performed DBA script to enterprise cloud service for customer portal issues in productions.
•Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
•Expert in using MS SQL Server tools SSIS, SSRS for high priority projects.
•Fluid understanding of multiple programming languages, including C#, C, C++, JavaScript, HTML, and XML.
•Worked with on-shore and off-shore developers for bug fixed.
•Leader and manage the team meetings with effectively in Enterprise Cloud service productions cloud around the global team.
Education:
Regis University, Denver, CO
MS, Computer Information Technology
Technical Skills:
Languages:
Open stack, Java,SQL,Oracle,Visua basic C++, HTML and XML
Software/Databases: CSA, API rest client,MS SQL Server7/2005/2008, 2008 R2, ETL Server, Access, SSRS, SSIS, Visual, Jenkins, Chef, Oracle Siebel, DataCenter Monitoring tool- Nagios, OEM, ETL, EAI, Citrix, HPSA tool and HP Reporter,RWS Server, VPC JIRA, MS Office home 365,JBoss,Tomcat and TFS Server
Operating Systems: Windows NT/2000/XP, MS-DOS, Unix, Linux,Windows Server2003
Testing Tools: Quality center, Load Runner, REST client and HP ALM
Professional Experience
Systems Software Eng. HPE, Roseville, CA Feb 2012- Present
HPE Helion Managed Virtual Private Cloud (VPC) bring servers, storage, network, software, and security together into an optimized and efficient resource pool. Managing Cloud infrastructure, servers, network, storage and other Cloud components and maintenance.
Deployed WebLogic & Toolchains for patches release and supported for Enterprise Cloud service customers in resolving their issues and Managed for Enterprise Cloud service for customer both public sector/commercial.
Working knowledge of platforms (Wintel, Linux and Virtualization), networking components (TCP/IP, DNS, and VLAN) and database environments
Performed DBA script for Enterprise Cloud service in production issues.
Check out code java files on SVN rebuilding ECS build and deployment for debugging
Experienced working in Unix / Linux, VM, API, Weblogic, Tomcat and Oracle Sql/sql database for troubleshooting productions issues.
Installed VM infrastructure for Enterprise cloud service.
Exprianced in enterprise cloud service provisioned oracle GRID via the ECS Tool Chain and the Oracle GRID functions providing network and storage support for the Oracle RDBMS.
Provide support in application server (Oracle WebLogic Server),Apaches and Tomkcats for Enterprise Cloud service.
Experienced in software and hardware issues for a server and productions issues.
Knowledge and experience working with cloud security/FedRAMP.(i.e state and federal gov)
Wrote and executed the test plan and test Case using Quality center/ALM (Application)
Set up environments for development, functional testing and integration testing.
Created scripts for API user, token, server management, developed the test cases for API and conducted testing.
Tested software and hardware features for the Helion Managed Private Cloud
Adopt at using both manual and automated testing tools to troubleshoot systems and Performed Smoke Testing Basic Validation and Run the smoke tests.
Creating, reporting, and managing software defects to software developers.
Maintained multiple production, QA, wrote test plan and tested during patches release
Responsible for software testing of enhancements of backend testing applications, and web logic.
API testing using rest client
Created scripts for API, developed test cases for API and conducted testing.
Supporting ECS-VPC customer for creating users for use with API and VPC
Gather and document behavioral and technical requirements
Wrote and executed Test Plan and Test Case using Quality center/ALM (Application)
Experienced with strong debugging skills across logs, databases and browser developer tools.
Worked with offshore development teams from different time zone, facilitated review and support sessions.
Self-motivated individual, able to work independently, in coordination with a team.
Volcano Corporation, Rancho Cordova, CA Dec 2011-Jan 2012
SQL Server/Tech Support
Volcano Corporation is revolutionizing the medical device industry with a broad suite of technologies that make imaging and therapy simpler, more informative and less invasive.
Responsibilities:
•Installed & configured database software, associated database tools and performance monitoring software.
•Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
•Experience in database Backup, Recovery, and Disaster Recovery procedures.
•Scheduled Jobs and Alerts using SQL Server Agent.
•Worked with Indexing, Statistics, Locking and Blocking on queries and adding scheduled jobs to re-index and update statistics in databases.
•Supported Production Environment, UAT, Test and Development Environment.
•Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.
•Conducted root cause and analysis for database incidents and problems.
EagleEye Analytics, Columbia, SC Apr 2011 – Oct 2011
SQL Server DBA
EagleEye analytics enables insurances companies to achieve underwriting excellent and greater profitable by optimizing risk selection and pricing. Preparing data for Talon involves gaining a thorough understanding the client's objectives and raw data in order to create a repeatable data transformation procedure for converting the data into a Talon compatible format.
Responsibilities:
Installed & Configured database software, associated Database tools, Backup and Restore Procedures (used third party tool Red gate).
Upgrade database from SQL Server 2005 and 2008.
Monitored data activities (i.e. database status, logs, space utilization, extents, locks and long transactions) a
Skilled in SQL 2005/2008 Business Intelligence tools, Data Warehousing and ETL processes.
Deliver comprehensive BI through MS solutions including MS Excel, CSV, SAS, Text and excel.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
Worked in a team of database developers to support the Business Intelligence and data services needs of the enterprise.
Managing FTP Server and TFS Server for creating solutions for SSIS packages.
Various system into the Enterprise SQL Server Database using SSIS packages containing tasks, transformations.
Performed backup and recovery and Setting up efficient backup strategy using the Red gate backup tool.
Environment: MS SQL Server 2008, SSIS, RED GATE, Quest Spotlight, TFS, Visual Studio, Stat Transfer and Window 2003
IMFLASH Technology, Lehi, UTAH Aug 2007 – Sep 2008
MT Support
One of the world's leading providers of advanced semiconductor solutions, and Intel Corporation, the world’s largest chip maker, and Intel, formed to manufacture NAND Flash memory for use in consumer electronics, removable storage and handheld communication devices.
Responsibilities:
•Analyzing data, summarizing content, presenting findings, and recommending solutions to defect.
•Developing performance metric tracking tools and Experienced with SEM and optical review tools, defect analysis software and SPC Tool troubleshooting.
•Exprianced in Documented all preventive maintenance using check sheets and tracking programs
•Monitoring and addressing SPC issues
•Worked closely with area leadership, industrial engineering, and area process and equipment engineering teams to identify opportunities for area improvements in regards to cycle time, efficiency, and productivity.
Micron Technology, Lehi, UTAH Sep 2005 – Aug 2007
Quality Assurance
One of the world's leading providers of advanced semiconductor solutions & the world’s largest chip maker.
Responsibilities:
•Tested DRAM/NAND flash memory processor
•Identified the defect for microchips devices
•Validate the DRAM/NAND flash components and version upgrades.
•Analyze the test results and review the test summary report and assisted with the design and implement solutions to the source system application.
Environment: Six SIGMA, MES, Excel,Access
Regis University, Denver, Co
May, 2002-May, 2003
DBA Practicum (LAB Assistant JR. Oracle Database Administrator)
Responsibilities:
•Installed oracle software and Supported to the lab student for Lab work.
•Created and configured databases for compliance with schema requirements.
•Managed work order support queue.
•Supported database users and various applications.
•Developed and maintain support documentation
H&H Attorney law firm, Denver, CO 02/2001–09/2001
Title: Intern database
Maintained SQL Server database and CMS Open accounting systems (hardware/software upgrades, backups, etc.). Supported SQL Server Databases and CMS Open accounting system, made continual improvements, and fix any problems that may arise.
Performed troubleshooting and fix problem that occur with SQL Server databases and CMS Open accounting system.
Worked with development tools such as Cold Fusion, Visual Basic, JavaScript, ASP, and various other programs. Worked with Microsoft SQL Server, Windows 2000, Windows NT Server 4.0, Windows 95/98, IIS, and Microsoft Access.
Coordinated with NetWare Administrators to improve and maintain database and CMS Open system performance. Wrote and maintained documents for Current SQL Database system and technical components of CMS open accounting system.
References
Available upon Request
Contact this candidate