SQL Developer Resume Detroit, MI - Hire IT People

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/XP/7/2003/2008,Mac OSX, FreeBSD, Linux

Server Platforms: Dell Poweredge Servers

Telephony Platforms: Telrad UnitE pbx, Avaya pbx, Telrad eMagine voicemail, Octel voicemail

Network Appliances: Cisco PIX 506e firewalls, Netgear/Nortel/Cisco/3com/Dlink switches, F5 BigIP loadbalancers, F5 Firepass SSL VPN appliance

Database Platforms: SQL Server 2000/2005/2008

SAN Platforms: EMC AX100

ERP System: Sage AccPac

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SQL Developer

Develop extensive T - SQL queries, SSIS packages and SSRS reports for the Confidential DocSite Patient Registry Product. The primary platform is SQL Server 2008 R2 with legacy installations running SQL Server 2005.
Support an install base of 5 separate DocSite installations for several major hospital systems including the Detroit Medical Center, Henry Ford Health System, and the Vermont Blueprint for Health. These installations combine to represents millions of patients, millions of clinical data points, and terabytes of data. Four installations represent data from a single customer each, the largest installation is multi-tenanted and serves many hospital systems simultaneously.
Serve as “Team Lead” for a team of five SQL Developers. Manage overall capacity of and utilization of SQL development resources for each monthly release cycle.
Assist Product and Solution Delivery teams in the development of requirements. Estimate the effort to develop the solution or feature for release scheduling
Work with database administration team to troubleshoot performance issues and optimize overall performance of our solutions.
Coordinate SQL based solutions for the .NET development team including database and query design.
Develop custom solutions for customers including the end to end database architecture, ETL, and reporting solution for the Vermont BiState in order to fulfill the “Uniform Data System” reports as defined by the United States department of Health Resources and Services Administration.

Confidential, Detroit, MI

Database and Systems Administrator

Performed an Exchange migration from one hosted service to another hosted service resulting in a 50% savings, a tenfold increase in storage, an email archive solution, and an upgrade from Exchange 2003 to Exchange 2007.
Support and Maintain 20 Databases running SQL Server 2000/2005 across 6 physical servers representing one terabyte of data.
Utilize SQL Profiler to run traces to debug and resolve database performance.
Utilize SQL Tuning Advisor to help determine indexing and statistics gathering to ensure write performance is maintained on our OLTP databases while allowing the real-time reporting our users demand.
Utilize RedGate SQL Compare to ensure that schema changes in our test

environment: have been deployed to the production environment as part of any database project deployment.

Confidential

PC/LAN Technician

Tune stored procedures, user-defined functions, and ad-hoc queries to maximize performance while minimize resource overhead on the servers.
Coordinate with end users to develop and fulfill report requests using T-SQL and SQL Server Reporting Services
Use T-SQL and SQL Server DTS/SSIS to perform ETL tasks.
Manage, Maintain, and Implement Asterand's voice and data infrastructure, including servers, desktops, storage platforms, phone system equipment, firewalls, vpn gateways, and other miscellaneous network appliances while Asterand scaled from a private local company of 25 individuals to an international public company of 100 individuals.
Support and maintain Asterand’s Windows 2000/2003 Active Directory infrastructure.
Perform desktop and technical support for Asterand's Detroit site, as well as remote users.
Maintain the hardware and software for Asterand's web operations at a collocation site in Southfield, MI.
Compose and enforce user policies and standard operating procedures for I.T.
Maintain open and effective communications with department heads to ensure that business needs are met with appropriate information technology resources.
Ensure security, availability, and integrity of critical Asterand data, applications, and appliances.
Coordinate and negotiate with vendors to provide Asterand with superlative resources at reasonable costs.
Develop Crystal Reports from AccPac Financial System data.
Plan, implement and maintain a backup system using Backup Exec 12 and a fiber-connected Powervault TL4000
Plan, implement and maintain a fiber channel SAN using an EMC AX100 as the storage device.
Administer and maintain websites running on IIS 5 and 6.

Confidential, MI

PC/LAN Technician

Performed PC, printer, fax, copier, and server maintenance for a mid-sized network.
Supported software and hardware resources for network and pc users.
Managed user accounts and various network resources.

We provide IT Staff Augmentation Services!

Sql Developer Resume

Detroit, MI

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship