It Coordinator/db2 Dba Resume
Atlanta, GA
OBJECTIVE
- Become a high level professional in the IT industry demonstrating my experience, knowledge and skills; improving and training myself in order to be more TEMPeffective and efficient; providing the most appropriate suppor
- Service and solutions being always a very hard worker keeping my sense of responsibility and professionalism.
TECHNICAL SKILLS:
Operating Systems: Windows, Unix/AIX/HP - UX and Linux
Databases: DB2, little bit of Postgres SQL and Access
Programming Languages (little): C++, HTML, Shell Script, Visual Basic, Visual C++, Visual Fox Pro, SQL
Web technologies: UVATS, ManageNow, Rational ClearCase, Rational ClearQuest, CMVC, Lotus Notes, Remote Desktop Connection, VNC, Peregrine Service Center, Peregrine Asset Center, CITRIX, Application Management Tool, WebLogic, BladeLogic, FileZilla and Websphere, Remedy, Service Now, IT Portal and Confidential Maximo
Content Management: Rational Portfolio Manager, Perforce, SharePoint, HP Service Manager, CA Harvest Software Change Manager Workbench
Tools: and IDEs: Lotus Notes, MS Office, Advanced Query Tool, Confidential InfoSphere Data Architect, Confidential InfoSphere Optim Performance Manager, ftp/sftp, Putty, SSH Tectia Client, WinSCP, UltraEdit and Notepad++
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
IT Coordinator/DB2 DBA
Responsibilities:
- Weekly and monthly database partitioned maintenance (roll in and out of data)
- Attach and detach data partitions as needed
- Package (SQL changes) promotions and demotions between environments, making modifications if needed
- Workloads management and connection detail
- Data refreshes and copies for regression tests
- Monthly audit and attestations to check authorities and roles, making sure nobody is granted wif more than specified/needed
- Monitor Gloden Gate replications
- Tables backup and tablespaces creation
- DB2, STMP, Gloden Gate and OPM recycles
- Month end activities, triage problem situations, force idle users/connections/applications and consuming processes off from the database as necessary to reduce contention and ensure tasks continue and complete
- Provide object (schema, tables, sizes, etc) details to application teams, QA team and IT analysts
- Monitor workload and expensive queries on the databases
Confidential, Minneapolis, MN
DB2 DBA
Responsibilities:
- Execute physical changes/modifications to databases structure and migrations
- Investigation, analysis, troubleshoot and resolution of databases related problems
- Control database access, grant/revoke authorities and privileges
- Database maintenance (reorgs, runstats)
- Maintain DB2 availability
- Database online/offline backups
- Database recovery and restores
- Set up DB2 HADR
- Control database access, grant/revoke authorities and privileges
- Oncall rotation and SLA adherence (24x7)
Confidential, Minneapolis, MN
DB2 DBA
Responsibilities:
- Build, and configure databases to meet specifications documented in physical Technical Architecture Design (TAD) documents
- Work closely wif application developers, data modelers, engineering, security administrators, capacity planning and monitoring, service desk scheduling and network administrators as needed
- Configure DB2 system environment and clients/servers connectivity
- Create DB2 instances
- Coordinate physical changes to databases
- Follow and work through: Incidents, Tickets, Problems, Work Orders, Work Requests, Service Requests, Activity Tasks and Changes
- Database online/offline backups
- Database recovery and restores
- Set up DB2 HADR
- Oncall rotation and SLA adherence (24x7)
Confidential, Columbia, MO
DB2 DBA
Responsibilities:
- Multiple Commercial DBA for: ACE, Ally, Amtrak, APEX, AZFF/FFIC/AZOA/AZOAC (Fireman's Fund Insurance Company), BCBS MA, Broadridge Financial Solutions, Campbell Soup, Chicago Parking, Equifax, Gerdau Ameristeel, Hertz, Macy's, NASCO, Panasonic, RMIS, Shared, Sprint, Sprint RMIS, TLMS, Vanity Fair, Viewpointe and WellPoint)
- DB2 installations, patchings and upgrades in Production, Q/A, Dev, Test and Sandbox environments
- Configure DB2 system environment and clients/servers connectivity
- Create DB2 instances
- Catalog nodes and databases
- Perform databases security health checking
- DB2 CIRATS closures
- Follow and work through: Incidents, Tickets, Problems, Work Orders, Work Requests, Service Requests, Activity Tasks and Changes
- Oncall rotation and SLA adherence (24x7)
Confidential, Bloomington, IL
DB2 DBA
Responsibilities:
- DB2 installations, patchings and upgrades in Production, Q/A, Dev, Test and Sandbox environments
- Create DB2 instances
- DML and DDL generation
- Control database access, grant/revoke authorities and privileges
- Capture applications and databases specific information
- Database online/offline backups
- Database recovery and restores
- Capture Explain information
- Set up DB2 HADR
- Oncall rotation and SLA adherence (24x7)
Confidential
DB2 DBA
Responsibilities:
- Investigation, analysis, troubleshoot and resolution of databases related problems
- Modify database and database manager configuration parameters
- DML and DDL generation
- Monitor databases activity
- Database online/offline backups
- Database recovery and restores
- Follow and work through: Incidents, Tickets, Problems, Work Orders, Work Requests, Service Requests, Activity Tasks and Changes
- Package promotions and ConfigDBs between environments
- EAR builds and files deployments
- Manage data workflow tools applications
Confidential
DB2 DBA
Responsibilities:
- DB2 installations, patchings and upgrades in Production, Q/A, Dev, Test and Sandbox environments
- Configure DB2 system environment and clients/servers connectivity
- Create DB2 instances
- Catalog nodes and databases
- Investigation, analysis, troubleshoot and resolution of databases related problems
- Perform databases security health checking to prevent possible problems or outages
- Capture applications and databases specific information
- Identify queries hitting the databases
- Capture Explain information
- Schedule jobs wif task center
- Oncall rotation and SLA adherence (24x7)
Confidential
Industrial Electrician Engineer
Responsibilities:
- Test electrical and electronic equipment and components for continuity, current, voltage and resistance
- Supervise building and testing of prototypes according to general instructions and established standards
- Install, maintain, operate and calibrate industrial instrumentation, electrical and electronic equipment, systems and related devices according to technical manuals and written instructions
- Set up and operate specialized and standard test equipment to diagnose, test and analyze the performance of electrical and electronic components, assemblies and systems
- Install, examine, replace or repair electrical wiring, receptacles, switch boxes, conduits, feeders, fibre-optic and coaxial cable assemblies and other electrical components
- Testing, adjusting and evaluation of incoming electrical, electro-mechanical and electronic components and assemblies to ensure conformance wif product specifications and tolerances
- Preventive maintenance programs performance and keep maintenance records
- Fail's diagnostic/analysis of electronic cards
- Troubleshoot, maintain and repair industrial, electrical and electronic control systems and other related devices
- Production support and recruitment/supervision of technicians & technologists
- Read and interpret drawings, blueprints, schematics and electrical code specifications to determine layout of industrial electrical equipment
- Conduct life tests on assemblies and analyze results
Confidential
IT Coordinator
Responsibilities:
- Computers/Equipment configuration, routing, reparation, maintenance and support
- Develop and implement security policies wif contingency plans and procedures
- Preventive/Corrective maintenance performance
- Electronic cards and components checking
- Software management and microprocessors programming
- Identify and document system requirements
- Industrial, quality and test manufacturing procedures and rework
- Consult user guides, technical manuals and other documents to research and implement solutions
- Provide business systems solutions, network and internet support to users
- Interview and recruit new resources (Juniors/Trainees)
Confidential
IT Junior
Responsibilities:
- Meet wif clients to discuss system requirements and specifications
- Provide advice and training on information systems to users and documentation of it
- Control and monitor e-mail use, web navigation and installed software
- Components, user interface development
- Provide information systems business solutions
- Evaluate and install computer hardware, networking software, operating system software and applications
- Several gas stations DBs management/administration
- Operating systems management
- Data recovery
- Network installation/configuration
- Equipment maintenance/assembly
- Emulate or reproduce technical problems encountered by users