Sr Database Adminitrator (5-8 years of exp in Oracle DB & AWS RDS Aurora required)

About Gartner IT:

Join a worldclass team of skilled engineers who build creative digital solutions to support our colleagues and clients. We make a broad organizational impact by delivering cuttingedge technology solutions that power Gartner. Gartner IT values its culture of nonstop innovation an outcomedriven approach to success and the notion that great ideas can come from anyone on the team.

About this role:

The Sr Database Administrator role is a role that will be part of the Database team within the GDM. The role is responsible for providing database administration support for databases used by GDM applications. The GDM database infrastructure includes Oracle AWS RDS Aurora databases residing in AWS public cloud. They belong to production as well as nonproduction environments. Database team is responsible for providing uptime SLA of 99.99 for the production environment. To achieve this SLA goal this role will support in monitoring and responding to any alerts relating to databases in the production environment in time.

What you will do:

• Plan and implement Oracle installations upgrades and migrations

• Perform core database administration activities such as database creation performance tuning monitoring backups/restore/recovery database cloning etc

• Maintain git repositories with UNIX shell scriptsTerraform Ruby and PERL scripts that are used for database maintenance

• Assist development team in day to day activities such as data model change push via github PRs to staging/production and SQL query tuning

• Maintain database backups on NFS server as well as AWS S3 backup

• Troubleshoot and assist in Oracle/AWS RDS Aurora related issues. Create SR and work with AWS support when needed.

• Maintain PL/SQL procedures functions and packages.

• Perform system administration when required to assist the team

• Provide Rotational On call support during weekends/Holidays

• Work with Cloud teams to implement solutions that would improve the productivity

• Evaluate new technologies coordinate with the team to implement the technology that improves the team output

• Maintain documentation on the wiki

What you will need:

• 58 years of experience of working as a database administrator

• Proven Oracle administration experience with 19c AWS RDS Aurora (PostgreSQL/MySQL)

• Excellent with RedHat like Linux operating systems

• Excellent with SQL PL/SQL and shell scripting

• Excellent troubleshooting and problemsolving skills

• Working knowledge of SDLC and Agile methodologies

• Ability and desire to learn new technologies in Oracle and DevOps area and work with the team to implement new solutions to improve productivity

• Demonstrated experience in Oracle core database activities such as software installation database creation performance tuning backup/restore/recovery and many more

• Working knowledge of scripting language such as UNIX shell scripts Terraform ruby Perl and Python

• Experience with NoSQL database such as DynamoDB DocumentDB etc. is a plus but not required

• Experience with Oracle Data Guard Oracle Enterprise Manager is a plus but not required

• Experience with AWS cloud technology such as working with EC2 S3 storage EBS volumes is a plus but not required

Dont meet every single requirement We encourage you to apply anyway. You might just be the right candidate for this or other roles.

LIPM2

Who are we

At Gartner Inc. (NYSE:IT) we guide the leaders who shape the world.

Our mission relies on expert analysis and bold ideas to deliver actionable objective insight helping enterprise leaders and their teams succeed with their missioncritical priorities.

Since our founding in 1979 weve grown to more than 21000 associates globally who support 14000 client enterprises in 90 countries and territories. We do important interesting and substantive work that matters. Thats why we hire associates with the intellectual curiosity energy and drive to want to make a difference. The bar is unapologetically high. So is the impact you can have here.

What makes Gartner a great place to work

Our sustained success creates limitless opportunities for you to grow professionally and flourish personally. We have a vast virtually untapped market potential ahead of us providing you with an exciting trajectory long into the future. How far you go is driven by your passion and performance.

We hire remarkable people who collaborate and win as a team. Together our singular unifying goal is to deliver results for our clients.

Our teams are inclusive and composed of individuals from different geographies cultures religions ethnicities races genders sexual orientations abilities and generations.

We invest in great leaders who bring out the best in you and the company enabling us to multiply our impact and results. This is why year after year we are recognized worldwide as a great place to work.

What do we offer

Gartner offers worldclass benefits highly competitive compensation and disproportionate rewards for top performers.

In our hybrid work environment we provide the flexibility and support for you to thrive working virtually when its productive to do so and getting together with colleagues in a vibrant community that is purposeful engaging and inspiring.

Ready to grow your career with Gartner Join us.

The policy of Gartner is to provide equal employment opportunities to all applicants and employees without regard to race color creed religion sex sexual orientation gender identity marital status citizenship status age national origin ancestry disability veteran status or any other legally protected status and to seek to advance the principles of equal employment opportunity.

Gartner is committed to being an Equal Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities. If you are a qualified individual with a disability or a disabled veteran you may request a reasonable accommodation if you are unable or limited in your ability to use or access the Companys career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at 1 (203)or by sending an email to.

Gartner Applicant Privacy Link: efficient navigation through the application please only use the back button within the application not the back arrow within your browser.