Sr. Database Administrator Resume
Mclean, VA
SUMMARY:
- I have 25 years of experience in System administration, database administration and application development.
- Experiences includes Oracle, Informix, Sybase, Peoplesoft, Solaris, Shell scripting, UNIX and Perl.
- Over 20 years of experience as a database administrator.
- Three of those years I served as PeopleSoft DBA.
- Experienced in performing upgrades, data migrations, database design, coding and testing financial packages using oracle tools.
- Well versed in customer information systems, client/server technologies, relational database management, RMAN, backup and recovery, data warehousing, and data replication.
TECHNICAL SKILLS:
HARDWARE: Sun 3/60 & 4/260, Sun Micro - System E10K, Sun E450, Sun E4500, Sun E250, Sun E5500, Sun E6000, Sun Fire 15K, Sun Blade, Windows Servers
SOFTWARE: PeopleSoft 7.0.2, SQL Server 7.0, SQL Database Design 7.0, Oracle 7 (HP Unix), Oracle 8.1.6 (OS 8), Oracle 9i, Oracle9iAS, Oracle 10g, Oracle 11g, Oracle 10g Grid, Oracle 12c, Grid, Oracle 10g RAC, Oracle 11g RAC, Oracle 8.0.6 (Solaris 2.6), Oracle Workflow 2.6.4, Oracle Warehouse Builder 10.2.0.3, Oracle Express Server 6.3.4, Oracle11g Data Guard, Solaris 8, Solaris 9, Solaris 10, Tripwire 3.0, Linux (Red Hat 4/5), Unix, MS/DOS, TOAD, MS Windows, Reflection for Unix, SQL Navigator 5.5, ERWIN, Microsoft Excel, Informatica, Informatica Power Center 8.6.0, OEM, RMAN, Netbackup 3.4, SQL-BackTrack 2.0,, Informix, Object cycle 2.0, Serena Dimensions 10.1.2, PVCS 7.5, SQL Server 2000, System Architect 10.4, DOORS 8.0
LANGUAGES: UNIX, Sybase, Informix 4GL, Oracle, SQL*FORMS, SQL*PLUS, Perl,T-SQL, C, Korn, Bash
PROFESSIONAL EXPERIENCE:
Confidential, McLean VA
Sr. Database Administrator
Responsibilities:
Participating in the monitoring and maintenance of several Oracle 11g R2 databases across Linux/VM Ware environments. Participating in the physical database design, coding, testing and implementing SQL code, infrastructure, and support database installation, database creation and maintenance in Oracle 11g R2. Responsible for development, test and production planning, installation and configuration, administrating, troubleshoot and debugging, and monitoring via (TOAD, SQL Developer),OEM 12c, ASM, database exports and imports, Oracle11g Data Guard, database upgrades, applying CPU/PSU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for the “HR” on the Department of State Operation System . Apply ESSR/MSR scripts, performing requirements changes, testing and implementation phase of development, test and production servers in a Solaris/Linux and VM environments.
Confidential, Columbia MD
Sr. Database Administrator
Responsibilities:
Participated in the monitoring and maintenance of several Oracle 11g R2 databases across a Solaris/Unix and Linux/VM Ware environments. Participating in the physical database design, coding, testing and implementing SQL code, infrastructure, and support database installation, database creation and maintenance in Oracle 11g R2. Responsible for test and development planning, installation and configuration, administrating, troubleshoot and debugging, and monitoring via (TOAD, SQL Developer),OEM 12c, ASM, database exports and imports, Oracle11g Data Guard, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for the “CMS” on the Medicaid and Medicare Operations Support System . Creating scripts, performing requirements changes, testing and implementation phase of development and test servers in a Solaris/Linux and VM environments. Coordinating data and tables deployments.
Confidential, Fair Oak, VA
Sr. Database Administrator
Responsibilities:
Participated in the monitoring and maintenance of several Oracle 11g R2 databases across a Citrix client and Linux/VM Ware environments. Participating in the physical database design, coding, testing and implementing SQL code, infrastructure, and support database installation, database creation and maintenance in Oracle 11g R2. Responsible for test and development planning, installation and configuration, administrating, troubleshoot and debugging, and monitoring via (TOAD, SQL Developer), database exports and imports, Oracle11g Data Guard, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for the “Army Reserve/National Guard” on the “ENBOSS” Engineering and Base Operations Support System . Creating scripts, performing requirements changes, testing and implementation phase of development and test servers in a Linux and VM environments.
Confidential, Fair Oak, VA
Sr. Database Administrator
Responsibilities:
Participated in the monitoring and maintenance of several Oracle 11g R2 databases across a Citrix client and Linux/VM Ware environments. Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, and support database installation, database creation and maintenance in Oracle 11g R2. Responsible for test and development planning, installation and configuration, administrating, troubleshoot and debugging, and monitoring via (TOAD, SQL Developer), database exports and imports, Oracle11g Data Guard, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for the “Army Reserve/National Guard” on the “ENBOSS” Engineering and Base Operations Support System . Creating scripts, performing requirements changes, testing and implementation phase of development and test servers in a Linux and VM environments.
Confidential, Arlington, VA
Sr. Database Administrator
Responsibilities:
Participated in the migration of nine databases from Informix 9/10 to Oracle 11.2.0.1 in the Linux/VM Ware environments. Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, and support database installation, database creation and maintenance in Oracle 11g R2. Responsible for test and development planning, installation and configuration, administrating, and monitoring via (TOAD, SQL Developer), database exports and imports, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for three programs such as “STARWEB” and “STARS” . Performed script writing, performing requirements changes, testing and implementation phases of development and test servers in a Linux and VM environments.
Confidential, Gaithersburg, MD
Sr. Oracle DBA
Responsibilities:
Participated in the physical database design, infrastructure and database support via installation, database creation and maintenance in Oracle 11g Windows environment. Responsible for production, test and development planning, installation and monitoring, backups, Oracle11g Data Guard, database exports and imports, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues.
Confidential, Arlington, VA
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, web and application server and support database installation, creation and maintenance in Oracle 11g and IBM Informix 9/10 environment. Responsible for production, training, test and development planning, installation and configuration, administrating, and monitoring via (TOAD, SQL Developer), backups, database exports and imports, database migration, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues and rendering support for three programs such as “ARGIS”, “STARS” and “JDIS”. Participated in script writing, performing requirements changes, testing and implementation phases of development and systems lifecycle in Solaris, Linux and Windows environments.
Confidential, Washington, DC
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, web and application server. Support database installation, creation and maintenance in Oracle 10g (10.2), and Oracle 11g. Responsible for production, pre-production, test and development planning installation and configuration of the EMGC and agents, administrating, and monitoring via OEM Grid, backups, database exports and imports, hot and cold backups, database migration, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues. Responsible for the installation of Oracle 11g AS (10.2.3) Web Logic server. Participate in script writing, performing requirements changes, testing and implementation phases of development and systems lifecycle. Participated in change control, data transformation, load routine and mapping using Informatica Power Center 8.6.0.
Confidential, Falls Church,VA
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, web and application server and support database installation, creation and maintenance in Oracle 9i (9.2.0.8), ColdFusion/J2EE and Java. Responsible for leading a team of developer/database administers in the maintenance and rendering support for three programs such as “SNAP”, “SGS” and “PPSM”. Responsible for production, pre-production, planning installation and configuration of the EMGC and agents, administrating, and monitoring via OEM Grid, backups, database exports and imports, hot and cold backups, database migration, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database and web issues. Responsible for the OS (Solaris 10) installation, OS upgrades and updates. Participate in the concept, requirements, architecture/design, testing and implementation phases of development and systems lifecycle.
Confidential, Annapolis, MD
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, application server and support database creation and maintenance in Oracle 10g AS R2, and Oracle 10g R2(10.2.0.3). Responsible for the maintenance, cloning of the databases and rendering support for two major naval programs such as “MIDS”, and “NAPS”. Responsible for production, pre-production, installing and configuring the EMGC and target agents, administrating, and monitoring via OEM Grid, backups, database exports and imports, hot and cold backups, database migration, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database issues. Responsible for the installation, configuration and maintenance of the Oracle Warehouse Builder 10g software, repository and the Oracle Workflow 2.6.4 application.
Confidential, Washington, D.C
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, application server and support database creation and maintenance in Oracle 11g, Oracle 10g AS, Oracle 10g R2(10.2.0.3), and Oracle 9i (9.2.0.7). Responsible for the database maintenance, database upgrades and support for several programs such as “CSREES”, “CREEMS” and “REEIS”. Responsible for production, pre-production, support to include maintenance, administrating and monitoring via OEM, backups via RMAN, database exports and imports, hot and cold backups, database migration, database upgrades, applying CPU patches, database security, capacity planning, performance tuning, configuration and application development support regarding all database issues.
Confidential, Washington, D.C
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, application server and support database creation and maintenance in Oracle 10g AS, Oracle 10g R1(10.1.0), Oracle 10g R2(10.2.0), System Architect 10.4, DOORS 8.0 and SQL Server 2000. Responsible for production, pre-production, support to include maintenance, administrating and monitoring via OEM, backups via RMAN, database exports and imports, hot and cold backups, database migration, database upgrades, applying patches, security, capacity planning, performance tuning, configuration and application development support regarding all database issues.
Confidential, Suitland, MD
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, application server and UNIX shell script to support database creation and maintenance in Oracle 9i (9.2), Oracle 9iAS, Oracle 10g (10.0.2). Responsible for production, development, and test support to include maintenance, administrating and monitoring via OEM and OMS, backups via RMAN, database exports and imports, hot and cold backups, Netbackup, database migration, database upgrades, applying patches, transaction logging, database security, capacity planning, performance tuning, RAC installation and configuration, and application development support regarding all database issues.
Confidential, Gaithersburg, MD
Sr. Database Administrator
Responsibilities:
Participated in the physical database design, coding, testing and implementing SQL code and UNIX shell script to support database creation and maintenance in Oracle 9i (9.2).
Responsible for production, development, and test support to include maintenance, administrating and monitoring via OEM and OMS, backups via RMAN, hot and cold backups, Netbackup, transaction logging, database security, capacity planning, performance tuning and application development support regarding all database issues.
Confidential, Reston, VA
System Engineer/Database Administrator
Responsibilities:
Participated in the HP N900/L900 system administration, troubleshoot issues, installation and update of the OS software. Responsible for the physical layout, designtesting and writing UNIX shell script to help support operation and maintenance. Oracle engineering including data migration for Oracle 8i and Oracle 9i via exports, imports and data replication, architecture, design, programming, implementation, maintenance, and administration. Primary responsibilities included the building, installing, configuring, and maintaining Oracle databases in support of all development, QA, Spatial Data (geocoding) and production and processing requirements for the client. Performs installations and upgrades to Oracle systems, performance tuning, monitoring of the systems, and database maintenance.
Confidential, Fairfax, VA
System Engineer/Database Administrator
Responsibilities:
Participated in a Sun micro-system/Unix system administration, converted 6 mico-systems into the SunFire15K, data migration for Oracle 8i to 9i, OS installs and upgrades for Solaris 8 and Solaris 9, the physical layout, design, the assembling of the systemstesting and writing Unix shell script to help support operation and maintenance. Primary responsibilities include building, installing, configuring, and maintaining Oracle databases in support of all development, QA, and backup, disaster planning and recovery. Responsible for the PeopleSoft application support maintaining all reports, process scheduler, application server and printing issues in a 3-tier environment.
Confidential, Springfield, VA
Unix System Administration/Database Administrator
Responsibilities:
Participated in a Sun Micro-system UNIX environment. Responsible for the installation and upgrade of Solaris 7 to Solaris 8, physical layout, design, the assembling of the systems, coding, testing and writing Unix shell script to help support operation and maintenance. Responsible for production, development, and test support to include maintenance, administrating, RAID manager, Veritas DBED, TOAD, monitoring systems, and monitoring backups via tar, security, capacity planning, performance tuning. Responsible for the PeopleSoft application support maintaining all reports, process scheduler, application server and printing issues in a 3-tier environment. Other responsibilities include troubleshooting, configuration management, data content validation, analyzing possible solutions to correct problem areas to improve system performance. Maintained an IPRO application, developing, backup, and supported the IPRO’s Oracle 8 NT database, rebooting and monitoring the application server in a 2-tier environment.
Confidential, Washington, D.C.
Database Administration
Responsibilities:
Participated in database migration from Logicare database to a MS SQL Server 7.0 environment. Responsible for the physical database design, coding, testing and implementing SQL code and UNIX shell script to support database creation and maintenance in two different environments Lawson/Oracle 8.0.5 and Remedy/Oracle 7.3.
Responsible for production, development, and test support to include maintenance, administrating and monitoring backups, hot backups, transaction logging, security, capacity, performance and application development support regarding all database issues. Other responsibilities include database tuning, configuration management, data content validation, analyzing possible solutions to correct problem areas and dynamically altering the index structure on existing tables to improve system performance. Using Oracle utilities to export and import data.
Confidential, Hanover, MD
Database Administrator
Responsibilities:
Participated in a large-scale database migration from Informix 7.2.3 to Oracle 8.0.6 on a Sun E10K in the Unix environment. Responsible for the physical database design, coding, testing and implementing SQL code and UNIX shell script to support database creation and maintenance. Responsible for production, development, and test support to include maintenance, administrating and monitoring backups via RMAN, hot and cold backups, SQL-BackTrack 2.0, transaction logging, security, capacity, performance and application development support regarding all database issues. Other responsibilities include database tuning, configuration management, data content validation, implementing triggersstored procedures, analyzing possible solutions to correct problem areas and dynamically altering the index structure on existing tables to improve system performance. Data warehousing using Informatica and Oracle utilities to export and import data. Participated in the PeopleSoft migrations, data move, system reboots and monitoring the Application Server in a 3-tier environment.
Confidential, Rockville, MD
Database Analyst/Programmer
Responsibilities:
Designed, implemented and administered Sybase databases on Windows NT platforms. Responsible for performing logical and physical database design; development of the database standards and procedures for client/server database applications; backup and recovery of test and production databases on NT server; design and implementation of the security schemas; installation, testing and evaluation of new releases of Sybase database software; design and implementation of database stored procedures; and general application of support of the data warehouse application. Responsible for developing and implementing procedures to support all data extraction and data warehouse application. Also responsible for developing implementing and maintaining any structural changes to the databases. Learning to write scripts in Perl.
Confidential, Vienna, VA
Programmer/Analyst
Responsibilities:
Participated in development of a large-scale mainframe and micro-computer system designed to perform Complaints (CAS) and Compliance (CRIS) functions in every Regional and District office of the Office of Federal Contract Compliance Programs(OFCCP). The system used Informix-4GL and Informix-ISQL in a Dynx's Unix (Sequent) micro-computer environment, Cobol and IBM utilities on a mainframe. Facilitated the successful operation of a single ESA program “production” application. Developed and maintained full working knowledge of the intent, technical methodology, and operating characteristics of the application software used by the program.
Functioned as an advisor to end-users, within the program. Assisted Computer Operators, Analysts and others in troubleshooting and resolving run failures in the program's micro-operations. Undertook occasional, brief Analytical/Programming tasks intended to augment the operation of "production" application program.
Confidential, Silver Spring, Maryland
Programmer/Analyst
Responsibilities:
Participated in development of a large scale mainframe and mini-computer system, which is designed to perform sampling and data collection functions in every state office of the Unemployment Insurance Service (UIS). The system utilized Informix-4GL in a Unix mini-computer environment, COBOL and IBM utilities on a mainframe. Completed the development of a prototype system with on-line data entry, update, on-line query and report generation capabilities. These programs were written in Informix-4GL and Informix-ISQL. Assisted the federal client in developing charts and various graphics for use in training materials and project documentation. Frequently, used client's specification to create graphic materials desired. Used WordPerfect 5.1, PageMaker, Harvard Graphics and Super Project Expert to complete the required task.
