SUMMARY:

• 12 years of information technology experience in all phases of project development and maintenance.
• 12 years as an Oracle DBA/database engineer for Oracle database 7/8/8i/9i/10g/11g/12c, OEM 12c/13c.
• Experience in PL/SQL development.
• Experience in SQL server admin and developer.
• 3 years as a PostgreSQL DBA

TECHNICAL SKILLS:

Operating Systems: UNIX(Solaris 8, 9, 10, 11 ), Red Hat Enterprise Linux(3, 4, 5, 6), Oracle Enterprise Linux (5, 6), AIX 7, Windows (3.x, NT, 2000, XP, 2003, 7, 10).

Database: Oracle, PostgreSQL, Sybase, MS SQL Server, Access, ODBC, ADO, DAO, Oracle Forms, Oracle Reports.

Languages: C++, VB, VB Script, PL/SQL, UNIX shell scripts, Transact SQL, ASP, SAS, Java, HTML, ActiveX, Power Builder.

Software: Oracle Designer, DBArtisan, Visio, Toad, ERWin, JDBC, ODBC, Microsoft Office (97, 2000, XP, 2010, 2016), Outlook, PVCS Version Manager.

Networking: Windows NT, TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, Hyattsville, MD

Database Administrator

Responsibilities:

• Administrating incredibly large Oracle databases in production, pre - production, development environment on AIX operating system.
• Database server installation. Database creation, upgrade, patching, performance tuning, trouble shooting, backup and recovery using RMAN.
• Data guard configuration and troubleshooting. Shell scripting. Database security management, database vulnerability remediation.
• Using Oracle Enterprise Manager Cloud Control. FRA configuration.

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Creating and administrating Oracle databases in production, development, test, and UAT environment with data guard replication and RAC on Solaris and Linux operating system.
• Implementing backup and recovery using RMAN.
• Database upgrading, patching, deployment, performance tuning, trouble shooting, shell scripting, database security management.
• Using Oracle Spatial, Oracle 11g Grid Control, Oracle 12c Enterprise Manager Cloud Control. Support application OpenText Records & Documents Vignette Edition (VRD).
• PostgreSQL installation, database creation, maintaining. Administrating databases in production, UAT, test, and developer environments.
• Database backup and recovery, replication. Database development and modification. User accounts maintenance. PgAdmin Installation. Database administration using pgAdmin and psql. Performance tuning.
• Sybase adaptive database administration, clone, security management, etc.
• Training on MongoDB.

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Oracle server installation on Solaris on LAN, Linus, and Windows. Supporting web-based .net applications, Java applications, and financial applications. Windows installation and patching for web-based applications.
• Creating and administrating Oracle Physical Data Guard and Logical Data Guard with RMAN hot backup and cold backup. Installing and administrating DG Broker. Database switch over.
• Performing Oracle database design. Performing conceptual data modeling, logical and physical database modeling. Performing physical database capacity planning and data-files mapping.
• RMAN configuration. Backup strategy planning. Database backup and recovery using RMAN and NetBackup.
• RAC installation, configuration and administration.
• Scripts creation for Oracle Prosight.
• Database upgrading from Oracle 10g to Oracle11.1.0.6, 11.1.0.7 and 11.2.0.1. Applying CPU patches.
• Scripts creation and modification on Solaris and Oracle..
• Implementing database architecture updates.
• Database cloning.
• Grid Control implementation.
• Database and application performance tuning.
• User accounts management.
• Supporting development of JAVA application database connection.
• Training in business intelligence tool OBIEE.
• Assisting other DBAs in database administration.

Confidential, O’Fallon, MO

Database Administrator

Responsibilities:

• Very large Oracle databases administration on Sun Solaris server clusters, AIX in development, testing, and production environment.
• Supporting financial application handling very large and high-frequency transactions with banks, organization and consumer clients.
• Database structure modification. Database cloning.
• RMAN configuration. Backup strategy planning. Database backup and recovery using RMAN.
• Administrating databases with Oracle RAC on ASM. Perform node addition.
• Administrating databases with data guard using both in-house created program and Oracle Data Guard. Data guard installation, database switch over, failover.
• Implementing large scale database application support, including the use of table partitions.
• Implementing database architecture updates.
• Database decommission.
• Developing DDL, DML, ETL scripts. Maintaining, updating and creating stored procedures, functions, triggers, packages using PL/SQL. Supporting data warehouse.
• Database and application performance tuning using tool including auto trace, Explain Plan, TKProf, AWR, ADDM, Oracle Advisor, SQL profiles, SQL tuning sets, statspack, iostat, sar, vmstat, netstat. Monitoring CPU, memory, disk I/O, space and network on UNIX.
• Utilizes tools for database administration, productivity enhancement(Oracle Grid Control, Toad, etc.).
• Participating 24x7 support .

Confidential, Fairfax, VA

Database Administrator

Responsibilities:

• Contracted as an Oracle DBA to work with HP, main duties were RAC installation, administration and customer support. Project was delayed due to HP’s hardware issues.

Confidential, Arlington, VA

Database Administrator

Responsibilities:

• Requirements analysis, function analysis; working with client and developing team to perform database conceptual, logical and physical design, modeling and coding.
• Oracle server installing and upgrading on Solaris, Linux..
• Creating Oracle databases.
• Allocating system storage and planning future storage requirements for the database system.
• Creating primary database storage structures (tablespaces) after application developers have designed an application.
• Creating primary objects (tables - including partitioned tables, synonyms, materialized views, indexes, synonyms).
• Database structure comparison and synchronization.
• Database replication.
• Collaborating with other DBAs, Database Management Commission, client’s project managers, analysts, application developers, and technical writers.
• Modifying database structure, as necessary, according to information given by application developers.
• Developing DDL, DML documentation, installation guides for deploying new versions of databases.
• Troubleshooting in O/S and database, problem rooting and resolution.
• Data profiling and cleaning for delivering accurate and consistent data.
• Database backup/recovery strategy creation and modification.
• Backing up and recovering databases using RMAN..
• Database accounts management.
• Database patching.
• Ensuring compliance with Oracle license agreement.
• Monitoring and optimizing the performance of the databases. Monitoring CPU, memory, disk I/O, space and network on UNIX.
• Daily database user support.
• Utilizes tools for database administration, productivity enhancement and version control (Oracle Designer, Oracle Grid Control, OEM, Remedy, Dimensions, etc.).
• Developing DDL, DML, ETL scripts. Maintaining, updating and creating stored procedures(using records, collections, nested tables, object types, bulk bind variables, Bulk Binds), functions(pipelined table functions), triggers, packages using PL/SQL.

Confidential, Arlington, VA

Database Engineer

Responsibilities:

• Reviewing and creating DDD(database design documentation).
• Database design.
• Database upgrade strategy planning.

Confidential, Fairfax, VA

Database administrator

Responsibilities:

• Administrating databases on Oracle, MS SQL Server, Sybase Adaptive.
• Performing Oracle server installation, database creating and maintenance.
• Creating primary objects (tables - including partitioned tables, views, indexes) once an application has been designed.
• Modifying the database structure, as necessary, according to information given by application developers.
• Database backup/recovery strategy creation and modification.
• Database backup, restore, and recovery using RMAN.
• Database and application tuning to optimize performance.
• System storage and tablespace allocating and planning.
• Database backup, restore, and recovery using RMAN.
• Problem rooting and resolution.
• Performing database tuning and application tuning.
• Database security maintaining.
• Developing and modifying stored procedures, scripts for reporting, data loading, ensuring data integrity, conversion and migration..
• Migrating databases from MS SQL Server and Sybase to Oracle.
• Modifying DRD (Data Requirement Documentation).

Confidential, Herndon, VA

Database Engineer

Responsibilities:

• Creating database structure in Oracle 10g.
• SQL, PL/SQL programming.
• Database and PL/SQL performance tuning.
• Database backup and restore.
• Loading data into database.
• Verifying results of applications created in Java.
• Training and supporting junior database developer.

Confidential, Dulles, VA

DBA / System Engineer

Responsibilities:

• Working with users and translated user requirements into database and program design.
• Performing application design, Oracle database conceptual, logical and physical design and modeling.
• Oracle 8i Database installation.
• Creating and administrating database on Oracle 8i.
• Created fact tables, dimension tables, Star Schemas in data marts
• Database backup/recovery strategy creation and modification.
• Database backup, recovery using RMAN and Export/Import utility.
• Testing backup and recovery procedures.
• Performing database tuning and application tuning.
• Monitoring Oracle databases for disk storage requirements and allocated disk space to tablespaces.
• Developing and maintaining administration facility applications, construction project management application, and document management application using Visual Basic.
• Administrating servers for corporate web site and client-server applications using SQL Server database and IIS.
• Database problem rooting and resolution.
• Web application development and maintenance.

Confidential, Washington, DC

Database Engineer

Responsibilities:

• Requirements analysis, function analysis, database design and coding.
• Installing and upgrading the Oracle server and application tools.
• Creating and maintaining databases using Oracle 7, Oracle 8i.
• Performing database conceptual, logical and physical design and modeling
• Performing database conversion and migration.
• Performing data analysis, troubleshooting..
• Creating primary objects (tables, views, indexes).
• Designing and programming star schema and OLAP data warehouse models. Conformed facts, dimensions, data marts. ETL scripts Creating.
• Creating database packages, functions, cursors, triggers, and stored procedures.
• Database development and programming on Sybase and MS SQL Server.
• Database problem rooting and resolution.
• Supporting users on data trouble shooting.
• Processing data for displaying in reports.
• Developing front-end interfaces using PowerBuilder.
• Performing database and program testing.