Data warehousing,resume profile

EXPERIENCE

Confidential

DBA role supporting data warehouse and transactional databases.
Solving escalated DB2 issue on worldwide production, QA and development databases.
Provide OS and storage Red Hat Linux configuration recommendations for servers running DB2 and DataStage.
Identifying and escalating DB2 issues to IBM support.
Writing stored procedures, triggers and database deployment scripts according to client's specifications.
Performing common administrative jobs: deployments, restores/backups, HADR setup, upgrades, performance tuning, creating indexes and views.
Working close on common projects with application teams BusinessObjects, DataStage, CMS .

Confidential

Provide IBM's DB2 for LUW Linux, Unix, Windows product vendor support for worldwide clients.
Solving DB2 issues on customer side, identifying defects, building test cases, analyzing product's source code, escalating defects to development team.
Analyzing DB2 crashes, diagnostic logs, function's call traces, function's stacks, memory dumps, explain plans.
Providing 24/7 shift rotation support for high priority/system down calls.
Recovering 'non-recoverable' databases due to the issues with data corruptions, transaction log, binary configuration files using internal tools and techniques.
Providing configuration and optimization recommendation for customer's DB2 systems.
Mentoring and training newly hired support engineers.
Creating APARs and Tech Notes.

Confidential

Implementation, support and administration of IT Infrastructure for Business BPO .
Tracking and resolving service calls with HP OVSD ticketing system according to defined SLA standard.
Supporting 1000 users using MS Windows and variety of applications, configuration scripts, 'Ghost Images'.
Enforcing company's IT security policy on users PC's and Servers.
Implementation and support of Citrix and SAP clients, troubleshooting authentication keys certificates, keys .
Management of AD and local user accounts, file access permissions.
Administrations of Active Directory, DHCP, file servers, printers, switches, Cisco VoIP phones.
Administration and support of scanning solutions in two projects with: Scan batches, OCR and validation services, SFTP file transfer, and SAP integration.
Remote services troubleshooting: Proxy, AD controllers, routers, SAP, Citrix, MS Exchange, DNS.
Escalation of issues, coordinating the support and contacting other world-wide IT groups via Phone, E-mail.
Remote administration and monitoring of 'Business Integration Solution' systems on Linux platforms. ASN/EDI messages > XML translation/processing/validation > SAP .

Confidential

Managing and supporting all IT aspects in publishing company.
Administration of 2 Windows 2000/2003 servers and Active Directory users, access rights, backups, patches, DHCP, DNS, file server and print server .
Network administration: Cisco switches, VLANs, cabling upgrades.
Administration and maintenance of 20 workstations, OS installation and configuration, hardware service and upgrades, login scripts configurations, desktop software support.
Administration, support and installation of 35-40 HP network printers and scanners.
Coordination the workflow between production/printing and preproduction/editing departments.

Confidential

Participating in short-term migration projects.
Workstation and OS upgrades or replacements, deploying workstation images.
Migrating user personal settings emails, customizations, files, printers, etc. into new workstations.

Confidential

Designing, implementing and supporting Windows NT / 2000 and NetWare small office LAN networks.
Network installations and upgrades including cabling, switches, hubs wire panels.
Providing user support on site and over the phone to company's customers.
Installation and configuration Microsoft's products: Server, Workstation, Exchange, IIS, Proxy, DHCP, WINS, migrations from Novell 3.11 to Windows 2000 Server.
Assembling, servicing and upgrading servers and workstations. Implementing backup solutions.

SKILLS

English language - fluent in speech and writing, Russian language - intermediate, Polish - native.
Advanced knowledge of 'DB2 for Linux, Unix and Windows': db2dart, db2pd, db2look, explain plans, snapshots, HADR, backup and recovery, system catalog tables, DPF, db2trc, DB2 internal architecture.
Advanced knowledge of Microsoft Products: AD, Terminal Services, DNS, DHCP, ISA, Exchange, IIS.
Advanced knowledge of AIX: system calls, LVM, VIOS, HMC, LPAR, WPAR, performance monitoring.
Administrative knowledge of Solaris and Linux.
Knowledge of network protocols: TCP/IP, DNS, DHCP, SSH, RIP, OSPF, EIGRP, ISL, 802.1Q, WLAN.
Knowledge of Cisco solutions at CCNA level.
Knowledge of security tools and solutions, Firewalls, VPN, SSH, iptables, PKI, NMAP, WireShark, Proxy.
Knowledge of scripting languages: SQL PL, Bash, AWK, VB Script, Dos batch, VBA.