Business Operator / Manager Resume Placentia, California - Hire IT People

SUMMARY

Technical Design Lead of a complex Data Warehouse
Experience with SDLC Methodologies
Excellent analytical, problem solving and debugging skills
Proficient in SQL programming and tuning
Broad experience including Oracle DBA and developer
Excellent written and oral communication skills

TECHNICAL SKILLS

UNIX/NT ORACLE
UNIX C/PERL/Shell
VAX - VMS/UNIX INGRES (V6)
UNIX C++/JAVA
Windows C#/.net
SUN UNIX / WIN. NT DEVELOPMENT ENVIRONMENT
VAX VMS DCL, MMS, CMS, TPU,DEBUG
IBM (pc) MSDOS/XENIX NOVEL NETWARE, MOST PC
SEQUENT UNIX SCCS, BOURNE/C/KORN SHELL

PROFESSIONAL EXPERIENCE

Confidential, Placentia, California

Business Operator / Manager

Responsibilities:

Acting technical design lead and deputy team lead
Collecting data from business analysts, understanding and interpreting their functional requirements and translating them to robust technical design
Overseeing full lifecycle system development process
Debugging and tuning of SQL and PLSQL programs
Writing Unix/Perl scripts and overseeing the test cycles
Design of complex application to extract data, process data using Oracle 4GL and transfer data from Switzerland to USA using Oracle Data Guard replication feature

Confidential

Senior Oracle Database Engineer/Integrator

Responsibilities:

installing, packaging and using above tools to run the application on all platforms
Migration of DB from Sparc Oracle10g to Oracle11g on X86 writing Unix shell scripts and PLSQL/SQL programs maintaining development and production databases and performing the required database tuning using OEM advisors and AWR reports
Installing Powercentre and using Informatica mapping tool to read in data into database
2 nd and 3 rd level Production Support
Support and installation of standby database ( Data Guard )
Developed and maintained .Net application using Visual Studio and C# to connect to Oracle database and provide a schedule of support for the team

Development Platform/Tools: Oracle11G (11.2.0.2 ) SOLARIS10 with ASM . Repository for version management used are SVN . Casetools Sybase-Power Designer . Good exposure to the Power Centre administration and the mapping Tool.

Confidential

Senior Oracle Database Developer/Engineer/Analyst

Responsibilities:

data modelling of a new application layer using Power Designer developing PLSQL packages and loading the framework using Power Center and unix scripts maintaining the development databases and performing the required database tuning generation Data Access Layer using Hibernate software

Development Platform/Tools: Oracle10G (10.1.0.4 ) SOLARIS10 . Repository for version management used are CVS . Casetools Sybase-Power Designer . Good exposure to RAD-Hibernate and the Power Centre Tool.

Confidential

Senior Oracle Database Developer/DBA/Architect

Responsibilities:

creating and managing Oracle Databases from development to the production environment. Backup and recovery using SQL-Backtrack and RMAN. Use of Statpacks and Tkprof reports for tuning purposes . tuning both at the database level and the SQL statements developing a suite of programs (using PLSQL/Shell/Perl/C ) to capture data and load into database for further transformations. Developing common routines which are then packaged and used by all applications providing Unix support and developing programs to automate running of the batch jobs in the initial phases involved in the logical design and the data modelling (ERM)
A nalysis, D esign, D ocumentation and I mplementation ( ADDI ) of parallel loading process of hundreds of Giga files using Perl, SQL-Loader, PLSQL, SQL. Involved complex realtime semaphore/lock mechanism
ADDI of an automated process transferring 13 Terabytes of data between Datamart and Datawarehouse instances using Transportable Tablespace (TTS) . Programmed in PLSQL, Kornshell and Perl
Many PLSQL programs written to implement interfaces with other sources. UTL FILE was used to export the data to files which was then sent via ASI using internal ASI-calls in Perl-scripts
ADDI of a Daemon process allowing interface from PLSQL programs to the server. This was then used as part of a job scheduling process. Written in PLSQL and Pro-C
Developed a web-based application to enable automatic job control using HTML, OWA suite of applications and JAVA
ADDI of an authentication process used to give user access to tables/rows/columns according to the user Schutzcode . Daily jobs were created to capture and allocate user rights (roles). On user-login triggers create the Fined Grained Access (FGA) which gave the user the required view of the information
Many SQL-scripts written to query system catalogues and ease monitoring the DB and performance tuning

We provide IT Staff Augmentation Services!

Business Operator / Manager Resume

Placentia, CaliforniA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship