SQL DBA
Resume:
STEVE T. NGUYEN
HOUSTON, TEXAS 77084
**********@*******.***
HOME# 281-***-****
POSITION SQL Database Administrator
EDUCATION 1995 - B.S. Business Management, Letourneau University Concentration in the skills required to make effective business
decisions and formulate short and long-range plans.
CERTIFICATIONS 01/2009 - Oracle Database 10g Administration I
12/2008 - Microsoft Certified Database Administrator
09/2008 - Microsoft Certified Professional (MCP) Managing and Maintaining Windows Server 2003
11/2001 - HTML 4.0, Access VBA, Java Scripting, IIS, and ASP.
10/2000 - Mastering Visual Basic 6 Development
TECHNICAL SKILLS
O.S.
Windows NT4/2000/2003 Server; Workgroups; XP; 2000; ME; 98 & 95; MS-DOS, Red Hat Linux Enterprise 4&5.
RDBMS & WEB
DEVELOPMENT SQL Server 6.5/7.0/2000/2005, Oracle 9i/10g, MS-Access 95/97/2000/2003/2007, OLTP, OLAP, Business Intelligence(SSAS), Reporting Services, Integration Services(SSIS), Data Transformation Services(DTS), VBA, C#, ASP.NET, Excel, Word, Visio, HTML; XHTML; XML; IIS; FTP; DNS; Mail Server, VB6, VBScript, JavaScript, OLE DB, ODBC, LAN & WAN.
MAINFRAME IBM MVS/ESA COBOL, COBOL II, JCL, VSAM, TSO/ISPF, ROSCOE; Utilities: Xpediter, Idcams, Syncsort, Dylakor, File-AID, Viasoft.
ASSIGNMENTS
MailTech Marketing 06/2007 – 12/2008
SQL Database Administrator
- Managing and Monitoring SQL Server 2005 Security.
- Design and create SQL 2005 Reporting Services.
- Design SSIS packages.
- Implementing and Managing Business Intelligence.
- Perform a full Database, and a Differential Backup.
- Perform a file or Filegroup Backup.
- Perform a Transaction Log Backup.
- Perform a Complete and a Differential Database Restoration.
- Restore a Database to a different SQL Server Instance.
- Managing and Manipulating Data using the bcp Utility and the Bulk Insert Statement.
- Implement SQL Server Databases, Tables, Stored Procedures, Triggers, Views, Indexes.
- Using Distributed Queries to Access External Data.
- Using Cursors to Retrieve Data.
- Perform XML tasks using SQL Server XML features.
- Index Tuning and Database Partitioning.
- Setting up and testing a Link Server Configuration.
- Installing and Configuring Mail Server.
- Managing Domain registration, Forwarding, and Locking.
- Installing and Configuring Windows Server 2000/2003.
- Administering Internet Information Services and Web Environment.
- Configuring and Managing Web and FTP Sites.
- Configuring Disks and Volumes.
- Planning RAID Configuration.
- Disk Defragmenter; Disk Quotas.
- Managing Users, Computers, and Groups.
- Develop and maintain a Personalized Vehicle Web Page “Driver Online Services” for customers and prospects with features like:
o Personalized email service reminders, recall notices, maintenance schedules, and vehicle service history.
o Immediate access to showroom promotions and service specials.
o Access maps, directions, traffic reports and much more.
- Develop Customer Value Matrix report to segment exiting vehicle buyers based on their service spending and loyalty.
- Export/Import data from or to various formats like delimited raw and text file to Excel, XML, SQL Server, and MS-Access.
Gulf State Toyota 10/1999 – 06/2007
SQL Database Administrator
- Backup and Restore Databases, Files, Filegroups, and Transaction Logs
- Created and Configured User Database; Modified Database Options
- Configured SQL Server 2000 Disk Subsystem for Performance, Fault Tolerance, and Recoverability.
- SQL Server Monitored and Tuned: Profiler, Trace, Index.
- Transferred and Transformed Data with DTS Graphical Tools.
- Used Bulk Copy Program (Bcp) and Bulk Insert Transact-SQL Statement.
- Created Application Roles and Managed Users Login.
- Created and Reviewed Jobs and Job History.
- Created Operators and Set Fail-Safe Operator; Configured Alerts.
- Performed Monitoring tasks.
- Planed and Implemented Replication.
- Created Snapshot, Transactional, and Merge Replication.
- Reviewed and Modified Distribute Publication, and Subscription Properties.
- Identified the goals and scope of a database development project
- Created and configured User Database, Stored Procedures and Triggers
- Developed and maintained ORP (Owner Relationship Program) Email system.
- Developed and maintained SQL Databases for Lexus and E-enroll system.
- Installed and supported internal SQL 2005 Databases for ProMail system.
- Configured SQL Mail and SQL Agent Mail.
- Maintained Oracle database tables for Dealer’s coupons.
- Created, managed, and troubleshoot user and group accounts.
- Diagnosed and resolved account lockouts.
- Created a Cursor to Retrieve Data.
- Administered Windows Server 2000/2003.
- Configured and Managing Web, FTP Sites, and Internet Information Services.
- Configured file system permissions.
- Created and Managed User Objects and Profiles.
- Secured Authentication with Policy.
- Managed and Modified Group Accounts.
- Configured Disks and Volumes; Extending Volumes.
- Implemented Disk Fault tolerance: Striped, Mirrored, and RAID-5 Volumes.
- Configured and Maintained Mail Server.
- Created and Maintained Toyota/Scion databases in SQL Server 2005.
- Converted Mainframe VSAM data to flat files and transferred data to SQL tables.
ENRON 10/1997 - 10/1999
Consultant
- Implemented and tested Year 2000 COBOL/COBOL II, COBOL MVS, and Realia-COBOL.
- Maintained the systems of Accounts Payable, Accounts Receivable, Purchase Payable, Financial Statements, and Taxing.
- Imported ASCII files (created by Realia-Cobol) into SQL 6.5.
- Converted Access95 Databases into Access97 Databases.
- Backup, Restore, and setup Users security for MS Access97 Databases
- Supported and provided guidance to users and programmers.
BONNER & MOORE 04/1997 - 08/1997
Programming Supervisor
- Developed and maintained BARCODES 39 and 128 for the City of Houston.
- Maintained an existing product COMPASS 6 using IBM & DEC COBOL.
- Supervised and oversaw the workload of team members.
- Supported and provided guidance to users and programmers.
GC SERVICES 10/1990 - 04/1997
Senior Programmer Analyst
- Developed and maintained COBOL/COBOL II applications, M204 RDBMS procedures and system designs.
- Established and implemented project estimates and task planning; analyzed problems; tested systems; documented project.
- Provided guidance to clients and junior programmers.
- Installed testing system for Windows NT Server 4.0 and MS SQL 6.5 which included creating tables and reports for each application.
- IBM’s certified for COBOL II and MVS/JCL.
Contact this candidate