|
|
|
|
|
|
 |
Search jobs by location:
Austria, Belgium, China, Malaysia, Mexico, Netherlands, Qatar, Saudi Arabia, Singapore, Thailand...More locations »
Search jobs by category:
Accounting, Administrative, Advertising, Architecture, Banking, Beauty/Cosmetics, Biotech, Computer, Construction, Customer Service, Design/Multimedia, Education, Engineering, Information Technology, Sales...More categories »
|
|
|
|
|
|
|
|
| Position wanted: |
Database Specialist |
| Job category: |
ComputerConsultancyInformation TechnologyInternetProgrammerSoftware DevelopmentTelecommunications |
| Objective and Resume Summary: |
|
Objective
Database Specialist with 14+ years of IT experience, with Oracle,
Teradata and MS SQL Server skills and many years of international
Experience is offering his expertise.
Technical Skills
Logical and physical data modeling, database design
Database administration, development and programming
Business and data analysis
RDBMS:
Oracle 7 through 10g (8 years)
Teradata V2R6.0, V2R6.1 and V2R6.2 (2+ years)
MS SQL Server 6.5, 7.0, 2000 (2 years)
Operating systems:
Unix (hp-ux, Sun SPARC Solaris, HP Tru64, Ibm Aix, Ncr Mp-ras)
Linux
Windows 2000/XP
Experience with high availability systems and Oracle running on
Top of them
Experience with transactional systems as well as data warehouses
And reporting systems
Data modeling tools: Erwin (strong experience),
Oracle Designer (not recent experience)
Programming languages: SQL, PL/SQL, Teradata SPL and MS Transact SQL,
UNIX shell scripting, C/C++, and others
ETL tools: Oracle Data Integrator (formerly Sunopsis), DataStage
Experience with various database and/or OS monitoring and diagnostic tools
Other tools and applications: Quest TOAD, SQL Navigator and Spotlight,
Siebel EIM, Rational ClearCase and ClearQuest, Crystal Reports,
Intersolv PVCS Version Manager and Version Tracker and others
Soft Skills
Excellent communication skills
Excellent documentation skills and technical writing abilities
Negotiation skills
Attention to detail
Wide problem-solving and troubleshooting skills
|
| Skills: |
Oracle Teradata database specialist consultant administrator DBA modeler modeller |
| Known languages (and levels): |
English-Very GoodGerman-A littleRussian-GoodOther: Slovak
|
| Type of Employment wanted: |
ContractFull TimePart TimeTemporary
|
| Minimum Yearly Salary in Numbers: |
Unspecified
|
| Current Location: |
Czech Republic, Prague |
| Education History, Qualifications & other additional information: |
| Level of Education: |
Masters
|
1987 - 1992 Comenius University, Faculty of Mathematics and Physics
Bratislava, Slovakia
- Master's degree in mathematical analysis achieved
|
| Work History & Experience: |
| Years of Work Experience: |
10 to 15 Years |
Current Position
January 2006 - present Teradata, Czech Republic, Ltd.
Prague, Czech Republic
(formerly NCR, Czech Republic, Ltd., Teradata division)
Professional Services Consultant
As member of the Professional Services team participated in two projects
from telecommunication area and one project and pre-sale activities
for a transportation industry customer.
Project: DHL Data Warehouse Commercial for DHL, Prague, Czech Republic
(January 2008 - present)
- Held the role of Teradata Databases Specialist on this project.
- Participated in database consolidation carried out together
with migration from one Teradata server to another.
Utilized Subversion version control system.
- Modified data materialization procedures based on business analyst's
inputs.
- Wrote various shell scripts necessary for the warehouse
operation/miscellaneous tasks.
Project: Enterprise Data Warehouse for KyivStar, Kyiv, Ukraine
(August 2006 - present)
- Held two roles on this project: Telco Data Model Specialist and
Teradata DBA.
- Participated in the following analyses:
- KyivStar's source systems analysis
- Current data warehouse analysis
- Business analysis with end users
- Also participated in Teradata's Telecommunication Logical Data Model
customization to KyivStar's requirements, physical data model design
and its database implementation.
Worked on finance and campaign-related subject areas and tested the
corresponding ETL.
- Carried out most of DBA activities: designed and created database
hierarchy, initially sized the databases and managed their sizes
afterwards, created and modified according to developers' needs all
database objects, set up users, roles, profiles and general security
rules based on customer's internal standards, designed and maintained
table compression and statistics collection, carried out various
maintenance tasks (packdisk, showfsp, scandisk, checktable, etc.),
backed up and restored databases according to project's needs,
monitored operations of Teradata systems, configured workloads, etc.
- Participated in ETL development: implemented, in Teradata
user-defined function written in C, finite state machine algorithm
to determine phone number call area. Also implemented in C
phone number normalization functions.
- Interfaced business users at interviews during business analysis
phase, KyivStar's IT staff, Ukrainian contractors developing ETL,
Teradata technical support staff and others.
- Wrote several manuals: "C User-defined Functions Documentation",
"DBA Documentation", co-authored "ETL Operation Documentation",
"ODI Development Documentation", "ODI Knowledge Module Documentation",
"ODI Administration Documentation" and
"Technical Architecture Documentation".
- After initial customer's discontent with automatically generated
"ODI Development Documentation", designed documentation sample to
their satisfaction and subsequently documented finance-related facets.
- Administered Oracle occasionally - e.g. saved Sunopsis repository
by fixing its corrupted database.
Pre-sale activity: Business case for DHL, Prague, Czech Republic
(July 2006)
- Prepared supporting materials for business case with the customer;
analyzed their warehouse data and calculated approximate potential
savings.
- From the financial point of view, the resulting project turned out
to be the most successful one for Teradata with this client.
Project: Enterprise Data Warehouse for Eurotel (now Telefonica O2),
Prague, Czech Republic (January 2006 - June 2006)
- Got familiar with Teradata RDBMS on this first Teradata-based project.
- Worked on bug-fixing in production data warehouse; analyzed data and
ETL process, diagnosed the bugs and proposed changes to ETL and/or
data. Carried out the changes - wrote the necessary SQL.
Got acquaint with the data model (ERwin) and ETL process (SQL scripts
and DataStage).
- Took part in team effort to test the 3R customer segmentation.
Previous Positions
August 2005 - November 2005 McKinsey & Company, Inc. Prague, Czech Republic
Oracle DBA
Oracle database administration in one of the company's global helpdesk
call centers.
- Oracle data management 2nd level support, formally regulated by ticket
system.
- On scale of 0 to 5, achieved 4.8 to 4.9 points according to end-user
satisfaction survey ratings.
December 2003 - July 2005 Group Health, Inc. New York, NY
Data Architect
Data Architecture for this health insurance company, mainly for its
largest and most important project, Claims and Providers Redesign
(CPR) - new claims processing system to interface and communicate
with the current production system running on OS/390.
Also worked on other projects, both new and modifications of existing
production systems.
- Data architecture, physical and logical data design using CA ERwin;
creation, management and production maintenance of database objects;
UNIX Korn Shell scripting; utilization of SQL*Loader, Export and
Import tools to load the data from mainframe extracts and PL/SQL
development to transform the data in order to load it correctly.
Occassional database tuning.
- Delivered to production operation the Claims History, Contracts
and Medical Coverage History components of the CPR project.
- Interfaced and cooperated with DBA group to create and configure
the Oracle databases in accordance with system's needs, with
mainframe programmers to ensure proper creation and load of data
extracts, with application developers developing the from-end parts
and occasionally with business units to cover for absent business
analyst.
July 2003 - October 2003 Czech Savings Bank, Inc. Prague, Czech Republic
Oracle Database Specialist/DBA
Worked as Oracle Database Specialist for the IT Infrastructure
Development Department of the largest bank in the Czech Republic.
- As department's Single Point of Contact for the bank's CRM & DWH
projects, coordinated projects' infrastructure requirements
in accordance with existing bank's infrastructure.
Dealt with external providers and with system integrator.
- Worked as a DBA for the CRM project. Participated in database
design and tuning, worked with Siebel experts on tuning the EIM
and base table load.
- In cooperation with Siebel experts optimized both initial and
incremental data loads according to CRM project's requirements.
- Provided comparison of several options for High Availability
solution of the DWH project. Helped the project to choose the most
appropriate one.
- Provided evaluations and comments on various provider-prepared and
internal solutions from the architecture and infrastructure point of
view.
- Participated in department's internal project "Monitoring and
Administration of UNIX systems" that set standards for the bank.
Authored the part on monitoring and administration of Oracle
databases running on UNIX systems.
August 2002 - January 2003 Merck & Co., Inc. Rahway, NJ
Oracle Database Engineer/DBA
Worked as a contractor for the Merck Research Laboratories, managed and
supported their Oracle8i production, test and development databases in
their distributed environment with replication.
- 'Owned' and supported the database schema of research data.
Worked on analysis and translation of end-user and application
developer requests into the appropriate database design.
Tested the changes and implemented them in production.
- Established the standards of database object version management
utilizing Rational ClearCase. Created initial baseline for all
production database objects in both the master database and its
replica. Responsible for the succeeding version management of these
database objects.
- Utilized various tools to implement the requests and provide services
such as logical and physical data modeling, SQL tuning, SQL and
PL/SQL coding and review.
Used Rational ClearQuest to manage change requests.
- Interfacing daily with the Basic Research Application Engineering
and Support groups.
July 1999 - July 2001 News Digital Media, Inc. New York, NY
Database Administrator/Engineer/Data Modeler, Lead DBA
Websites supported:
fox.com
foxnews.com
foxsports.com
thesimpsons.com
and others.
- Installation, configuration, management, tuning and troubleshooting
of Oracle and MS SQL database servers, production and development
databases.
- Responsibilities:
- Perform database analysis, design, coding, testing and
implementation of database structures and schema objects.
- Install, test, evaluate, implement and maintain all DBMS related
system software and tools.
- Review database access code and recommend tuning opportunities.
- Design and implement database backup and recovery procedures.
- Monitor and tune database performance, including SQL tuning.
- Actively recommend changes to increase efficiency, minimize
operating expense or improve accuracy and timeliness of application
systems.
- Develop, document and enforce database standards and procedures.
- Maintain and improve high availability and disaster recovery.
- Designed, developed, and successfully delivered several applications
and systems for the company. Maintained the applications in production.
- Participated in high-level architectural design and decisions
regarding newly developed systems and applications.
- Development and tuning of SQL, PL/SQL and T-SQL code, UNIX shell
scripts and Windows NT command batches for database backup, data
upload and other purposes.
- Supported company developers in their programming efforts - advised
on Oracle and MS SQL Server database development.
- Mentored one junior DBA.
- Tools used for administration: Oracle Enterprise Manager,
DBA Management Pack, Diagnostic Pack, Tuning Pack, Quest TOAD,
SQL*Loader, Export/Import, Korn Shell script (wrote scripts for
database backup, export, cluster fail-over and other purposes),
Server Manager, SQL*Plus and others.
- Tools for Oracle database monitoring - Oracle Enterprise Manager 2.1,
CA ManageIT suite of tools.
April 1995 - March 1999 Login, Inc. Stupava, Slovakia
Oracle Database Administrator/Developer, System Analyst/Data Modeler
Responsibilities:
- Installation, configuration and management of various Oracle software.
- Planning, creation, configuration, management and tuning of Oracle
databases for company and its customers.
- Logical and physical data modeling using Oracle Designer and
CA ERwin.
- SQL and PL/SQL development and tuning.
- Worked on and successfully delivered several Oracle database
administration and development projects; e.g. the ING Bank, Slovakia,
the National Bank of Slovakia (Slovak central bank),
the Slovak Clearinghouse and other customers, mostly from financial
industry.
- Analysis, design, testing, delivery and customer support of
the Domestic Payment System for ING Bank, Bratislava;
analysis & design method used: Grady Booch's OOAD, system designed
using Oracle Designer ran on Oracle database.
July 1992 - March 1995 Slovak Insurance Company, Inc.
Bratislava, Slovakia
System Analyst & Designer/Data Modeler, Programmer/Analyst
Responsibilities:
- Analysis and design of new information system for the company.
Mostly logical data analysis and modeling. Structured analysis
method (ER diagrams, etc.).
- Life insurance analysis and programming (insurance mathematics,
technical calculus). Languages: C, FoxPro.
|
|
|
|
| Jobseekers:73609 |
Resumes:68165 |
Employers:8083 |
Jobs:19537 |
|
