Post Job Free

Resume

Sign in

DBA, Enterprise Project Management, Architect, CISSP

Location:
Sioux Falls, SD
Salary:
100,000
Posted:
May 13, 2017

Contact this candidate

Resume:

MARTIN D. SKYE RESUME ****

*** ***** ****** ******, ***. 3

Sioux Falls, South Dakota

1-605-***-****

PROFESSIONAL SUMMARY

Enterprise Database Administrator certified and experienced with multiple database systems (SQL SERVER, SAP Sybase, Oracle, IBM DB2 LUW EEE) specializing in database performance and tuning. Enterprise Database Administrator with strong ability to solve slow performance issues and troubleshoot global distributed database systems. Team Player and works well with on-shore and off-shore teams. Cloud Computing Technologies to save money to balance application and network loads in an Enterprise Distributed Environment. I have worked for some the largest corporations as a tech lead:

Citigroup

United Health Group

US Army Corps of Engineers

Raytheon

NASA

NOAA

Wells Fargo

FICO – Fico Credit Scores Creator – Fair Isaac Corporation Inc.

Successful Projects:

oRAYTHEON\NASA\NOAA - Launch of Landsat 7 Satellite – EROS (Earth Resource Observation System) – 10 year life span

oUnited Health Group - Deployment of the largest Distributed Database System in History - SYBASE

oUnited Health Group – Data Warehouse Migration of 200 terabyte SYBASE IQ database to new physical hardware systems for United Behavioral Health Systems

oCitigroup Acquisition of Mexico Bank – Banamex MEX (MPP, OLTP, OLAP)

oCitigroup – Database migration of 20 terabyte DB2 database to ARCHIVAL systems

oCitigroup – Database migration of 200 terabyte SQL SERVER database to COB systems

oBroadridge Financial Systems – Database migration of 4 terabyte SYBASE OLTP database from AIX to LINUX

oBroadridge Financial Systems - Database migration of 1,000 terabytes of data for Wells Fargo, Scotia Mcleod, Edward Jones Investments, Cetera Banker for development systems – Canada and USA

SQL SERVER PROFESSONAL CERTIFICATIONS:

Microsoft Certified Systems Engineer – 2008 to 2016

Microsoft Certified Database Professional – 2000 to 2012

Microsoft Certified Solutions Expert – 2008 to 2016

SYBASE PROFESSONAL CERTIFICATIONS:

Sybase DBA Professional 15.0 to 16.0 – 2016

Sybase IQ Administrator 15.4 to 16.0 - 2016

EDUCATION

Bachelor of Science in Business Administration – Marketing Management, National American University - 1990

Bachelor of Science in Management Information Systems – Database & Network Management, National American University - 1993

Master of Business Administration – Project Management, Colorado Technical University - 2002

Master of Science in Computer Science – Computer Security Administration, Colorado Technical University - 2008

CERTIFICATIONS

Certified Computer Security Administrator – CISSP (2016)

GIAC Certified Intrusion Analyst – GIAC (2016)

Project Management Institute – PMI (2016)

Certified Sybase DBA Professional (2016)

Certified Oracle DBA Professional (2011)

Certified Landsat 7 Computer Security & System Administration (2010)

Certified Internal Auditor – CIA (2016)

Certified DBA Professional DB2/UDB LUW EEE, 9 – 11

PROFESSIONAL EXPERIENCE

Global Citigroup Headquarters, Irving, Texas November 2015 – October 2016 -

Global Infrastructure SME - Subject Matter Expert – SQL SERVER and SAP SYBASE ASE

License by Core per Microsoft

Use of SERVICE NOW for change tickets, request tickets, incident tickets.

Performed Project Management for Banamex USA and Mexico.

Participate in Sev 1 and Sev 2 tickets for production issues through Microsoft LYNC and phone meetings.

APERTURE VISTA SERVER Management – register physical servers and virtual machines, hardware reports, server reports, client registration, cost control, ownership

CISCO UCS Management – network discovery flows, hardware reports and portfolios, configuration, diagnostics, monitoring, storage reviews, provisioning of computer infrastructures.

CISCO UCS Central – global discovery of servers in different regions, domains, sectors, zones, monitoring, uptime, system reports, remote management.

SME – Subject Matter Expert for Global Database SQL SERVER, SYBASE – Mexico, Banamex USA

DB2 UDB Archival Project – Citigroup Legacy Systems – Migrate 20 terabyte DB2 database to Archive

Oracle Archival Project – Citigroup Legacy Systems – Migrate 800 terabyte Oracle database to Archive

All database installations done by DBAC Tool – Automated Citigroup Database installation tool for Sybase 15 to 15.7, SQL SERVER 2005 to 2016

Ticketing System – SNOW or Service Now

DTS-SSIS packages for all clients – BUSA, LATAM Domains

BI and SQL SERVER Reporting Services

Cloud Computing Technologies – Pivot, Azure, AWS, Virtualization

Windows Server Cluster Administrator, IIS, Terminal Services

Windows Server Administrator – 2003 to 2016

Continuous Integration Database Tools

SQL SERVER snapshot replication systems and full database mirroring for COB systems

SYBASE replication using warm-standby systems

Reduced downtime 100 percent and completely lowered Mean Time to Repair.

All Global Database Technologies registered in Citigroup Sybase Database – Database Solutions Portal

Wintel SA registered all Physical Servers and VM in Aperture Vista

UNIX SA registered all Physical Servers and VM in Aperture Vista

Reviewed and implemented all database maintenance programs and schedules for each customer

Use of Perceive to monitor Physical Servers and VM – CPU and Memory

Use of Spotlight to monitor SQL SERVERS and SYBASE in Mexico

Use of SSMS to monitor SQL SERVERS in USA

Use of BMC Patrol to monitor SYBASE and SQL SERVERS globally

All database installations done by DBAC Tool – Automated Citigroup Database installation tool for SYBASE and SQL SERVER 2005 to 2016

Robocopy, FTP, Telnet

Created management reports for all SYBASDE SQL SERVER projects on status and completion

We were the database solutions group for the Citi Global Headquarters in Irving, Texas – REGIONS APAC, EMAC, LATAM, USA, and EURO.

TATA Consulting Firm with Citibank of Mexico (Banamex), Irving, Texas October 2014 – October 2015 – Global Database Administrator – (SQL SERVER and SAP SYBASE)

Use of SERVICE NOW for change tickets, request tickets, incident tickets.

Perform all DEV, UAT and PROD changes and incident tickets.

North American Support – BUSA Domain.

LATAM Mexico Support – LAC Domain.

Windows Server Clustering

VM Clustered Environments

Cloud Computing – Microsoft Azure (IAAS), Amazon - AWS

Participate in Sev 1 and Sev 2 tickets for production issues through Microsoft LYNC and phone meetings.

Troubleshooting difficult and hard to understand issues in a multi-faceted, global, database environments requiring deep understanding of slow performance of SQL SERVER and Sybase

Use of Database Solutions Portal to install and update database instances and servers.

Perform all SQL Server Database migrations from 2008 R2 to 2016.

Perform all SYBASE database migrations from 15.0 to 16.0 versions

Validation of Windows Server Environments for database migrations - WINTEL

Validation of UNIX Server Environments for database migrations - RHEL

Monitor development, continuity of business, production cloud/distributed database systems.

Monitor poor queries and slow performance – performance and tuning.

Database mirroring and log shipping disaster recovery solutions – DR and COB.

Snap-shot replication disaster recovery solution for SQL SERVER

SYBASE Replication Server using Warm-Standby Systems for COB environments

Database migrations from SAP Sybase ASE 15.0 to 16.0.

Use of LDAP for database security model.

Use of Aperture Vista for hardware server reviews.

Use of PERCEIVE to monitor hardware servers.

Use of PATROL and SPOTLIGHT for database monitoring automation.

Use of SQL SERVER Dynamic Management Views and Sybase Performance Reports – sp_sysmon to due performance and tuning efforts – Database Deep Dive Architecture Reviews.

Use of Veritas Net backup for file system backups.

Use of Sybase Central 6.0 to manage Sybase Data Servers.

Use of SQL SERVER MANAGEMENT STUDIO 2012 to manage SQL SERVER instances.

Run DBCC, REORGS, and UPDATE STATS for SAP Sybase ASE and SQL SERVER database maintenance.

Creation of linked servers for data uploads in SQL SERVER.

.

BROADRIDGE FINANCIAL SOLUTIONS, Denver, CO June 2013 – June 2014 – SAP Sybase and Oracle Database Administrator

Financial Portfolio databases managed by Broadridge Financial Solutions:

Wells Fargo – USA

Edward Jones Investments – USA and Canada

Cetera Banker – USA

Scotia Mcleod – USA and Canada

Credit Suisse (Capital One) - USA

Build SAP SYBASE ASE 15.0.3, 15.5 to 15.7 Data Servers/Instances on AIX and LINUX.

Help prepare Data Servers for ASE Enterprise Licenses.

Create SAP SYBASE ASE development environments using Oracle VM Ware on LINUX.

Create Oracle instances for development databases and schemas to assist developers in code releases.

Oracle versions 9i to 11G.

SAP Sybase versions 11.0 to 15.7 (threaded kernel – K21)

Create ASE Data Servers and take production database dumps and loading them into integration/development database environments so Aspire Integration Team can patch, develop, update, code, test and script the proper fixes to the production database systems.

Perform cross-platform dump and load migrations from AIX to LINUX. SYBASE ASE on operating system devices instead of raw devices.

Fix a database conversion stored procedure given by SYBASE called: sp_post_xpload that ran 2 days and did performance and tuning so it ran within a 4 hour period.

Bash and Korn shell scripting. Put in Sybase Infrastructure scripts to run reorgs, upstats, dbcc's, rebuild indexes.

Troubleshoot development problems with Alliance SYBASE Team and recommend performance and tuning procedures and processes for the database and network, Perform "Break-Glass" procedures using Remedy Tickets to solve slow performance issues in QA and Production Systems.

QA and Production Systems on AIX and Integration/Development Systems on Linux Platforms.

Microsoft Outlook, UNIX Term Putty, Ftp, Telnet, SCP -c arcfour, Ssh, Microsoft Office, Cisco Web-Connect for Intranet Chat.

CW WARD CONSULTING FIRM with FICO/Fair Isaac Corporation, Inc., Minneapolis, MN 2009 – 2012 – Enterprise SQL Server Database Administrator, Sybase & Oracle DBA

Setup production and development environments by working with team of 5 SQL SERVER DBA’s on 2008 R2 – migrations, backup/recovery, enterprise edition version, working on upgrades and migrations to SQL SERVER 2012.

Worked with SQL SERVER REPLICATION, SSIS (ETL), SSRS (Reports), business intelligence studio – SSAS, database monitoring, set all database parameters dealing with cache, CPU, memory management, performance and tuning (query analyzer, index tuning wizard), clustered environment, HA environments, Transact-SQL, assist developers on loading scripts into production, perform all database maintenance.

Worked with a team of 10 Sybase and Oracle DBA’s on the latest Sybase 15.7 and Oracle 11g environments.

Created test environment for FICO to compare the power of Sybase ASE 15.7 and Oracle transaction processing against OLTP rated standards and analyze performance statistics creating a cost benefit and analysis report.

Created test environment for FICO to compare the power of Sybase IQ 15.4 and Oracle OLAP/Analytic capabilities and analyze performance statistics creating a cost benefit analysis report.

Sybase Database Administration working with Sybase IQ 15.4 - DSS, Sybase ASE 15.7 OLTP.

Installed Sybase Replication Server 15.5. Administrate and manage company systems dealing with Oracle RAC, Oracle Performance and Tuning, Oracle Enterprise Manager (OEM) and Grid Control, Oracle Database Administration products.

Installed all instances, databases and table spaces. Create Sybase replication to work with Oracle database instance and Sybase data server. All information reported to the transaction processing council.

UNITED SIOUX TRIBES DEVELOPMENT CORPORATION, INC.

US ARMY CORPS OF ENGINEERS, Pierre, SD & Washington DC 2004 – 2008

Enterprise Solutions Architect – Database and Platform Infrastructure

Microsoft SQL SERVER, Oracle and Sybase database administration.

Used Agile and Scrum Software Development with complex computer systems engineering to design robust and lean computer systems and ensure they meet department requirements and cost objectives.

Meet with 7 system engineers weekly to discuss design specifications and make recommendations to improve system design and modifications.

Used RAD system tools and graphic computer and system design software to build system specifications to customer requirements. Cloud computing infrastructures and technologies to create a cost savings.

Built exact user requirements methodology and develop complex research practices to locate the best system designs to engineer lean development and production systems.

WINTEL Platforms: Windows 2000 – 2008 server, active directory tree, create users and domains.

UNIX platforms: IBM, SUN, HP, Silicon Graphics. UNIX Shell: KORN, C, RSH, SSH, Bourne. Windows: Active Directory, Windows XP, Vista, X windows, PowerShell, SharePoint. Security: Intrusion Detection Systems such as Tripwire, Intrusion Prevention Systems, Norton Antivirus, No Single Point of Failure, Firewalls, Biometrics, Routers, Encryption, Computer Forensics, Public Key Infrastructures, ISA Infrastructures.

Programming Languages: C, C++, XML, Shell Scripting, Java, ASP.net, Visual Basic.

Ability to make improvements in any system dealing with performance issues, slow performance and break fixes using knowledge in networking, database management, programming languages, operating systems, and interconnectivity such as VLAN, LAN, MAN, WAN, PAN, and Wireless counterparts, VPN, DMZ, Internet and Intranet Design Strategies.

UNITED HEATH GROUP/UNITED HEALTH TECHNOLOGIES, MN 2000 - 2004

Information Technology Project Manager (2002-2004)

Team Lead – Database Infrastructure\Distributed Database Systems (2000-2004)

Lead a team of 20 DBA’s using Microsoft SQL Server, Sybase, Sybase IQ, Sybase Replication Server and Oracle managing and monitoring 2,000 databases on Windows, IBM and SUN platforms for call centers, united behavioral health, healthcare claims processing, customer phone inquiries, and organ donation, elderly care and web applications.

Responsible for database performance and tuning, backup and recovery, production management, implement production releases and assist developers in database development.

Assisted in development of service level agreements and interfaced with customers in all database issues.

Developed project management processes for group using different phases of application and database development.

Used Project Management end to end methodology tracking project management processes in IT phases from application, network to the back-end database using Planning, Analysis, Design, Implementation, Integration and Test.

Went to all project management meetings at UHG for the database group. Interfaced with all Management and IT Groups within United Health Technologies - Network, Security, Database, System Administration, Project Management, CEO, CFO, CIO, and Steering Committee etc. On-call 7X24 using cell phones and UNIX script paging technology.

Used Embarcadero, Middle Ware Administration Platforms, BMC SQL Back Track, White Sands, Sybase Central, Microsoft Project, Microsoft Access, Microsoft Office Suite, Web Sphere, Apache Web Servers, BMC Patrol, Linux UNIX Flavor.

ITIL – Information Technology Infrastructure Library training, PMI – Project Management Institute training and certification, PMBOK Certification Programs, Professional Project Management Certification – Colorado Technical Institute – PMI 2002.

Monitored and uploaded, ftp’d UNIX files for database performance website. SOX – Sarbanes – Oxley, GLBA – Gramm, Leach, Bliley Act, HIPAA – Health Insurance Portability and Accountability Act.

E-business/E-commerce business transactions and administration.

VM Ware, Share Point. Microsoft Project.

Administered a $5,500,000 million budget for the group.

RAYTHEON STX LANDSAT 7 NOAA/NASA, Sioux Falls, SD 1997 – 2000

SQL SERVER and SYBASE DBA – WINTEL\UNIX System Administrator

Managed, secured and monitored 200 web and software servers connecting to Sybase VLDB databases and 20 hardware servers using Windows and Silicon Graphics IRIX, SUN OS and HP.

Managed, secured and monitored Microsoft SQL SERVER databases on Windows NT hardware servers.

Managed software resources that support the ingest, processing and distribution MODIS/ASTER/LANDSAT data down link/up-link into/from ground station and data center of satellite repositories that is part of a global multi-disciplinary or EROS (Earth Resource Observation System) program monitoring networks web servers/ Sybase database that track changes in the earth’s environment. The EOSDIS (Earth Observation System/Distributed Information System) CORE system supports the execution of concurrent processes in multiple modes (directories) through the use of complex, highly integrated state of the art network architecture and mass storage systems called EMASS (AMASS software) interconnected by a FDDI – Fiber Data Distributed Interface and HIPPI – High Performance Parallel Interface network technology.

Performed patches and upgrades as necessary to Hardware and Software Platforms.

Created support and trouble tickets with vendor on hardware and software issues to find solutions to break-fixes.

Certified in Landsat 7 Satellite Program as Production Scheduler, Resource Scheduler, Ingest, Security and Security/System Administration and as Sybase Database Administrator.

Certified MSCE on Windows and Landsat 7 Certified on UNIX.

Certified Microsoft Database Professional.

Middle Ware Administration Platforms.

Autosys Software Products, Microsoft Project, Microsoft Office Suite.



Contact this candidate