Database Administrator Oracle
Resume:
Thomas Hines
Hamden, CT *****
******.*.*********@*****.***
Dear Hiring Manager:
I'm writing to express my interest in your posting for an experienced Oracle Database Administrator.
With hands-on experience overseeing the design, development, and maintenance of various database systems, I believe my skills perfectly suit your needs.
I enjoy solving large, complex data problems, and enjoy the process of building and determining a solution.
I can quickly identify new resolutions that will not only help solve major business problems, but also ensure that the business maintains compliance given my extensive research abilities and deep industry knowledge.
The requirements and skills listed on your website closely match my background and future career goals. I look to grow in my role as a Database Administrator. I believe your company will be an ideal place to apply my work experience.
My resume is attached, and I'd be happy to pass along a list of past projects. I can be reached anytime at 203-***-**** or ******.*.*********@*****.***. Thank you for your time and consideration. I look forward to speaking with you about this opportunity.
Sincerely,
Thomas Hines
Thomas Hines
652 Circular Avenue
Hamden, Connecticut 06514
******.*.*********@*****.***
EXECUTIVE SUMMARY
Lead Database Administrator (DBA) with vast experience designing, coding, testing, and supporting next generation database solutions in Oracle, SQL Server, and MySQL environments. Core competencies include:
Backup and Recovery Strategies
Database Design
User Management
Performance Troubleshooting
PowerShell and T-SQL scripting
24/7 Production Support
Excellent analytical skills
Global Products and Services
Upgrades and Patching
PROFESSIONAL EXPERIENCE
Entry Point Communications 05/28/2024 – 07/31/2024
Beginner Docker DBA
Configured Docker containers and created Docker files for different environments
Technical Skills:
Docker – Junior project experience
Docker, Docker Compose
Linux Operating System - Ubuntu 20.04.5 LTS
Database Servers: MYSQL version 9.0.1 and POSTGRESQL version 16.3.
MYSQL Backup Tools: mysqldump utility and restore using mysql command.
POSTGRESQL Backup Tools: pg_dump and pg_restore
Responsibilities
Knowledge of containerization technologies using tools like Docker.
Used MYSQL and POSTGRESQL database images with Docker to run and create Docker containers.
Use the latest MYSQL and POSTGRES images from Docker Hub and run them using Docker Compose, (docker-compose.yml).
Provided daily operational activities such as backups and restores.
Robert Half, CA Remote Contractor 09/11/2023 – 05/24/2024
Senior Oracle Database Administrator
Complete the pruning of data for a database archiving process that will eventually move data to the AWS cloud.
o Develop SQL PL/SQL scripts to archive data from Oracle(11g, 12c and 19c databases
o Work with Application and QS teams to validate/reconcile results
o Perform database restores using Delphix snapshots and/or Oracle Datapump exports/imports
o Troubleshoot performance issues with database and code
o Collaborate with multiple teams to troubleshoot and resolve issues
o Attend program meetings and participate in Agile sprint/scrum teams
o Ability to work PST hours
o Ability to work after hours and on weekends when needed
Skills and Experience
o DBA experience working with Oracle 11g, 12c and 19c RDBMS on Linux and Unix
o Very strong Oracle SQL and PL/SQL skills
o Ability to analyze, troubleshoot and resolve complex Oracle RDBMS performance issues
o Experience using Oracle RDBMS Datapump
o Experience with Linux shell scripting
o Experience archiving data in Oracle
o Experience migrating data/databases to AWS
o Knowledge and experience working with PeopleSoft on Oracle
Charles Schwab Corporation, Austin, TX Remote Contractor 03/20/2023 - 08/19/2023
Oracle Database Administrator – Senior
Supervises all changes and additions to data repository changes requested by application development teams. Assumes overall responsibility for the management of assigned database products with 24-hour emergency technical support.
Evaluate corporate-wide environments to improve system performance and functionality.
Perform maintenance tasks on existing test and production environments that includes modifying database sizes, migrating changes through various environments.
Designs, test, and implement backup, recovery and restore procedures for assigned databases; monitor and assure DASD requirements and problem resolution.
System DBA Oracle 11g, 12c and 19c experience.
DataGuard experience.
GoldenGate replication experience.
Database architecture experience.
Performance tuning Application support experience.
Shell scripting.
Oracle software on Red Hat Linux.
Oracle Real Application Clusters, (RAC) and Automatic Storage Management, (ASM).
Experience in using Oracle Multitenant Container Databases, (CDB) and Pluggable Databases, (PDB) in Oracle 19c.
Experience in Recovery Manager, (RMAN), Backup and Recovery, Disaster Recovery options and Duplicates, (Cloning).
Conning & Company, Hartford, CT 2018 - 2022
Lead-Senior Database Administrator
24x7 Oracle Production Database Administration. Managed, troubleshot, and resolved Oracle databases and applications issues. Managed development and test databases. Installed Oracle databases and patches, defined backup strategies and DR/HA solutions, monitored and resolved performance issues, optimized SQL queries, and answered Oracle related product questions.
Installed and configured Oracle 12.2.0.3/18.12.0.0/19.14.0.0 on stand-alone Windows servers.
Installed and created Conning Oracle databases.
Setup and configured Standby database (Physical) for high availability.
Installed 12 and 19 versions of Oracle patches; as well as Java patches. Migrated Development, Test, UAT and Production databases to new servers.
Performed backups and recoveries using RMAN hot backups, (Level 0 and Level 1).
Established and documented backup/recovery strategies and procedures including RMAN incremental backups.
RMAN duplicate/cloning databases for development database testing, test database testing, UAT database testing and Production.
Tuning heavy data loads. Monitoring and Performance tuning.
Coordinated with the developers and customized the SimCorp Dimension and GAIN modules.
Tuned the Database for improved performance using tkprof, explain plans, execution plans, and AWR.
Identified and resolved I/O bottlenecks, heavy data loading jobs.
Used Oracle Advanced Queueing in a propagation/transmitting of messages fashion from a Subscriber to multiple Publishers / Distributor to multiple Consumers
Setup and maintained monitoring and alerting of databases and executing proactive health checks.
Advised our customers on infrastructure and technical questions related to Oracle.
Maintained close contact with colleagues in our personal Oracle network and communicate errors, enhancement requests and operational documentation.
Served as support for Microsoft SQL Server database administration; tasks including configuration management, backup/restore/recovery, performance optimization, and space management.
Install, configure, deploy, upgrade and patch Microsoft SQL Server. Perform capacity planning, performance tuning, monitoring, troubleshooting and optimization of the databases.
Implemented Microsoft SQL Server database replication infrastructure.
Used Ola Hallengren's utilities that made up SQL Server Maintenance Solution.
Used the SSIS catalog to deploy SQL Server Integration Services (SSIS) projects. Upgraded and moved this catalog for developers so they can easily deploy and manage their integration services projects after deployment.
Designed and implemented migration strategies for the Oracle Database Server on the Azure Cloud.
Implemented Integration with Active Directory and KERBEROS authentication.
ESPN, Inc., Bristol, CT 2003 –2017
Lead Database Administrator
Worked on the team that provided proactive support for more than 200 Production and 1,200 Non-Production databases ensuring full compliance with applicable Service Level Agreements, (SLA’s), 24/7 support of Production database services to ensure the highest standards of availability, resilience, integrity, security, and performance required by our business systems. Monitored and upgraded multiple Oracle GoldenGate installations.
In-depth knowledge of Oracle 10g/11g/12c and Microsoft SQL Server 2012/2014/2016 with Production support experience in a multi-tier production environment
Installed and configured database software, performed upgrades and applied patches to software
Assisted with Backup & Recovery of Data Systems, managed database RMAN backups, RMAN restores/refreshes, user accounts, and permissions
Installed and configured Oracle GoldenGate replication from Oracle OLTP environments to remote Oracle Data Warehouses and Oracle Data Marts
Provided support and assistance to development team in the design, development, testing, tuning and implementation of database applications
Analyzed, designed, created and implemented databases including data models, logical and physical databases, data dictionaries and schemas, access methods, device allocations, validation checks, organization and security
Used CSSCAN on Oracle databases for change in character set conversion upon migration. Used the Database Migration Assistant for Unicode (DMU) software for handling invalid character data during character set migration from Western European to Oracle’s flavor of Unicode, (AL32UTF8).
Managed and supported Oracle database appliance (ODA). Document and maintain database standards and operations procedures regarding theses Engineering Systems.
Designed, developed, and administered Oracle and Microsoft SQL Server databases
Worked with global products and services in the sports information field
NASDAQ Stock Market, NEW YORK, NY 1998-2003
Senior Database Administrator
Managed, monitored, and provided 24-hour support for multiple Test, Development, QA, and Production Oracle and Microsoft SQL Server databases in Oracle RAC and Microsoft Cluster environments
Managed physical configurations, installations, and upgrades of server applications and hardware
Provisioned (database) development and testing environments
Designed, developed, modified, adapted, and implemented short and long-term solutions to IT needs through new and existing applications, systems architecture, network systems, and applications infrastructure
Reviewed and tuned SQL and PL/SQL code
Maintained multiple Oracle, Microsoft SQL Server, and Tandem database management systems in database design, testing implementation, maintenance, and administration in a multiple platform environment contributing to policy and procedure development
Maintained and monitored database utilities, relationships between the database users and applications, use query languages to design required summary or aggregation tables to support analyses
Created and maintained SQL queries and routines including shell scripts for database management
Maintained database support tools, database tables and dictionaries, security and access control and Oracle Recovery Manager, Export/Import (and Datapump), SQL*Loader experience, as well as RMAN recovery and backup procedures
Worked with Database Vendor Support for problem resolution on installed data systems products
EDUCATION
Bachelor of Arts, Legal Studies, Quinnipiac College, 1991-1994
Thomas Hines, Technical Addendum
Knowledge of and experience with several technologies and applications including but not limited to:
Exposure to many technologies in both Oracle and Microsoft SQL Server: clustering, version and migration management, Oracle Advanced DataGuard experience, Oracle GoldenGate administration experience, Dell SharePlex experience, Oracle Exadata and Oracle Database Appliance Engineered Systems experience, Linux, AlwaysOn Availability Groups, and others
RMAN hot backups, (Level 0 and Level 1).
Used Datapump Export, (expdp), and Import, (impdp), for databases as logical backups and restores.
Extensive experience in the use of Flashback Guarantee Restore Points.
Experience with Data Guard for High Availability and for Disaster Recovery. Use of the Observer to monitor the primary database.
Exposure to LANs, WANs, Citrix Metaframe, Microsoft technologies and SQL Server and XML
Oracle and SQL Server performance and tuning skills including server configuration and tracing facilities
Good working knowledge of job scheduling and monitoring tools for database systems, including command line script use and development
Contact this candidate