Posted: 05/02/2023 Job Number: 37367

Job Description

Job Purpose

The Lead Oracle Database Administrator is responsible for design, test, implement, maintain, and control the organization’s databases across multiple platforms, technologies (e.g., physical, relational and object oriented) and computing environments (e.g., host based, distributed systems, client server). The responsibility is also to provide technical guidance to less experienced database administrators in their assigned duties. Ability to apply comprehensive functional and technical knowledge in a team setting for problem resolution, design and engineering decisions and system architecture planning is key.

Responsibilities

Prior experience of working with databases in high transaction OLTP environments with the ability to handle ~20 TB+ databases
Design, architect, plan database solutions to meet the business need. Applies comprehensive business processes, application design and functional knowledge in problem resolution. Proposes and defines solutions and standards which may impact a team or the organization.
Lead and contribute to the development of new methods, procedures, processes, or systems and understand the impact of these changes. Responsible for decisions impacting a team and may provide input into the decision-making process for larger decisions.
Designs and implements disaster recovery solutions for critical systems.
Provides leadership and expertise in investigation and resolution of performance related issues for warehousing and trading system environments. Design major reconstructions of database structures to ensure appropriate levels of performance, data integrity, recovery, and security.
Assist in planning, organizing, and controlling database administration activities and in the development of the overall project plans and timetables. Provide technical expertise to client and other data processing management and staff.
Assist in providing technical guidance, support and training to the database administration staff and provides evaluation on their technical proficiency to management.
Write clear and concise status reports, memos, and miscellaneous items such as test results, problem resolutions, etc. Write detailed technical specifications.
Facilitate discussion of technical issues. Conduct basic negotiations with other departments to achieve project/product goals.
Monitor and analyze system performance (e.g., stress volume), perform cost analysis for users, perform systems testing, performance and tuning. Notify management of findings and recommend solutions.
Evaluate and recommend major new database software products.
Develop and implement standards, procedures, and policies regarding software and applications databases (including naming, migration, backup, recovery, and security).
Provide support in the logical and physical design of databases in coordination with application development.
Participate in project management tracking on cross-functional teams.
Read professional literature to investigate new tools, technologies, methods, techniques etc. to determine their functionality in the company’s environment.
Implements improvements to process and code used for automating maintenance and operational tasks in various systems including critical trading systems, warehousing systems and other OLTP systems
Leverage in-depth knowledge of database clustering technologies to design and administer several clustered warehousing and transactional databases
Provide Production & Development Database Administration (DBA) support for Oracle. Key database administration responsibilities:
- Installing & upgrading database software and resolving database software problems.
- Tuning and troubleshooting software & database performance issues.
- Configuring monitoring and proactively reviewing statistics for errors, capacity, and performance issues.
- Performing evaluations of potential tools & utilities.
- Automating database tasks via scripting or using tools.
- Updating, migrating, and refreshing database environments.
Ensuring database recoverability within the constraints of any application, project, and other requirements.
Oversight for creation, maintenance, and testing of database infrastructure processes and technologies deployed in the organization.
Take a lead role as appropriate in procedural development for both disaster recovery and operational Readiness
Prior experience or exposure to application design/data modeling is highly desired

Knowledge and Experience

Bachelor's degree in computer science or a related discipline, or an equivalent level of technical knowledge required.
Exposure to Equities and Options markets and a basic understanding of these markets is essential.
9+ years of experience in administering databases on Unix or Linux based platforms, with at least 4+ years’ experience in Oracle RDBMS with 3 years of experience in supporting large data environments on Oracle RAC. Strong Exadata experience with the ability to support Exadata administration tasks is strongly preferred.
Solid knowledge of Linux / Unix operating systems and shell programming is required
Understanding of system architecture and system administration tasks is a plus.
A hands-on person with excellent communication, have the necessary people and soft skills for working with the other technology teams in support of the technologies
Effective communication skills with ability to maintain good relations with other database managers, users, developers, operations, and information security teams is essential
Understanding of broader system, database architectures, system and network architecture is suggested.
Solid knowledge of Linux / Unix operating systems, shell and Perl programming is required. Any exposure of other programming languages such as Python, Java or C/C++ would also be helpful.
The person must have the ability to work in a fast-paced business environment. The person must have the aptitude to work with application and business data and must have the mind-set, ability to learn/support multiple data platform technologies.
Prior experience of working with databases in high transaction environments on Oracle on 19c or higher, RAC, MySQL, or PostgreSQL
Effective communication skills with ability to maintain good relations with users, developers, operations, and information security teams.

Schedule

This role offers work from home flexibility of up to 2 days per week.

Meet Your Recruiter

Maxwell McIlwaine

Apply Now:

Apply Later

Share This Job:

Apply Online Apply with LinkedIn

Share This Job:

Related Jobs:

About Atlanta, GA

Ready to embark on an exciting career journey in one of the most vibrant cities in the South? Explore job opportunities in Atlanta, Georgia, where endless possibilities await! Known for its bustling arts scene, eclectic music venues, world-class cuisine, and renowned landmarks like the Fox Theatre and Centennial Olympic Park, Atlanta offers a perfect blend of urban charm and Southern hospitality. Home to professional sports teams like the Atlanta Braves and Falcons, as well as the High Museum of Art and Piedmont Park, this thriving metropolis provides a unique mix of career growth opportunities and cultural experiences. Start your job search today and discover why Atlanta is the ideal place to take your career to new heights!