Analyst II
Job Summary
Job Description
- 7+ years experience in Database Administration.
- In-depth knowledge of database management systems.
- Experience in AWS RDS.
- Relevant certifications such as PostgreSQL Certified Professional or Oracle Certified Professional.
- Experience with database management tools like pgAdmin, Oracle Enterprise Manager, etc.
- Familiarity with cloud-based database services.
- Health Insurance with Dental & Vision
- 401K Plan
- Life Insurance, STD & LTD
- Paid Vacations & Holidays
- Paid Parental Leave
- FSA Dependent & Limited Purpose care
- Learning & Development
10 skills required
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):
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
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.
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
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.
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:
- Health Insurance with Dental & Vision
- 401K Plan
- Life Insurance, STD & LTD
- Paid Vacations & Holidays
- Paid Parental Leave
- FSA Dependent & Limited Purpose care
- Learning & Development
Similar Jobs
Palo Alto Networks
Autodesk
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
bytedance
Qualcomm
Nintendo
Get notifed when new similar jobs are uploaded
Jobs in United States
The Walt Disney Company
SSC Technologies
MediaOcean
Get notifed when new similar jobs are uploaded
Similar Category Jobs
Looks like we're out of matches
