Community

Home >

Jobs >

Logical Database Administrator

Texas, United States (On-site)

Logical Database Administrator

1 Month ago • 8 Years + • Administrative

About the job

7 skills required for this role

Test your skills to join the top 1% applicants for this job

shell

aws

sql

linux

postgresql

innovation

oracle

Job Description

As a Logical Database Administrator at Apexon, you will design, develop, maintain, and improve database solutions. This involves close collaboration with application development teams and stakeholders to enhance existing applications and implement new solutions. Key responsibilities include advanced database administration (performance monitoring, tuning, support), Agile participation (backlog grooming, user story development), and providing support across production, development, and test environments. You will develop and modify Linux shell scripts and possess advanced expertise in Oracle SQL and PL/SQL development and tuning. Experience with Erwin for reverse engineering and AWS is also required. The role demands strong knowledge of Oracle databases, SQL, PL/SQL, and PostgreSQL.

Must have:

8+ years database experience
Advanced Oracle SQL & PL/SQL
Performance tuning expertise
Oracle 11/19c on Solaris/Linux
Oracle SQL Developer & Erwin
Agile methodologies
PostgreSQL knowledge
Develop and maintain database solutions

Perks:

Health Insurance with Dental & Vision
401K Plan
Life Insurance, STD & LTD
Paid Vacations & Holidays
Paid Parental Leave
FSA Dependent & Limited Purpose care
Learning & Development

Description

Position at Apexon

About Apexon:

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.

Apexon brings together distinct core competencies – in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement.

Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

We enable #HumanFirstDIGITAL

Role Description:

You’ll be responsible for (Responsibilities):

As a Logical Database Administrator, you will be responsible for designing, developing, maintaining, and improving database solutions by implementing new solutions. The role involves working closely with application development teams, business stakeholders, and other partners to enhance existing applications and implement new solutions. This role also requires a strong emphasis on performance monitoring, tuning, and database administration, ensuring high availability for users.
Minimum Requirements:
8+ years of experience in implementing, administering, managing, and monitoring databases in production and non-production environments, ensuring data integrity and security.
8+ years of advanced knowledge in developing and optimizing Oracle SQL and PL/SQL code.
Proven ability to lead large, complex initiatives and performance tuning improvements, including using Explain Plan for query optimization.
Strong knowledge of Oracle internal views, functions, and architecture, including tablespace consolidation and index analysis.
Experience with Oracle 11/19c databases on Solaris/Linux systems for troubleshooting and optimization.
Proficiency in Oracle SQL Developer and Erwin Modeling tools for creating data models, including star schemas.
Experience using Agile methodologies in large development projects.

Key Responsibilities:

Design, develop, and maintain database solutions and support applications developers.
Collaborate with development teams and stakeholders to enhance the applications and implement new solutions.
Perform advanced database administration tasks, including performance monitoring, tuning, and providing database-related support.
Participate in Agile practices such as backlog grooming and user story development.
Provide production, development, and test environment support, including on-call support for troubleshooting.
Develop and modify Linux shell scripts to support day-to-day database administration tasks.
Advanced expertise in Oracle SQL and PL/SQL development and tuning.
Able to work with ErWin tool for reverse engineering and create subject areas.
Able to work on AWS and its technology.
Must have good knowledge of PostgreSQL.
Other duties as assigned.

You’ll have (Qualification & Experience):

Bachelor's Degree in related field is required.

Don’t worry if you don’t check all the boxes; we’d still love to hear from you.

Our Commitment to Diversity & Inclusion:

Did you know that Apexon has been Certified™ by Great Place To Work®, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.

Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law.

You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com)

Our Perks and Benefits:

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones.

As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.

We also offer: