We provide IT Staff Augmentation Services!

Dba Architect Resume Profile

2.00/5 (Submit Your Rating)

Fairfax, VA

Summary

15 years of full life-cycle database development in client server and Internet. Worked on small-scale independent assignments as well as part of larger teams creating significant and complex database solutions. Solid hands-on experience and knowledge of Database Architect, Triggers, Stored Procedures, Transact SQL, relational database management systems, and Automated SQL Jobs. Exceptional problem solving skills, self-discipline, and management experience. Ideally suited for Technical Lead, Senior SQL Developer, or senior Database Architect.

Skills and Experience

  • RDBMS: Sybase, MS SQL Server
  • Database Administrator, Developer, and Architect
  • Backups and Recovery
  • DTS Packages, Data Conversions
  • Systems: Windows XP, 2000, NT , Windows NT Server 4.0, 2000
  • Software: MS Access, MS SourceSafe, MS Project, ERWin, Visio, Crystal Reports, Red Gate Tools.

Employment

Confidential

DBA Architect

  • Design and administer Microsoft SQL Server databases for the headquarters office of a large labor union. Created a scalable database design using normalization processes for databases ranging from 25 tables to 200 tables containing 10 million data records. Tuned queries, assigned proper indexes, created triggers and stored procedures. And created a variety of reports and analysis for varying constituencies.
  • Monitoring, tuning and maintaining the database servers ensuring that the servers run at optimal performance. Monitor the error log and event log for database errors, routine database maintenance performed on overall system, monitoring space requirements and adding new storage space when required.
  • Designed and developed user level security for membership users including SQL and windows accounts.
  • Created DTS packages to import and export data between various internal and external databases.
  • Designed, developed and deployed a backup and recovery process by establishing standards and schedules for database backups and developing recovery procedures for each database.
  • Transferring database structure and data from a development server to a production server and vice versa.
  • Acted as the Project Manager Liaison between AFT, Artisys, and Artisys Consultants.
  • Expert in Transact SQL.

Confidential

Database Administrator

  • Installed and maintained SQL Server 7.0 databases for a web application that allows artists to upload music and pictures to a server.
  • Enhanced web queries for the server.
  • Acted as System Administrator for the server. Managed the Server Accounts as well as the SQL accounts. Designed and deployed the database users' security and their level of security.
  • Designed, created and deployed backup and recovery duties by establishing standards and schedules for database backups. Developed recovery procedures for each database.
  • Worked with developers by assisting in the overall database design by creating normalized databases, fine tuning queries, transact SQL, assigning proper indexes, creating triggers, Transact SQL and storing procedures.

Confidential

Project Manager

  • Managed and supervised in-house programmers, MS-SQL Server and Desktop Configuration unit.
  • Held the position of MS-SQL DBA.
  • Utilized ER-Win and Visio for Data Modeling.
  • Generated daily reports for Telco's Directors on the status of the FASTER system- new clients order system.
  • Generated weekly reports for NetBase Directors on the staff activities and job functions.

Confidential

Database Administrator / Applications Manager

  • Held the position of DBA for Sybase SQL Server and MS SQL Server.
  • Held the position of team lead for programmers, Oracle DBA and Web Developer.
  • Built the Payroll Reporting System for DOT headquarter and its regions.
  • Held the position of team lead for the Y2K Project.
  • Developed the test Plan and the solution for 22 different applications using Access, Clipper and Stage.
  • Acted as System's Engineer for NT4.0 Servers and Novell's 4.x servers.
  • Evaluated and designed DOT's applications based on different systems.
  • Acted as Program Manager for the Marad contract in the absence of the existing PM.
  • Recognized by both DOT and MadenTech heads for developing user friendly, cost effective, manageable and accurate systems for the DOT's environment.
  • Involved in recommending and configuring new technology at DOT.

Confidential

SYSTEMS ANALYST contractor

  • Designed and maintained a Microfilm Tracking System-MTS.
  • Designed and maintained Literary Preservation Tracking System-LPTS.
  • Converted different systems to Utilize MS-Access and revised systems functionality to be more user-friendly.

We'd love your feedback!