Analyst II

3 Weeks ago • 5 Years +

Job Summary

Job Description

The Analyst II will be responsible for installing, configuring, and maintaining Aurora PostgreSQL databases. They will manage database backup and recovery strategies, optimize database queries and indexes for maximum efficiency, and ensure compliance with security policies. The role involves designing and implementing database schemas, stored procedures, and functions, providing support for database-related issues, and troubleshooting complex problems. The candidate must have at least five years of experience as a PostgreSQL Database Administrator and four years as an Oracle Database Administrator. Bachelor's degree in Computer Science or a related field is required.
Must have:
  • 7+ years of experience in Database Administration.
  • Experience as a Database Administrator.
  • In-depth knowledge of AWS PostgreSQL, Oracle Database and MySQL
  • Understanding of data security and access control principles.
  • Extensive experience in AWS RDS.
  • Strong knowledge of PostgreSQL replication, high availability.
Good to have:
  • Relevant certifications such as PostgreSQL Certified Professional.
  • Experience with database management tools like pgAdmin.
  • Familiarity with cloud-based database services.
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

Job Details

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):

Key Responsibilities:
Database Management:
Install, configure, and maintain Aurora PostgreSQL databases. 
Implement and manage database backup and recovery strategies.
Oracle installation, upgrade, ASM administration
Performance Tuning:
Monitor database performance and identify performance bottlenecks.
Optimize database queries and indexes for maximum efficiency.
Conduct regular performance reviews and provide recommendations for improvements.
Security and Compliance:
Implement and maintain database security policies and procedures.
Ensure compliance with data protection regulations and company policies.
Conduct regular security audits and vulnerability assessments.
Database Development:
Collaborate with development teams to design and implement database schemas, stored procedures, and functions.
Provide guidance on best practices for database development and optimization.
Participate in code reviews and provide feedback to developers.
Troubleshooting and Support:
Provide expert-level support for database-related issues.
Troubleshoot and resolve complex database problems in a timely manner.
Maintain detailed documentation of issues and resolutions.

Requirements
7+ years of experience in Database Administration.
Proven experience as a Database Administrator.
In-depth knowledge of database management systems, primarily AWS PostgreSQL, Oracle Database and MySQL
Familiarity with database design principles, data normalization, and indexing techniques.
Understanding of data security and access control principles.
Extensive experience in AWS RDS.
Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
Experience with PostgreSQL monitoring and performance tuning tools.
Proficiency in SQL and experience with writing complex queries and stored procedures.
Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
Familiarity with Linux/Unix operating systems and shell scripting.
Experience using and administering Oracle Enterprise Manager (OEM)/Cloud Control
Qualifications:
Experience: Minimum of 5 years of experience as a PostgreSQL Database Administrator and 4 years as an Oracle Database Administrator.
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
Technical Skills: 
Proficiency in PostgreSQL and Oracle database management.
Strong knowledge of SQL and PL/pgSQL (PostgreSQL) and PL/SQL (Oracle).
Experience with database performance tuning and optimization.
Familiarity with database backup and recovery tools and techniques.
Understanding of database security best practices.
Experience with database monitoring tools and techniques.
Knowledge of data migration strategies and tools.
Hands-on experience on Oracle 19c Multitenant databases
Soft Skills: 
Excellent problem-solving and analytical skills.
Strong communication and collaboration abilities.
Detail-oriented with a focus on accuracy and quality.
Ability to work independently and as part of a team.
Preferred Qualifications:
Certifications: Relevant certifications such as PostgreSQL Certified Professional or Oracle Certified Professional.
Tools: Experience with database management tools like pgAdmin, Oracle Enterprise Manager, etc.
Cloud Platforms: Familiarity with cloud-based database services (e.g., AWS RDS,MYSQL).

 

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:

  1. Health Insurance with Dental & Vision
  2. 401K Plan
  3. Life Insurance, STD & LTD
  4. Paid Vacations & Holidays
  5. Paid Parental Leave
  6. FSA Dependent & Limited Purpose care
  7. Learning & Development 

Similar Jobs

Jane Street - Linux Engineer

Jane Street

London, England, United Kingdom (On-Site)
3 Days ago
E2open - Senior Enterprise Service Engineer

E2open

Hyderabad, Telangana, India (On-Site)
1 Week ago
Info Stretch - Lead Data Engineer

Info Stretch

Bengaluru, Karnataka, India (On-Site)
6 Months ago
ION - Principal Technical Consultant - Endur

ION

Berlin, Berlin, Germany (On-Site)
7 Months ago
Omitron - Orbital Analyst Engineering Internship

Omitron

(Remote)
2 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Epic Games - Build Engineer, Fortnite

Epic Games

(On-Site)
3 Months ago
AI Dash - Software Development Engineer - III DevOps

AI Dash

Bengaluru, Karnataka, India (Hybrid)
3 Months ago
Interactive Brokers - Java Software Engineer

Interactive Brokers

Zug, Zug, Switzerland (On-Site)
7 Months ago
Forescout - Professional Services Engineer - DoD

Forescout

United States (On-Site)
1 Week ago
London stock Exchange - LSEG Pricing Services - Support Lead

London stock Exchange

New York, United States (On-Site)
4 Days ago
Meta - Software Engineer, Machine Learning

Meta

United States (Remote)
1 Month ago
OMP - Quality Assurance Test Engineer - Senior

OMP

Maharashtra, India (Hybrid)
8 Months ago
Fortis Games - Senior DevOps Engineer

Fortis Games

Canada (On-Site)
4 Months ago
Hive Innovative Group - Senior PHP developer

Hive Innovative Group

Cairo, Cairo Governorate, Egypt (On-Site)
10 Months ago
Next Level Business Services - Teradata Developer

Next Level Business Services

St. Louis, Missouri, United States (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

Jobs in United States

Blink Health - Knowledge Management Associate

Blink Health

Pittsburgh, Pennsylvania, United States (On-Site)
1 Week ago
Vimeo - Senior Software Engineer, Growth

Vimeo

New York, New York, United States (On-Site)
3 Weeks ago
Samsung Semiconductor - Principal Engineer, AI/ML Software Compiler

Samsung Semiconductor

San Jose, California, United States (On-Site)
1 Month ago
GoMotive - Business Development Representative

GoMotive

Nashville, Tennessee, United States (Hybrid)
3 Weeks ago
Passive Logic - Technical Engineering Program Manager

Passive Logic

Salt Lake City, Utah, United States (On-Site)
7 Months ago
Discord - Senior Data Engineer

Discord

San Francisco, California, United States (Remote)
2 Months ago
Black Bery - Regional Sales Account Manager, Automotive

Black Bery

San Jose, California, United States (Remote)
3 Weeks ago
Motorola Solutions - Events and Communications Specialist

Motorola Solutions

Fort Worth, Texas, United States (On-Site)
2 Weeks ago
NVIDIA - Solutions Architect, Generative AI

NVIDIA

Santa Clara, California, United States (On-Site)
4 Weeks ago
Marsh McLennan - Operational Due Diligence Consultant

Marsh McLennan

Boston, Massachusetts, United States (Hybrid)
1 Week ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Lansing, Michigan, United States (On-Site)

Warsaw, Masovian Voivodeship, Poland (On-Site)

United States (On-Site)

Lansing, Michigan, United States (On-Site)

United States (On-Site)

Lansing, Michigan, United States (On-Site)

Lansing, Michigan, United States (On-Site)

Lansing, Michigan, United States (On-Site)

Austin, Texas, United States (On-Site)

Sacramento, California, United States (On-Site)

View All Jobs

Get notified when new jobs are added by InfoStretch Corporation

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug