Scott G. Curl Email and Phone Number

🔷 Recruited as DBA Team Lead for AWS Multi Account Cloud Environment with accountability for AWS database infrastructure design and implementation. Attended AWS RE:Invent 2019.🔷 Collaborated closely with DBA team to determine AWS DB policies and procedures with authority as final decision maker for all AWS Database environments for the DBA team.🔷 Coordinated with Baker Hughes Security to assist in determining permissions both DBAs and application users. Coordinated with the Cloud Network Team to implement firewall rules for AWS DBs.🔷 Served on a team of 5 at Retail Finance (3 developers & data warehouse team lead). On a project team of 10 Retail Finance, Developers, Business Analysts, and App Owner. Interviewed and made recommendations for new hires.🔷 L3 Non ERP Database Support, L3 AWS Database Support, L2 Mentoring & Training, Chef Scripts, Lambda Functions, Cloud Formation Templates.

🔷 Accepted a Cloud DBA position with GE Oil & Gas following sales of majority of assets by GE Capital. Cloud DBA. Provided primary support for AWS Database Environment consisting of RDS and EC2s.🔷 Migrated ~75 dbs to AWS via Database Migration Services, Schema Conversion Tool, Azure Migration Wizard, SQL Server S3 Restore, Oracle Data Pump, and Shell scripting. Traveled to Italy 3 times to perform DB migrations.🔷 Migrated ~70 dbs from premises to AWS RDS & EC2s, saving 70% in operations costs. Completed all projects ahead of deadline with a reputation for reviewing pending projects directory and taking on added projects.🔷 Provided L3 Support, mentored L2 in AWS Support, developed and supported Chef Scripts to create SQL Server EC2s, worked with Scalr for AWS instance deployments, as well as some work with Redshift.

-• Created and tested ETL processes scripts that cleansed, transformed and loaded credit card processing data on a daily, monthly, quarterly and yearly basis.• Maintained statuses, assisted management in delegation of tasks for reoccurring monthly projects. Assessed what changes needed to be made as well as determined which team member made changes to which processes. • Often created test data when not present in order to develop ETL processes so that projects were finished ahead of schedule.• Suggested alternative methods for creating ETL process in order to reduce steps in the process.• Quickly adapted to ETL tool and environment having created first production process within first 30 days of use with no prior knowledge.• Ensured all processes complied with policies and procedures by adhering to coding standards and via documentation.• Assisted with testing new patches and upgrades to servers as well as software.Tools/Skills:Ab Initio, Informix, Solaris 10, KSH, CSH, SSH, Putty, VNC, EBCDIC, Informix Onpload, Informix SPL, MySQL, Notepad++, WinSCP, SFTP, AWK, NAWK

🔷 As Data Warehouse Developer, developed Ab Initio Graphs/Functions/Transforms. Created Ab Initio ETL Jobs to add data from First Data EBCIDIC files, SalesForce data, Oracle databases, flat files, and CSV to Informix data warehouse.🔷 Developed queries for DML & DDL for Informix Data Warehouse, created Informix High Performance Loader Jobs, and developed Shells scripts to run ETL jobs.🔷 Served on a 10-member team for Real Estate, including 3 developers, Database Manager, and contracts. Served on a team of 10 DBAs reporting to CTO-Director Digital Operations Database. Worked on a 50-person AWS Cloud Team.🔷 ETL Jobs, Ab Intio, Informix Database Queries, Informix High Performance Data Loader Jobs, Shell Scripts, AWS RDS Database Instances, Migration Jobs.🔷 Additional project included iSeries Application DBA. Worked with application team, performed queries to obtain data for app teams, and converted the iSeries database schema to Oracle using Agile with App Team.

🔷 Competitively selected to serve in key Program Analyst roles for a leading regional, independent oil & natural gas exploration and production company focusing on the Gulf of Mexico. Attended SQL PASS Summit 2012.🔷 As Database Developer, developed and supported production applications within an Access and SQL database environment. Developed a purchase order system using Excel as the application and Access as the database.🔷 Tasked with applications support for offshore data entry, daily production reports, monthly allocation system, and historical data, as well as cost estimates.🔷 Developed ad hoc queries for office use, managed users, provided support for all issues, from minor bugs to server issues and adding features and reports to applications.🔷 Responsible for the transition in progress of moving data from the Access application to the SQL Server application by converting the data, Active Reports & T-SQL, ASP.net web pages, and setting up and maintaining servers.🔷 As Accounting System Administrator, administered, supported, and performed data extraction in the Bolo (Gwiz) accounting system. Managed all user accounts and user permissions from within the application.🔷 Provided installation support, user logins, database locks, and ad hoc queries. Created an SQL ODBC interface for the Unidata multi value database which Bolo resides in, for use in Excel & Access reporting tools.🔷 As Drilling Software Administrator, administered, supported, and performed data extraction in the Peleton Wellview drilling application. Managed user accounts, SQL server database, Windows client & server, and Office application issues.🔷 Presented a proposal to EPL management to purchase software that converted Unidata multi value database to SQL Server database to integrate with finance and production systems, providing better query information for reporting.

🔷 Provided all support for a network of 2 servers and 20 clients. Maintained and developed Access database reports for addresses, management information, and phone numbers for all locations throughout the U.S.🔷 Developed an ASP website to allow users to access. Created reports using Crystal Reports. Administered and supported Great Plains Dynamics accounting application.🔷 Assigned to oversee a project to convert from Novell Netware to a Windows network. Prepared clients by replacing computers and upgrading hardware. Assisted with server setup and migration of data/applications to new network.🔷 Handled all Y2K bug issues, ensured that all computers and applications were current and that a comprehensive disaster recovery plan was in place.