Project Technical Support
Resume:
Title:No Title
********@*******.***
Document
Source below
NAME: Emerson Migueis
ADDRESS: **** ********* **
CITY: Smyrna
STATE/PROVINCE: GA
ZIP/POSTAL CODE: 30080
COUNTRY: USA
EMAIL: ********@*******.***
PHONE: 770-***-****
CANDIDATE ID: 107511
CITIZENSHIP: Requires Sponsorship
EDUCATION: Bachelor Degree
EXPERIENCE: 14
WILL RELOCATE: Yes
RELOCATION INFO: Any state
JOB WANTED: Any
RATE NEEDED: US
$ 60,000/Yr.HOMEPAGE:
HOTSKILLS: Oracle DBA, Unix technical support, Ingres DBA, Sybase DBA
ESUME
Emerson Migueis
3403 Woodlands Drive
Smyrna GA 30080
Phone: 770-***-****
(Home) / 770-***-**** (Work)
Email: ********@*******.***
Summary
* Bachelor's Degree in Chemical Engineering, Rural Fed. University of Rio de Janeiro
* Postgraduate in System Analysis, Brazilian Institute for Computer Science Research
* 14 years' industry experience
* Database Administrator and Analyst with Technical Support skill
Software
* Databases: Oracle 8.x/7.x, Sybase 10.x/11.x, Open Ingres v1.2, Ingres release 6.04
* Operating Systems: Unix Dec-OSF/1 v3.2 148 Alpha, Sun OS v3.1 rev B,Sun Os v5.6, SCO-
Unix Open Sever release 5, SCO-Unix System V release 3.2 v2.0, HP/Ux, Windows/NT 3.51/4.0
* Application Software: PL/SQL, Ingres 4GL-SQL, Report Writer, Unix Shell Scripts, M/SQL
Mumps, Medidata Mumps
Hardware
* IBM-PC, DEC Alpha, Sun SPARC, HP-9000, IBM-Power PC, RS-6000
Experience
April 2001
- Present: Computer Consulting Services Corporation, Atlanta, GA
Database Administrator
Software: Oracle 8i, WebDB, tkprof, SQL
Hardware: Sun Solaris 2.7
Project Description: Application and database tuning of various applications
(in WebDB) running on an e450 Server
Personal Accomplishments:
* Database-wide SQL tuning
* Init.ora optimization
* I/O Contention analysis
* Space Management to contain tablespace size
* Development and maintenance of analisys scripts to highlight Database/Space/OS problems
March 1999
- March 2001: Montreal Systems Ltd.(Information Tecnology Company)
Consultant
March 1999
- March 2001: Petrobras S.A. (National Petroleum Company)
Oracle Database Administrator and Oracle/Ingres Developer
Software: Oracle v8.0.5, PL/SQL, Ingres 4GL-SQL
Hardware: IBM-PC, RS-6000, Sun SPARC
Project Description: Oilwell Engineering System, this system controls many
phases of petroleum production
Personal Accomplishments:
* Created approximately 400 tables across 11 databases
* Defined user access in the Oracle environment
* Added and deleted users and roles
* Created integrity constraints and create 10 triggers needed to guarantee data integrity
* Loaded data from Ingres, RDB, Mumps and Access to Oracle intermediate tables
* Wrote 174 PL/SQL procedures to load Oracle production tables with intermediate tables
data
* Wrote 10 4GL-SQL procedures to load Ingres database with data from IBM mainframe
July 1993 - March 1999: DPR Systems Ltd. (Information Tecnology Company)
Consultant
January 1998 - March 1999: Globo TV Network S.A. (International TV Network)
Oracle Database Administrator/PL-SQL Developer
Software: Oracle 7.3/8.0.5, PL/SQL, Windows/NT v3.51, AIX Unix
Hardware: IBM-PC, RS-6000
Project Description: Client Support.
Personal Accomplishments:
* Installed Oracle Server v7.3 for Windows/NT v3.51 and Clients for Windows 3.11/95
* Created and defined development environment for an Oracle database. Created 5
tablespaces one for each system (Actor's Register system, Cable TV system,
Events System, Engineering Indicator system, Payment of Consulting system)
* Created users,roles and assign privileges
* Migrated data between Oracle for Windows/NT and Oracle for Unix.
* Supervised programmers
* Develop PL/SQL procedures and triggers
* Tuned application (SQL tuning) to improve response time, created indexes, changed
optimizer mode, passed hints to the optimizer and showed query
execution plan
* Designed Backup routines with Windows/NT backup utility and Oracle export utility
October 1997 - December 1997: Cyanamid (Chemical Industry)
Sybase Database Administrator
Software: Sybase 10.x/11.x, Windows/NT v3.51,4.0
Hardware: IBM-PC
Project Description: Sales System
Personal Accomplishments:
*
Installed Sybase Server v10 for Windows/NT v3.51 and Clients for Windows 3.11/95
* Created and defined the database, database devices and tables in Sybase
* Created users and granted access to the Sybase environment
* Tuned Sybase queries using query execution plan
* Migrated data between Sybase v10 and Sybase v11 using export utility
August 1997
- September 1997 : Social Security South America (Security Company)
Technical Consultant/System Administrator
Software: Sybase 10.x, Windows/NT v3.51
Hardware: IBM-PC
Project Description: Social Security System
Personal Accomplishments:
* Created and defined the database, database devices and tables in Sybase
* Created users and granted access to the Sybase environment
* Tuned Sybase queries using query execution plan
* Designed Backup routines using Windows/NT backup utility, Sybase dump and export
utility
* Administrated Windows/NT v3.51, added and deleted users, configured and
partitioned the hard disk, configured tape drives
April 1997 - July 1997: L'oreal (Cosmetic Industry)
INGRES Database Administrator
Software: Ingres release 6.04, HP/Ux
Hardware: HP9000
Project Description: SIMC - Marketing Application
Personal Accomplishments:
* Tuned Ingres Marketing application (SQL) used query execution plan, divided
large tables, organized queries, created indexes
* Generated statistics to tables and organized system catalogs to improve access
performance
* Analyzed database to verify inconsistent status
* Organized database with table relocation (data migration from one area to
another)
July 1996 - March 1997: Continente (Supermarket), Mesbla (Department Store), Dallas
(Supermarket), Guanabara Hotel
Unix Technical Support/M/SQL Mumps Programmer
Software: Unix DEC OSF/1 v3.2, HP/UX
Hardware: Alpha DEC
Project Description: Client Support
Personal Accomplishments:
* Configured terminal and printers, termcap, terminfo, parity, speed
* Developed Administrative Shell Scripts : Backup script, Script to remove
temporary files, Script to fix permissions on software, Script do start printer
daemon
* Maintained Mumps Reports to Guanabara Hotel
March 1996 - June 1996: Petrobras S.A. (National Petroleum Company)
INGRES Database Administrator
Software: Windows/NT, Ingres v6.04, SQL/Windows
Hardware: Alpha DEC
Project Description: Sales System
Personal Accomplishments:
* Created approximately 150 tables
* Created integrity constraints, rules and databases procedures
* Wrote 5 SQL/Windows programs to load database SQL/Base with data from Ingres
January 1994 - February 1996: GU - United Group Ltd. (Collection Agency )
System Analyst/4GL-SQL Developer
Software: Ingres release 6.04, Ingres report writer, HP/Ux
Hardware: HP9000
Project Description: Charge Debtors Customers
Personal Accomplishments:
* Developed an application in Ingres 4GL/SQL. This application extract
information pertaining to customers in debt and presented the information, in
report format, to business users for follow-up
* Gathered and analyzed user requirements to extract information from the
database
* Wrote approximately 60 Reports using Ingres report writer
* Wrote approximately 50 Procedures using Ingres 4GL/SQL to create tables
to summarize information
* Tested reports with users to confirm results
* Develop administrative Shell Scripts: Backup Script, Script to remove temporary
files, Script to fix permissions on software, Script to check disk space
* Configured terminals changing terminfo database
* Maintained Ingres database: Optimized database at catalog level, recreated
indexes for frequently used tables
July 1993 - December 1993: UNIRIO - Rio de Janeiro University
System Analyst
Software: Ingres release 6.04, SCO-Unix
Hardware: IBM-PC
Project Description: Academic System
Personal Accomplishments:
* Gathered, Analyzed user requirements
* Designed Academic System application, using Data Flow Diagram and Data Modeling
using Relationship and Entity Model
* Defined devices such as computers, terminals, multi serial lines, hard disks
* Defined operating System and Database
* Added and delete users (operating system and database)
* Defined backup routines (operating system and database)
* Trained users to use the environment
March 1993 - July 1993: CTIS Ltd. (Information Tecnology Company)
Unix Consultant
March 1993 - July 1993: Dataprev (Data Processing of Social Security Company)
Unix System Administrator
Software: SCO-Unix, Ingres v6.04
Hardware: IBM-PC
Project Description: Client Support
Personal Accomplishments:
* Tuned SCO-Unix (Production and Development Environments) to work with Ingres
Database using Unix utilities like sar, vmstat to report system activity and
try to obtain the best reponse time changing system variables
* Administrated SCO-Unix
August 1991 - March 1993: Medidata Systems Ltd. (Computer Manufacturing Company)
Field Technical Support Analyst
August 1991 - March 1993: Ipiranga (Petroleum Company), Embratel (Telecomunication
Company), Cobra (Computer Manufactoring), IDMA
(Plastic Factory), White Martins (Gases Factory), Scandiflex
(Chemical Industry), Medidata (Computer Manufactoring)
Unix Technical Support/M-SQL Technical Support
Software: SCO-Unix, SCO Xenix, Sun OS, M/SQL Mumps
Hardware: Medidata Computers
Project Description: Client Support.
Personal Accomplishments:
* Provided varied Unix technical support to numerous clients, as listed above
* Installed, configured and upgraded SCO-Unix, SCO-Xenix, Sun OS
* Administrated Unix Operating System. Tasks involved: adding and deleting users,
configuring and partitioning hard disk, adding and configuring I/O's such as
ports, printers and tape drives, installing patches, software filesets and
applications, administering TCP/IP network connectivity and NFS (network
filesystem)
* Tuned SCO-Unix Operating System using sar and vmstat to generate a report of
activities
* Developed Shell Scripts (Korn, Bourne and C Shells)
* Installed, configured and upgraded M/SQL Mumps
November 1990 - August 1991: Jaw Participations Ltd. (Services Bureau)
Xenix Technical Support/Joiner Programmer
Software: SCO-Xenix, Joiner
Hardware: Medidata Computer (IBM-PC like)
Project Description: Payroll System
Personal Accomplishments:
* Administrated SCO-Xenix: removed temporary files, scheduled tasks, backups using system
utilities, organized directory tree, administered access permissions, monitored disk
space
* Developed Administrative Xenix Shell Scripts (backup script, script to fix permission,
script to remove temporary files)
* Developed Support Joiner Programs (programs to limit user access)
October 1989 - October 1990: Manguinhos Petroleum Industry S.A. (Petroleum Industry)
System Analyst/Technical Support
Software: SCO-Unix, M/SQL Mumps
Hardware: Medidata Computer OMNI-21
Project Description: Account/Receivable Systems Implementation.
Personal Accomplishments:
* Implemented and Supported Account/Receivable Systems
* Trained Account System personnel to use the Account System
* Administrated SCO-Unix and SCO-Xenix Operating Systems: backups, monitor runaway
processes, disk space, run filesystem check, administer passwords, maintain software,
data file access and check printer status
* Mapped out global Mumps files to facilitate access with SQL
* Developed Mumps programs to export data from Mumps to text files
* Administrated and supported M/SQL Mumps
April 1987 - September 1989: Task Systems Ltd. (Software Company)
System Analyst/Mumps Programmer
September 1987 - September 1989: Silinor S.A. - Silicone of Northeast S.A. (Chemical
Industry)
System Analyst/Mumps Programmer
Software: Medidata Mumps
Hardware: Medidata M-1001
Project Description: Equipment Maintenance, Buying and Inventory System
Personal Accomplishments:
* Installed user Mumps application
* Gathered user information for Buying System
* Developed, implemented Buying System
* Trained Buying users personnel to use the Buying System
* Maintained Inventory and Equipment Maintenance Systems
April 1987 - August 1987: Ipiranga Petroleum Company S.A. (Petroleum Company)
Mumps Programmer
Software: Medidata Mumps
Hardware: Medidata M-1001
Project Description: Payable System.
Personal Accomplishments:
* Developed Reports for Payable System.
Contact this candidate