We provide IT Staff Augmentation Services!

Ms Sql Server Dba/support Resume

0/5 (Submit Your Rating)

San Jose, CaliforniA

Hire Now

SUMMARY:

  • Experienced MS SQL Server DBA and Developer
  • Experienced in database administration, design, tuning and ETL
  • Strong analytical, conceptual, and problem - solving abilities
  • Demonstrated success designing, implementing and documenting solutions that improve business functionality
  • Skilled in report and query writing

TECHNICAL SKILLS:

DATABASES: Microsoft SQL Server 2012/2008R2/2005/2000, Oracle 10g, MS Access

PROGRAMMING LANGUAGES: T-SQL, PL/SQL, Powershell, Java, Visual Basic 6.0, VB Script, HTML, COBOL, C

BUSINESS INTELLIGENCE SOFTWARE: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server DTS, JasperReports, iReport, JasperServer, NetBeans

OTHER SOFTWARE: Rally, Embarcadero ER Studio, LifePRO, Visio

PROFESSIONAL EXPERIENCE:

MS SQL SERVER DBA/SUPPORT

Confidential, San Jose, California

Responsibilities:

  • As part of a rapid development prototyping team, performed the following support and DBA functions:
  • Successfully performed database/software installation and led migration to new production database server, as well as installed software on additional servers. Set up and tested both merge and transactional replication on servers running MS SQL Server 2008R2.
  • Performed database administration tasks, such as setting up user permissions, monitoring databases and fixing database problems, such as crashes and blocking, on servers running MS SQL Server 2008R2 and 2012.
  • Developed support processes and successfully led a support team of seven people responsible for responding to issues raised by both team members and external users of the ION system.

MS SQL SERVER AND ORACLE DEVELOPER (consulting positions)

Confidential, San Francisco, California

Responsibilities:

  • Coded and tested SSIS packages in MS SQL Server 2005, which transformed and imported wholesale automotive data for the usedcars.com website for Dealix Corporation, a division of ADP.
  • Converted general work order and Backflow Prevention System reports written in Oracle Forms and Oracle Reports to JasperReports using the iReport IDE for East Bay Municipal Utility District (EBMUD). Deployed reports to JasperServer. Wrote Java code and modified Oracle PL/SQL packages to pass parameters and update the database.
  • Created SQL Server 2008R2 stored procedures, functions, views and SSRS manufacturing reports such as the backlog/back order report and the shop order variance report for MDC Vacuum Products. Also created a process for loading historical data into the database. Data was extracted from a Microsoft Dynamics AX manufacturing ERP database.
  • Created MS SQL Server 2008 stored procedures and SSIS packages to load data to support the Medically Indigent Reporting System (MICRS) project for Alameda County Health Care Services Agency.

MS SQL SERVER DBA/DEVELOPER (permanent position)

Confidential, Glenview, Illinois

Responsibilities:

  • Maintained, enhanced and tuned a nightly ETL process that loaded about 70 tables in the repository from the LifePRO transaction database, extracted data from the repository, transformed the data and created shadow files for uploading to the mainframe. This process consisted of DTS packages containing ActiveX scripts using the VB scripting language, as well as stored procedures, views and user-defined functions.
  • Designed the database, created tables and wrote stored procedures for the AD&D eligibility system and Agent Portal projects. Also created a process for automatically loading Excel spreadsheets to the MS SQL Server 2005 database. Built this process using a DTS package that calls stored procedures.
  • Provided 24 x 7 on-call production support for MS SQL Server scheduled jobs, as well as production support for the LifePRO insurance system, which has a 100+ GB MS SQL Server 2005 back end.

MS SQL SERVER DEVELOPER/INSTRUCTOR (consulting position)

Confidential, Chicago, Illinois

Responsibilities:

  • Developed and taught a relational database and introduction to SQL Server course for IT employees at Confidential (GTL).
  • Created logical data model for GTL’s Special Risk Admin System, as well as developed database standards documentation.

ORACLE DEVELOPER - BUSINESS INTELLIGENCE PROJECT (consulting position)

Confidential, Chicago, Illinois

Responsibilities:

  • Developed logical and physical data model for an Oracle database used by a business intelligence Web application. This application determined the expected severity value of a vehicle involved in an accident. This helped loss takers to decide what action to take regarding a particular loss.
  • Modified database table scripts and updated the data dictionary.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship