Sr Database Admin (Finance)
TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Senior Database Administrator to join our team in Orlando, FL.
Job Summary: The Senior Database Administrator maintains, manages, and optimizes Oracle Server databases for Enterprise and External applications. This includes working closely with system managers and developers to optimize systems for availability and performance and provide data analysis services.
Essential Duties and Responsibilities:
- Propose innovative solutions and communicate ideas to the supervisor and the group.
- Work with software developers and senior team members to develop database designs and enhancements.
- Provide technical assistance by responding to inquiries regarding errors, problems, or questions.
- Analyze, install, and test product upgrades.
- Monitor application performance post-implementation and take required actions.
Education: Bachelor's degree from a four-year college or university, or equivalent combination of education and relevant experience.
Required Skills & Experience:
- 10 years of experience in Database Administration and Development for large and complex Oracle databases
- Strong technical background with the ability to perform business analysis and write effective documentation and specifications
- Expertise in writing and optimizing complex SQL and PL/SQL
- Expertise in Unix and writing Shell scripts
- Expertise in SQL*Plus
- Expertise with architecture and database design for Oracle 11g, 12c, and 19c, including installation and migration
- Hands-on experience as a production DBA, including RMAN backup and recovery
- Expertise in high-availability solutions and architecture
- Availability for 24/7 Production Database On-Call Support
Preferred Skills & Experience:
- Analyze, design, program, debug, and modify software enhancements and/or new products used in local, networked, or Internet-related computer programs
- Write code, complete programming, and perform testing and debugging of applications using current programming languages and technologies
- Write and/or analyze functional and performance requirements
- Estimate software development time and prepare software design documents
- Determine and obtain concurrence on acceptance criteria
- Develop, debug, and test code using simulators, stimulators, and mockups
- Correct errors by making appropriate changes and rechecking the program to ensure desired results
- Compile and write documentation of program development and subsequent revisions
- Write or contribute to instructions or manuals to guide end users
- Prepare detailed workflow charts and diagrams describing input, output, and logical operations, converting them into a series of instructions coded in a computer language
- Provide software support (phone, email, and onsite) to customers
- Perform daily and weekly systems integrity checks of deployed systems and applications
- Utilize software version control software for check-in/check-out of code
