|
msrite57 (ID: 256776)
MS SQL DBA - versions 6.5, 7.0, 2000, 2005 & 2008
|
|
|
Programming & Databases
|
|
Earnings (Year):
$0
|
|
|
|
|
Summary
|
| Member Since: |
October 23, 2002 | 0 quotes in last 30 days
| Last Signed in: July 31, 2010
|
| Location: |
Jamestown, North Carolina | United States |
| Would work on site: |
Yes |
| Earnings (All Time): |
$0 |
Earnings by Skill (Year): |
| Programming & Databases |
$0 |
| Database Design |
$0 |
| Embedded Development |
$0 |
| IT Training |
$0 |
| Programming |
$0 |
| Web Programming |
$0 |
|
Feedback |
| Rate: |
Min. Rate: $35.00 | Min. Budget: $0.00 |
Work Terms |
| Industries: |
Education, Oil & Gas, Healthcare Services, Pharma & Biotech |
|
|
Highlights
|
- MS SQL 2000, 2005, 2008 Upgrades and implementations, Design, (minimum work on this topic). Sometimes there would be a need to modify a DTS package to create an old report or a new report that the user requested. Implement, (Assist with Upgrades from SQL versions to newer versions of SQL). Managed, (with one other DBA over 400 databases on about 38 servers with about 100 databases over a Terabite in size). Some of the databases had their .mdf’s and .ldf’s on SAN drives. The SAN drive was managed by a network person, but our duties as the DBA was to monitor the free disk space and make recommendations if needed. Backups were perform either with RedGate or with SQL Jobs. We would backup the databases across the network to one backup server daily, nightly or weekly and then once a week those backups would be zipped and then backed up by the network guy using … Net Backup to another location. Managed SQL Jobs daily … which included (Optimizations, Integrity Checking, Re-Indexing – Weekly), (Full Backups – Daily, Weekly), (Tlog Backups – Hourly, Daily) and Diff Backups. Monitored Free Disk space was on-going. Set user privileges at the database level. NOTE: If jobs failed then I performed research and resolution on them.
- Oracle 9i and 10g …Upgrades and installs running on Unix and Linux operating system working with users and vendors to resolve issues that may arise from daily activity.
|
|
Skills
|
| Years of Experience: |
17 year(s) |
| Highest degree: |
Bachelor's Degree |
| Software Skills: |
o Microsoft Certified Professional (MCP) since 2002
o Microsoft Certified DBA 2000 (MCDBA) (not certified) 14-Day Boot Camp
o Microsoft Certified System Engineer (MCSE) (not certified) 14-Day Boot Camp
o Microsoft SQL Server 2008 DB Dev (MCTS) (not certified) 10 – 2 hour sessions
o Microsoft SQL Server 2008 DB Dev BI (not certified) 10 – 2 hours sessions
o Microsoft SQL Server 2008 DB Dev (MCITP) (not certified)
o Oracle 9i Admin I Training (OCA) (not certified) – Master’s Level Course
o Oracle 10g Admin I Training (OCA) (certified) since 12/30/08 – 5 day Training Class (May 2008)
o Back-End DBA/Development:
o Microsoft SQL 6.5, 7.0, 2000, 2005,2008
o Vax/VMS Command Line SQL
o Oracle 9i and 10g (classes & on the job)
o Application N-Tier Data Warehouse (Data Mart) and Database:
o Corrective Action Tracking Service Web (CATSWEB)
o Application Client Server Database:
o Saleslogix (Customer Relation Management – CRM)
o Ross (HR, Payroll, AR, GL)
o ABACUS (Education Software for training for End of Grade Testing)
o SiteKeeper
o Microsoft Visual Basic 6
o MS ASP.Net and MS VB.Net (Classroom Only)
o Report Writers:
o InfoMaker 9 Reports
o MS Access Reports
o Crystal Reports
o Operating Systems:
o IBM AS400
o Vax/VMS
o Unix/Red Hat Linux
o Previous Responsibilities:
o (4) Implementations, DTS Packages, (2) Conversions, Numerous Installs/Upgrades Front End Applications and Back End Databases, (3) Project Managements |
| Additional Skills: |
- Courses Taken while pursuing a Master's Degree in Information Systems and Operations Management at UNCGreensboro ... Greensboro, NC
1/2004 - Present
· UNCG NC (Note: I have 9 more semester hours to complete my degree)
Masters (Masters Courses Taken Since January 2004)
ISM 623 & 624 eBusiness Strategy and eCommerce Applic. Development(ASP.Net) – (Spring 2007)
ISM 608 & 609 Networks & Telecomm. & Distributed Systems & Architect (Fall 2006)
ISM 625 & 626 Info Assurance & Sys Security & Information Tech Security (Spring 2006) (Sarbanes Oxley Issues)
ISM 606 & 607 Open Source Operating Systems (Linux - Red Hat) (Fall 2005)
ISM 622 Database Design & Admin (Oracle 9i) (Spring 2005)
ISM 604 & 605 Bus Applications Programming I & II (VB.Net) (Fall 2004)
ISM 611 Data Warehousing & Mining (Fall 2004)
ISM 601 Info Systems and Technology (Spring 2004)
ISM 602 Business Data Systems (Spring 2004)
Masters, Information Systems and Management, January 2004 - On-going, GPA 3.06 |
| Tested Skills: |
 |
| The Freelancer has not taken any Skill Tests. |
|
|
Work Terms
|
|
No information provided
|
|
|
| |
|
|
|
|
| |
|
My Account URL
|
|
Contact this Freelancer Now!
|
|
Instant Messenger
|
|
|
|
Global Region
|
| Country: |
|
United States |
| GMT: |
|
(GMT-05:00) Indiana (East) |
| Local Time: |
|
8:01 PM |
|
|
|
|
|
| Profile |
|
|
|
