DBA SQL Server
Resume:
Ivan Alves Tavares Junior - Experient and competent DBA to support complex environments
e-mail: ****.*******.**@*****.***
Skype : ITavaresJr
Objective:
Work as a Database Administrator to assist development teams in the creation and maintenance of reliable and high scalable systems, as well as contribute with my skills in the management of high complex and heterogeneous production environments.
Languages:
English - French - Brazilian Portuguese
Certifications - Actual Certification Status:
- IBM Certified Database Administrator - IBM UDB v8.1 Linux, Unix and Windows, since August 2006
- Microsoft Certified Professional, since January 1996
- Microsoft Certified Technical Specialist – SQL Server 2005, since August 2008.
Education:
Degree - Where - Course - Country - Year
DEC - UNICAP - Computer Science - Brazil - 1995
Postgraduate - FCAP - Management of Quality in Services - Brazil - 2001
Professional Experience:
TCI File [Middle-sized IT consulting firm - http://www.grupotci.com.br ]
11/2001-Today. Recife, Pernambuco-Brazil [Contract]
DBA Microsoft SQL Server 2000 AND Oracle 10g
- Support development teams to:
.. Define database access solutions for e-Fisco project;
.. Create, validate and update database models and physical schemas (version control);
.. Build and tuning complex SQL routines - queries, triggers, functions and procedures;
.. Performance analysis and tuning;
- Database team management.
The TCI mission is promote solutions of outsourcing to manage and to operate business-oriented processes of its customers in different areas such as logistics, electronic document management, business process management and IT. Work to TCI gave me the opportunity to learn concepts of logistic and business process management, as well as allowed me extend my experience in database administration and team management.
Environment: SQL Server 2000, Oracle 10g, Red Hat Linux AS 4.0, Windows 2000/2003, ErWin 4.1, Office XP and Microsoft Project 98.
Reason to want to leave: Immigrate to Canada.
POLICENTRO TI S/A [Large-sized IT consulting firm - http://www.policentro.com.br ]
11/2001-05/2006. Recife, Pernambuco-Brazil [Contract]
DBA in DB2 UDB 8.2 and Microsoft SQL Server 2000 for e-Fisco project.
- Support development teams to:
.. Define database access solutions for e-Fisco project;
.. Create, validate and update database models and physical schemas (version control);
.. Build and tuning complex SQL routines - queries, triggers, functions and procedures;
.. Performance analysis and tuning;
- Database team management.
- Integrate the system engineering team to define solutions for e-Fisco project.
e-Fisco is an integrated system for Pernambuco's State Government - Brazil, divided in five great subjects areas: tributary, administrative, financial, planning and budgetary. The system has 30 modules, and involves replacing the existing system application and handling the new user requests as required. Five of those systems were in production since August 2003 and twelve should be released until November 2006. e-Fisco has benefited 85.000 persons directly. e-Fisco project is a partnership between Unisys (project leader) and Policentro. The database team was shared and supported the two companies.
Environment: DB2 UDB 7.1/8.2, SQL Server 2000, Red Hat Linux 7.2, Windows 2000, ErWin 4.1, QDesigner 10, WebSphere 4.0, Java, J2EE, Office XP, OpenOffice and Microsoft Project 98.
Reason for leaving: Study French in Montreal and research professional opportunities before immigrate to Canada.
CSI Comercio Soluc?es Inteligentes-[Small-sized IT consulting firm - http://www.csi.com.br ]
05/2000 - 10/2001, Recife, Pernambuco-Brazil [Contract]
DBA and support analyst specialized in Microsoft SQL Server 7.0/2000 and Oracle 8i.
- Support development teams to:
.. Define database access solutions based on clients requests;
.. Create, validate and update database models and physical schemas (version control);
.. Build and tuning complex SQL routines - queries, triggers and procedures;
.. Performance analysis and tuning;
.. Migration from SQL Server 7.0 to Oracle 8i - ETL;
.. Develop ActiveX components for database access as well as general use routines;
-Develop Administrative applications using Visual Basic 6.0.
I integrated the engineering system team which defined database access solutions for several projects of C.S.I. The Bompreco Supermarket - a Wal-Mart company in Brazil - uses solutions C.S.I., as well as aviation tickets resellers and many others customers.
Environment: SQL Server 7.0/2000, Oracle 8i, Windows 2000, ErWin 4.0, Visual Basic 6.0, Office 97 and Microsoft Project 98.
PROCENGE UES-[Medium-sized IT consulting firm - http://www.procenge.com.br ]
04/1999-03/2000. Recife, Pernambuco - Brasil [Contract]
DBA and support analyst, specialized in Microsoft SQL Server 7.0 and Oracle 8i
-Support the development team of the project SiiG - Sistema Integrado de Informac?es Gerenciais;
.. Define database access solutions for SiiG project;
.. Create, validate and update database models and physical schemas (version control);
.. Build and tuning complex SQL routines - queries, triggers and procedures;
.. Performance analysis and tuning;
.. Migration from SQL Server 7.0 to Oracle 8i - ETL;
-Develop ActiveX components for database access as well as general use routines;
-Create DLL components (infrastructure and database access);
SiiG project goals were to humanize and speed the process of school management in all public schools of the States of Pernambuco, Bahia, Paraiba, Rio Grande do Norte and Piaui. This client-server system (N-tier), composed of 27 integrated systems, was built using Microsoft Visual Basic, SQL Server and MTS. More than 900.000 students and the staff of Secretary of Education has benefited from SiiG. The version of SiiG for the Government of State of Bahia's used Oracle 8i.
Environment: SQL Server 7.0, Oracle 8i, Windows NT4.0/2000, ErWin 4.0, Visual Basic 6.0, Office 97, MTS and Microsoft Project 98.
CONECTA Informatica-[Small-sized IT consulting firm and Microsoft Authorized Technical Center]
02/1997 - 03/1999. Recife, Pernambuco - Brazil [Employee]
-Support analyst and DBA specialized in Microsoft Windows NT, SQL Server and Visual Basic;
-Microsoft Certified Trainer - Official Curriculum: Visual Basic 3/4/6, SQL Server 4.2/6.0/6.5/7.0, WOSA;
-System analyst for projects in finance, banking and administrative areas;
-Speaker in some Brazilian National Conferences representing Microsoft (Infonordeste/PE 1997, Sucesso/RN 1996).
Environment: Visual Basic 3/4/6, SQL Server 4.2/6/6.5/7.0, ErWin 3.52, Office 95, Windows 95 and NT 4.0.
Reason for leaving: The firm lost many clients after a reform of the banking system in Brazil. The firm had to close down most of it's operation causing major lay-off.
Bank BANORTE S/A - [Brazilian Regional Bank]
01/1990-08/1996. Recife, Pernambuco - Brazil [Employee]
-System Analyst-administrative systems;
-Programmer - financial and banking projects using Natural II/Adabas, as well as Visual Basic/SQL Server and Clipper/Dbase;
-Participation in the group of study and analysis of new technologies and definition of development standards;
-Implementation of network (Microsoft Lan Manager) and relational database (Microsoft SQL Server);
-Support for office applications as well as PC languages-Visual Basic, Clipper and Dbase;
Environment: Natural II, Adabas, IBM-MVS, IBM-VM, Ms-Dos 4, Windows 3.0 and NT 3.51, Visual Basic 3.0, Word 2.0, Ms-dos 6.2, Wordstar 5.0, Lotus 1-2-3, Harvard Graphics, Dbase III and IV, Clipper 5.0.
Exams History:
Where - Subject - Year
-----------------------------------------------------------------------------------
IBM
- 701 - DB2 UDB v8.1 for Linux, Unix and Windows Database Administration - 2006
- 512 - DB2 UDB v7.1 Family Fundamentals - 2002
Microsoft
- 029 - Designing and Implementing Databases with Microsoft SQL Server 7.0 - 1999
- 026 - System Administration of Microsoft SQL Server? 6.5 - 1997
- 027 - Implementing a Database Design on Ms SQL Server 6.5 - 1996
- 065 - Programming with Microsoft Visual Basic? 4.0 - 1996
- 044 - Networking Basics for Windows? 95 and Windows? NT - 1996
- 151 - Ms Windows Operating Systems and Services Architecture II - 1996
- 150 - Ms Windows Operating Systems and Services Architecture I - 1996
- 021 - Microsoft SQL Server 4.2 Database Implementation Exam - 1995
- 050 - Microsoft Visual Basic? 3.0 for Windows Application Development - 1995
Courses:
Where - Subject - Year
----------------------------------------------------------------------------
Centre_Lartigue/Montreal/Québec:
- Cours de Francisation - 2006
Qualiti/Brazil:
- Java - 2006
IBM/Brazil:
- IBM DB2 UDB v7.1 - 2001
Oracle:
- A80-Administrac?o Oracle - 1999
- BR8-Backup e Recovery Oracle - 1999
TechData/USA:
- Mastering Microsoft Visual Basic 6.0 - 1997
Microsoft/Brazil:
- Microsoft Solutions Development Discipline - 1997
CONECTA/Brazil:
- Microsoft Networking Essentials - 1996
- Administering Microsoft Windows NT 4.0 - 1997
Bras & Figueiredo/Brazil:
- Implementing Microsoft SQL Server 6.0 - 1996
- Administration of Microsoft SQL Server 6.0 - 1996
References upon request.
Contact this candidate