Sql Dba Resume
NJ
Summary
- Around 3 years of total IT Experience in administration, maintenance and testing of databases using MS SQL Server 2000/2005. Experienced in various processes including Incident, Change, Problem and Configuration Management.
- Experience in Database activities like Installation, Configuration, Backup & Recovery, Database Security, Database creation and Maintenance, Disk Capacity Planning, Performance Monitoring and Tuning, Troubleshooting and Documentation.
- Configured and managed High Availability technologies like Logshipping, Mirroring and Transactional Replication.
- Good knowledge of SQL Server BI tools like SSRS, SSAS, SSIS and in the design of Business Intelligence Solutions.
- Proven ability to adapt quickly to new projects, capable of working with both onshore and offshore project teams.
Education
Master of Science in Engineering Management
Computer/Technical Expertise
LANGUAGES C, C++, Java, Oracle 10g, .NET, SQL, HTML, XML WEB SERVERS IIS SCRIPTING LANGUAGES Shell Scripting DATABASES RDBMS Concepts, MS Access, Oracle, SQL Server 2000 & 2005(YUKON) OPERATING SYSTEMSAUTOMATION TOOLS
Windows 98/XP/2000/VISTA, Windows Server 2000/2003, Windows 7Solid Works, 3D CAD design software, SAS
UTILITIES MS-OFFICE Tools, Microsoft Office Project 2007, MS VisioWork Experience
Production Support Analyst/SQL DBA Mar 06-Dec 07Confidential,India
Project#1: Clarify Support
‘Clarify’ is a global support application, maintaining about 80 servers in 7 vast regions world-wide. PIDPLUS application generates part number/product key while CRITSIT application provides assistance for critical issues on customer’s invoice. It is designed to monitor cases that have major business impact for customers, partners, and/or Microsoft. Axis/Engineering services, formerly known as Rapid Onsite Support Services provides support for Microsoft products.
Responsibilities:
- Installation and configuration of SQL Server 2000/2005 Standalone and Cluster
- Configuring and troubleshooting issues on Replication, Log shipping and Database Mirroring.
- Configuring Backup and DBCC jobs as a part of Disaster recovery and database maintenance activities.
- Resolving blocking and performance related issues by running various t-sql queries.
Environment: MS SQL Server 2000, MS SQL Server 2005(Yukon), IIS 6.0, Windows 2003, Windows Vista, PID PLUS, Clarify CRM, Windows clustering server, ENGSRV, CRITSIT.
SQL DBA/Developer Jul 05-Mar 06Confidential,India
Project/Training: Technology Infrastructure Services
Worked as MS SQL DBA/Developer for Wipro internal application support project and primarily involved in SQL Server database administration and development to support HR, Finance and Sales modules.
Responsibilities:
- Developing and designing Cubes using SSAS and Reports using SSRS
- Configure and deploy Reports along with maintaining database servers
- Working knowledge of SQL Server 2000, 2005, and 2008 performance monitoring and tuning.
- Working knowledge of SQL Server BI tools such as BIDS, SSRS, SSAS, SSIS, and DTS.
Environment: MS SQL Server 2000, MS SQL Server 2005(Yukon), IIS 6.0, Windows 2003
Academic Work Experience
Graduate Teaching Assistant: Univ of Texas at Arlington, Dept of Industrial, Mfg & Systems Engg Jun 09-Present
- Organized and managed classes for undergraduate students, graded papers, and quizzes.
- Stimulate class discussions and tutored students to use software like SAS in the labs.
- Arranged class videos, website updates for distance students and participated in ‘Engineering Awareness’, ‘Park Maintenance’, ‘Blood donation’, ‘Green Revolution’ & ‘Environment Protection’ programs.
Student Support Assistant: Office of Information Technology, University of Texas at Arlington. Jan 09-May 09
- Respond to requests for technical assistance in person, via phone, electronically.
- Diagnose and resolve technical hardware, software and network issues.
- Tracks and routes problems to appropriate sources, requests and documents resolutions.
Graduate Projects
Confidential,United States
Worked on a live project, ‘Product Configuration (Redress)’, assembled raw data of product configuration & kitting gap analysis of products over 45 different countries into a database. Performed extensive research on global markets to understand supply chain & logistic problems. Compiled, analyzed the cost for various redress activities & proposed reasonable recommendations for the management to address the global redress issues, improve on the existing activities and lower costs.
Engineering & Project Management Project at University of Texas, Arlington
A project based course in practicing Program Management techniques throughout the product life cycle. Worked in a team environment solving realistic program management problems associated with the life cycle of a cell phone and used current program management tools and techniques like financial tool, MS Office project 2007.
Honors
- Member of ‘Phi Kappa Phi’, the honor society for all academic disciplines.
- Member of ‘Tau Beta Pi’, the Engineering Honor Society.
- Member of Student Alumni Association 2010 at the University of Texas, Arlington
Certifications
- Microsoft Certified Database Administrator(MCDBA) Since Mar 06
- Post-Graduate Diploma in Computer Applications(PGDCA)