Database Administrator Intermediate / ETL Database Developer Resume

SUMMARY:

Highly skilled IT Specialist in designing, implementing and maintaining client/server and user interface applications.
SQL technical skills in: Data migration, ETL, Data modeling in MS SQL Server ( 2005,2008), Ingres and Informix Environments.
Excellent knowledge in developing SSIS packages and UNIX and DOS scripting.
Strong Transact SQL skills, including stored procedures and udfs. good knowledge of Oracle PL/SQL

TECHNICAL SKILLS:

Numerous courses taken in: OpenRoad, Ingres Database Administration, Database Design, SQL, Embedded SQL with C and COBOL, Unix Administration, C++, Unix Shells, Database Management, Networking and Data Communication.
Self taught in Visual Basic, PHP, JAVA, JavaScript, HTML

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator Intermediate / ETL Database Developer

Responsibilities:

Primary resource for several critical mission data integration and conversion services for many Real Estate databases in Microsoft SQL Server environment.
Developed and executed complex SQL Server Integration Services (DTS/SSIS) packages.
Developed and executed T - SQL, DOS and UNIX script jobs.
Performed many data and metadata modifications according to customer specifications using high quality standards.
Managed changes as per customer requirements and I attended internal meetings to represent our team at cutover process
Supported, troubled shouted, fixed data migration problems for complex and large data exchange in staging and production.
Determined approach and change specifications in support of data exchange.
Performed data cleansing from different data source to unsure for data migration success.
Transformed data from various data sources: delimited text, Excel and Access files.
Coached junior staffs.
Monitored data feed processes and data transfer between data exchanges and developed Audit process between the systems.

Confidential, CA

Database Administrator

Application Developer

Collected and identified new requirements on a mission critical database (National Coal Resources Data System) that holds information on US coal drills.
Managed and maintained OpenRoad applications.
Analyzed, designed, coded, tested and implemented changes to GUI that is similar to ORACLE form or VISUAL BASIC
Monitored access and security to the databases and the applications.
Provided Help Desk support to users.
Designed, developed and tested data validation tools using Visual Basic and ODBC.
Generated on-demand reports as per users’ requests.

Ingres DBA

Performed data conversion from MS Access & Excel Files to Ingres objects
Installed and configured Ingres and Ingres client (a relational Database System) on Solaris and Widows platforms.
Wrote SQL, C-Shell and Bourne Shell scripts to automate DBA tasks.
Monitored access and security to databases.
Advised management on Hardware and Software upgrades and on GUI design, security and integrity of data.
Generated on-demand reports as per users’ requests.

DBA Administrator:

Installed and configured Informix on Solaris.
Created R-indexes to enhance and improve spatial query performance.
Performed data migration from MS Excel, MS Access and Ingres to Informix.
Advised management on Hardware and Software upgrades.
Performed data conversion from MS Access & Excel Files to Informix File format and vice versa.

Confidential

Application Developer

Responsibilities:

Responsible for the maintenance of the Travel Management System (TMS) for the Census Bureau.
Maintained and Modified a character base interface application, using Ingres ABF/4GL tool on a VAX/VMS environment
Maintained and modified embedded SQL reports written in with C and Cobol Languages.
Designed, developed and implemented new features as per new business rules.
Wrote a set of utilities in PL/SQL that converts a Per Diem rates delimited files to Oracle and Ingres tables.
Provided Help Desk support and trained new users and developers.

Confidential

System Programmer and Quality Assurance Specialist

Responsibilities:

Developed a set of database validation tools in PL1 language on IBM CMS main frame.
Developed Hardware/Software Tracking System using Windows4GL and Ingres Database.
Designed and performed Test Plan and Test Cases for the validation of a telecommunication software.