SQL Server DBA/Developer Resume Palo Alto, CA - Hire IT People

Summary

Experience in MS-SQL Server Administration including Design and implementation of Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning.
Comfortable with Sql Server 2008, SSIS (Sql Server Integration Services).
Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Strong experience in database Backup, Restore and Recovery procedures and Isolation Levels.
Thorough experience in Query Optimization, Tuning of Stored Procedures, and Performance Tuning
Hands on experience and knowledge of high availability SQL Server solutions (DB Mirroring) and replication.
Knowledge of active-active and active-passive clustering.
Has experience in implementing Log Shipping.
Self-motivated, creative team player with effective communication and Leadership qualities.

Technical Skills

Programming Languages:C, C++, C#, PERL
Database:SQL Server 2008,MySQL, PL/SQL,MS-Access
Operating Systems:UNIX, Windows XP/Vista

Scripting LanguagesPerl, PHP,CSS, JavaScript
Web Technologies:ASP.NET,HTML,XML,HTML

EDUCATION: MS (Computer Science)
BE (Information Technology)

Work Experience

Confidential, Palo Alto, CA
Nov 2010 to May 2012
SQL Server DBA/Developer

Monitored and tuned databases to meet the performance and availability requirements.
Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent.
Created maintenance plans, scheduled jobs.
Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server.
Migrated the databases and managed the database location files and size.
Created Clustered Indexes and Non-Clustered Indexes to increase the performance of databasequeries.
Secured the SQL Server by creating user logins and Windows logins with appropriate roles, dropping and locking the logins, creation of groups, granting the privileges to users and Groups.
Implemented database mirroring as a part of disaster recovery plan.
Involved in resolving blocking and dead lock issues performance issues.
Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
Managed Transactional replication from the Production servers to the Reporting servers.
Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps, integrity checks, and updating statistics.
Worked on daily reports which notifies about the database growth, failed jobs, failed backups and failed transactional log backups.
Experienced in RDBMS.
Involved in performing Extraction, Transformation and Loading.
Development and implementation of Backup and Recovery strategies.
Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.

Confidential, Fremont, CA August 2010 to November 2010
Software Development Intern

Regression testing of the software to make my own test cases.
Next task is to do R&D, research to remove barcode scanning and to implement optional method which takes less time of scanning.

Confidential, San Jose, CA
February 2009 to April 2010 Operating Analyst Intern

Data collection, data entry, database design, database testing, Crystal reporting, report reviews and other investigation related to Operation and within the Analysis Reporting & System Unit.
The ability to gather and analyze statistical data, develop written reports and create supporting maps, graphics and charts.

Confidential July 2007 to November 2007
Technical Assistant

Worked for set up of school computer lab which included the installation of OS, Linux and then setting up of the network
Assist in maintaining the school webpage.
Edit and update Web site using multiple languages, including HTML, XML, and CSS.
Assist students and faculty in using computer hardware and software.
Run reports/statistics (with provided instructions) on program usage.

Confidential January 2007 to June 2007
Web Developer

Developed a web application based on PHP, ASP, and SQL Server 2005 with a high level of security & performance.
This application will helps client in developing websites and managing information about users who are using this site by different browsers, different areas, different port addresses etc.
Provided Security, consistency, efficiency, track state etc.
Involved in analysis, design, coding, unit testing, integration testing, system testing.
Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems.
Involved in analysis, database designing, coding and testing.

We provide IT Staff Augmentation Services!

Sql Server Dba/developer Resume

Palo Alto, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship