Analyst II

2 Weeks ago • 5-9 Years

Job Summary

Job Description

The Analyst II will be responsible for database management including installing, configuring, and maintaining Aurora PostgreSQL databases, as well as implementing backup and recovery strategies. They will also be involved in Oracle installation, upgrade, and ASM administration, performance tuning, and security and compliance. Furthermore, they will collaborate with development teams to design and implement database schemas, stored procedures, and functions, providing guidance on best practices and participating in code reviews. Troubleshooting and providing expert-level support for database-related issues will also be a key part of the role. The analyst will need to maintain detailed documentation of issues and resolutions. The ideal candidate should have a Bachelor's degree.
Must have:
  • 7+ years of experience in Database Administration
  • In-depth knowledge of database management systems.
  • Extensive experience in AWS RDS.
  • Proficiency in SQL.
  • Strong analytical and problem-solving skills.
Good to have:
  • Relevant certifications like PostgreSQL Certified Professional
  • Experience with database management tools like pgAdmin.
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

FICO - Technical Lead - Automation/Performance Testing

FICO

Bengaluru, Karnataka, India (On-Site)
2 Weeks ago
Outbrain - DevOps Security Engineer

Outbrain

Netanya, Center District, Israel (Hybrid)
2 Weeks ago
AI Dash - Technical Writer

AI Dash

Bengaluru, Karnataka, India (Hybrid)
1 Week ago
AI Dash - Technical Project Manager

AI Dash

Bengaluru, Karnataka, India (Hybrid)
1 Week ago
Xepelin - Engineering Manager | Platform

Xepelin

(Remote)
4 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Feld Entertainment - Body Refurb Technician

Feld Entertainment

Ellenton, Florida, United States (On-Site)
7 Months ago
Ettain Group - Linux Support Engineer

Ettain Group

Addison, Texas, United States (On-Site)
9 Years ago
CloudLinux - Senior Go Developer for CloudLinuxOS

CloudLinux

Vojvodina, Serbia (Remote)
1 Month ago
ByteDance - Site Reliability Engineer, Edge Services

ByteDance

Seattle, Washington, United States (On-Site)
3 Months ago
ByteDance - Research Scientist in Foundation Model, Speech & Audio Graduates - 2024 Start (PhD)

ByteDance

Seattle, Washington, United States (On-Site)
6 Months ago
Fractal - DevOps - Lead

Fractal

Mumbai, Maharashtra, India (On-Site)
6 Months ago
Unisys - Senior Endpoint Engineer

Unisys

Santa Clara, California, United States (On-Site)
1 Week ago
Rackspace Technology - Support Data Engineer II

Rackspace Technology

San Antonio, Texas, United States (Remote)
1 Month ago
Info Stretch - Lead Data Engineer

Info Stretch

Chennai, Tamil Nadu, India (On-Site)
6 Months ago
Canonical - Linux Cryptography and Security Engineer

Canonical

(Remote)
2 Weeks ago

Get notifed when new similar jobs are uploaded

Jobs in United States

ByteDance - Senior Software Engineer - Network Security

ByteDance

San Jose, California, United States (On-Site)
1 Month ago
Daybreak Game Company LLC - Software Development Engineer MTGO Client

Daybreak Game Company LLC

Renton, Washington, United States (Remote)
3 Months ago
Philips - Sales Support, Clinical Demonstration Specialist - Mobile Surgery (South Zone)

Philips

Orlando, Florida, United States (On-Site)
1 Week ago
Riot Games - 3D Character Art Lead

Riot Games

Los Angeles, California, United States (On-Site)
2 Weeks ago
PivotRoots - Field Marketing Intern

PivotRoots

El Segundo, California, United States (Hybrid)
1 Week ago
Riot Games - Senior Game Producer - League of Legends, Summoner's Rift Environment

Riot Games

Los Angeles, California, United States (On-Site)
4 Months ago
NBC universal - Multi-Platform Producer

NBC universal

Centennial, Colorado, United States (On-Site)
3 Weeks ago
GHX - Deal Desk Analyst

GHX

United States (On-Site)
5 Days ago
Tencent - Global Business Development Manager

Tencent

California, United States (On-Site)
2 Months ago
Perplexity AI - AI Software Engineer - Discovery

Perplexity AI

San Francisco, California, United States (On-Site)
6 Days 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)

St. Louis, Missouri, 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