EDUCATION
Diploma in Computer Programming
B.S.E.E

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

Work Experience:

Confidential,Oracle/Sql Server DBA 01/19/2010 – present
His primary responsibilities:
Participate as part of a team maintaining and developing web based software applications.
Mostly MS SQL Server environment with a large, enterprise Oracle system in a dynamic, research oriented healthcare and scientific IT division of NIH.
Position involves hands on database configuration for managing databases, installing and upgrading database server and application tools; and involves some data layer software and data object development for MS SQL Server and Oracle
DBA work involves good RDBMS fundamentals; modifying the database structure as required by solution architects/developers; creating primary database objects (tables, views, indexes) from scripts or application design; controlling and monitoring user access to the database.
Pro- active management of production database systems and risk mitigation; Monitoring and optimizing the performance of the database; Backing up and restoring the database; Maintaining archived data on appropriate storage devices.
SQL query and stored procedure development, job automation, multi-table joins and query optimization
Good communications and analytical skills.
Advise project managers, business analysts and customers regarding best technical practices.
. Migration of Sql Server 2000 databases to Sql server 2008; migration of Oracle 9i databases to Oracle 11g.

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

• Performs all aspects of database administration for managing SQL Server 2005 databases .
• 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.
• implementation and ongoing support of an Oracle 10g database
• performance tuning for complex queries and data structures.
• Advanced usage of T-SQL,Triggers,Procedures, Functions for data transformations

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

• 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
• Implementation and ongoing support of an Oracle 10g database
• performance tuning for complex queries and data structures.
• Ability to use Erwin Data Modeling Tools
• Extensive use of PL/SQL.

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

• Advanced T-SQL scripting for stored objects of Sql 2005 databases.
• 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, user permissions ,grants,and security.
• Reverse-engineering of databases to the logical & physical data model.
• Advanced usage of T-SQL,Triggers,Procedures, Functions
• Reverse-engineering of Crystal Report for Impact analysis

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

• Advanced usage of T-SQL,Triggers,Procedures, Functions ODF Sql 2000 databases
• DTS package development
• ER-Win data modeling for database design document
• Use of Rational Rose approach to for design, test and release documentation

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
• implementation and ongoing support of an Oracle 10g database
• performance tuning for complex queries and data structures.
• 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,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. Views of complex queries and data structures.