Database Administrator Operations Manager

Salvador Castaneda

Davenport, Iowa, United States

**************@*****.*** 309-***-****

linkedin.com/in/salvador-castaneda-9a400312

Summary

100% remote telecommute experience

** ***** ********** *orking with Databases and Servers in a Windows environment; On-premise and on the Cloud.

AWS experience working on EC2 instances

Successfully Managed a team of 12 Dev Ops Database Administrators around the globe Experience working with Stand-alone SQL server instances, clustered instances, high availability clustered instances and replication

Experience working with physical and Virtual Servers Previously held Secret Security Clearance

Experience working with all aspects of database management, from instance parameters, to permissions, performance tuning, optimization, backup and recovery Business minded with experience leading initiatives and seeing the big picture Experience working with budgets, forecasting and investment analysis Proven ability to move projects and initiatives through a faster life-cycle then previously anticipated Windows Server and Unix/Linux Server Administration Some DevOps experience working with powershell, git, amazon workspace and tools Hands on development of data mining reports using Crystal Reports and .Net Strong track record of identifying and remediating performance bottlenecks in transactional database environments larger than 1TB

Hands on experience migrating Oracle instances to SQL Server instances and vice-versa; Informix databases to SQL Server; SQL Server to SQL Server; Oracle to Oracle. Deep understanding and hands on experience with (STIG); a cybersecurity methodology for standardizing security protocols within networks, servers, databases and logical designs to enhance overall security. Solid knowledge of Version/Source Control

Oracle 8i Certified Database Administrator

Experience

Owner

Supira Consulting

Mar 2020 - Present (2 years 7 months +)

Support, maintain and administer SQL Server 2019 database servers on AWS and Rackspace (physical and virtual instances) in a High Availability environment. SQL Server Change Tracking and Change Data Capture experience Migration experience from physical servers to AWS virtual environment (EC2, RDS), (R, I, M Series) Limited experience managing and creating Azure snowflake environments Experience working with Snapcenter snap backup jobs Experience managing up to 15 direct senior personnel Experience working with Profit and Loss statements, budgets in general, and staffing budgets Salvador Castaneda - page 1

Experience making difficult decision on the fly where company profits and customer relations are on the line.

Infrastructure Database Engineer

Arconic

Oct 2019 - Jan 2022 (2 years 4 months)

Support and maintain 2016/2017 SQL Server, SSAS and SSIS servers on a day to day basis, include performance tuning, migration of databases, cubes and disaster recovery. Support SQL Server Clusters and SQL Server High Availability Clusters Assist in deploying SSIS and SSAS packages, cubes, as well as providing guidance and troubleshooting when issues arise

Support all aspects of 2013 Sharepoint and Sharepoint reporting services In process of Installing and Migrating Sharepoint from 2013 to 2019. Work with Business Intelligence and operations teams for 24/7 availability of systems Responsible for patching of servers, working with Active Directory, Configuring and maintaining Backup Exec and Team Foundation Servers

Work with application teams in troubleshooting application issues on applications used with Manufacturing

Support, Migrate, Install and troubleshoot Team Foundation Server Support, Migrate, Install and troubleshoot Veritas Backup Exec 21 Assist in Active Directory, firewall, and domain troubleshooting Provide assistance in troubleshooting Rockwell Automation manufacturing software Support and troubleshoot IIS, and web application issues Cloud Database Engineer, Sr.

Infor

Dec 2018 - Oct 2019 (11 months)

Support of all facets of M3 Single/Multi-tenant AWS EC2 database servers. Utilizing Remote Desktop Manager, Securelink, Amazon Workspace, AWS CloudSuite Portal, Powershell, git bash, and faro on a day to day basis. Senior Database Administrator, Lead

IHMVCU

Sep 2018 - Dec 2018 (4 months)

Worked with Analytics and Insights team to take transaction based database system and convert it into a data warehouse for reporting and analytical purposes utilizing star schema's, dim, facts, bridge and temporal tables.

Informatica 9.5; Data Quality (DQ), Data Transformation (B2B DT), Big Data Management (BDM) training.

Visual Studio 2015, 2017, with Team Foundation Server 2018, Azure Devops(TFS) to create ETL packages and jobs.

Learned database layout of Spectrum financial database system SQL Server 2016 Enterprise.

PowerBI Report Server 2018, install, configure and set up permissions on dashboards. Adobe Campaign workflow integration

Salvador Castaneda - page 2

Senior Database Administrator

COOP Financial

May 2018 - Sep 2018 (5 months)

Provide guidance to teammates on day to day tasks, work with other teams to bring cohesion, created much needed documentation and began updating scripts in order to automate tasks Working with team to migrate and consolidate separate legacy 2005, 2008 database servers into consolidated SQL Server 2016 clustered database servers Analyze, re-write and optimize sql procedures and jobs, working to convert them into SSIS packages Support clustered and non clustered databases environments with encryption Assist team members in learning new database features and sharing information to help them better do their day to day job.

Work with and assist application developers in an effort to convert cold fusion forms to .Net. Work with financial data such as CUNA Mutual, FIS, BINS and other Credit Card processing data Oracle / Maximo Database Administrator

Harris Corporation

Dec 2017 - Dec 2017 (1 month)

Support all facets of Oracle and IBM Maximo financial systems Senior Database Administrator / Manager

Infor

Jul 2015 - Mar 2017 (1 year 9 months)

Successfully led a team of 12 database administrator located around the world; supporting 1600 databases servers on Oracle RDBMS, SQL Server and Posgresql in both Windows and Linux environments on the AWS Cloud

Unified four separate teams into one cohesive team while increasing customer satisfaction Daily duties included troubleshooting, performance tuning, backups, restores, migration support, application support, implementing best practices, isolating and providing guidance on problem sql statements, creating checklists, documentation and working to automate DBA tasks. Worked with DevOps in assisting to troubleshoot automated backup routines, replication automation and database user permission automation.

Completely removed personnel from working the grave yard shift to increase morale while still providing support around the clock.

Worked to lead my team by being in the forefront to always be aware of what is actually happening in the front lines.

Senior Database Administrator - Lead

Rock Island Arsenal

Jun 2008 - Jul 2015 (7 years 2 months)

Worked for several companies (Bowhead, General Dynamics, Dell, QSS and Perot Systems) while supporting the Rock Island Arsenal Network Enterprise Center Developed analytical and data mining reports for upper management on a day to day basis and eventually I automated the process by creating a customizable web-based front end using coldfusion to publish reports using crystal reports connecting to a master report database. I also created slave databases on all other databases servers to assist in automating the push of data to the master report database. Allowing for on-demand reporting.

Salvador Castaneda - page 3

Led a team of two Database Administrators and four web developers for a period of year on an initiative to migrate SQL databases to newer versions, migrate applications from Oracle to SQL server and to develop and migrate web based applications to .Net from coldfusion. Hands on experience installing and troubleshooting Oracle Database instances on Unix HP-UX and Linux RedHat, Microsoft SQL Server, Windows Servers, Microsoft Operations Manager, Active directory

(users, groups, permissions, containers), Microsoft Clusters, IIS, Sharepoint, ColdFusion Web Services, SSAS, SSIS, Database Mail and Server Group policies Hands on experience installing security updates and patches on both Oracle RDMBS and Microsoft SQL Server; performance tuning Oracle and SQL database servers; optimizing sql queries; automating backups; performing restores; migrations and working with customers architecting database structures. Developed checklists, documentation and processes for team duties to meet Government requirements. Developed, migrated and assisted customers in troubleshooting SSIS and DTS packages. Database Conversionist

Fidlar Technologies

Jun 2003 - Jun 2008 (5 years 1 month)

Hands on experience exporting, extracting and manipulating database data and structures in order to migrate them off of legacy based database systems and into Microsoft SQL Server At times, I had to creatively figure out how to access databases systems with no documentation and no login information in order to assist customers exporting the data out. Developed scripts and packages in order to automate the conversion of data from like legacy database systems into SQL Server, effectively becoming the only person in the company to ever take a customer live with all of their data. The norm was to import customer data 30 days after taking the customer live with our applications.

Developed Crystal reports based on customer requirements on a day to day basis, including troubleshooting and migrating/updating existing reports. Developed an application using Visual Basic and C++ that allowed end users to query and update database data. I made the application headers and sql/t-sql completely customizable. Developed and troubleshot DTS packages.

Hands on experience installing SQL Server, Windows Server, proprietary applications, Crystal Reports, printers and working with firewalls.

Assisted development team in creating and troubleshooting Ghost Imaging Process. Hands on experience working with ODBC and ADO connections. Database Pre-Sales Consultant

Oracle

Sep 1997 - Jun 2002 (4 years 10 months)

Hands on experience installing, configuring and troubleshooting Oracle 8/8i/9i databases, 9i Internet Application Server, Portal Architecture and Apache Http server for customer demonstrations in a Pre- Sales environment.

Developed custom scripts using Http, SQL and PL/SQL for customers demonstrations Created and gave presentations to C-level executives on Oracle 8/8i database architecture, Enterprise Manager, Backup, Recovery, Performance Tuning packs, 9iAS Portal benefits, architecture and instructed classes on how to build and manage a 9iAS Portal Website. Hands on experience installing and troubleshooting all aspects of Windows 2000, NT 4.0 Server/ Workstation and Windows 95 computer systems.

Hands on experience replacing internal laptop and desktop parts Salvador Castaneda - page 4

Experience configuring and maintaining Primary/Backup Domain Controllers, Active Directory Groups, Print Servers, Veritas Netbackup3.02.

Hands on experience configuring and troubleshooting network related issues: Novell, TCP/IP, DHCP, PPP and static IP.

Education

Community College of the Air Force

ongoing, Human Resources Management/Personnel Administration, General 1995 - 1997

Licenses & Certifications

Oracle Database Professional - Oracle

Skills

Active Directory • Windows Server • Microsoft SQL Server • Network Security • Troubleshooting • Network Administration • Software Documentation • Security • ITIL • System Administration Salvador Castaneda - page 5

Contact this candidate