Db2 Senior Database Administrator Resume
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.
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.
EXPERIENCE:
DB2 Senior Database Administrator
Confidential
Responsibilities:
- 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 Confidential 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).
DB2 Advanced Support Engineer
Confidential
Responsibilities:
- 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.
IT Support and Implementation Engineer
Confidential
Responsibilities:
- 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.
- 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).
IT Network Administrator
Confidential, NY
Responsibilities:
- 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.
- Workstation and OS upgrades or replacements, deploying workstation images.
- Migrating user personal settings (emails, customizations, files, printers, etc.) into new workstations.
IT Analyst
Confidential, NY
Responsibilities:
- 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.
