We provide IT Staff Augmentation Services!

Sql Server Dba Resume

3.00/5 (Submit Your Rating)

New Jersey, NJ

SUMMARY
This Systems Engineer has over ten (10) years programming experience inthe PC arenawith the primary applications being office automation, inventory control,and logistics tracking support. His software experience brings ORACLE, SYBASE, INFORMIX AND MS SQL SERVER to solve the intricate problems of today\'s environment.

EDUCATION
Diploma in Computer Programming,specializing in Business Programming
B.S.E.E., specializing in digital systems for aerospace technology

SPECIFIC KNOWLEDGE AND EXPERIENCE


DATABASES

Oracle 10g

SQL Server 2005

LANGUAGES

PLSQL

TSQL

Work Experience:
Confidential, Oracle / SQL Server DBA January 2008 – Oct 2009
His primary responsibilities are :

  • Performs all aspects of database administration for managing databases and SQL Servers.
  • Proficient in planning, analysis, designing, and constructing databases.
  • Knowledge of industry standards and best practices for database security and capable of

analyzing and defining database and information security requirements.

  • Develops database queries, applies patches and fixes, performs backup/recovery, tunes
  • database and creates database schemas.
  • Develops SQL queries, back-end programs, Oracle user permissions and grants, and Oracle security.
  • Assist in defining file organization, indexing methods, and security procedures for specific user applications
  • Provide assistance in designing the logical data model and physical data model.
  • Execute performance tuning activities of installed Production Database.
  • Integrate and import data from multiple platforms and applications into an existing centralized data store.
  • Design, develop and deploy applications and databases on multiple platforms for mainframe and Windows enterprise environments
  • Extensive use of PL/SQL.

Confidential, Oracle DBA March 2007 - Oct 2007
His primary responsibilities included:

  • Installation and configuration of the Oracle Application server Coordinate releases
  • Checking PLSQL for coding standards and executing ad-hoc queries

Confidential,SQL Server DBA September 2006 – March 2007
His primary responsibilities were:

  • Backup / restoration of databases
  • Refreshing of indexes and performance of consistency checks, tuning of SL statements and stored objects
  • Advanced T-SQL scripting for stored objects

Confidential, SQL Server DBA September 2005 – September 2006
His primary responsibilities included:

  • Backup / restoration of databases
  • Refreshing of indexes and performance of consistency checks, tuning of SL statements and stored objects
  • Advanced T-SQL scripting for stored objects

Confidential, Developer March 2004 – September 2005
His primary responsibilities were:

  • Maintenance of DOCEX application code using Oracle 9i views for reporting via Crystal Reports.
  • PLSQL Developer is used as a development tool
  • Migration of legacy system to .NET

Confidential,Advanced Medical/CSC February 2004 – March 2004
His primary responsibilities were the maintenance of a Powerbuilder 7 application utilizing SQL Server 2000 as the database for medical records tracking

Confidential, (Contract) December 2003 – February 2004
His primary responsibilities were a report writer in Powerbuilder 6.5 to Oracle 9 via Powertool for an in-house conversion project from JD Edwards to a more conventional system. Oracle PL/SQL development was performed via PL/ SQL developer.

Confidential, (Contract) February 2002 – November 2003
His primary responsibilities were the maintenance of a migrated Powerbuilder 7.x application to track call center responses for the Federal EmergencyManagement Agency (FEMA). This application uses MS SQL Server 7.x to facilitate contractual reporting. As part of his daily duties, he was the SQL Server DBA. These duties included: creating instances of the database, backup/restoration of databases, performance of advanced SQL for reporting purposes, writing stored procedures, triggers and views, disaster recovery and configuration management.

Confidential, (Contract) November 2001 – February 2002
His primary responsibility in the early phases of this database system was to provide mockup support for JAD/ RAD session screens. Eventually, the Child Welfare System for the State of MD was designed using Powerbuilder 7 to Sybase EAS Server to UDB [aka DB2].

Confidential, March 2001 – September 2001
His primary responsibilities were the re-engineering of the distributed Powerbuilder 7 pieces of the Army\'s Financial Management (FMIS) Information System. Other duties included: Sagent data warehousing training and data conversion; SQL Server 7 table techniques and n-tier architectural approaches.

Confidential, September 2000 – March 2001
His primary responsibilities were the maintenance of the client server applications in Powerbuilder 6.5 and to integrate this with Oracle 8i. His duties included the maintenance of code and data quality ofthe financial benefit plan information, minor DBA for the develop and test instances. Future plans included a thin client browser based solution as directed.

Confidential, September 1999 – September 2000
His primary responsibilities were the Design & Development of client - server applications for the FAA involving the categorization of unauthorized spare partsutilizing Powerbuilder 6.5, PFC & MS SQL Server. This involved the use of many hats: DBA with Enterprise manager; establishing foreign key relationships; establishing new design methods to solve problems; participating in involved design questions and deployment methods. A further explanation of duties involved the DBA functions of create tables, alter tables and add constraints, populate these tables, creating instances of the database, backup/ restore of databases, perform advanced SQL for reporting purposes, writing stored procedures, triggers and views and configuration management; participating in design reviews, establish the deployment methods of server- push technology across an intra-continental divide to over 100 sites and 5000 users.

Confidential, November 1998- September 1999
His primary responsibilities were Development Design & Development of client - serverapplications for the US State Department involving the naturalization process utilizing Powerbuilder 6.5, PFC and Oracle 8. Integrated the use of the rich text edit control for LARGE mail merges from database constraints. This technique was necessary because of the volume (minimum 2000/day) and position of the data within the database.

Confidential, April 1998 – October 1998
His primary responsibilities were Development & Maintenance programming in Powerbuilder 5.0 (16-bit) for a tracking system(s) to the Dept of Energy; development of simple stored procedures for Sybase System 11. This process involved Rapid application development techniques [total SDLC decisions in 15 sec or less], system architecture, window navigation and update methodology. This was also the first project with the Powerbuilder PFC. Familiarity of DB Artisan for DBA work with Sybase proved invaluable.

Confidential, December 1997 - February 1998
His primary responsibilities were the maintenance ofthe maintenance of programming in Powerbuilder 5.0 (16-bit) for a data processing tracking system on contract to the Nuclear Regulatory Commission utilizing Sybase System 10.

Confidential, August 1997 – December 1997
His primary responsibilities were the maintenance ofthe imaging tracking system in Powerbuilder 4.0on contract to the Federal Emergency Regulatory Commission utilizing Informix. An additional assignment, while on contract was the maintenance of programming in Powerbuilder 4.0 for a medical tracking system on contract to the US Coast Guard with primary emphasis in Mail enabled data windows utilizing Oracle 7.3.

We'd love your feedback!