Database Administrator

Job Description

Job Purpose

As a Senior Database Administrator, you will be part of the Global Data Services team with accountability for designing, testing, implementing and maintaining the organization s databases across multiple platforms, technologies (e. g. , relational, non-relational and warehousing) and computing environments (e. g. , host based, distributed systems, client server). The role requires the ability to apply comprehensive functional and technical knowledge in a team setting for problem resolution, design and engineering decisions and system architecture planning.

Responsibilities

• Conduct database administrative work to support for production systems
  • Installing and upgrading database software and resolving database software problems
  • Performing evaluations of potential tools and utilities
  • Automating database tasks via scripting or through the use of tools
  • Updating, migrating, and refreshing database environments
  • Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues
• Provide support for Development, QA teams and systems
• Design, architect, plan database solutions to meet the business need
• Design and implement disaster recovery solutions for critical systems
• Implement improvements to process and code used for automating maintenance and operational tasks in various systems using programming languages such as PL/SQL, PERL, shell, Python, etc.
• Identify opportunities to fine-tune and optimize database systems and applications
• Ensure database recoverability within the constraints of any application, project and other requirements

Knowledge and Experience

• Bachelor s Degree in Computer Science, Information Technology or related field
• 5+ years of experience in the design, maintenance and administration of relational databases
• In depth knowledge of ASM and Grid Infrastructure
• Experience with Core Oracle Admin, RAC, MAA, Data guard, etc.
• Experience with SQL and PL/SQL coding skill
• Experience working in a Unix/Linux environment with understanding of Kernel and OS tuning
• Experience with performance and troubleshooting using tools or techniques such as OEM Grid Control Tuning Advisor, AWR, Statspack, TKPROF, Sql Trace, SQL Profile, SPM, Trace Events, Waits & Latches
• Proficient in Shell Scripting, Perl DBI/DBD or JDBC
• Strong proficiency to solve problems
• Ability to independently complete projects with minimal guidance
• Proven success in creating complete infrastructure to maintain a large server farm
• Ability to work an on-call schedule, after hours and weekends as needed
• Ability to learn new technology with a willingness to teach
• Experience with Exadata is preferred.
• Having knowledge or experience on rdbms technologies like PostgreSQL and MySQL.
• Having Knowledge or experience on NoSQL technologies like MongoDB, Cassandra is desirable.
• Having Knowledge on messaging system like Apache Kafka is desirable.

Schedule

This role offers work from home flexibility of one day per week.