Database Administrator Sql Developer

Mark Staples San Antonio, TX ***** • ***********@*****.***

https://www.linkedin.com/in/mark-staples-391b78110/ Design • Development • Administration • Conversion SENIOR DATABASE ADMINISTRATOR US Citizen.

An accomplished, detail-oriented, Senior Database Administrator with a solid background in database management, encompassing 25 years of experience. High expertise in managing multiple servers in multi-instance environments, backups/restores, troubleshooting and proactive maintenance. Strong technical knowledge of database programming and architecture. Excellent project management skills, with proven ability to direct and manage all aspects to ensure on-time and under-budget delivery. Proven ability to successfully streamline, optimize and maintain system functionality performance and recoverability. Experienced Unix/Linux/IBM Aix administrator with shell scripting, RMAN and OEM experience. Used Oracle versions 11G, 12C and 19C. Experienced with Jira for Agile project Management.

CERTIFICATIONS

• CompTIA Security + Certified CE

https://www.certmetrics.com/comptia/public/verification.aspx?code=TDKC3PL78Z6PF854 PROFESSIONAL OVERVIEW

Senior Developer Engineer / Oracle Financial Services Analytical Applications, Oracle Financial Services Data Integration Hub.

(OFSAA) on Linux Red Hat USAA financial Services Company. San Antonio. August 2019 to February 2023.

• Technical Team Lead / Providing support for OFSAA FTP and OFSAA DIH.

• Oracle DBA experienced with OEM, DataPump, SQL Developer tools and PL/SQL.

• SQL Server DBA T-SQL Developer.

• PL/SQL Developer

• Used IBM DataStage ETL system to load data from numerous sources.

• Used BMC Control-M to manage ETL jobs and OFSAA Batches.

• Used Jira for Agile project management.

• Snowflake trained.

Senior DBA Oracle / EDB Postgress Teksystems Inc. San Antonio DOD/DHA Lackland Airforce Base. November 2018 to Present.

• Provided DBA support remediating DOD Oracle systems to adhere to the DoD STIG Cybersecurity Standard.

• Provided DBA support migrating from Oracle 11/12 Windows to EDB Postgress 11.2.9 Linux X86. Senior DBA Oracle / SQL Server Resource Data, Inc. July 2017 to November 2018.

• Provided DBA support for the largest telecom company in Alaska; this included leading the Oracle 11 to 12 upgrade project; used Oracle data pump to move data between Oracle 11 and Oracle 12 to create a test environment; utilized DBUA to go live.

• Used ETL techniques, for the Chugach Alaska Corp, to migrate Taleo data from the Oracle cloud; transformed that data and loaded it into local SQL Server databases; utilized SQL Server Migration Assistant.

• Performed a database assessment of the Anchorage Municipal Light and Power database systems; this included both SQL Server and Oracle versions 12, 11, and 10; generated a report of system weaknesses and provided recommendations and solutions. Senior DBA Oracle / Sybase / SQL Server Computer Task Group May 1993 to December 2016

• Performed all DBA tasks; management, backup/recovery, installation, patching, performance tuning, and data migration.

• Installed and configured IBM RISC 6000 Aix servers.

• Data conversion from SQL Server 2000 to SQL Server 2005; for the State of Alaska.

• Technical Lead SQL Server 7.x Windows NT DBA; backup/recovery, security and performance tuning; created and maintained interfaces from SQL Server to client Oracle databases; created several utilities using T-SQL; all for Arctic Supply Chain Integrators.

• Directed all database administration and maintenance; completed an upgrade from SQL Server 6.x to 7.x; managed over 30 Oracle instances on Sun OS, Linux and IBM AIX; for British Petroleum.

• Moved Alyeska Pipeline applications from mainframe based dumb terminals to the client server model using Oracle and IBM RISC- 6000 AIX systems; within a few weeks converted a Geo Graphical information system oil well mapping application.

• Became the key resource in helping Alyeska reach its goal of implementing a client server system architecture; this resulted in providing users with much more power/flexibility on their desktop; increased employee productivity and saved millions of dollars. Mark Staples San Antonio, TX 78248 • ***********@*****.*** https://www.linkedin.com/in/mark-staples-391b78110/

• Accomplished physical database design, backup and recovery, performance and tuning on IBM Risc-6000 AIX 3.25, OS2 for Alyeska Pipeline; was also the Oracle Financials DBA.

Oracle DBA / Unix Systems Administrator Alyeska Pipeline Service Company January 1990 to January 1993

• Installed and administered Oracle RDBMS and IBM AIX; conducted the migration from DB2 to Oracle RDBMS.

• Oracle InterConnect administrator and developer; also completed updates and patches as Oracle Financials DBA. EDUCATION & TRAINING

Bachelor of Science Degree, Business Administration, Computer Information Systems, Northern Arizona University Oracle database administration and Performance Tuning and Oracle RDBMS architecture Oracle database warehouse database design

AIX system administration

DB2, SQL/DS design and development

EDS corporate training, program structuring and standardization techniques, included several programming languages TECHNICAL SKILLS

Databases:

SQL Server, Oracle 5-12, Sybase 4-11, MS Access, DB2 Operating Systems:

AIX, SCO Unix, Digital Unix, Sun Solaris, Linux, Red Hat, Windows Server Programming Languages:

Unix Script, C, Cobol, Cobol II, Assembler, Pl/SQL, T-SQL, Power Shell. Software / Applications / Utilities:

OEM Oracle Enterprise Manager, SQL*Loader, Oracle Data Pump, Oracle SQL Developer, Cold Fusion, Oracle Interconnect

Contact this candidate