Business Analyst/Technical Support/MSSQL DBA

A "hands-on" SQL Server Database Administrator (DBA) with M.S in Information Technology. Extensive qualifications in all facets of Information Technology from conceptual design through documentation. Proven ability to multi-task and meet workplace deadlines.

SUMMARY OF QUALIFICATIONS

• DBA for SQL Server serving 90 Microsoft SQL Servers individually and 800 severs globally. Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA's to ensure 24 hour x 7 days a week support of all corporate databases.

• Generalist expert in all aspects of information technology including program and project management, collaboration, change management, full SDLC and large scale project and business initiative execution.

• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.

• Extensive experience in data analysis, data manipulation, database statistics, system study, documentation and programming.

• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

TECHNICAL SKILLS AND CERTIFICATIONS

Databases MS-SQL 2000/2005/2008, Ms Access, Sybase and Oracle 10g.

Operating Systems Windows 2000/2003/NT/XP/Vista, DOS, UNIX and MAC.

Applications Ms Office, Rational rose, jGrasp and eclipse for Java, Visual Studio, Microsoft SQL Server, Enterprise Manager, SQL Management Studio, DB Artisan, HP Open View Service Center, IBM Tivoli Storage Manager, SQL Server Migration Assistant and SQL Ways.

Languages Java, Java Swing, HTML, C, VB, ASP.net and T-SQL.

Certifications & Trainings Microsoft SQL Server 2008 Implementation and Maintenance, CIPT1 V6.0 – Implementing Cisco Unified Communications IP Telephony, Storage systems, Storage security and management.

PROFESSIONAL EXPERIENCE

Barclays Capital 2008-Present

Jersey city, NJ

MSSQL Database Administrator

• Responsible for MSSQL logical and physical database design, implementation and maintenance using MSSQL 2008/2005/2000.

• Created new databases, users and database objects like tables, stored procedures and views, setup log-shipping and developed and testing a backup and disaster recovery Plan.

• Used IBM Tivoli Storage Manager for restoring backup from tape and restoring databases.

• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.

• Trouble shooting Problems by using SQL server profiler.

• Responsible for General Database Administration and Performance tuning.

• Experienced in resolving deadlock and blocking issues for concurrent users.

• Scheduling and managing jobs on MS SQL Server and Monitoring jobs performance and impact on normal operations.

• Experience in implementation and administration of SQL Server clustered environment.

• Index & Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.

• Work with developers to move test code into production.

• Efficient response to database events in a production environment including resource management & performance monitoring of cluster administration, managing high-availability, database recovery, replication, log shipping and mirroring etc.

• Sybase to SQL Migration – Objects, Schema and Data Migration.

• Led year-long project involving upgrading of SQL Server 32-bit to 64-bit server. Collaborated with senior management and Application teams on migration plans and responsible for actual implementation.

Sybase Database Administrator

• Responsible for the day-to-day administration of database servers. This includes Startup, shutdown, Backup, Recovery, resources monitoring, trouble-shooting, system performance monitoring and system sizing.

Voice Support Analyst

• Worked with the Voice Engineering team in installing and configuring a Cisco Unified Communications Manager (CUCM).

• Configure CUCM to support on-cluster calling in a single-site deployment.

• Implement a dial plan in CUCM to make internal calls and place calls within the public switched telephone network (PSTN).

• Build and test a sophisticated IP telephony network.

Storage Engineering

• Familiar with storage systems and backup environments.

• Performed Storage Allocation tasks according to the requirements.

• Designed and developed a web-based ASP.net internal application called Storage Management Portal which aids the global storage team to centrally manage heterogeneous storage information that includes SAN, NAS and TSM environments.

OCD, J&J – Data Analyst 2007

Rochester, NY

• Worked with Reliability Engineering team in collecting and analyzing the reliability data to examine and predict the failure rates of Systems and Subsystems.

• Use Oracle 8i and Excel to query data from databases and present in a format to facilitate decision-making.

• Collect data and put it in statistically useful format for review by management.

• Manage databases used for generating reliability reports.

• Performed test executions and defect reporting using Mercury Quality Center

PPP Infotech Ltd. – Web Analyst 2007

Chennai, India

• Worked within a team to design user interfaces for www.pppindia.com/shopping website.

• Researched on various affiliate programs and Applied e-commerce design strategies to increase revenue of the above website.

EDUCATION

• M.S in Information Technology, Rochester Institute of Technology, Rochester NY

• B.Tech in Information Technology, Hindustan College of Engineering (Anna University), Chennai, India

Contact this candidate