SQL Server DBA or Database Developer or SQL Server Database Administrator or ... Resume

Title
SQL Server DBA or Database Developer or SQL Server Database Administrator or ...

Primary Skills
Database Systems, Web and Design Software, LAN/WAN Technologies, etc.

Location
US-GA-Lawrenceville

Posted
Jan-05-09



OBJECTIVE:

Obtain a challenging technology position in an organization that enables growth and offers advancement opportunity with increasing job knowledge.

TECHNICAL SKILLS:

* Database Systems: Microsoft SQL Server 2005/2000/7.0 and Oracle 8i, Oracle9i and Microsoft Access 2003/2000/97
* Web and Design Software: Macromedia design suite Dreamweaver (v4.0, UltraDev v4.0 and MX 2004, Flash v5.0, and FireWorks v4.0) and Adobe graphic design suite (Illustrator v9.0, ImageReady v3.x, and PhotoShop v6.0).
* Languages: Visual Basic, VB.Net, ASP, ASP.NET, HTML, XML, SOAP, HL7, JavaScript, Java, C/C++, Pro*C, PL/SQL, SQL, Stored Procedure, VBA, and Macros.
* Operating systems Microsoft operating systems (Windows 98, Windows Me, Windows NT server, Windows 2003/2000 server, XP, and Vista) and Apple Macintosh (v7.x and v8.x).
* Application software: Oracle Forms & Reports, Microsoft (Word, Excel, PowerPoint, Project) and Corel WordPerfect (v4.x-v6.x and WordPerfect 97).
* Web Browsers: Microsoft Internet Explorer (v3.x - v6.x) and Netscape Navigator (v2.x - v7.x).
* LAN/WAN Technologies: Ethernet, 3Com Hubs and Switches.
* Other Skills: Data entry and Creative Development.
* Ability to work with minimal direction, yet also able to work in team environment.
* Clear and effective written and verbal communication skills

WORK EXPERIENCE:

August 2008 - Present
TechPurpose, Alpharetta, GA
DBA/Developer (Contractor)
* Created replication process to hosting servers
* Created several SSIS packages to perform varies business functions
* Performed complete Database design, development, test, implement DB, and business intelligence solutions
* Participate in creation and delivery of data driven applications for end users
* Performed Database Backup/Restore planning and management.
* Performed Stored Procedures development and testing.
* Utilize SQL Server reporting Service (SSRS) to publish reports to upper managers


March 2007 - July 2008
AT&T, Atlanta, GA
DBA/Developer (Contractor)
* Worked extensively on the SQL queries, stored procedures and functions. Wrote complex stored procedures
* Built and managed the MS SQL Server Databases and Infrastructures including upgrading the department from MS SQL 2000 to the MS SQL 2005.
* Used SQL Server Reporting Service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats.
* Scheduled jobs were created to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
* Created SQL Server Integration Services (SSIS) to perform multiple data extractions from IEX TotalView application.
* Develop new or maintain existing databases based on specifications
* Share knowledge by effectively documenting work
* Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
* Resolve database performance issues, database capacity issues, and etc...
* Manage security of database structures and corporate data held within databases.
* Develop database procedures, triggers and SQL scripts for development teams.
* Maintain database changes from Development, QA to Production.
* Assist in the definition and implementation of database standards.
* Monitor databases for errors and perform problem determination when necessary.
* Worked on mission critical projects and fast paced environments

May 2003 - January 2007
Quest Diagnostics, Tucker, GA
DBA/Developer (Permanent)
* Run daily, weekly and monthly reports for management consumption.
* Performed complete Database design, development, and implementation.
* Import Different Business Unit data into the eForm (Web Application)
* Architect and implemented an " ANF Tracking " Web application for the Finance Department in Atlanta
* Import/export patient demographics in different format (i.e. text, ascii, HL7, etc.)
* Automate repetitive tasks
* Performed database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, implementation, and modification.
* Performed Database Search and Query Strategy design, implementation, testing, and optimization
* Performed Stored Procedures development and testing.
* Performed Database Migration Plan management, testing, and execution.
* Performed Database Backup/Restore planning and management.
* Performed database software recommendation, setup, and configuration.
* Architect and implemented an " TOROL Tracking " database application for the Atlanta Support Center

February 2002 to February 2003
General Electric (Power Systems), Atlanta, GA
DBA Administrator / Developer (Contractor)
* Managed Oracle 8.x/9i database systems. Key responsibilities included the following: General Database Administration, Performance Tuning, Capacity Planning, and Data Backup and Recovery operations.
* Installed and provided technical support for in-house application using Oracle Developer/2000 runtime reports and forms.
* Performed extensive tuning and optimization of database and application code (e.g. stored procedures, user-defined functions, triggers, etc.) to boost operating efficiency. Built numerous triggers to implement business rules for auditing purposes.
* Designed and implemented Oracle reports for input into management reports.
* Created a multi-user Oracle Application Test Environment with updated data from the Production system to test new software patches before deployment into the Production environment.
* Performed periodic refresh of the data in the Test Environment with data in the Production system.
* Designed a fully integrated user interface using Oracle forms to interact with the database system.
* Provided SQL, Pro*C, PL/SQL and database support to a team of Java, XML and C++ developers performing Web development.
* Installed and configured Oracle Enterprise Manager 8i (OEM) to handle jobs scheduling, event monitoring, capacity planning, and email and pager notification for all Oracle databases, including two Oracle 8.0.6 relational database systems running on UNIX host servers.
* Was responsible for designing data backup strategy for a 24x7 mission critical database application using RMAN.
* Performed SQL tuning and memory adjustment, by gathering and interpreting statistics about the critical areas of databases via use of dynamic performance views and data dictionary tables.

October 2001 to February 2002
Cingular Wireless, Atlanta, GA
Developer / DBA Administrator (Contractor)
* Performed all aspects of project planning and management.
* Architect and implemented an "Employee Benefits" database application for Cingular's HR department.
* Performed Data Discovery and Data Requirements Gathering.
* Performed complete Database design, development, and implementation.
* Performed database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, implementation, and modification.
* Performed Database Search and Query Strategy design, implementation, testing, and optimization
* Performed Stored Procedures development and testing.
* Performed Database Report design and implementation, using Active Reports.
* Performed Data Import/Export Plan design, implementation, and execution.
* Performed Database Migration Plan management, testing, and execution.
* Performed Database Backup/Restore planning and management.
* Performed database software recommendation, setup, and configuration.

August 2000 to September 2001
Ivan R. Dee Publisher (www.ivanrdee.com), Chicago, IL
Web/Database Administrator (Internship)
Principal database responsibilities were as follow:
* Redesigned and implemented the company's internal "Publishing" database running on a proprietary legacy database system.
* Performed complete Database design, development, and implementation. These included database schema (i.e. tables, views, indexes, relationships, etc.) definition, design, and implementation.
* Performed Database Search and Query Strategy design, implementation, testing, and optimization.
* Performed Stored Procedures development and testing, as well as Database Report design and implementation.
* Performed Data Import/Export Plan design, management, testing, and execution.
* Designed and implemented the company's website for the Spring 2001 season, utilizing software and design tools such as Dreamweaver and Adobe Photoshop. (A portfolio of my previous projects can be furnished upon request.)

August 1999 to May 2001
Northeastern University, Chicago, IL
Lab Consultant
* Provide Help Desk Support to college students using the Northeastern University's computer center.
* Perform installation and configuration of network hardware (e.g. network hubs, network switches, etc.), desktop PC's, and network printers located on the university's campus-wide computer network.
* Perform operating system and application software installation and setup on desktop PC's.
* Assist the network administrators with performance of basic network administrative functions: user accounts setup and management, computer accounts setup and management, network share management, network printer setup and configuration, network printing and network folder and file security access management.

EDUCATION:
Northeastern University, Chicago, IL August, 1999 to May 2001
B.S. - Computer Science

Oakton Community College, Des Plaines, IL August, 1997 to July 1999
Major - Computer Science

COLLEGE COURSE WORK:
* Modern Database Management, Web Programming (HTML), Programming (C/C++, Java, Visual Basic, and Data Structure), Operating Systems, Web Design, and Computer Graphics.

SENIOR PROJECT:
* Designed and developed a program to calculate a cable company's weekly and monthly revenue by employee using the C++ programming language. The program displayed the information in a business like format.

COMPUTER TRAINING:
* Microsoft Windows NT Server 4.0 Core Technologies
* Oracle 8i/9i
* SQL Server 2005/2000
* XML Web Services using Microsoft ASP.NET
* Visual Basic.NET

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Lawrenceville, GA | Resumes in Georgia

View other SQL Server DBA or Database Developer or SQL Server Database Administrator or ... resumes, Database Administrator resumes