Scott Kelleher Email & Phone Number

Houston, Tx, Us

Issaquah, Wa, Us

Chattanooga, Tennessee, Us

The DevOps MySQL DBA is the owner of multiple relational databases, responsible for strategy, advancement, automation, and performance optimization within Amazon Web Services (AWS). You are a master at deep diving into explain plans, identifying problematic queries and stored procedures, reducing IOPS. As a member of the DevOps team, you’ll have a passion for automating boring activities, and implementing infrastructure as code. This role will work closely with software engineering, providing detailed feedback to developers on code improvement strategies relating to the database. ESSENTIAL JOB FUNCTIONS INCLUDE:Monitor and maintain system up time and performance in accordance with established SLAs.Provide feedback on code release impact on database performance in lower environments.Database performance and capacity analysis/tuning.Design and implement automated disaster recovery strategy within AWS.Collaborate closely with developers on code optimization.Recommend data strategy, structure, and tools for product performance.Assist building ESG/3rd Eye Enterprise Data Hub supporting customer facing and internal data analytics requirements.Expert knowledge of MySQL 5.x; working knowledge of Cassandra or similar NoSQL.Works as part of the DevOps Team supporting cloud deployment pipelines using Jenkins, Cloud Formation, Chef, Puppet, and other tools as appropriate.Support containerization technologies such as Docker, Kubernetes, etc.Support cloud deployment pipelines using Jenkins, Cloud Formation, Chef, Puppet, and other tools as appropriate.Consult and act as subject matter expert (SME) for implementing data security (encryption at rest, data masking / anonymization).Able to write and maintain scripts such as Bash, PowerShell, and Python.Install, and maintain service alerting tools such as: Monit, DataDog, Grafana, Prometheus, and Elastic Search.Utilize source code revision control tools (such as GitLab) for source code management.

Hickory, North Carolina, Us

Responsible for, but not limited to design, implementation, troubleshooting, optimization and performance tuning for supported Product databases. Well versed in database administration, developing complex business logic in SQL and developing ETL processes. Responsible for ensuring effective and timely resolution of customer technical issues in a fast-paced, startup environmentPRIMARY DUTIES● Creates and maintains all databases required for development, testing, and Production usage.● Participates heavily in Capacity Planning, Scalability, Backup & Recovery strategies, Security, Monitoring and Performance Tuning.● Designs, implements and troubleshoots Transact-SQL scripts.● Installs, creates databases and performs upgrades of the database and software to new release levels.● Configures Oracle Real Application Clusters (RAC).● Provides technical support to Application development teams.● Mentors Professional Services staff to complete basic steps.● Develops and maintains best practices.● Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.

Madison, Wi, Us

Maintain the production environment to enhance the client experience of SVA’s system.● Automated notification of the scheduled processes to alert the appropriate resource.● Maintained consistency between Development, QA, and Production environments. ● Developed and adjusted T-SQL scripts in order to maintain flow of production data.● Resolved data flow issues between clients and 3rd party sources, EDI transactions.● Reviewed system logs and researched errors.● Maintained HIPAA compliance as client data was medical data. ● Worked with developers to enhance and streamline deployment process, and to reduce technical debt.● Reviewed third party products to enhance the SQL Server environment.

Winona, Mn, Us

Enhance the environment to streamline repetitive tasks, improve the knowledge base, and improve the tool set while providing support for production and development database environments.● Took a data replication tool from sales pitch to production, including supporting development and test environments, documentation, and problem alerting.● Managed a team responsible for installation and maintenance of Golden Gate. ● Managed the installation and configuration of two Oracle Exadata machines.● Implemented new technologies to streamline work and minimize outages.● Managed the moving production databases between servers.● Managed the move of 24 development and test databases in less than two months.● Created a semi-automated process to replicate a production database for deployment staging and employee training purposes.● Utilized expertise to train fellow database administrators and to mentor junior database administrators on both new and older technologies.● Installed, configured, and deployed Oracle Enterprise Manager 12C (Cloud Control) to replace Oracle Enterprise Manager 10G (Grid Control.)● Worked with developers to enhance and streamline deployment process, to reduce technical debt, and to enhance Fastenal’s internal and external applications.● Worked with auditors to insure separation of duties, and security of data.● Worked with first level support to streamline workflow and secure data.● Reviewed, enhanced, and validated the backup strategy that was ten years old.● Supported the Oracle environment with strategic use of PL/SQL.

Minneapolis, Mn, Us

Provided production and development support for production systems as part of the Data Center Engineering team, and administered databases along all aspects of service lifecycle.● Responsible for the deployment, configuration, monitoring, and ongoing operations of database services.● Administer systems as assigned to provide appropriate documentation, cross-training, capacity management, and recommendations for future state.● Develop and maintain backup and recovery procedures for database services.● Engage with Development and Application Services teams to develop, scale, and improve production systems and services.● Develop reports and other applications necessary to support database service operations.● Administer user and application access to database services.● Complete Incident and Problem Management tasks to resolve open issues.● Adhere to and refine best-practice directives.● Work collaboratively with team members to analyze current systems and recommend and implement changes to current systems.

Minneapolis, Mn, Us

Provided production and development support for FactoryWorks as a contract employee.● Provided middle tier and back end support for all environments. ● Investigated, suggested, and implemented system enhancements.● Streamlined creation of test data by utilizing Oracle’s Transportable Tablespaces.● Automated schema loads for development and system test environments.Provide production support and resolve backlog issues for MMX as a contract employee.● Provided 24 X 7 production support on a weekly rotation.● Utilized the Agile methodology for project management.● Improved Sybase MobiLink synchronization times by more then 80% by removing histograms from certain Oracle table statistics; which required calling DBMS_STATS to gather statistics.● Upgraded a quote generation application from Oracle 9I to 10G, and suggested enhancements.● Assisted in replicating production database to four supporting Oracle environments.● Enhanced nightly delta load Tivoli scripts improving logic. ● Supported team members in SQL coding efforts.● Identified a critical error in parameter configuration; resolution will help performance.

Supported both SQL Server and Oracle databases. Primary systems had daily feeds from a Cobol based system that generated flat files for processing by sql-loader and dts packages.

Milwaukee, Wi, Us

Suported primarily Oracle and Sybase DBMS, and several SQL Server instances.

Master’S Degree, Christian Leadership Studies

Bachelor’S Degree, Management Of Information Systems