System Administrator / Consultant Resume

SUMMARY:

SQL Server DBA with over 5 years IT experience, including more than 4 years as a developer in technical industry. Proficient in SQL Server 6.5 to 8.0, Oracle 8i & 9i, PL/SQL, ASP, .Net, C# and Visual Basic; possess strong communication and problem solving skills developed through a variety of projects. Offer proven ability in team leadership and proactive systems support.

TECHNICAL SKILL:

Programming Languages: Visual Basic 6.0, C, C++, Java, C#, ASP, ASP.Net

Web Technologies/Systems:: HTML, ASP, VBScript, Microsoft Front Page 2000, Macromedia Flash 5.0

Database Technologies / Systems: ODBC, Oracle 8i & 9i, Access 2000, Microsoft SQL Server 2000 & 2005, PL - SQL

Operating Systems: Windows 9x/NT/2000, UNIX

Other: Visual Fox- Pro, UML, OOP, OpenGL, Prolog, LISP, XML, COM, Dream weaver, TCP/IP, MS Visio, ADO, Visual Interdev, Crystal Report (8.5 & 10), Visual Age,.Net, VB.Net, PHP, MySQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential

Monitor MS SQL servers for errors and performance degradation.
Creating Stored Procedure in T-SQL, Cursor, and Triggers for database functionalities.
Upgrade existing MS SQL Server software to newer versions and/or Service Pack Levels.
Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
Set up and schedule jobs that perform backups and database structure checks.
Develop reports for different department using SQL Server Reporting Services.
Created OLAP cubes for SQL Analysis Services.
Configure Replication, Log Shipping, and Failover clustering to meet customer needs for production environment to development environment.
Move, transform, and load heterogeneous and homogeneous into SQL Server databases, as well as export SQL Server data to text file and other database systems.
Define Server Build Requirements for SQL Server portion of build and how certain operating system parameters, options, components, etc. need to be configured for a dedicated SQL Server system.
Define Security Requirements and manage Server Login accounts for App databases and system services.
Define QA process for Application Databases on SQL Servers
Define Disaster Recovery and Backup Strategy.
Helped Developer team in coding with C# and converting COM object to C# level.
Performed Project lead for job tracking application developed in C#, ASP.Net, and backend with SQL 2000.

Confidential

Application Developer

Responsible for Team co-ordination for the project and delivery of the project. Built web-based applications in ASP, which involved a Search application, Report builder using Crystal Report 8.5 utilities. Wrote Stored procedure and triggers in SQL 2000 for better performance of large query in application. Also created web based reporting application using java, Crystal Report, ASP, and SQL 2000.

Confidential

Design and maintain the Marlon Smith's catering web site using Microsoft Front Page 2000.
Creation of graphics using Macromedia Flash 5.0, PhotoShop, Dream Weaver.
Created online order application using ASP, and Visual Basic 6.0.
Wrote procedure in SQL and connection procedure in VB and ASP to SQL 2000.

System Administrator / Consultant:

Adding and configuring new workstations running on NT server and Windows 2000.
Setting up users accounts in NT server.
Create Report using Crystal Report, and VB 6.0.
Develop and implement security and inter-processor communication systems, including firewall.
Allocating mass storage space
Web Development using ASP, Front Page, HTML, Flash, and Photoshop.

Confidential

Developer / Database Administrator / Database Programmer / QA

Responsibilities include designing, implementing, and maintaining the database system using Visual Basic 6.0, Visual Fox-Pro, ASP, Oracle, Access 2000, MS SQL Server, PL/SQL, Main Frame, .Net, MS .Net Visual C++, and Crystal Report. Also establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use.

Designed and developed custom database applications using Visual Basic 6.0, front end and Oracle as back end.
Created Application using ASP, Visual Basic, and Java.
Developed Access 2000 application.
Migrated Access 2000 database to Oracle database using Visual Basic 6.0 and PL/SQL.
Database Performance and Tuning.
Install new instance of SQL Server and perform Replication, Log Shipping, and DTS on database servers.
Create security procedure for new users and account for database users.
Performing back up and recovery procedures to prevent the database and system failure using PL/SQL and Oracle.
Administration, monitor, maintained and performs tuning and testing of multiple database applications using Visual Basic6.0, PL/SQL.
Create Report using Crystal Report, and VB 6.0.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship