Sparrow Consulting
Joe Wrobleski
443-690-0680
Resume for Ricardo Fernandez
Career Profile
DBA/Senior Analyst with more than 40 years of experience in software life-cycle development. Served as project manager and technical lead responsible for the design, planning, scheduling, budgeting, and management of numerous computer systems projects. Possesses knowledge of Oracle7, Oracle8i and Oracle91 as a database administrator and strong skills in Solaris UNIX Systems Administration. Has extensive expertise in development/integration on various computer environments including UNIX servers (Sun, HP and DEC), IBM mainframes, Honeywell 6000, and DEC VAX computers. He also has expertise in the UNIX operating system, involving C, TCP/IP, and UNIX shell commands.
Provide DBA technical
support on two projects ( EXSTAR and PARIS)
Write PL/SQL scripts to
delete duplicate rows in the production database tables and apply integrity
constraints to the tables.
Write scripts to refresh,
compute statistics, and rebuild indexes on database tables
Write and modify PL/SQL
Procedures that produce reports on a financial system
Write and modify views to
provide secure access to production tables for specific users
Provide DBA support to
system testing of applications
Install new releases of the
production and test databases and software
Perform audit on software
and database tables on production and development databases
§
Provided technical support and general database administrative services
of account creation/deletion/modification for numerous Oracle applications,
data validation and referential integrity checks and performance monitoring to
ensure rapid access to data from all applications
§
Supported tuning and reorganizing Oracle 7.x, Oracle 8.x, and Oracle 9i
instances and databases for development, testing, and production
§
Supported new versions of Oracle releases and supportive software. Installing and initializing 9i database for
the ISM Project at DIA
§
RMAN installation and monitoring
§
Corrected and validated database tables
§
Managed a group of ten and provided technical support
§
Provided general database administrative services of account
creation/deletion/modification for numerous Oracle applications, data
validation and referential integrity checks and performance monitoring to
ensure rapid access to data from all applications
§
Initiated and managed major data reorganization, creating index schema
§
Researched the parent-child and other key relationships between hundreds
of data elements
§
Supported tuning and reorganizing of Oracle 7.x and Oracle 8.x instances
and databases for development, testing, and production
§
Supported multiple servers in the lab (SUN SPARC 20 server using SOLARIS
2.2; HP 770 (TACK-4) using HPUX 10.x; HP 710 server using HPUX 9.x)
§
Provided Oracle DBA support in a Graphical User Interface (GUI) client/server
application development environment (PowerBuilder in MS Windows)
§
Designed an Oracle instance’s tablespace configuration, creating and
altering users and roles and assigning system privileges
§
Utilized EXPORT/IMPORT utility to backup and transfer an Oracle’s
instance structure
§
Installed and configured SQLNET in a client/server environment
§
Provided administrative support to an Oracle R&D lab to coordinate
and manage resources for development, testing, training, and production
§
Added user accounts to a UNIX server, created groups, assigned groups
and home directory to users, created
cron jobs and backup scripts and monitored the execution of these scripts. Configured TCP/IP access to a server. Used FTP, TELNET and SAM
§
Worked on ENWGS Program Manager’s staff, providing technical direction
for the adherence to military, programming, and documentation standards
§
Reviewed and approved new or modified system specifications and
preliminary software architecture to meet these specifications
§
Attended Critical Design Reviews
and participated in final decisions to accept, modify, or reject final software
designs for new ENWGS Research and Development Releases
§
Managed documentation produced by the Software Design Facility contractor
that was used to develop and maintain the ENWGS software during its life-cycle
§
Supervised civil servants workers and monitored contractor efforts in
support of the NCCS software located in CINCUSNAVEUR and its subordinate commands
in
§
Reviewed the results of task assignments and made evaluations of the
contractor’s efforts
§
Assigned and supervised the installation of major software releases to
members of NLT
§
Solved computer command and control system problems as a technical
consultant to the CIUNCUSNAVEUR staff.
Briefed CINCUSNAVEUR junior and senior staff officers on the
capabilities of the NCCS systems
§
Maintained and enhanced NWSS operational software at CINCPACFLT
§
Identified and analyzed software problems on a twenty-four hour basis to
resolve emergencies that occurred with the NWSS software and trained personnel
to maintain integrity of the data bases
of the NWSS system
§
Served as liaison between the CINCPACFLT users and the SPAWAR Central
Maintenance Group for NWSS located in
Installed emergency
fixes to the NWSS software and developed, supervised, and executed a plan for a
completely revised NWSS system release