TECHNICAL SKILLS:

Database Systems: Oracle versions from 7.2 through 12c, MS SQL Server versions from 2000 through 2012, Microsoft Access, Sybase, Postgres 9.2

Software: Oracle Enterprise Manager and Enterprise Manager Grid Control, CA ERWin, Embarcadero DBStudio, Quest Toad 11.6, Embarcadero Change Manager, MS SQL Server Enterprise Manager and Management Studio( 2005 and 2008 ), Golden32, MS Visual Studio, Symantec BackupExec, XML Schema, XML DTD, SPF, Microsoft Word, WinZip, WinRar, WS FTP, Microsoft Outlook, Microsoft Exchange, Microsoft Excel, Microsoft Access, Microsoft Visio, Oracle SQL Developer

Operating Systems: Windows 2012R2, 2008, 2003 and Vista Server family, Windows XP, Windows NT 4, Novell Netware 5, MVS, RHEL

Application Servers: Apache / Tomcat web server, IIS

Software Languages: Oracle SQL and PL/SQL, MS Transact SQL, Powershell,, HTML, XML, XSLT, Java, JSP

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Ensured the integrity and availability of all NGRMS development, testing, performance testing, and Government observed testing databases hosted on the ETC and CACI cloud servers.
• Developed and implemented backup procedures and for all NGRMS development, testing, performance testing, and Government observed testing databases and schemae using RMAN.
• Developed and deployed Windows OS jobs using Powershell to perform diverse database activities such as executing exporting and importing schemas using datapump and executing SQL*Plus scripts across multiple servers and database instances.
• Created Deployment scripts and ERDs for the NGRMS application ensuring proper version control, schema auditing, referential integrity and performance goals were maintained.
• Maintained Data Dictionary, Logical Data Model (DIV - 2) and Physical Data Model (DIV-3) in Erwin and Cameo.
• Performance tuned databases and SQL/PL/SQL for optimal processing. Analyzing schema to determine proper course of action, whether it be index creation, Optimizer hints or SQL revision.
• Performed upgrades from Oracle 11gR2 to 12c, including conversion to Container/Pluggable database architecture.

Confidential

Senior Development Database Administrator

Responsibilities:

• Design, develop and implement PL/SQL packages, procedures and triggers in support of multiple Confidential applications, ensuring data integrity, availability and application performance are maintained at designated levels.
• Design, develop and implement a reporting data warehouse of Student/Assessment Score information, including partitioning and materialized views for performance optimization.
• Design, develop and perform an analysis of database query performance comparing Amazon Redshift, Oracle 11gR2, and Oracle 12c with and without the in memory option.
• Respond to support, enhancement and defect fix requests from in-house users, ensuring that data integrity and availability are maintained.
• Design, develop and implement an adhoc data feed application of educational organization information, producing dynamic result sets based on user supplied parameters.
• Create Deployment scripts and ER diagrams for all new schema development .
• Update documentation and ER diagrams for legacy database schemas.
• Analyze and refactor long running PL/SQL packages and procedures to optimize performance.
• Analyze, develop and deploy schema modifications to optimize application performance.
• Develop and update SQL Loader processes and PL/SQL packages and procedures to extract, transform and load (ETL) delimited text files into Oracle database schemas .

Confidential

Database Administrator

Responsibilities:

• Ensured the integrity and availability of all client databases hosted on Confidential Engineering servers, (over 250 schemas on 8 separate Oracle instances and over 300 databases on 20 separate SQL Server instances) as well as assisting the Product Support team in troubleshooting client installations at remote sites.
• Developed and implemented backup procedures and audit processes for all Oracle databases and schemae using RMAN. Developed and implemented like procedures for SQL Server.
• Developed and implemented a physical standby database using a custom written Archivelog Shipping process to the Amazon Cloud.
• Installed and configured SQL Server 200, 2008, 2012 and Oracle 9i, 10g and 11g databases including RAC. Determined physical layout, log configuration and database feature deployment for all Oracle and SQL Server databases.
• Implemented DR processes using Oracle DataGuard, Oracle Streams, SQL Server Database Mirroring and SQL Server Log Shipping.
• Developed and implemented database hardening scripts and procedures for Oracle and SQL Server instances to comply with NIST, FISMA and other information security regulations associated with the protection of PII and PHI data.
• Deployed Full Text Search capability in SQL Server and Oracle, including the installation and configuration of 3 rd party applications necessary for SQL Server.
• Performance tuned databases and SQL/PL/SQL/Transact SQL for optimal processing. Analyzing schema to determine proper course of action, whether it be index creation, Optimizer hints or SQL revision, using tools such as tkprof, stacktrace and LogMiner.
• Analyzed load test results for opportunities to improve database/schema performance and scalability.
• Created and administered development, test, QA, staging, production and training databases for all Confidential products.
• Created migration scripts transforming client data from various external systems and database types to standard Confidential product schemae.
• Created and deployed SQL Server DTS and SSIS packages to perform ETL activities.
• Developed and deployed Windows OS jobs using Powershell to perform diverse database activities such as executing RMAN scripts, exporting and importing schemas using datapump and executing SQL*Plus scripts across multiple servers and database instances.
• Designed and developed specific modifications to the entellitrak core product to enhance the product’s functionality, scalability and flexibility.
• Created Deployment scripts and ERDs for all products and custom applications.
• Collected and organized all developer SQL into periodic database patch scripts.

Confidential

Oracle Database Administrator/Sr. Programmer

Responsibilities:

• Installed and configured Oracle 8I, 9i and 10g databases on Windows 2000 and 2003 servers for OLTP and Data Warehouses, including RAID configuration, OS installation, and design and implementation of Oracle tablespaces for maximum OS processing efficiency.
• Designed and created schema, including referential integrity and data integrity constraints, stored program development (triggers, sequences, views, functions, stored procedures and packages) in support of a wide variety of Web-based applications.
• Created Deployment scripts and ER diagrams for all schemae, allowing easy deployment at remote sites for projects hosted at client site.
• Developed and implemented backup procedures and audit processes for these databases and schemae using RMAN.
• Developed PL/SQL packages and procedures that imported XML data files, inserted the files into CLOBs, and parsed the data into multiple tables while maintaining referential integrity in the process.
• Developed SQL Loader processes and PL/SQL packages and procedures to extract, transform and load (ETL) delimited text files into Oracle data warehouses and Decision support systems .
• Develop processes to extract data from Dbase, Access and Excel files; transform and load the data into a variety of Oracle and SQL Server databases including data warehouses, financial and other OLTP and decision support systems.
• Designed, developed, maintained, enhanced, and administered Oracle data warehouses to report laboratory performance statistics and EPA Cost Recovery.
• Developed batch job processes using Oracle Enterprise Manager and the DBMS JOB package as well as Windows OS scheduled tasks.
• Designed and implemented replication processes for multi-master replication.
• Performance tuned database and SQL/PL/SQL for optimal processing. Analyzed schema to determine proper course of action, whether it be index creation, Optimizer hints or SQL revision, using tools such as tkprof, stacktrace and LogMiner .
• Produced reports from several complex automated systems in response to user ad hoc requests, which were often extremely time-critical.
• Worked with end users to resolve microcomputer software and hardware problems.
• Administered, including design, enhancement, tuning, backup and recovery, all stored procedure and data transformation service development of a Microsoft SQL Server relational database system responsible for tracking EPA Site-specific labor cost information and creating monthly invoices to the EPA based on this labor information.
• Administered, including design, enhancement, tuning, backup and recovery of a Microsoft SQL Server relational database system responsible for tracking speakers, attendees, topics, logistics, and accepting credit card payments for the annual EPA Brownfields Conference.
• Managed administration and development staff working on several Web and database projects, including reviewing timesheets, tracking LOE, and workload
• Design, development, and implementation of Web applications related to the databases administered by this section for internal Confidential clients and external clients over the World Wide Web.
• Design, development, and implementation of Web applications transforming XML data into RDBMS and exporting XML data from RDBMS into requested formats using XML Schema, DTD and XSLT.
• Act as backup server administrator for the database and Web servers that deliver database content for internal Confidential clients and external clients over the World Wide Web.