Oswaldo Camacho Zepeda
DB* DBA/IT Specialist
Objective
To become a high level professional in the IT industry and demonstrate my
experience and skills, improving and training myself in order to be more
effective and provide the most appropriate support and solutions.
To always be a very hard worker and keep my sense of responsibility.
Education
CETI, Jalisco, Mexico 1999 - 2003
Information Technology and Computer's Systems Technologist - Certificated
CUCEI - Universidad de Guadalajara, Mexico 2003 - 2007
Bachelor Degree in Information Technology (IT) - Certificated
Professional ID: 5703539
Skills
Operating Systems: Windows NT, Windows 2000 Server, Windows 2003, Windows
XP, Window Me, UNIX & AIX, Mac OS, Linux (Little)
Databases: DB2, TOAD for DB2, MySQL, SQL Server, Postgres SQL, Access
Programming Languages: C++, Java, HTML/JavaScript (Little), PHP, Visual
Basic, Visual C++, Visual Fox Pro, SQL
Web technologies: UVATS, ManageNow!, Rational ClearCase, Rational
ClearQuest, CMVC, Lotus Notes, Remote Desktop Connection, VNC, Putty,
Peregrine Service Center, Peregrine Asset Center, CITRIX, Application
Management Tool (AMT), BladeLogic (BL), Websphere, SSH Tectia Client and
IBM Maximo
Content Management: Rational Portfolio Manager, Perforce (P4), Sharepoint
Tools and IDEs: Lotus Notes, Microsoft Office, DB2 ESE, TOAD for DB2, ftp,
putty, WinSCP, Putty
Teamwork: Excellent communication skills, teamwork in all kinds of
environment and capable to work under pressure and deadlines.
Experience
TATA Consultancy Services - Bank of America (December 2008 - present)
Jalisco, Mexico
Position: IT Specialist/DB2 DBA
. Confer with clients (Bank of America and Merrill Lynch) to discuss
and document system requirements and its specifications
. Maintain the applications and environments performance
. Design, development, delivery and 3rd Level Support for current and
future state asset, change, configuration, incident and problem
applications/processes
. Perform ConfigDBs working with IBM DB2, SSH Tectia Client and TOAD
for DB2 applications
. Interview and select staff for possible team members, supervise
computer analysts, technicians and other personnel and oversee their
professional development and training via appraisals
. ITSM development/configuration
. Status reports, metrics and timesheets elaboration
. Perform EAR builds and files deployment on different environments
working with Perforce (P4), Application Management Tool (AMT),
BladeLogic (BL) and IBM Maximo applications
. Fulfill/Accomplish with the SLA (Service Level Agreement) to provide
an accurate service delivery
. Manage workflow tools applications
. In-depth technical studies for professional certifications
. Work on environment requests and analyze logs using Tectia SSH
Client and FTP applications
. Provide IT solutions, strategies and management advice
IBM (February 2007 - December 2008) Jalisco, Mexico
Position: IT Specialist/DB2 DBA
. Meet with clients (IBM BHC, Lenovo & ASIT) in the USA to discuss
system requirements and its specifications
. Problem determination and investigation for web incidents working
with UVATS, ManageNow, CMVC and Hyperion
. Work with problems/TIRs/production tickets/defects: verification,
recreation, assignment/allocation, transference, return, tracking
and closure of them
. Daily calls moderator: Status/Defect/Test calls
. In-depth technical studies for professional certifications
. Fulfill/Accomplish with the SLA (Service Level Agreement) to provide
an accurate service delivery
. Work with different releases and environments/ambients/test clients
. Daily chat attendance with the team (MX, US, INDIA and CHINA) and
other chats as well
. Provide IT solutions
. Oncall weekends and remote working (24x7x365)
. Different chart reports elaboration: OAP, E-Config and MOR
. Recruit, supervise and train new resources for Argentina and China
and oversee their professional development and training, making a
training plan
. Keep the performance, integrity, concurrency, security, answer time,
and health in many different DBs systems
. Database Administration/Management in several servers
. Data recovery
. Perform DB's security health checking
. Install DBMS (Database Managers) and fixpaks in production,
development and test servers
. Perform DB's online and offline backups
. Windows and AIX server's access and users revalidation
Sanmina-SCI (March 2004 - March 2006) Jalisco, Mexico
Position: Industrial Electrician Engineer
. Test electrical and electronic equipment and components for
continuity, current, voltage and resistance
. Supervise the 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 with 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
Printek (June 2002 - September 2003) Jalisco, Mexico
Position: IT Coordinator
. Computers/Equipment configuration, routing, reparation, maintenance
and support
. Develop and implement security policies with contingency plans and
procedures
. Preventive/Corrective maintenance performance
. Electronic cards and components checking
. Software management and programming (Microprocessors)
. 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 in response to identified difficulties
. Interview and recruit new resources (Juniors/Trainees)
Combu-Express (February 2001 - April 2002) Jalisco, Mexico
Position: IT Junior
. Meet with clients to discuss system requirements and specifications
. Provide advice and training on information systems to users in
response to identified difficulties and documentation of it
. Control and monitor e-mail use, web navigation and installed
software
. Components, user interface (UI) development
. Provide information systems business solutions
. Evaluate and install computer hardware, networking software,
operating system software and software 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
Additional Trainings
English
Guadalajara, Jalisco, Mexico
12 Basic Levels
4 Advanced Levels
TOEFL 1
TOEFL 2
Daily Conversation Club
Advanced Conversation Club
Continuous Conversation Club
English Teacher's Training
Electronic
MDS Technician (Basic Electronic), ICT, FVT, HMU
DVD's Manufacturing Technology
Quality /Management
Guadalajara, Jalisco, Mexico
5's, IPC, HDD's, ESD
Introduction to Process and Quality
Defect Prevention Activities & DP Tool
iQMS for PL's
IQA, EQA, FI & Base Line Audit
Statistical Process Control
DAR - Decision & Analysis Resolution
Q Portal
Requirements Management
TQAS
CAR - Causal Analysis Resolution
Risk Management
CMMi Awareness
Defect Prevention
Process Improvement
Metrics Workshop
Workshop for NC's root cause at Project Level
IT Guadalajara,
Jalisco, Mexico
Macromedia Flash Mx / 8.0 Design
Computer Systems Maintenance & Computers Networks
Programming in C++
Structured Wiring
Preventive and Corrective Maintenance of Computers
Internet Basic Services
Introduction to UNIX
Active Directory & Windows 2003 Server Security
Intelligent Buildings
Wireless Communication with Multi-Standards
Information Technology Security in 21st Century
Programs Protection & Defense
Complex Dynamical Networks
Systems Problems in Cell Biology and Bio-Medicine
Capability Maturity Model Integration (CMMI)
Emigrating to IP Telephone
Prosoft Project
Telmex Network: Evolution and Expansion
Future of the Software
Information Integrity: Security for all
Software Engineering in Automotive Industry
Tendencies and Tools for Software Test Quality Cycles
AIX/6000 for Users
DB2 8 Essentials
Fundamentals of DB2 8
System & Database Administration
SQL Fundamentals
Software Engineering Activities
Application Services Data Privacy Overview
Essentials of Rational Clear Case for Windows
Dallas, Texas, U.S.
ASIT Level 2 Support
Dallas, Texas, U.S.
Blue Horizon Level 2 Support
Dallas, Texas, U.S.
US Banking
AML 2008, 2009, 2010 and 2011
IPP 2008, 2009, 2010 and 2011
Java Basics
PHP
DB2 Overview
SAS Business Intelligence
DWH, BI & Informatica
Mainframes
DB2 Database Administration
DB2 - Accessing Data & Manipulating DB's Objects
Administering Data Placement in DB2 UDB
DB2 9 Fundamentals
Planning & Securing a DB2 DB
Manipulating Data with DB2 UDB
Managing Database Access in DB2 UDB
SQL
DB2 DBA for Linux, UNIX and Windows
Managing a DB2 UDB server
DB2 for z/OS
Professional Certifications
IBM Professional Certified Database Associate - DB2 9
IBM Guadalajara 2009
IBM Professional Certified DBA for Linux, UNIX and Windows - DB2 9
IBM Guadalajara 2010
IELTS English British Council / University of Cambridge / IELTS
Australia / IELTS UK / International House 2010
US Banking and Finance TCS-FTC
Guadalajara 2009
English Skills
Exam: IELTS
Institutions: British Council / University of Cambridge / IELTS Australia /
IELTS UK / International House
Overall Band Score: Band 7.5
Year: 2010
Contact Numbers and Email
Home: +523*-****-****
Office: +523*-****-****
Mobile: +521**-***-***-** (Preferred)
Personal Email: ****.*******@*****.***
Work Email: *******.******@*************.***